# Table: Invoices

Table: ARIBH
View: AR0032
Record length: 1993
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
Invoice Entry Number |  | CNTBTCH, CNTITEM
Customer Number | D M | IDCUST
Document Number | D M | IDINVC

## Fields: 169

Field | Type | Title | Presentation
--- | --- | --- | ---
CNTBTCH | BCD*5.0 | Batch Number |
CNTITEM | BCD*4.0 | Entry Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
IDCUST | String*12 | Customer Number | Mask: %-12C
IDINVC | String*22 | Document Number | Mask: %-22C
IDSHPT | String*6 | Ship-To Location Code | Mask: %-6C
SHIPVIA | String*15 | Reserved |
SPECINST | String*60 | Special Instructions |
TEXTTRX | Integer | Document Type | List: 3 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
IDTRX | Integer | Transaction Type | 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 | Integer | Reserved |
ORDRNBR | String*22 | Order Number | Mask: %-22C
CUSTPO | String*22 | PO Number | Mask: %-22C
JOBNBR | String*15 | Reserved |
INVCDESC | String*60 | Invoice Description |
SWPRTINVC | Integer | Invoice Printed | List: 2 entries
0 | = | No
1 | = | Yes
INVCAPPLTO | String*22 | Apply-to Document | Mask: %-22C
IDACCTSET | String*6 | Account Set | Mask: %-6N
DATEINVC | Date | Invoice Date |
DATEASOF | Date | As of Date |
FISCYR | String*4 | Fiscal Year | Mask: %04D
FISCPER | String*2 | Fiscal Period | Mask: %02D
CODECURN | String*3 | Currency Code | Mask: %-3N
RATETYPE | String*2 | Rate Type | Mask: %-2N
SWMANRTE | Integer | Rate Overridden | List: 2 entries
0 | = | No
1 | = | Yes
EXCHRATEHC | BCD*8.7 | Exchange Rate |
ORIGRATEHC | BCD*8.7 | Apply-to Exchange Rate |
TERMCODE | String*6 | Terms | Mask: %-6N
SWTERMOVRD | Integer | Terms Code Overridden | List: 2 entries
0 | = | No
1 | = | Yes
DATEDUE | Date | Due Date |
DATEDISC | Date | Discount Date |
PCTDISC | BCD*5.5 | Discount Percentage |
AMTDISCAVL | BCD*10.3 | Discount Amount Available |
LASTLINE | BCD*3.0 | Number of Details |
CODESLSP1 | String*8 | Salesperson 1 | Mask: %-8N
CODESLSP2 | String*8 | Salesperson 2 | Mask: %-8N
CODESLSP3 | String*8 | Salesperson 3 | Mask: %-8N
CODESLSP4 | String*8 | Salesperson 4 | Mask: %-8N
CODESLSP5 | String*8 | Salesperson 5 | Mask: %-8N
PCTSASPLT1 | BCD*5.5 | Sales-Split Percentage 1 |
PCTSASPLT2 | BCD*5.5 | Sales-Split Percentage 2 |
PCTSASPLT3 | BCD*5.5 | Sales-Split Percentage 3 |
PCTSASPLT4 | BCD*5.5 | Sales-Split Percentage 4 |
PCTSASPLT5 | BCD*5.5 | Sales-Split Percentage 5 |
SWTAXBL | Integer | Taxable | List: 2 entries
0 | = | No
1 | = | Yes
SWMANTX | Integer | Do Not Calc. Tax | List: 2 entries
0 | = | No
1 | = | Yes
CODETAXGRP | String*12 | Tax Group | Mask: %-12N
CODETAX1 | String*12 | Tax Authority 1 | Mask: %-12N
CODETAX2 | String*12 | Tax Authority 2 | Mask: %-12N
CODETAX3 | String*12 | Tax Authority 3 | Mask: %-12N
CODETAX4 | String*12 | Tax Authority 4 | Mask: %-12N
CODETAX5 | String*12 | Tax Authority 5 | Mask: %-12N
TAXSTTS1 | Integer | Tax Class 1 |
TAXSTTS2 | Integer | Tax Class 2 |
TAXSTTS3 | Integer | Tax Class 3 |
TAXSTTS4 | Integer | Tax Class 4 |
TAXSTTS5 | Integer | Tax Class 5 |
BASETAX1 | BCD*10.3 | Tax Base 1 |
BASETAX2 | BCD*10.3 | Tax Base 2 |
BASETAX3 | BCD*10.3 | Tax Base 3 |
BASETAX4 | BCD*10.3 | Tax Base 4 |
BASETAX5 | BCD*10.3 | Tax Base 5 |
AMTTAX1 | BCD*10.3 | Tax Amount 1 |
AMTTAX2 | BCD*10.3 | Tax Amount 2 |
AMTTAX3 | BCD*10.3 | Tax Amount 3 |
AMTTAX4 | BCD*10.3 | Tax Amount 4 |
AMTTAX5 | BCD*10.3 | Tax Amount 5 |
AMTTXBL | BCD*10.3 | Taxable Amount |
AMTNOTTXBL | BCD*10.3 | Non-Taxable Amount |
AMTTAXTOT | BCD*10.3 | Tax Total |
AMTINVCTOT | BCD*10.3 | Document Total Before Tax |
AMTPPD | BCD*10.3 | Prepayment Amount |
AMTPAYMTOT | BCD*3.0 | Number of Scheduled Payments |
AMTPYMSCHD | BCD*10.3 | Total Payment Amount Scheduled |
AMTNETTOT | BCD*10.3 | Document Total Including Tax |
IDSTDINVC | String*16 | Recurring Charge Code |
DATEPRCS | Date | Date Generated |
IDPPD | String*22 | Prepayment Number | Mask: %-22C
IDBILL | String*6 | Recurring Billing Cycle |
SHPTOLOC | String*60 | Ship-To Location Name |
SHPTOSTE1 | String*60 | Ship-To Address Line 1 |
SHPTOSTE2 | String*60 | Ship-To Address Line 2 |
SHPTOSTE3 | String*60 | Ship-To Address Line 3 |
SHPTOSTE4 | String*60 | Ship-To Address Line 4 |
SHPTOCITY | String*30 | Ship-To City |
SHPTOSTTE | String*30 | Ship-To State/Prov. |
SHPTOPOST | String*20 | Ship-To Zip/Postal Code |
SHPTOCTRY | String*30 | Ship-To Country |
SHPTOCTAC | String*60 | Ship-To Contact Name |
SHPTOPHON | String*30 | Ship-To Phone Number | Mask: (%-3C) %-3C-%-24C
SHPTOFAX | String*30 | Ship-To Fax Number | Mask: (%-3C) %-3C-%-24C
DATERATE | Date | Rate Date |
SWPROCPPD | Integer | Cust/Natl Over Credit Flag | List: 4 entries
0 | = | Neither over credit limit
1 | = | Customer over credit limit
2 | = | National over credit limit
3 | = | Both over credit limit
CUROPER | Integer | Rate Operator | List: 2 entries
1 | = | Multiply
2 | = | Divide
DRILLAPP | String*2 | Drill Down Application Source | Mask: %-2A
DRILLTYPE | Integer | Drill Down Type |
DRILLDWNLK | BCD*10.0 | Drill Down Link Number |
SHPVIACODE | String*6 | Ship Via Code | Mask: %-6N
SHPVIADESC | String*60 | Ship Via Description |
SWJOB | Integer | Job Related | List: 2 entries
0 | = | No
1 | = | Yes
ERRBATCH | Long | Error Batch |
ERRENTRY | Long | Error Entry |
EMAIL | String*50 | Ship-To E-mail |
CTACPHONE | String*30 | Ship-To Contact's Phone | Mask: (%-3C) %-3C-%-24C
CTACFAX | String*30 | Ship-To Contact's Fax | Mask: (%-3C) %-3C-%-24C
CTACEMAIL | String*50 | Ship-To Contact's E-mail |
AMTDSBWTAX | BCD*10.3 | Discount Base With Tax |
AMTDSBNTAX | BCD*10.3 | Discount Base Without Tax |
AMTDSCBASE | BCD*10.3 | Discount Base |
INVCTYPE | Integer | Invoice Type | List: 2 entries
1 | = | Item
2 | = | Summary
SWRTGINVC | Integer | Retainage Invoice | List: 2 entries
0 | = | No
1 | = | Yes
RTGAPPLYTO | String*22 | Original Doc. No. | Mask: %-22C
SWRTG | Integer | Has Retainage | List: 2 entries
0 | = | No
1 | = | Yes
RTGAMT | BCD*10.3 | Retainage Amount |
RTGPERCENT | BCD*5.5 | Percent Retained |
RTGDAYS | Integer | Days Retained |
RTGDATEDUE | Date | Retainage Due Date |
RTGTERMS | String*6 | Retainage Terms Code | Mask: %-6N
SWRTGDDTOV | Integer | Retainage Due Date Override | List: 2 entries
0 | = | No
1 | = | Yes
SWRTGAMTOV | Integer | Retainage Amount Override | List: 2 entries
0 | = | No
1 | = | Yes
SWRTGRATE | Integer | Retainage Exchange Rate | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
VALUES | Long | Optional Fields |
SRCEAPPL | String*2 | Source Application | Mask: %-2A
ARVERSION | String*3 | A/R Version Created In |
TAXVERSION | Long | Tax State Version |
SWTXRTGRPT | Integer | Report Retainage Tax |
CODECURNRC | String*3 | Tax Reporting Currency Code | Mask: %-3N
SWTXCTLRC | Integer | Tax Reporting Calculate Method | List: 2 entries
0 | = | No
1 | = | Yes
RATERC | BCD*8.7 | Tax Reporting Exchange Rate |
RATETYPERC | String*2 | Tax Reporting Rate Type | Mask: %-2N
RATEDATERC | Date | Tax Reporting Rate Date |
RATEOPRC | Integer | Tax Reporting Rate Operator | List: 2 entries
1 | = | Multiply
2 | = | Divide
SWRATERC | Integer | Tax Reporting Rate Override | List: 2 entries
0 | = | No
1 | = | Yes
TXAMT1RC | BCD*10.3 | Tax Reporting Amount 1 |
TXAMT2RC | BCD*10.3 | Tax Reporting Amount 2 |
TXAMT3RC | BCD*10.3 | Tax Reporting Amount 3 |
TXAMT4RC | BCD*10.3 | Tax Reporting Amount 4 |
TXAMT5RC | BCD*10.3 | Tax Reporting Amount 5 |
TXTOTRC | BCD*10.3 | Tax Reporting Total |
TXBSERT1TC | BCD*10.3 | Retainage Tax Base 1 |
TXBSERT2TC | BCD*10.3 | Retainage Tax Base 2 |
TXBSERT3TC | BCD*10.3 | Retainage Tax Base 3 |
TXBSERT4TC | BCD*10.3 | Retainage Tax Base 4 |
TXBSERT5TC | BCD*10.3 | Retainage Tax Base 5 |
TXAMTRT1TC | BCD*10.3 | Retainage Tax Amount 1 |
TXAMTRT2TC | BCD*10.3 | Retainage Tax Amount 2 |
TXAMTRT3TC | BCD*10.3 | Retainage Tax Amount 3 |
TXAMTRT4TC | BCD*10.3 | Retainage Tax Amount 4 |
TXAMTRT5TC | BCD*10.3 | Retainage Tax Amount 5 |
TXBSE1HC | BCD*10.3 | Func. Tax Base 1 |
TXBSE2HC | BCD*10.3 | Func. Tax Base 2 |
TXBSE3HC | BCD*10.3 | Func. Tax Base 3 |
TXBSE4HC | BCD*10.3 | Func. Tax Base 4 |
TXBSE5HC | BCD*10.3 | Func. Tax Base 5 |
TXAMT1HC | BCD*10.3 | Func. Tax Amount 1 |
TXAMT2HC | BCD*10.3 | Func. Tax Amount 2 |
TXAMT3HC | BCD*10.3 | Func. Tax Amount 3 |
TXAMT4HC | BCD*10.3 | Func. Tax Amount 4 |
TXAMT5HC | BCD*10.3 | Func. Tax Amount 5 |
AMTGROSHC | BCD*10.3 | Func. Distribution w/ Tax Total |
RTGAMTHC | BCD*10.3 | Func. Retainage Amount |
AMTDISCHC | BCD*10.3 | Func. Discount Amount |
DISTNETHC | BCD*10.3 | Func. Distribution w/o Tax Total |
AMTPPDHC | BCD*10.3 | Func. Prepayment Amount |
AMTDUEHC | BCD*10.3 | Func. Amount Due |
SWPRTLBL | Integer | Label Printed | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.