# View: Posting Journals

RotoID: OE0120
Tables: OEAUDH
DLL: OEAUDH

## Compositions: 2

RotoID | Title | Tables | DLL
--- | --- | --- | ---
OE0100 | Posting Journals - Details | OEAUDD | OEAUDD
OE0123 | Posting Journals Optional Fields | OEAUDHP | OEAUDHP

## Keys: 4

Title | Fields
--- | ---
Day End Number | TRANSTYPE, DAYENDNUM, ENTRYNUM
Document Number | TRANSTYPE, DOCNUM, DAYENDNUM, ENTRYNUM
Transaction Date | TRANSTYPE, TRANSDATE, DAYENDNUM, ENTRYNUM
Customer Number | TRANSTYPE, CUSTOMER, DAYENDNUM, ENTRYNUM

## Fields: 84

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
TRANSTYPE | 1 | Integer | Transaction Type | E A K R | List: 4 entries
1 | = | Invoice
2 | = | Credit Note
3 | = | Shipment
4 | = | Debit Note
DAYENDNUM | 2 | Long | Day End Number | E A K R |
ENTRYNUM | 3 | Long | Entry Number | E A K R |
PRINTED | 4 | Boolean | Printed | E A |
TRANSDATE | 5 | Date | Transaction Date | E A |
FISCYR | 6 | String*4 | Fiscal Year | E A | Mask: %-4d
FISCPER | 7 | Integer | Fiscal Period | E A |
DOCNUM | 8 | String*22 | Document Number | E A | Mask: %-22C
ARINVBATCH | 9 | BCD*5.0 | A/R Invoice Batch Number | E A |
REFERENCE | 10 | String*60 | Reference | E A |
DESC | 11 | String*60 | Description | E A |
CUSTOMER | 12 | String*12 | Customer Number | E A | Mask: %-12C
CUSTNAME | 13 | String*60 | Customer Name | E A |
TAXGROUP | 14 | String*12 | Tax Group | E A | Mask: %-12N
ORDNUMBER | 15 | String*22 | Order Number | E A | Mask: %-22C
ORDDATE | 16 | Date | Order Date | E A |
INVNUMBER | 17 | String*22 | Invoice Number | E A | Mask: %-22C
INVDATE | 18 | Date | Invoice Date | E A |
PONUMBER | 19 | String*22 | Purchase Order Number | E A | Mask: %-22C
TERRITORY | 20 | String*6 | Territory | E A | Mask: %-6N
INVDISCPER | 21 | BCD*5.5 | Discount Percentage | E A |
INVDISCAMT | 22 | BCD*10.3 | Discount Amount | E A |
INSOURCURR | 23 | String*3 | Invoice Currency | E A | Mask: %-3N
INRATE | 24 | BCD*8.7 | Invoice Exchange Rate | E A |
INRATETYPE | 25 | String*2 | Invoice Rate Type | E A | Mask: %-2N
INRATEDATE | 26 | Date | Invoice Rate Date | 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 | Customer Tax Class 1 | E A |
TCLASS2 | 33 | Integer | Customer Tax Class 2 | E A |
TCLASS3 | 34 | Integer | Customer Tax Class 3 | E A |
TCLASS4 | 35 | Integer | Customer Tax Class 4 | E A |
TCLASS5 | 36 | Integer | Customer Tax Class 5 | E A |
TBASE1 | 37 | BCD*10.3 | Tax Base 1 | E A |
TBASE2 | 38 | BCD*10.3 | Tax Base 2 | E A |
TBASE3 | 39 | BCD*10.3 | Tax Base 3 | E A |
TBASE4 | 40 | BCD*10.3 | Tax Base 4 | E A |
TBASE5 | 41 | BCD*10.3 | Tax Base 5 | E A |
TAMOUNT1H | 42 | BCD*10.3 | Tax Amount 1 - Functional | E A |
TAMOUNT2H | 43 | BCD*10.3 | Tax Amount 2 - Functional | E A |
TAMOUNT3H | 44 | BCD*10.3 | Tax Amount 3 - Functional | E A |
TAMOUNT4H | 45 | BCD*10.3 | Tax Amount 4 - Functional | E A |
TAMOUNT5H | 46 | BCD*10.3 | Tax Amount 5 - Functional | E A |
TINAMT1S | 47 | BCD*10.3 | Tax Included Amount 1 - Source | E A |
TINAMT2S | 48 | BCD*10.3 | Tax Included Amount 2 - Source | E A |
TINAMT3S | 49 | BCD*10.3 | Tax Included Amount 3 - Source | E A |
TINAMT4S | 50 | BCD*10.3 | Tax Included Amount 4 - Source | E A |
TINAMT5S | 51 | BCD*10.3 | Tax Included Amount 5 - Source | E A |
TEXAMT1S | 52 | BCD*10.3 | Tax Excluded Amount 1 - Source | E A |
TEXAMT2S | 53 | BCD*10.3 | Tax Excluded Amount 2 - Source | E A |
TEXAMT3S | 54 | BCD*10.3 | Tax Excluded Amount 3 - Source | E A |
TEXAMT4S | 55 | BCD*10.3 | Tax Excluded Amount 4 - Source | E A |
TEXAMT5S | 56 | BCD*10.3 | Tax Excluded Amount 5 - Source | E A |
TACCT1 | 57 | String*45 | Tax G/L Account 1 | E A | Mask: %-45C
TACCT2 | 58 | String*45 | Tax G/L Account 2 | E A | Mask: %-45C
TACCT3 | 59 | String*45 | Tax G/L Account 3 | E A | Mask: %-45C
TACCT4 | 60 | String*45 | Tax G/L Account 4 | E A | Mask: %-45C
TACCT5 | 61 | String*45 | Tax G/L Account 5 | E A | Mask: %-45C
INVNETH | 62 | BCD*10.3 | Net Invoice Amount (Functional) | E A |
INVNETS | 63 | BCD*10.3 | Net Invoice Amount (Source) | E A |
ARRECBATCH | 64 | BCD*5.0 | A/R Receipts Batch Number | E A |
CHECKDATE | 65 | Date | Receipt Date | E A |
CHECKNUM | 66 | String*24 | Check/Receipt Number | E A |
PAYMENT | 67 | BCD*10.3 | Check Amount | E A |
PASOURCURR | 68 | String*3 | Receipt Currency | E A | Mask: %-3N
PARATETYPE | 69 | String*2 | Receipt Rate Type | E A | Mask: %-2N
PARATE | 70 | BCD*8.7 | Receipt Exchange Rate | E A |
PARATEDATE | 71 | Date | Receipt Rate Date | E A |
SALESPER1 | 72 | String*8 | Salesperson 1 | E A | Mask: %-8N
SALESPER2 | 73 | String*8 | Salesperson 2 | E A | Mask: %-8N
SALESPER3 | 74 | String*8 | Salesperson 3 | E A | Mask: %-8N
SALESPER4 | 75 | String*8 | Salesperson 4 | E A | Mask: %-8N
SALESPER5 | 76 | String*8 | Salesperson 5 | E A | Mask: %-8N
SALESPLT1 | 77 | BCD*5.5 | Sales Percentage 1 | E A |
SALESPLT2 | 78 | BCD*5.5 | Sales Percentage 2 | E A |
SALESPLT3 | 79 | BCD*5.5 | Sales Percentage 3 | E A |
SALESPLT4 | 80 | BCD*5.5 | Sales Percentage 4 | E A |
SALESPLT5 | 81 | BCD*5.5 | Sales Percentage 5 | E A |
POSTDATE | 82 | Date | Posting Date | E A |
MULTIDOC | 83 | Boolean | Multiple Documents | E A |
VALUES | 84 | Long | Optional Fields | E A C |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.