Table: Posting Journals - Details

Table: OEAUDD
View: OE0100
Record length: 1207
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: 114

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   

This page was generated on 2009-Nov-19

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