Table: O/E Superview

Table: PMOE
View: PM0473
Record Length: 1499

Flags: A R 

Keys: 1

Title Flags Fields
DAYENDSEQ

Fields: 124

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:3 entries
1 = Quote
2 = Order Entry
3 = Shipment
TRANSTYPE Integer Transaction Type List:2 entries
1 = Posted
2 = Adjustment
DETAILTYPE Integer Detail Line Type List:2 entries
0 = Item
1 = Miscellaneous Charges
MULTIFROM Integer From Multiple Documents List:2 entries
1 = Yes
0 = No
FROMDOC String*22 From Document Number
FRMDOCTYPE Integer From Document Type List:3 entries
1 = Quote
2 = Order Entry
3 = Shipment
SEQUENCENO BCD*10.0 Sequence Key
LINENO BCD*10.0 Line Number
DOCNUM String*22 Document Number
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
IDCUST String*12 Customer 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
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
EXTBILLSR BCD*10.3 Extended Billing Amount (source)
EXTBILLHM BCD*10.3 Reserved
WIPACCT String*45 Work In Process Account Mask: %-45C
REVACCT String*45 Revenue/Billing Account
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 Misc Charge
PROJSTAT Integer ^2 Status List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
OEBILLABLE Boolean Invoiced in O/E?
DATEBUS Date Posting Date
CVAMT BCD*10.3 Cost Variance Amount

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