# 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: 183

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: %-30c
SHPTOFAX | 103 | String*30 | Ship-To Fax Number | E A P | Mask: %-30c
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: 10 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
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: %-30c
CTACFAX | 124 | String*30 | Ship-To Contact's Fax | E A P | Mask: %-30c
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 |
DATEBUS | 196 | Date | Posting Date | E A |

This page was generated on 2009-Nov-19

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