# 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 | Contract | E A | Mask: %-16C
PROJECT | 25 | String*16 | Project | E A | Mask: %-16N
CATEGORY | 26 | String*16 | Category | 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 | Project 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 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.