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 2008-May-01

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