View: Posting Journals

RotoID: OE0120
Table: OEAUDH
Protocol: Header
DLL:OEAUDH

Compositions: 2

RotoID Tables Title DLL
OE0100 OEAUDD Posting Journals - Details OEAUDD
OE0123 OEAUDHP Posting Journals Optional Fields 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: 110

Field Index Type Title Attributes Presentation
TRANSTYPE 1 Integer Transaction Type E A K R  List:5 entries
1 = Invoice
2 = Credit Note
3 = Shipment
4 = Debit Note
5 = Order
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 
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 
TRCURRENCY 85 String*3 Tax Reporting Currency E A  Mask: %-3N
TRRATE 86 BCD*8.7 Tax Reporting Currency Rate E A 
TRRATETYPE 87 String*2 Tax Reporting Currency Type E A  Mask: %-2N
TRRATEDATE 88 Date Tax Reporting Currency Date E A 
TREAMOUNT1 89 BCD*10.3 TRC Excluded Amount 1 E A 
TREAMOUNT2 90 BCD*10.3 TRC Excluded Amount 2 E A 
TREAMOUNT3 91 BCD*10.3 TRC Excluded Amount 3 E A 
TREAMOUNT4 92 BCD*10.3 TRC Excluded Amount 4 E A 
TREAMOUNT5 93 BCD*10.3 TRC Excluded Amount 5 E A 
TRIAMOUNT1 94 BCD*10.3 TRC Included Amount 1 E A 
TRIAMOUNT2 95 BCD*10.3 TRC Included Amount 2 E A 
TRIAMOUNT3 96 BCD*10.3 TRC Included Amount 3 E A 
TRIAMOUNT4 97 BCD*10.3 TRC Included Amount 4 E A 
TRIAMOUNT5 98 BCD*10.3 TRC Included Amount 5 E A 
CUSACCTSET 99 String*6 Customer Account Set E A  Mask: %-6N
JOBLINES 100 Long Job Related Detail Lines E A 
LNINVABLE 101 Long Invoiceable Detail Lines E A 
HASRTG 102 Boolean Has Retainage E A  List:2 entries
0 = No
1 = Yes
RTGTERMS 103 String*6 Retainage Terms E A  Mask: %-6N
RTGAMOUNT 104 BCD*10.3 Retainage Amount E A 
RTGPERCENT 105 BCD*5.5 Retainage Percent E A 
RTGRATE 106 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGTXBASE1 107 BCD*10.3 Retainage Tax Base 1 E A 
RTGTXBASE2 108 BCD*10.3 Retainage Tax Base 2 E A 
RTGTXBASE3 109 BCD*10.3 Retainage Tax Base 3 E A 
RTGTXBASE4 110 BCD*10.3 Retainage Tax Base 4 E A 
RTGTXBASE5 111 BCD*10.3 Retainage Tax Base 5 E A 
RTGTXAMT1 112 BCD*10.3 Retainage Tax Amount 1 E A 
RTGTXAMT2 113 BCD*10.3 Retainage Tax Amount 2 E A 
RTGTXAMT3 114 BCD*10.3 Retainage Tax Amount 3 E A 
RTGTXAMT4 115 BCD*10.3 Retainage Tax Amount 4 E A 
RTGTXAMT5 116 BCD*10.3 Retainage Tax Amount 5 E A 
DATEBUS 117 Date Posting Date E A 
EDN 118 String*30 Export Declaration Number E A 

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