# View: Posting Journals - Details

RotoID: OE0100
Table: OEAUDD
Protocol: Detail, Ordered revisions
DLL: OEAUDD

## Compositions: 3

RotoID | Tables | Title | DLL
--- | --- | --- | ---
OE0120 | OEAUDH | Posting Journals | OEAUDH
OE0110 | OEAUDDP | Posting Jnls Detail Opt. Fields | OEAUDDP
OE0105 | OEAUDDD | Posting Journals - Detail-Details | OEAUDDD

## Keys: 2

Title | Fields
--- | ---
Day End Number | TRANSTYPE, DAYENDNUM, ENTRYNUM, LINENUM
Day End No./Entry No./Line No. | DAYENDNUM, ENTRYNUM, LINENUM

## Fields: 110

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
TRANSTYPE | 1 | Integer | Transaction Type | E A K R | List: 5 entries
1 | = | Invoice
2 | = | Credit Note
3 | = | Shipment
4 | = | Debit Note
5 | = | Order
DAYENDNUM | 2 | Long | Day End Number | E A K R |
ENTRYNUM | 3 | Long | Entry Number | E A K R |
LINENUM | 4 | Integer | Line Number | E A K R |
LINETYPE | 5 | Integer | Line Type | E A | List: 2 entries
1 | = | Item
2 | = | Miscellaneous
ITEM | 6 | String*24 | Item Number | E A |
MISCCHARGE | 7 | String*6 | Miscellaneous Charge Code | E A |
DESC | 8 | String*60 | Description | E A |
PRICELIST | 9 | String*6 | Price List | E A |
CATEGORY | 10 | String*6 | Category | E A | Mask: %-6N
LOCATION | 11 | String*6 | Location | E A | Mask: %-6N
QTYSHIPPED | 12 | BCD*10.4 | Quantity Shipped | E A |
INVUNIT | 13 | String*10 | Unit of Measure | E A |
UNITPRICE | 14 | BCD*10.6 | Unit Price | E A |
PRICEOVER | 15 | Boolean | Price Override | E A |
UNITCOST | 16 | BCD*10.6 | Unit Cost | E A |
EXTCOSTH | 17 | BCD*10.3 | Extended Cost (Functional) | E A |
EXTCOSTS | 18 | BCD*10.3 | Extended Cost (Source) | E A |
COSTVARH | 19 | BCD*10.3 | Cost Variance (Functional) | E A |
COSTVARS | 20 | BCD*10.3 | Cost Variance (Source) | E A |
EXTOVER | 21 | Boolean | Extended Amount Override | E A |
EXTINVMISC | 22 | BCD*10.3 | Extended Amount | E A |
REVAMTH | 23 | BCD*10.3 | Revenue (Functional) | E A |
REVAMTS | 24 | BCD*10.3 | Revenue (Source) | E A |
UNITWEIGHT | 25 | BCD*10.4 | Unit Weight | E A |
EXTWEIGHT | 26 | BCD*10.4 | Extended Weight | E A |
TAUTH1 | 27 | String*12 | Tax Authority 1 | E A | Mask: %-12N
TAUTH2 | 28 | String*12 | Tax Authority 2 | E A | Mask: %-12N
TAUTH3 | 29 | String*12 | Tax Authority 3 | E A | Mask: %-12N
TAUTH4 | 30 | String*12 | Tax Authority 4 | E A | Mask: %-12N
TAUTH5 | 31 | String*12 | Tax Authority 5 | E A | Mask: %-12N
TCLASS1 | 32 | Integer | Tax Class 1 | E A |
TCLASS2 | 33 | Integer | Tax Class 2 | E A |
TCLASS3 | 34 | Integer | Tax Class 3 | E A |
TCLASS4 | 35 | Integer | Tax Class 4 | E A |
TCLASS5 | 36 | Integer | Tax Class 5 | E A |
TINCLUDED1 | 37 | Boolean | Tax Included 1 | E A |
TINCLUDED2 | 38 | Boolean | Tax Included 2 | E A |
TINCLUDED3 | 39 | Boolean | Tax Included 3 | E A |
TINCLUDED4 | 40 | Boolean | Tax Included 4 | E A |
TINCLUDED5 | 41 | Boolean | Tax Included 5 | E A |
TBASE1 | 42 | BCD*10.3 | Tax Base 1 | E A |
TBASE2 | 43 | BCD*10.3 | Tax Base 2 | E A |
TBASE3 | 44 | BCD*10.3 | Tax Base 3 | E A |
TBASE4 | 45 | BCD*10.3 | Tax Base 4 | E A |
TBASE5 | 46 | BCD*10.3 | Tax Base 5 | E A |
TAMOUNT1 | 47 | BCD*10.3 | Tax Amount 1 | E A |
TAMOUNT2 | 48 | BCD*10.3 | Tax Amount 2 | E A |
TAMOUNT3 | 49 | BCD*10.3 | Tax Amount 3 | E A |
TAMOUNT4 | 50 | BCD*10.3 | Tax Amount 4 | E A |
TAMOUNT5 | 51 | BCD*10.3 | Tax Amount 5 | E A |
REVENUACCT | 52 | String*45 | Revenue Account | E A | Mask: %-45C
COGSACCT | 53 | String*45 | Cost of Goods Sold Account | E A | Mask: %-45C
VARIANACCT | 54 | String*45 | Variance Account | E A | Mask: %-45C
INVACCT | 55 | String*45 | Inventory Control Account | E A | Mask: %-45C
RETURNTYPE | 56 | Integer | Return Type | E A | List: 3 entries
1 | = | Items Returned to Inventory
2 | = | Damaged Items
3 | = | Price Adjustment
SHPCLRACCT | 57 | String*45 | Shipment Clearing Account | E A | Mask: %-45C
EXTCSTADJH | 58 | BCD*10.3 | Functional Adjusted Ext.Cost | E A |
EXTCSTADJS | 59 | BCD*10.3 | Source Adjusted Ext. Cost | E A |
CSTVARADJH | 60 | BCD*10.3 | Functional Adjusted Cost Variance | E A |
CSTVARADJS | 61 | BCD*10.3 | Source Adjusted Cost Variance | E A |
INVDISC | 62 | BCD*10.3 | Invoice Discount | E A |
FROMDOC | 63 | String*22 | From Document | E A |
DDTLNO | 64 | String*6 | Kit No. | E A | Mask: %-6N
VALUES | 65 | Long | Optional Fields | E A C |
TERMDISCBL | 66 | Integer | Discountable | E A | List: 2 entries
0 | = | No
1 | = | Yes
WEIGHTUNIT | 67 | String*10 | Weight Unit of Measure | E A |
DEFUWEIGHT | 68 | BCD*10.4 | Def. Weight UOM Unit Weight | E A |
DEFEXTWGHT | 69 | BCD*10.4 | Def. Weight UOM Ext. Unit Weight | E A |
PRPRICEBY | 70 | Integer | Price By | E A | List: 2 entries
1 | = | Quantity
2 | = | Weight
CAPPROVEBY | 71 | String*8 | Price Approved By | E A | Mask: %-8N
TRAMOUNT1 | 72 | BCD*10.3 | Tax Reporting Amount 1 | E A |
TRAMOUNT2 | 73 | BCD*10.3 | Tax Reporting Amount 2 | E A |
TRAMOUNT3 | 74 | BCD*10.3 | Tax Reporting Amount 3 | E A |
TRAMOUNT4 | 75 | BCD*10.3 | Tax Reporting Amount 4 | E A |
TRAMOUNT5 | 76 | BCD*10.3 | Tax Reporting Amount 5 | E A |
JOBRELATED | 77 | Boolean | Job Related | E A |
CONTRACT | 78 | String*16 | Contract Code | E A | Mask: %-16C
PROJECT | 79 | String*16 | Project Code | E A | Mask: %-16N
CCATEGORY | 80 | String*16 | Category Code | E A | Mask: %-16N
COSTCLASS | 81 | Integer | Cost Class | E A | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
PROJSTYLE | 82 | Integer | Project Style | E A | List: 3 entries
0 | = |
1 | = | Standard
2 | = | Basic
PROJTYPE | 83 | Integer | Project Type | E A | List: 4 entries
0 | = |
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
REVREC | 84 | Integer | Accounting Method | E A | List: 9 entries
0 | = |
1 | = | Completed Project
2 | = | Total Cost Percentage Complete
3 | = | Labor Hours Percentage Complete
4 | = | Billings and Costs
5 | = | Project Percentage Complete
6 | = | Category Percentage Complete
7 | = | Completed Contract
8 | = | Accrual-Basis
BILLTYPE | 85 | Integer | Billing Type | E A | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
ARITEMNO | 86 | String*16 | A/R Item Number | E A |
ARUNIT | 87 | String*10 | A/R Item Unit | E A |
RTGAMOUNT | 88 | BCD*10.3 | Retainage Amount | E A |
RTGPERCENT | 89 | BCD*5.5 | Retainage Percent | E A |
RTGDAYS | 90 | Integer | Retainage Days | E A |
RTGDATEDUE | 91 | Date | Retainage Due Date | E A |
RTGDDTOVR | 92 | Boolean | Retainage Due Date Override | E A |
RTGAMTOVR | 93 | Boolean | Retainage Amount Override | E A |
RTGTXBASE1 | 94 | BCD*10.3 | Retainage Tax Base 1 | E A |
RTGTXBASE2 | 95 | BCD*10.3 | Retainage Tax Base 2 | E A |
RTGTXBASE3 | 96 | BCD*10.3 | Retainage Tax Base 3 | E A |
RTGTXBASE4 | 97 | BCD*10.3 | Retainage Tax Base 4 | E A |
RTGTXBASE5 | 98 | BCD*10.3 | Retainage Tax Base 5 | E A |
RTGTXAMT1 | 99 | BCD*10.3 | Retainage Tax Amount 1 | E A |
RTGTXAMT2 | 100 | BCD*10.3 | Retainage Tax Amount 2 | E A |
RTGTXAMT3 | 101 | BCD*10.3 | Retainage Tax Amount 3 | E A |
RTGTXAMT4 | 102 | BCD*10.3 | Retainage Tax Amount 4 | E A |
RTGTXAMT5 | 103 | BCD*10.3 | Retainage Tax Amount 5 | E A |
OVERHDACCT | 104 | String*45 | Overhead Account | E A | Mask: %-45C
OVERHDH | 105 | BCD*10.3 | Overhead (Functional) | E A |
OVERHDS | 106 | BCD*10.3 | Overhead (Source) | E A |
LABORACCT | 107 | String*45 | Labor Account | E A | Mask: %-45C
LABORH | 108 | BCD*10.3 | Labor (Functional) | E A |
LABORS | 109 | BCD*10.3 | Labor (Source) | E A |
PMTRANSNBR | 110 | Long | PM Transaction Number | E A |

This page was generated on 2009-Nov-19

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