Table: Posting Journals - Details

Table: OEAUDD
View: OE0100
Record Length: 1237

Flags: A R 

Keys: 2

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

Fields: 115

Field Type Title Presentation
TRANSTYPE Integer Transaction Type List:5 entries
1 = Invoice
2 = Credit Note
3 = Shipment
4 = Debit Note
5 = Order
DAYENDNUM Long Day End Number
ENTRYNUM Long Entry Number
LINENUM Integer Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
LINETYPE Integer Line Type List:2 entries
1 = Item
2 = Miscellaneous
ITEM String*24 Item Number
MISCCHARGE String*6 Miscellaneous Charge Code
DESC String*60 Description
PRICELIST String*6 Price List
CATEGORY String*6 Category Mask: %-6N
LOCATION String*6 Location Mask: %-6N
QTYSHIPPED BCD*10.4 Quantity Shipped
INVUNIT String*10 Unit of Measure
UNITPRICE BCD*10.6 Unit Price
PRICEOVER Boolean Price Override
UNITCOST BCD*10.6 Unit Cost
EXTCOSTH BCD*10.3 Extended Cost (Functional)
EXTCOSTS BCD*10.3 Extended Cost (Source)
COSTVARH BCD*10.3 Cost Variance (Functional)
COSTVARS BCD*10.3 Cost Variance (Source)
EXTOVER Boolean Extended Amount Override
EXTINVMISC BCD*10.3 Extended Amount
REVAMTH BCD*10.3 Revenue (Functional)
REVAMTS BCD*10.3 Revenue (Source)
UNITWEIGHT BCD*10.4 Unit Weight
EXTWEIGHT BCD*10.4 Extended Weight
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
TINCLUDED1 Boolean Tax Included 1
TINCLUDED2 Boolean Tax Included 2
TINCLUDED3 Boolean Tax Included 3
TINCLUDED4 Boolean Tax Included 4
TINCLUDED5 Boolean Tax Included 5
TBASE1 BCD*10.3 Tax Base 1
TBASE2 BCD*10.3 Tax Base 2
TBASE3 BCD*10.3 Tax Base 3
TBASE4 BCD*10.3 Tax Base 4
TBASE5 BCD*10.3 Tax Base 5
TAMOUNT1 BCD*10.3 Tax Amount 1
TAMOUNT2 BCD*10.3 Tax Amount 2
TAMOUNT3 BCD*10.3 Tax Amount 3
TAMOUNT4 BCD*10.3 Tax Amount 4
TAMOUNT5 BCD*10.3 Tax Amount 5
REVENUACCT String*45 Revenue Account Mask: %-45C
COGSACCT String*45 Cost of Goods Sold Account Mask: %-45C
VARIANACCT String*45 Variance Account Mask: %-45C
INVACCT String*45 Inventory Control Account Mask: %-45C
RETURNTYPE Integer Return Type List:3 entries
1 = Items Returned to Inventory
2 = Damaged Items
3 = Price Adjustment
SHPCLRACCT String*45 Shipment Clearing Account Mask: %-45C
EXTCSTADJH BCD*10.3 Functional Adjusted Ext.Cost
EXTCSTADJS BCD*10.3 Source Adjusted Ext. Cost
CSTVARADJH BCD*10.3 Functional Adjusted Cost Variance
CSTVARADJS BCD*10.3 Source Adjusted Cost Variance
INVDISC BCD*10.3 Invoice Discount
FROMDOC String*22 From Document
DDTLNO String*6 Kit No. Mask: %-6N
VALUES Long Optional Fields
TERMDISCBL Integer Discountable List:2 entries
0 = No
1 = Yes
WEIGHTUNIT String*10 Weight Unit of Measure
DEFUWEIGHT BCD*10.4 Def. Weight UOM Unit Weight
DEFEXTWGHT BCD*10.4 Def. Weight UOM Ext. Unit Weight
PRPRICEBY Integer Price By List:2 entries
1 = Quantity
2 = Weight
CAPPROVEBY String*8 Price Approved By Mask: %-8N
TRAMOUNT1 BCD*10.3 Tax Reporting Amount 1
TRAMOUNT2 BCD*10.3 Tax Reporting Amount 2
TRAMOUNT3 BCD*10.3 Tax Reporting Amount 3
TRAMOUNT4 BCD*10.3 Tax Reporting Amount 4
TRAMOUNT5 BCD*10.3 Tax Reporting Amount 5
JOBRELATED Boolean Job Related
CONTRACT String*16 Contract Code Mask: %-16C
PROJECT String*16 Project Code Mask: %-16N
CCATEGORY String*16 Category Code Mask: %-16N
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
PROJSTYLE Integer Project Style List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE Integer Project Type List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC Integer Accounting Method 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 Integer Billing Type List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
ARITEMNO String*16 A/R Item Number
ARUNIT String*10 A/R Item Unit
RTGAMOUNT BCD*10.3 Retainage Amount
RTGPERCENT BCD*5.5 Retainage Percent
RTGDAYS Integer Retainage Days
RTGDATEDUE Date Retainage Due Date
RTGDDTOVR Boolean Retainage Due Date Override
RTGAMTOVR Boolean Retainage Amount Override
RTGTXBASE1 BCD*10.3 Retainage Tax Base 1
RTGTXBASE2 BCD*10.3 Retainage Tax Base 2
RTGTXBASE3 BCD*10.3 Retainage Tax Base 3
RTGTXBASE4 BCD*10.3 Retainage Tax Base 4
RTGTXBASE5 BCD*10.3 Retainage Tax Base 5
RTGTXAMT1 BCD*10.3 Retainage Tax Amount 1
RTGTXAMT2 BCD*10.3 Retainage Tax Amount 2
RTGTXAMT3 BCD*10.3 Retainage Tax Amount 3
RTGTXAMT4 BCD*10.3 Retainage Tax Amount 4
RTGTXAMT5 BCD*10.3 Retainage Tax Amount 5
OVERHDACCT String*45 Overhead Account Mask: %-45C
OVERHDH BCD*10.3 Overhead (Functional)
OVERHDS BCD*10.3 Overhead (Source)
LABORACCT String*45 Labor Account Mask: %-45C
LABORH BCD*10.3 Labor (Functional)
LABORS BCD*10.3 Labor (Source)
PMTRANSNBR Long PM Transaction Number
EDN String*30 Export Declaration Number

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