Table: Posting Journals

Table: OEAUDH
View: OE0120
Record length: 1246
Flags: A R 

Keys: 4

Title  Flags  Fields

Day End Number  TRANSTYPE, DAYENDNUM, ENTRYNUM
Document Number  D  TRANSTYPE, DOCNUM, DAYENDNUM, ENTRYNUM
Transaction Date  D  TRANSTYPE, TRANSDATE, DAYENDNUM, ENTRYNUM
Customer Number  D  TRANSTYPE, CUSTOMER, DAYENDNUM, ENTRYNUM

Fields: 113

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   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
PRINTED  Boolean  Printed   
TRANSDATE  Date  Transaction Date   
FISCYR  String*4  Fiscal Year  Mask: %-4d
FISCPER  Integer  Fiscal Period   
DOCNUM  String*22  Document Number  Mask: %-22C
ARINVBATCH  BCD*5.0  A/R Invoice Batch Number   
REFERENCE  String*60  Reference   
DESC  String*60  Description   
CUSTOMER  String*12  Customer Number  Mask: %-12C
CUSTNAME  String*60  Customer Name   
TAXGROUP  String*12  Tax Group  Mask: %-12N
ORDNUMBER  String*22  Order Number  Mask: %-22C
ORDDATE  Date  Order Date   
INVNUMBER  String*22  Invoice Number  Mask: %-22C
INVDATE  Date  Invoice Date   
PONUMBER  String*22  Purchase Order Number  Mask: %-22C
TERRITORY  String*6  Territory  Mask: %-6N
INVDISCPER  BCD*5.5  Discount Percentage   
INVDISCAMT  BCD*10.3  Discount Amount   
INSOURCURR  String*3  Invoice Currency  Mask: %-3N
INRATE  BCD*8.7  Invoice Exchange Rate   
INRATETYPE  String*2  Invoice Rate Type  Mask: %-2N
INRATEDATE  Date  Invoice Rate Date   
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  Customer Tax Class 1   
TCLASS2  Integer  Customer Tax Class 2   
TCLASS3  Integer  Customer Tax Class 3   
TCLASS4  Integer  Customer Tax Class 4   
TCLASS5  Integer  Customer Tax Class 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   
TAMOUNT1H  BCD*10.3  Tax Amount 1 - Functional   
TAMOUNT2H  BCD*10.3  Tax Amount 2 - Functional   
TAMOUNT3H  BCD*10.3  Tax Amount 3 - Functional   
TAMOUNT4H  BCD*10.3  Tax Amount 4 - Functional   
TAMOUNT5H  BCD*10.3  Tax Amount 5 - Functional   
TINAMT1S  BCD*10.3  Tax Included Amount 1 - Source   
TINAMT2S  BCD*10.3  Tax Included Amount 2 - Source   
TINAMT3S  BCD*10.3  Tax Included Amount 3 - Source   
TINAMT4S  BCD*10.3  Tax Included Amount 4 - Source   
TINAMT5S  BCD*10.3  Tax Included Amount 5 - Source   
TEXAMT1S  BCD*10.3  Tax Excluded Amount 1 - Source   
TEXAMT2S  BCD*10.3  Tax Excluded Amount 2 - Source   
TEXAMT3S  BCD*10.3  Tax Excluded Amount 3 - Source   
TEXAMT4S  BCD*10.3  Tax Excluded Amount 4 - Source   
TEXAMT5S  BCD*10.3  Tax Excluded Amount 5 - Source   
TACCT1  String*45  Tax G/L Account 1  Mask: %-45C
TACCT2  String*45  Tax G/L Account 2  Mask: %-45C
TACCT3  String*45  Tax G/L Account 3  Mask: %-45C
TACCT4  String*45  Tax G/L Account 4  Mask: %-45C
TACCT5  String*45  Tax G/L Account 5  Mask: %-45C
INVNETH  BCD*10.3  Net Invoice Amount (Functional)   
INVNETS  BCD*10.3  Net Invoice Amount (Source)   
SALESPER1  String*8  Salesperson 1  Mask: %-8N
SALESPER2  String*8  Salesperson 2  Mask: %-8N
SALESPER3  String*8  Salesperson 3  Mask: %-8N
SALESPER4  String*8  Salesperson 4  Mask: %-8N
SALESPER5  String*8  Salesperson 5  Mask: %-8N
SALESPLT1  BCD*5.5  Sales Percentage 1   
SALESPLT2  BCD*5.5  Sales Percentage 2   
SALESPLT3  BCD*5.5  Sales Percentage 3   
SALESPLT4  BCD*5.5  Sales Percentage 4   
SALESPLT5  BCD*5.5  Sales Percentage 5   
POSTDATE  Date  Posting Date   
MULTIDOC  Boolean  Multiple Documents   
VALUES  Long  Optional Fields   
TRCURRENCY  String*3  Tax Reporting Currency  Mask: %-3N
TRRATE  BCD*8.7  Tax Reporting Currency Rate   
TRRATETYPE  String*2  Tax Reporting Currency Type  Mask: %-2N
TRRATEDATE  Date  Tax Reporting Currency Date   
TREAMOUNT1  BCD*10.3  TRC Excluded Amount 1   
TREAMOUNT2  BCD*10.3  TRC Excluded Amount 2   
TREAMOUNT3  BCD*10.3  TRC Excluded Amount 3   
TREAMOUNT4  BCD*10.3  TRC Excluded Amount 4   
TREAMOUNT5  BCD*10.3  TRC Excluded Amount 5   
TRIAMOUNT1  BCD*10.3  TRC Included Amount 1   
TRIAMOUNT2  BCD*10.3  TRC Included Amount 2   
TRIAMOUNT3  BCD*10.3  TRC Included Amount 3   
TRIAMOUNT4  BCD*10.3  TRC Included Amount 4   
TRIAMOUNT5  BCD*10.3  TRC Included Amount 5   
CUSACCTSET  String*6  Customer Account Set  Mask: %-6N
JOBLINES  Long  Job Related Detail Lines   
LNINVABLE  Long  Invoiceable Detail Lines   
HASRTG  Boolean  Has Retainage  List: 2 entries
0=No
1=Yes
RTGTERMS  String*6  Retainage Terms  Mask: %-6N
RTGAMOUNT  BCD*10.3  Retainage Amount   
RTGPERCENT  BCD*5.5  Retainage Percent   
RTGRATE  Integer  Retainage Exchange Rate  List: 2 entries
0=Use Original Document Exchange Rate
1=Use Current Exchange Rate
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   
DATEBUS  Date  Posting Date   

This page was generated on 2009-Nov-19

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