View: O/E Superview

RotoID: PM0473
Table: PMOE
Protocol: Header
DLL:PMOE

Compositions: 1

RotoID Tables Title DLL
PM0474 PMOEO O/E Optional Field PMOEO

Keys: 1

Title Fields
DAYENDSEQ

Fields: 120

Field Index Type Title Attributes Presentation
DAYENDSEQ 1 Long Day End Sequence E A K R 
DAYENDDATE 2 Date Day End Date E A 
DOCTYPE 3 Integer Document Type E A  List:3 entries
1 = Quote
2 = Order Entry
3 = Shipment
TRANSTYPE 4 Integer Transaction Type E A  List:2 entries
1 = Posted
2 = Adjustment
DETAILTYPE 5 Integer Detail Line Type E A  List:2 entries
0 = Item
1 = Miscellaneous Charges
MULTIFROM 6 Integer From Multiple Documents E A  List:2 entries
1 = Yes
0 = No
FROMDOC 7 String*22 From Document Number E A 
FRMDOCTYPE 8 Integer From Document Type E A  List:3 entries
1 = Quote
2 = Order Entry
3 = Shipment
SEQUENCENO 9 BCD*10.0 Sequence Key E A 
LINENO 10 BCD*10.0 Line Number E A 
DOCNUM 11 String*22 Document Number E A 
FISCALYEAR 12 String*4 Fiscal Year E A  Mask: %04D
FISCALPER 13 Integer Fiscal Period E A  List:13 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
13 = 13
REFERENCE 14 String*60 Reference E A 
DESC 15 String*60 Description E A 
IDCUST 16 String*12 Customer Number E A  Mask: %-12C
TRANSDATE 17 Date Transaction Date E A 
CURRENCY 18 String*3 Currency Code E A  Mask: %-3N
RATETYPE 19 String*2 Rate Type E A  Mask: %-2N
RATEDATE 20 Date Rate Date E A 
RATEOP 21 Integer Rate Operator E A  List:2 entries
1 = Multiply
2 = Divide
RATE 22 BCD*8.7 Rate E A 
CONTRACT 23 String*16 ^1 E A  Mask: %-16C
PROJECT 24 String*16 ^2 E A  Mask: %-16N
CATEGORY 25 String*16 ^3 E A  Mask: %-16N
RESOURCE 26 String*24 Resource A  Mask: %-24C
ARITEM 27 String*16 A/R Item Number E A  Mask: %-16C
ARUOM 28 String*10 A/R Unit of Measure E A  Mask: %-10C
ITEMNO 29 String*24 Item Number E A 
LOCATION 30 String*6 Location E A  Mask: %-6N
QUANTITY 31 BCD*10.5 Quantity E A 
UNIT 32 String*10 Unit Of Measure E A  Mask: %-10c
CONVERSION 33 BCD*10.6 Conversion E A 
UNITCOSTSR 34 BCD*10.6 Unit Cost (source) E A 
UNITCOSTHM 35 BCD*10.6 Unit Cost (functional) E A 
DISCOUNTSR 36 BCD*10.6 Discount Amount in source currency E A 
DISCOUNTHM 37 BCD*10.6 Discount Amount in functional currency E A 
EXTAMTSR 38 BCD*10.3 Extended Amount (source) E A 
EXTAMTHM 39 BCD*10.3 Extended Amount (functional) E A 
TOTAMTSR 40 BCD*10.3 Total Amount (source) E A 
TOTAMTHM 41 BCD*10.3 Total Amount (fucntional) E A 
TAXAMTSR 42 BCD*10.3 Total tax amout (source) E A 
TAXAMTHM 43 BCD*10.3 Total tax amout (functional) E A 
TAMTSR 44 BCD*10.3 Total Amount inc. tax (source) E A 
TAMTHM 45 BCD*10.3 Total Amount inc. tax (functional) E A 
BILLRATE 46 BCD*10.6 Billing Rate E A 
BILLTYPE 47 Integer Billing Type E A  List:4 entries
0 = None
2 = Billable
3 = No Charge
1 = Non-billable
EXTBILLSR 48 BCD*10.3 Extended Billing Amount (source) E A 
EXTBILLHM 49 BCD*10.3 Reserved E A 
WIPACCT 50 String*45 Work In Process Account E A  Mask: %-45C
REVACCT 51 String*45 Revenue/Billing Account E A 
CVACCT 52 String*45 Cost Variance Account E A  Mask: %-45C
CALCOHEAD 53 Integer Calculate Overhead? E A  List:3 entries
1 = Yes
0 = No
2 = Not Set
CALCLABOR 54 Integer Calculate Labor? E A  List:3 entries
1 = Yes
0 = No
2 = Not Set
COMMENTS 55 String*250 Comments E A 
TAUTH1 56 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 57 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 58 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 59 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 60 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 61 Integer Tax Class 1 E A 
TCLASS2 62 Integer Tax Class 2 E A 
TCLASS3 63 Integer Tax Class 3 E A 
TCLASS4 64 Integer Tax Class 4 E A 
TCLASS5 65 Integer Tax Class 5 E A 
TITMCLSS1 66 Integer Item Tax Class for Tax Authority 1 E A 
TITMCLSS2 67 Integer Item Tax Class for Tax Authority 2 E A 
TITMCLSS3 68 Integer Item Tax Class for Tax Authority 3 E A 
TITMCLSS4 69 Integer Item Tax Class for Tax Authority 4 E A 
TITMCLSS5 70 Integer Item Tax Class for Tax Authority 5 E A 
TINCLUDE1 71 Integer Tax Included 1 E A 
TINCLUDE2 72 Integer Tax Included 2 E A 
TINCLUDE3 73 Integer Tax Included 3 E A 
TINCLUDE4 74 Integer Tax Included 4 E A 
TINCLUDE5 75 Integer Tax Included 5 E A 
TAXBASES1 76 BCD*10.3 Tax Base 1 (source) E A 
TAXBASES2 77 BCD*10.3 Tax Base 2 (source) E A 
TAXBASES3 78 BCD*10.3 Tax Base 3 (source) E A 
TAXBASES4 79 BCD*10.3 Tax Base 4 (source) E A 
TAXBASES5 80 BCD*10.3 Tax Base 5 (source) E A 
TAXBASEH1 81 BCD*10.3 Tax Base 1 (functional) E A 
TAXBASEH2 82 BCD*10.3 Tax Base 2 (functional) E A 
TAXBASEH3 83 BCD*10.3 Tax Base 3 (functional) E A 
TAXBASEH4 84 BCD*10.3 Tax Base 4 (functional) E A 
TAXBASEH5 85 BCD*10.3 Tax Base 5 (functional) E A 
TAXAMTS1 86 BCD*10.3 Tax Amount 1 (source) E A 
TAXAMTS2 87 BCD*10.3 Tax Amount 2 (source) E A 
TAXAMTS3 88 BCD*10.3 Tax Amount 3 (source) E A 
TAXAMTS4 89 BCD*10.3 Tax Amount 4 (source) E A 
TAXAMTS5 90 BCD*10.3 Tax Amount 5 (source) E A 
TAXAMTH1 91 BCD*10.3 Tax Amount 1 (functional) E A 
TAXAMTH2 92 BCD*10.3 Tax Amount 2 (functional) E A 
TAXAMTH3 93 BCD*10.3 Tax Amount 3 (functional) E A 
TAXAMTH4 94 BCD*10.3 Tax Amount 4 (functional) E A 
TAXAMTH5 95 BCD*10.3 Tax Amount 5 (functional) E A 
DRILLSRCTY 96 Integer Drill Down Type E A 
DRILLDWNLK 97 BCD*10.0 Drill Down Link E A 
DRILLAPP 98 String*2 Drill Down Application E A 
OHACCT 99 String*45 Overhead Account E A  Mask: %-45C
OVERHD 100 Integer Overhead Type E A  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 101 BCD*10.6 Overhead Rate E A 
HEADPER 102 BCD*5.5 Overhead Percentage E A 
OHSR 103 BCD*10.3 Overhead Amount E A 
OHHM 104 BCD*10.3 Overhead Amount E A 
LABACCT 105 String*45 Labor Account E A  Mask: %-45C
LABOR 106 Integer Labor Type E A  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE 107 BCD*10.6 Labor Rate E A 
LABORPER 108 BCD*5.5 Labor Percentage E A 
LABORSR 109 BCD*10.3 Labor Amount E A 
LABORHM 110 BCD*10.3 Labor Amount E A 
TRANSNUM 111 Long Transaction Number E A 
VALUES 112 Long Optional Fields E A C 
TAMTRETSR 113 BCD*10.3 Source Retainage Amount E A 
TAMTRETHM 114 BCD*10.3 Functional Retainage Amount E A 
RETDUEDT 115 Date Retainage Due Date E A 
OHLABORQTY 116 BCD*10.5 Quantity for Misc Charge E A 
PROJSTAT 117 Integer ^2 Status E A  List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
OEBILLABLE 118 Boolean Invoiced in O/E? E A 
DATEBUS 119 Date Posting Date E A 
CVAMT 120 BCD*10.3 Cost Variance Amount E A 

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).