Table: Invoices

Table: ARIBH
View: AR0032
Record Length: 2246

Flags: A R 

Keys: 3

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

Fields: 181

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 Document 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
IDSHIPNBR String*22 Shipment Number Mask: %-22C
SWOECOST Integer Do O/E Costing and Consolidation List:2 entries
0 = No
1 = Yes
ENTEREDBY String*8 Entered By
DATEBUS Date Posting Date
EDN String*30 Export Declaration Number
AMTWHT1TC BCD*10.3 Estimated Tax Withheld Amount 1
AMTWHT2TC BCD*10.3 Estimated Tax Withheld Amount 2
AMTWHT3TC BCD*10.3 Estimated Tax Withheld Amount 3
AMTWHT4TC BCD*10.3 Estimated Tax Withheld Amount 4
AMTWHT5TC BCD*10.3 Estimated Tax Withheld Amount 5
SFPAURL String*100 SF Payments Acceptance URL
SFPAID String*36 SF Payments Acceptance ID

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