View: Invoices

RotoID: AR0032
Table: ARIBH
Protocol: Header, Key auto generate
DLL:ARIBH

Compositions: 5

RotoID Tables Title DLL
AR0031 ARIBC Invoice Batches ARIBC
AR0033 ARIBD Invoice Details ARIBD
AR0034 ARIBS Invoice Payment Schedules ARIBS
AR0402 ARIBHO Invoice Optional Fields ARIBHO
AR0160 Customer Balances ARCBAL

Keys: 3

Title Fields
Invoice Entry Number CNTBTCH, CNTITEM
Customer Number / Document Numbe IDCUST, IDINVC
Document Number IDINVC

Fields: 194

Field Index Type Title Attributes Presentation
CNTBTCH 1 BCD*5.0 Batch Number E A K R 
CNTITEM 2 BCD*4.0 Entry Number E A K R 
IDCUST 3 String*12 Customer Number E A  Mask: %-12C
IDINVC 4 String*22 Document Number E A  Mask: %-22C
IDSHPT 5 String*6 Ship-To Location Code E A  Mask: %-6C
SHIPVIA 6 String*15 Reserved E 
SPECINST 7 String*60 Special Instructions E A 
TEXTTRX 8 Integer Document Type E A P  List:3 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
IDTRX 9 Integer Transaction Type E A C  List:14 entries
11 = Invoice - Item Issued
12 = Invoice - Summary Entered
13 = Invoice - Recurring Charge
14 = Invoice - Summary Issued
15 = Invoice - Item Entered
21 = Debit Note - Item Issued
22 = Debit Note - Summary Entered
24 = Debit Note - Summary Issued
25 = Debit Note - Item Entered
31 = Credit Note - Item Issued
32 = Credit Note - Summary Entered
34 = Credit Note - Summary Issued
35 = Credit Note - Item Entered
40 = Interest Charge
INVCSTTS 10 Integer Reserved E 
ORDRNBR 11 String*22 Order Number E A  Mask: %-22C
CUSTPO 12 String*22 PO Number E A  Mask: %-22C
JOBNBR 13 String*15 Reserved E 
INVCDESC 14 String*60 Invoice Description E A 
SWPRTINVC 15 Integer Invoice Printed E A  List:2 entries
0 = No
1 = Yes
INVCAPPLTO 16 String*22 Apply-to Document E A  Mask: %-22C
IDACCTSET 17 String*6 Account Set E A  Mask: %-6N
DATEINVC 18 Date Document Date E A 
DATEASOF 19 Date As of Date E A 
FISCYR 20 String*4 Fiscal Year A C  Mask: %04D
FISCPER 21 String*2 Fiscal Period A C  Mask: %02D
CODECURN 22 String*3 Currency Code E A  Mask: %-3N
RATETYPE 23 String*2 Rate Type E A  Mask: %-2N
SWMANRTE 24 Integer Rate Overridden E A  List:2 entries
0 = No
1 = Yes
EXCHRATEHC 25 BCD*8.7 Exchange Rate E A 
ORIGRATEHC 26 BCD*8.7 Apply-to Exchange Rate E A 
TERMCODE 27 String*6 Terms E A  Mask: %-6N
SWTERMOVRD 28 Integer Terms Code Overridden E A  List:2 entries
0 = No
1 = Yes
DATEDUE 29 Date Due Date E A 
DATEDISC 30 Date Discount Date E A 
PCTDISC 31 BCD*5.5 Discount Percentage E A 
AMTDISCAVL 32 BCD*10.3 Discount Amount Available E A 
LASTLINE 33 BCD*3.0 Number of Details E A C 
CODESLSP1 34 String*8 Salesperson 1 E A  Mask: %-8N
CODESLSP2 35 String*8 Salesperson 2 E A  Mask: %-8N
CODESLSP3 36 String*8 Salesperson 3 E A  Mask: %-8N
CODESLSP4 37 String*8 Salesperson 4 E A  Mask: %-8N
CODESLSP5 38 String*8 Salesperson 5 E A  Mask: %-8N
PCTSASPLT1 39 BCD*5.5 Sales-Split Percentage 1 E A 
PCTSASPLT2 40 BCD*5.5 Sales-Split Percentage 2 E A 
PCTSASPLT3 41 BCD*5.5 Sales-Split Percentage 3 E A 
PCTSASPLT4 42 BCD*5.5 Sales-Split Percentage 4 E A 
PCTSASPLT5 43 BCD*5.5 Sales-Split Percentage 5 E A 
SWTAXBL 44 Integer Taxable E A C  List:2 entries
0 = No
1 = Yes
SWMANTX 45 Integer Do Not Calc. Tax E A  List:2 entries
0 = No
1 = Yes
CODETAXGRP 46 String*12 Tax Group E A  Mask: %-12N
CODETAX1 47 String*12 Tax Authority 1 E A C  Mask: %-12N
CODETAX2 48 String*12 Tax Authority 2 E A C  Mask: %-12N
CODETAX3 49 String*12 Tax Authority 3 E A C  Mask: %-12N
CODETAX4 50 String*12 Tax Authority 4 E A C  Mask: %-12N
CODETAX5 51 String*12 Tax Authority 5 E A C  Mask: %-12N
TAXSTTS1 52 Integer Tax Class 1 E A 
TAXSTTS2 53 Integer Tax Class 2 E A 
TAXSTTS3 54 Integer Tax Class 3 E A 
TAXSTTS4 55 Integer Tax Class 4 E A 
TAXSTTS5 56 Integer Tax Class 5 E A 
BASETAX1 57 BCD*10.3 Tax Base 1 E A 
BASETAX2 58 BCD*10.3 Tax Base 2 E A 
BASETAX3 59 BCD*10.3 Tax Base 3 E A 
BASETAX4 60 BCD*10.3 Tax Base 4 E A 
BASETAX5 61 BCD*10.3 Tax Base 5 E A 
AMTTAX1 67 BCD*10.3 Tax Amount 1 E A 
AMTTAX2 68 BCD*10.3 Tax Amount 2 E A 
AMTTAX3 69 BCD*10.3 Tax Amount 3 E A 
AMTTAX4 70 BCD*10.3 Tax Amount 4 E A 
AMTTAX5 71 BCD*10.3 Tax Amount 5 E A 
AMTTXBL 80 BCD*10.3 Taxable Amount E A C 
AMTNOTTXBL 81 BCD*10.3 Non-Taxable Amount E A C 
AMTTAXTOT 82 BCD*10.3 Tax Total E A C 
AMTINVCTOT 83 BCD*10.3 Document Total Before Tax E A C 
AMTPPD 84 BCD*10.3 Prepayment Amount E A C 
AMTPAYMTOT 85 BCD*3.0 Number of Scheduled Payments E A C 
AMTPYMSCHD 86 BCD*10.3 Total Payment Amount Scheduled E A C 
AMTNETTOT 87 BCD*10.3 Document Total Including Tax E A C 
IDSTDINVC 88 String*16 Recurring Charge Code E A C 
DATEPRCS 89 Date Date Generated E A C 
IDPPD 90 String*22 Prepayment Number E A C  Mask: %-22C
IDBILL 91 String*6 Recurring Billing Cycle E A 
SHPTOLOC 92 String*60 Ship-To Location Name E A 
SHPTOSTE1 93 String*60 Ship-To Address Line 1 E A 
SHPTOSTE2 94 String*60 Ship-To Address Line 2 E A 
SHPTOSTE3 95 String*60 Ship-To Address Line 3 E A 
SHPTOSTE4 96 String*60 Ship-To Address Line 4 E A 
SHPTOCITY 97 String*30 Ship-To City E A 
SHPTOSTTE 98 String*30 Ship-To State/Prov. E A 
SHPTOPOST 99 String*20 Ship-To Zip/Postal Code E A 
SHPTOCTRY 100 String*30 Ship-To Country E A 
SHPTOCTAC 101 String*60 Ship-To Contact Name E A 
SHPTOPHON 102 String*30 Ship-To Phone Number E A P  Mask: (%-3C) %-3C-%-24C
SHPTOFAX 103 String*30 Ship-To Fax Number E A P  Mask: (%-3C) %-3C-%-24C
DATERATE 104 Date Rate Date E A 
SWPROCPPD 105 Integer Cust/Natl Over Credit Flag E A C  List:4 entries
0 = Neither over credit limit
1 = Customer over credit limit
2 = National over credit limit
3 = Both over credit limit
AMTDUE 106 BCD*10.3 Amount Due E A C 
CREATESCHD 107 Integer Reserved E 
CUROPER 108 Integer Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
DRILLAPP 109 String*2 Drill Down Application Source E A  Mask: %-2A
DRILLTYPE 110 Integer Drill Down Type E A 
DRILLDWNLK 111 BCD*10.0 Drill Down Link Number E A 
TAXRECALC 112 Integer Reserved E 
GETIBSINFO 113 Integer Force Re-read of IBS Totals E A C 
PROCESSCMD 114 Integer Process Command E A C  List:11 entries
0 = Calculate Taxes
1 = Distribute Taxes
2 = Sum Taxes
3 = Total Taxes
4 = Insert Optional Fields
5 = Derive Tax Reporting Exchange Rate
8 = Enable Rate Lookup
9 = Disable Rate Lookup
10 = Enable Tax Reporting Rate Lookup
11 = Disable Tax Reporting Rate Lookup
12 = Process OE invoice for DEP
SHPVIACODE 115 String*6 Ship Via Code E A  Mask: %-6N
SHPVIADESC 116 String*60 Ship Via Description E A 
PRPTYCODE 117 Integer Property Code E A C  List:1 entries
1 = Mode: Normal(1), Batch(2)
PRPTYVALUE 118 Long Property Value E A C 
SWJOB 119 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
ERRBATCH 120 Long Error Batch E A C 
ERRENTRY 121 Long Error Entry E A C 
EMAIL 122 String*50 Ship-To E-mail E A 
CTACPHONE 123 String*30 Ship-To Contact's Phone E A P  Mask: (%-3C) %-3C-%-24C
CTACFAX 124 String*30 Ship-To Contact's Fax E A P  Mask: (%-3C) %-3C-%-24C
CTACEMAIL 125 String*50 Ship-To Contact's E-mail E A 
AMTDSBWTAX 126 BCD*10.3 Discount Base With Tax E A C 
AMTDSBNTAX 127 BCD*10.3 Discount Base Without Tax E A C 
AMTDSCBASE 128 BCD*10.3 Discount Base E A 
INVCTYPE 129 Integer Invoice Type E A  List:2 entries
1 = Item
2 = Summary
SWRTGINVC 130 Integer Retainage Invoice E A  List:2 entries
0 = No
1 = Yes
RTGAPPLYTO 131 String*22 Original Doc. No. E A  Mask: %-22C
SWRTG 132 Integer Has Retainage E A  List:2 entries
0 = No
1 = Yes
RTGAMT 133 BCD*10.3 Retainage Amount E A 
RTGPERCENT 134 BCD*5.5 Percent Retained E A 
RTGDAYS 135 Integer Days Retained E A 
RTGDATEDUE 136 Date Retainage Due Date E A 
RTGTERMS 137 String*6 Retainage Terms Code E A  Mask: %-6N
SWRTGDDTOV 138 Integer Retainage Due Date Override E A  List:2 entries
0 = No
1 = Yes
SWRTGAMTOV 139 Integer Retainage Amount Override E A  List:2 entries
0 = No
1 = Yes
SWRTGRATE 140 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
VALUES 141 Long Optional Fields E A C 
SRCEAPPL 142 String*2 Source Application E A  Mask: %-2A
ARVERSION 143 String*3 A/R Version Created In E A C 
TAXVERSION 144 Long Tax State Version E A C 
SWTXRTGRPT 145 Integer Report Retainage Tax E A C 
CODECURNRC 146 String*3 Tax Reporting Currency Code E A  Mask: %-3N
SWTXCTLRC 147 Integer Tax Reporting Calculate Method E A  List:2 entries
0 = No
1 = Yes
RATERC 148 BCD*8.7 Tax Reporting Exchange Rate E A 
RATETYPERC 149 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEDATERC 150 Date Tax Reporting Rate Date E A 
RATEOPRC 151 Integer Tax Reporting Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
SWRATERC 152 Integer Tax Reporting Rate Override E A C  List:2 entries
0 = No
1 = Yes
TXAMT1RC 153 BCD*10.3 Tax Reporting Amount 1 E A 
TXAMT2RC 154 BCD*10.3 Tax Reporting Amount 2 E A 
TXAMT3RC 155 BCD*10.3 Tax Reporting Amount 3 E A 
TXAMT4RC 156 BCD*10.3 Tax Reporting Amount 4 E A 
TXAMT5RC 157 BCD*10.3 Tax Reporting Amount 5 E A 
TXTOTRC 158 BCD*10.3 Tax Reporting Total E A C 
TXBSERT1TC 159 BCD*10.3 Retainage Tax Base 1 E A 
TXBSERT2TC 160 BCD*10.3 Retainage Tax Base 2 E A 
TXBSERT3TC 161 BCD*10.3 Retainage Tax Base 3 E A 
TXBSERT4TC 162 BCD*10.3 Retainage Tax Base 4 E A 
TXBSERT5TC 163 BCD*10.3 Retainage Tax Base 5 E A 
TXAMTRT1TC 164 BCD*10.3 Retainage Tax Amount 1 E A 
TXAMTRT2TC 165 BCD*10.3 Retainage Tax Amount 2 E A 
TXAMTRT3TC 166 BCD*10.3 Retainage Tax Amount 3 E A 
TXAMTRT4TC 167 BCD*10.3 Retainage Tax Amount 4 E A 
TXAMTRT5TC 168 BCD*10.3 Retainage Tax Amount 5 E A 
TXBSE1HC 169 BCD*10.3 Func. Tax Base 1 E A C 
TXBSE2HC 170 BCD*10.3 Func. Tax Base 2 E A C 
TXBSE3HC 171 BCD*10.3 Func. Tax Base 3 E A C 
TXBSE4HC 172 BCD*10.3 Func. Tax Base 4 E A C 
TXBSE5HC 173 BCD*10.3 Func. Tax Base 5 E A C 
TXAMT1HC 174 BCD*10.3 Func. Tax Amount 1 E A C 
TXAMT2HC 175 BCD*10.3 Func. Tax Amount 2 E A C 
TXAMT3HC 176 BCD*10.3 Func. Tax Amount 3 E A C 
TXAMT4HC 177 BCD*10.3 Func. Tax Amount 4 E A C 
TXAMT5HC 178 BCD*10.3 Func. Tax Amount 5 E A C 
AMTGROSHC 179 BCD*10.3 Func. Distribution w/ Tax Total E A C 
RTGAMTHC 180 BCD*10.3 Func. Retainage Amount E A C 
AMTDISCHC 181 BCD*10.3 Func. Discount Amount E A C 
DISTNETHC 182 BCD*10.3 Func. Distribution w/o Tax Total E A C 
AMTPPDHC 183 BCD*10.3 Func. Prepayment Amount E A C 
AMTDUEHC 184 BCD*10.3 Func. Amount Due E A C 
SWPRTLBL 185 Integer Label Printed E A  List:2 entries
0 = No
1 = Yes
TXTOTRTTC 186 BCD*10.3 Retainage Tax Total E A C 
TXTOTAMT1 187 BCD*10.3 Tax Amount 1 Total E A C 
TXTOTAMT2 188 BCD*10.3 Tax Amount 2 Total E A C 
TXTOTAMT3 189 BCD*10.3 Tax Amount 3 Total E A C 
TXTOTAMT4 190 BCD*10.3 Tax Amount 4 Total E A C 
TXTOTAMT5 191 BCD*10.3 Tax Amount 5 Total E A C 
RTGAMTDTL 192 BCD*10.3 Retainage Amount from Details E A C 
IDSHIPNBR 193 String*22 Shipment Number E A  Mask: %-22C
SWOECOST 194 Integer Do O/E Costing and Consolidation E A  List:2 entries
0 = No
1 = Yes
ENTEREDBY 195 String*8 Entered By E A C 
DATEBUS 196 Date Posting Date E A 
EDN 197 String*30 Export Declaration Number E A 
AMTWHT1TC 198 BCD*10.3 Estimated Tax Withheld Amount 1 E A C 
AMTWHT2TC 199 BCD*10.3 Estimated Tax Withheld Amount 2 E A C 
AMTWHT3TC 200 BCD*10.3 Estimated Tax Withheld Amount 3 E A C 
AMTWHT4TC 201 BCD*10.3 Estimated Tax Withheld Amount 4 E A C 
AMTWHT5TC 202 BCD*10.3 Estimated Tax Withheld Amount 5 E A C 
SFPAURL 203 String*100 SF Payments Acceptance URL E A 
SFPAID 204 String*36 SF Payments Acceptance ID E A 
TXTOTWHT 205 BCD*10.3 Total Tax Withholding E A C 
AMTDUEWHT 206 BCD*10.3 Amount Due with Tax Withholding E A C 
AMTDUEWHDS 207 BCD*10.3 Amt Due Disc/Withhold Adjusted E A C 

This page was generated on 2021-Nov-24

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