Table: Invoices

Table: ARIBH
View: AR0032
Record length: 2030
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: 173

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   

This page was generated on 2008-May-01

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