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

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