Table: P/O Superview

Table: PMPO
View: PM0305
Record Length: 1542

Flags: A R 

Keys: 1

Title Flags Fields
DAYENDSEQ

Fields: 132

Field Type Title Presentation
DAYENDSEQ Long Day End Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DAYENDDATE Date Day End Date
DOCTYPE Integer Document Type 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 Integer Transaction Type List:4 entries
1 = Posted
2 = Cost Adjustment
3 = Commitment Update
4 = Billing Adjustment
ADDCOST Integer Additional Cost Type List:4 entries
0 = None (Item)
1 = Prorated
2 = Prorated Manually
3 = Expensed
MULTIFROM Integer From Multiple Documents List:2 entries
1 = Yes
0 = No
FROMDOC String*22 From Document Number
FRMDOCTYPE Integer From Document Type List:5 entries
8 = Requisition
1 = Purchase Order
2 = Receipt
3 = Return
4 = Invoice
SEQUENCENO BCD*10.0 Sequence Key
LINENO BCD*10.0 Line Number
COSTLINENO BCD*10.0 Additional Cost Line Number
DOCNUM String*24 Document Number Mask: %-22C
FISCALYEAR String*4 Fiscal Year Mask: %04D
FISCALPER Integer Fiscal Period 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 String*60 Reference
DESC String*60 Description
VENDORID String*12 Vendor Number Mask: %-12C
TRANSDATE Date Transaction Date
CURRENCY String*3 Currency Code Mask: %-3N
RATETYPE String*2 Rate Type Mask: %-2N
RATEDATE Date Rate Date
RATEOP Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
RATE BCD*8.7 Rate
CONTRACT String*16 ^1 Mask: %-16C
PROJECT String*16 ^2 Mask: %-16N
CATEGORY String*16 ^3 Mask: %-16N
RESOURCE String*24 Resource Mask: %-24C
ARITEM String*16 A/R Item Number Mask: %-16C
ARUOM String*10 A/R Unit of Measure Mask: %-10C
ITEMNO String*24 Item Number
LOCATION String*6 Location Mask: %-6N
QUANTITY BCD*10.5 Quantity
UNIT String*10 Unit Of Measure Mask: %-10c
CONVERSION BCD*10.6 Conversion
UNITCOSTSR BCD*10.6 Unit Cost (source)
UNITCOSTHM BCD*10.6 Unit Cost (functional)
DISCOUNTSR BCD*10.6 Discount Amount in source currency
DISCOUNTHM BCD*10.6 Discount Amount in functional currency
ALLOTAXSR BCD*10.3 Allocated Tax (source)
ALLOTAXHM BCD*10.3 Allocated Tax (functional)
EXPTAXSR BCD*10.3 Expensed Tax (source)
EXPTAXHM BCD*10.3 Expensed Tax (functional)
RTAXAMTSR BCD*10.3 Recoverable Tax (source)
RTAXAMTHM BCD*10.3 Recoverable Tax (functional)
EXTAMTSR BCD*10.3 Extended Amount (source)
EXTAMTHM BCD*10.3 Extended Amount (functional)
TOTAMTSR BCD*10.3 Total Amount (source)
TOTAMTHM BCD*10.3 Total Amount (fucntional)
TAXAMTSR BCD*10.3 Total tax amout (source)
TAXAMTHM BCD*10.3 Total tax amout (functional)
TAMTSR BCD*10.3 Total Amount inc. tax (source)
TAMTHM BCD*10.3 Total Amount inc. tax (functional)
BILLRATE BCD*10.6 Billing Rate
BILLTYPE Integer Billing Type List:4 entries
0 = None
2 = Billable
3 = No Charge
1 = Non-billable
WIPACCT String*45 Work In Process Account Mask: %-45C
CVACCT String*45 Cost Variance Account Mask: %-45C
CALCOHEAD Integer Calculate Overhead? List:3 entries
1 = Yes
0 = No
2 = Not Set
CALCLABOR Integer Calculate Labor? List:3 entries
1 = Yes
0 = No
2 = Not Set
COMMENTS String*250 Comments
TAUTH1 String*12 Tax Authority 1 Mask: %-12N
TAUTH2 String*12 Tax Authority 2 Mask: %-12N
TAUTH3 String*12 Tax Authority 3 Mask: %-12N
TAUTH4 String*12 Tax Authority 4 Mask: %-12N
TAUTH5 String*12 Tax Authority 5 Mask: %-12N
TCLASS1 Integer Tax Class 1
TCLASS2 Integer Tax Class 2
TCLASS3 Integer Tax Class 3
TCLASS4 Integer Tax Class 4
TCLASS5 Integer Tax Class 5
TITMCLSS1 Integer Item Tax Class for Tax Authority 1
TITMCLSS2 Integer Item Tax Class for Tax Authority 2
TITMCLSS3 Integer Item Tax Class for Tax Authority 3
TITMCLSS4 Integer Item Tax Class for Tax Authority 4
TITMCLSS5 Integer Item Tax Class for Tax Authority 5
TINCLUDE1 Integer Tax Included 1
TINCLUDE2 Integer Tax Included 2
TINCLUDE3 Integer Tax Included 3
TINCLUDE4 Integer Tax Included 4
TINCLUDE5 Integer Tax Included 5
TAXBASES1 BCD*10.3 Tax Base 1 (source)
TAXBASES2 BCD*10.3 Tax Base 2 (source)
TAXBASES3 BCD*10.3 Tax Base 3 (source)
TAXBASES4 BCD*10.3 Tax Base 4 (source)
TAXBASES5 BCD*10.3 Tax Base 5 (source)
TAXBASEH1 BCD*10.3 Tax Base 1 (functional)
TAXBASEH2 BCD*10.3 Tax Base 2 (functional)
TAXBASEH3 BCD*10.3 Tax Base 3 (functional)
TAXBASEH4 BCD*10.3 Tax Base 4 (functional)
TAXBASEH5 BCD*10.3 Tax Base 5 (functional)
TAXAMTS1 BCD*10.3 Tax Amount 1 (source)
TAXAMTS2 BCD*10.3 Tax Amount 2 (source)
TAXAMTS3 BCD*10.3 Tax Amount 3 (source)
TAXAMTS4 BCD*10.3 Tax Amount 4 (source)
TAXAMTS5 BCD*10.3 Tax Amount 5 (source)
TAXAMTH1 BCD*10.3 Tax Amount 1 (functional)
TAXAMTH2 BCD*10.3 Tax Amount 2 (functional)
TAXAMTH3 BCD*10.3 Tax Amount 3 (functional)
TAXAMTH4 BCD*10.3 Tax Amount 4 (functional)
TAXAMTH5 BCD*10.3 Tax Amount 5 (functional)
DRILLSRCTY Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link
DRILLAPP String*2 Drill Down Application
OHACCT String*45 Overhead Account Mask: %-45C
OVERHD Integer Overhead Type List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE BCD*10.6 Overhead Rate
HEADPER BCD*5.5 Overhead Percentage
OHSR BCD*10.3 Overhead Amount
OHHM BCD*10.3 Overhead Amount
LABACCT String*45 Labor Account Mask: %-45C
LABOR Integer Labor Type List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE BCD*10.6 Labor Rate
LABORPER BCD*5.5 Labor Percentage
LABORSR BCD*10.3 Labor Amount
LABORHM BCD*10.3 Labor Amount
TRANSNUM Long Transaction Number
VALUES Long Optional Fields
TAMTRETSR BCD*10.3 Source Retainage Amount
TAMTRETHM BCD*10.3 Functional Retainage Amount
RETDUEDT Date Retainage Due Date
OHLABORQTY BCD*10.5 Quantity for Additional Costs
PROJSTAT Integer ^2 Status List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
TXEXPCOMSR BCD*10.3 Tax (exp) Committed (source)
TXEXPCOMHM BCD*10.3 Tax (exp) Committed (func)
TXALLCOMSR BCD*10.3 Tax (all) Committed (source)
TXALLCOMHM BCD*10.3 Tax (all) Committed (func)
TRANSREF Long Transaction Reference
OTHERREF Long Cost/Revenue TRANSNUM
DATEBUS Date

This page was generated on 2022-Aug-18

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