# Table: Posting Journals

Table: OEAUDH
View: OE0120
Record length: 1164
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: 102

Field | Type | Title | Presentation
--- | --- | --- | ---
TRANSTYPE | Integer | Transaction Type | List: 4 entries
1 | = | Invoice
2 | = | Credit Note
3 | = | Shipment
4 | = | Debit Note
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) |
ARRECBATCH | BCD*5.0 | A/R Receipts Batch Number |
CHECKDATE | Date | Receipt Date |
CHECKNUM | String*24 | Check/Receipt Number |
PAYMENT | BCD*10.3 | Check Amount |
PASOURCURR | String*3 | Receipt Currency | Mask: %-3N
PARATETYPE | String*2 | Receipt Rate Type | Mask: %-2N
PARATE | BCD*8.7 | Receipt Exchange Rate |
PARATEDATE | Date | Receipt Rate Date |
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 |  | Mask: %-3N
TRRATE | BCD*8.7 |  |
TRRATETYPE | String*2 |  | Mask: %-2N
TRRATEDATE | Date |  |
TREAMOUNT1 | BCD*10.3 |  |
TREAMOUNT2 | BCD*10.3 |  |
TREAMOUNT3 | BCD*10.3 |  |
TREAMOUNT4 | BCD*10.3 |  |
TREAMOUNT5 | BCD*10.3 |  |
TRIAMOUNT1 | BCD*10.3 |  |
TRIAMOUNT2 | BCD*10.3 |  |
TRIAMOUNT3 | BCD*10.3 |  |
TRIAMOUNT4 | BCD*10.3 |  |
TRIAMOUNT5 | BCD*10.3 |  |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.