View: P/O Superview

RotoID: PM0305
Table: PMPO
Protocol: Header
DLL:PMPO

Compositions: 1

RotoID Tables Title DLL
PM0522 PMPOO P/O Optional Field PMPOO

Keys: 1

Title Fields
DAYENDSEQ

Fields: 128

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:8 entries
1 = Purchase Order
2 = Receipt
3 = Return
4 = Invoice
5 = Credit Note
6 = Debit Note
7 = Committed Receipt
9 = Committed Invoice
TRANSTYPE 4 Integer Transaction Type E A  List:4 entries
1 = Posted
2 = Cost Adjustment
3 = Commitment Update
4 = Billing Adjustment
ADDCOST 5 Integer Additional Cost Type E A  List:4 entries
0 = None (Item)
1 = Prorated
2 = Prorated Manually
3 = Expensed
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:5 entries
8 = Requisition
1 = Purchase Order
2 = Receipt
3 = Return
4 = Invoice
SEQUENCENO 9 BCD*10.0 Sequence Key E A 
LINENO 10 BCD*10.0 Line Number E A 
COSTLINENO 11 BCD*10.0 Additional Cost Line Number E A 
DOCNUM 12 String*24 Document Number E A  Mask: %-22C
FISCALYEAR 13 String*4 Fiscal Year E A  Mask: %04D
FISCALPER 14 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 15 String*60 Reference E A 
DESC 16 String*60 Description E A 
VENDORID 17 String*12 Vendor Number E A  Mask: %-12C
TRANSDATE 18 Date Transaction Date E A 
CURRENCY 19 String*3 Currency Code E A  Mask: %-3N
RATETYPE 20 String*2 Rate Type E A  Mask: %-2N
RATEDATE 21 Date Rate Date E A 
RATEOP 22 Integer Rate Operator E A  List:2 entries
1 = Multiply
2 = Divide
RATE 23 BCD*8.7 Rate E A 
CONTRACT 24 String*16 ^1 E A  Mask: %-16C
PROJECT 25 String*16 ^2 E A  Mask: %-16N
CATEGORY 26 String*16 ^3 E A  Mask: %-16N
RESOURCE 27 String*24 Resource A  Mask: %-24C
ARITEM 28 String*16 A/R Item Number E A  Mask: %-16C
ARUOM 29 String*10 A/R Unit of Measure E A  Mask: %-10C
ITEMNO 30 String*24 Item Number E A 
LOCATION 31 String*6 Location E A  Mask: %-6N
QUANTITY 32 BCD*10.5 Quantity E A 
UNIT 33 String*10 Unit Of Measure E A  Mask: %-10c
CONVERSION 34 BCD*10.6 Conversion E A 
UNITCOSTSR 35 BCD*10.6 Unit Cost (source) E A 
UNITCOSTHM 36 BCD*10.6 Unit Cost (functional) E A 
DISCOUNTSR 37 BCD*10.6 Discount Amount in source currency E A 
DISCOUNTHM 38 BCD*10.6 Discount Amount in functional currency E A 
ALLOTAXSR 39 BCD*10.3 Allocated Tax (source) E A 
ALLOTAXHM 40 BCD*10.3 Allocated Tax (functional) E A 
EXPTAXSR 41 BCD*10.3 Expensed Tax (source) E A 
EXPTAXHM 42 BCD*10.3 Expensed Tax (functional) E A 
RTAXAMTSR 43 BCD*10.3 Recoverable Tax (source) E A 
RTAXAMTHM 44 BCD*10.3 Recoverable Tax (functional) E A 
EXTAMTSR 45 BCD*10.3 Extended Amount (source) E A 
EXTAMTHM 46 BCD*10.3 Extended Amount (functional) E A 
TOTAMTSR 47 BCD*10.3 Total Amount (source) E A 
TOTAMTHM 48 BCD*10.3 Total Amount (fucntional) E A 
TAXAMTSR 49 BCD*10.3 Total tax amout (source) E A 
TAXAMTHM 50 BCD*10.3 Total tax amout (functional) E A 
TAMTSR 51 BCD*10.3 Total Amount inc. tax (source) E A 
TAMTHM 52 BCD*10.3 Total Amount inc. tax (functional) E A 
BILLRATE 53 BCD*10.6 Billing Rate E A 
BILLTYPE 54 Integer Billing Type E A  List:4 entries
0 = None
2 = Billable
3 = No Charge
1 = Non-billable
WIPACCT 55 String*45 Work In Process Account E A  Mask: %-45C
CVACCT 56 String*45 Cost Variance Account E A  Mask: %-45C
CALCOHEAD 57 Integer Calculate Overhead? E A  List:3 entries
1 = Yes
0 = No
2 = Not Set
CALCLABOR 58 Integer Calculate Labor? E A  List:3 entries
1 = Yes
0 = No
2 = Not Set
COMMENTS 59 String*250 Comments E A 
TAUTH1 60 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 61 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 62 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 63 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 64 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 65 Integer Tax Class 1 E A 
TCLASS2 66 Integer Tax Class 2 E A 
TCLASS3 67 Integer Tax Class 3 E A 
TCLASS4 68 Integer Tax Class 4 E A 
TCLASS5 69 Integer Tax Class 5 E A 
TITMCLSS1 70 Integer Item Tax Class for Tax Authority 1 E A 
TITMCLSS2 71 Integer Item Tax Class for Tax Authority 2 E A 
TITMCLSS3 72 Integer Item Tax Class for Tax Authority 3 E A 
TITMCLSS4 73 Integer Item Tax Class for Tax Authority 4 E A 
TITMCLSS5 74 Integer Item Tax Class for Tax Authority 5 E A 
TINCLUDE1 75 Integer Tax Included 1 E A 
TINCLUDE2 76 Integer Tax Included 2 E A 
TINCLUDE3 77 Integer Tax Included 3 E A 
TINCLUDE4 78 Integer Tax Included 4 E A 
TINCLUDE5 79 Integer Tax Included 5 E A 
TAXBASES1 80 BCD*10.3 Tax Base 1 (source) E A 
TAXBASES2 81 BCD*10.3 Tax Base 2 (source) E A 
TAXBASES3 82 BCD*10.3 Tax Base 3 (source) E A 
TAXBASES4 83 BCD*10.3 Tax Base 4 (source) E A 
TAXBASES5 84 BCD*10.3 Tax Base 5 (source) E A 
TAXBASEH1 85 BCD*10.3 Tax Base 1 (functional) E A 
TAXBASEH2 86 BCD*10.3 Tax Base 2 (functional) E A 
TAXBASEH3 87 BCD*10.3 Tax Base 3 (functional) E A 
TAXBASEH4 88 BCD*10.3 Tax Base 4 (functional) E A 
TAXBASEH5 89 BCD*10.3 Tax Base 5 (functional) E A 
TAXAMTS1 90 BCD*10.3 Tax Amount 1 (source) E A 
TAXAMTS2 91 BCD*10.3 Tax Amount 2 (source) E A 
TAXAMTS3 92 BCD*10.3 Tax Amount 3 (source) E A 
TAXAMTS4 93 BCD*10.3 Tax Amount 4 (source) E A 
TAXAMTS5 94 BCD*10.3 Tax Amount 5 (source) E A 
TAXAMTH1 95 BCD*10.3 Tax Amount 1 (functional) E A 
TAXAMTH2 96 BCD*10.3 Tax Amount 2 (functional) E A 
TAXAMTH3 97 BCD*10.3 Tax Amount 3 (functional) E A 
TAXAMTH4 98 BCD*10.3 Tax Amount 4 (functional) E A 
TAXAMTH5 99 BCD*10.3 Tax Amount 5 (functional) E A 
DRILLSRCTY 100 Integer Drill Down Type E A 
DRILLDWNLK 101 BCD*10.0 Drill Down Link E A 
DRILLAPP 102 String*2 Drill Down Application E A 
OHACCT 103 String*45 Overhead Account E A  Mask: %-45C
OVERHD 104 Integer Overhead Type E A  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 105 BCD*10.6 Overhead Rate E A 
HEADPER 106 BCD*5.5 Overhead Percentage E A 
OHSR 107 BCD*10.3 Overhead Amount E A 
OHHM 108 BCD*10.3 Overhead Amount E A 
LABACCT 109 String*45 Labor Account E A  Mask: %-45C
LABOR 110 Integer Labor Type E A  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE 111 BCD*10.6 Labor Rate E A 
LABORPER 112 BCD*5.5 Labor Percentage E A 
LABORSR 113 BCD*10.3 Labor Amount E A 
LABORHM 114 BCD*10.3 Labor Amount E A 
TRANSNUM 115 Long Transaction Number E A 
VALUES 116 Long Optional Fields E A C 
TAMTRETSR 117 BCD*10.3 Source Retainage Amount E A 
TAMTRETHM 118 BCD*10.3 Functional Retainage Amount E A 
RETDUEDT 119 Date Retainage Due Date E A 
OHLABORQTY 120 BCD*10.5 Quantity for Additional Costs E A 
PROJSTAT 121 Integer ^2 Status E A  List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
TXEXPCOMSR 122 BCD*10.3 Tax (exp) Committed (source) E A 
TXEXPCOMHM 123 BCD*10.3 Tax (exp) Committed (func) E A 
TXALLCOMSR 124 BCD*10.3 Tax (all) Committed (source) E A 
TXALLCOMHM 125 BCD*10.3 Tax (all) Committed (func) E A 
TRANSREF 126 Long Transaction Reference E A 
OTHERREF 127 Long Cost/Revenue TRANSNUM E A 
DATEBUS 128 Date E A 

This page was generated on 2023-Aug-31

© 2023 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).