Table: Documents

Table: AROBL
View: AR0036
Record Length: 1206

Flags: A R 

Keys: 10

Title Flags Fields
Customer Number/Document Number IDCUST, IDINVC
Document Number IDINVC
Order Number D M  IDORDERNBR, IDCUST, SWPAID, IDINVC
PO Number D M  IDCUSTPO, IDCUST, SWPAID, IDINVC
Due Date D M  DATEDUE, IDCUST, IDINVC
National Account Number D M  IDNATACCT, IDCUST, IDINVC
Fully Paid Switch M  SWPAID, IDCUST, IDPREPAID, IDINVC
Customer No./Document Date D M  IDCUST, DATEINVC
Retainage Outstanding D M  SWRTGOUT, IDCUST, IDINVC
Shipment Number D M  IDSHIPNBR, IDCUST, SWPAID, IDINVC

Fields: 156

Field Type Title Presentation
IDCUST String*12 Customer Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
IDRMIT String*24 Check/Receipt No. Mask: %-24C
IDORDERNBR String*22 Order Number Mask: %-22C
IDCUSTPO String*22 PO Number Mask: %-22C
DATEDUE Date Due Date
IDNATACCT String*12 National Account Number Mask: %-12C
IDCUSTSHPT String*6 Ship-To Location Mask: %-6C
TRXTYPEID Integer Transaction Type List:19 entries
1 = Unapplied Cash - Posted
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
26 = Debit Note - Advance Credit Claim
31 = Credit Note - Item Issued
32 = Credit Note - Summary Entered
34 = Credit Note - Summary Issued
35 = Credit Note - Item Entered
40 = Interest Charge
50 = Prepayment - Posted
51 = Receipt - Posted
73 = Refund - Posted
TRXTYPETXT Integer Document Type List:8 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
5 = Unapplied Cash
10 = Prepayment
11 = Receipt
19 = Refund
DATEBTCH Date Batch Date
CNTBTCH BCD*5.0 Batch Number
CNTITEM BCD*4.0 Entry Number
IDGRP String*6 Group Code Mask: %-6N
DESCINVC String*60 Document Description
DATEINVC Date Document Date
DATEASOF Date As-of Date
CODETERM String*6 Terms Mask: %-6N
DATEDISC Date Discount Date
CODECURN String*3 Currency Code Mask: %-3N
IDRATETYPE String*2 Rate Type Mask: %-2N
SWRATEOVRD Integer Rate Overridden List:2 entries
0 = No
1 = Yes
EXCHRATEHC BCD*8.7 Exchange Rate
AMTINVCHC BCD*10.3 Func. Currency Invoice Amount
AMTDUEHC BCD*10.3 Func. Currency Amount Due
AMTTXBLHC BCD*10.3 Func. Currency Taxable Amount
AMTNONTXHC BCD*10.3 Func. Currency Non-Taxable Amt.
AMTTAXHC BCD*10.3 Func. Currency Tax Amount
AMTDISCHC BCD*10.3 Func. Currency Discount Amount
AMTINVCTC BCD*10.3 Cust. Currency Invoice Amount
AMTDUETC BCD*10.3 Cust. Currency Amount Due
AMTTXBLTC BCD*10.3 Cust. Currency Taxable Amount
AMTNONTXTC BCD*10.3 Cust. Currency Non-Taxable Amt.
AMTTAXTC BCD*10.3 Cust. Currency Tax Amount
AMTDISCTC BCD*10.3 Cust. Currency Discount Amount
SWPAID Integer Fully Paid List:2 entries
0 = No
1 = Yes
DATELSTACT Date Last Activity Date
DATELSTSTM Date Last Statement Date
DATELSTDLQ Date Reserved
CODEDLQSTS Integer Reserved
CNTTOTPAYM BCD*3.0 Number of Scheduled Payments
CNTLSTPAID BCD*3.0 Reserved - Last Payment Number Paid
CNTLSTPYST BCD*3.0 Payment Number on Last Statement
AMTREMIT BCD*10.3 Reserved - Receipt Amount
CNTLASTSEQ BCD*3.0 Last Applied Payment Seq. No.
SWTAXINPUT Integer Do Not Calc. Tax List:2 entries
0 = No
1 = Yes
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
AMTBASE1HC BCD*10.3 Func. Base Amount 1
AMTBASE2HC BCD*10.3 Func. Base Amount 2
AMTBASE3HC BCD*10.3 Func. Base Amount 3
AMTBASE4HC BCD*10.3 Func. Base Amount 4
AMTBASE5HC BCD*10.3 Func. Base Amount 5
AMTTAX1HC BCD*10.3 Func. Tax Amount 1
AMTTAX2HC BCD*10.3 Func. Tax Amount 2
AMTTAX3HC BCD*10.3 Func. Tax Amount 3
AMTTAX4HC BCD*10.3 Func. Tax Amount 4
AMTTAX5HC BCD*10.3 Func. Tax Amount 5
AMTBASE1TC BCD*10.3 Cust. Base Amount 1
AMTBASE2TC BCD*10.3 Cust. Base Amount 2
AMTBASE3TC BCD*10.3 Cust. Base Amount 3
AMTBASE4TC BCD*10.3 Cust. Base Amount 4
AMTBASE5TC BCD*10.3 Cust. Base Amount 5
AMTTAX1TC BCD*10.3 Cust. Tax Amount 1
AMTTAX2TC BCD*10.3 Cust. Tax Amount 2
AMTTAX3TC BCD*10.3 Cust. Tax Amount 3
AMTTAX4TC BCD*10.3 Cust. Tax Amount 4
AMTTAX5TC BCD*10.3 Cust. Tax Amount 5
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
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
IDPREPAID String*22 Prepay. Apply-to Doc. No. Mask: %-22C
DATEBUS Date Posting Date
RATEDATE Date Rate Date
RATEOP Integer Rate Operator
YPLASTACT String*6 Last Activity Year/Period
IDBANK String*8 Bank Code Mask: %-8N
DEPSTNBR BCD*8.0 Deposit Number
POSTSEQNCE BCD*5.0 Posting Sequence No.
SWJOB Integer Job Related List:2 entries
0 = No
1 = Yes
SWRTG Integer Has Retainage List:2 entries
0 = No
1 = Yes
SWRTGOUT Integer Retainage Outstanding List:2 entries
0 = No
1 = Yes
RTGDATEDUE Date Date Retainage Due
RTGOAMTHC BCD*10.3 Func. Curr. Orig. Rtng. Amt.
RTGAMTHC BCD*10.3 Func. Curr. Retainage Amount
RTGOAMTTC BCD*10.3 Cust. Curr. Orig. Rtng. Amt.
RTGAMTTC BCD*10.3 Cust. Curr. Retainage Amount
RTGTERMS String*6 Retainage Terms Code Mask: %-6N
SWRTGRATE Integer Retainage Exchange Rate List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGAPPLYTO String*22 Original Doc. No. Mask: %-22C
VALUES Long Optional Fields
SRCEAPPL String*2 Source Application Mask: %-2A
ARVERSION String*3 A/R Version Created In
INVCTYPE Integer Invoice Type List:3 entries
0 = Not Applicable
1 = Item
2 = Summary
DEPSEQ ??? Deposit Serial Number
DEPLINE Long Deposit Line Number
TYPEBTCH String*2 Batch Type Mask: %-2N
CNTOBLJ Long Number of OBLJ Details
CODECURNRC String*3 Tax Reporting Currency Code
RATERC BCD*8.7 Tax Reporting Exchange Rate
RATETYPERC String*2 Tax Reporting Rate Type
RATEDATERC Date Tax Reporting Rate Date
RATEOPRC Integer Tax Reporting Rate Operator
SWRATERC Integer Tax Reporting Rate Override List:2 entries
0 = No
1 = Yes
SWTXRTGRPT Integer Report Retainage Tax
CODETAXGRP String*12 Tax Group
TAXVERSION Long Tax State Version
SWTXCTLRC Integer Tax Reporting Calculate Method List:2 entries
0 = No
1 = Yes
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
TXBSERT1TC BCD*10.3 Tax Base 1
TXBSERT2TC BCD*10.3 Tax Base 2
TXBSERT3TC BCD*10.3 Tax Base 3
TXBSERT4TC BCD*10.3 Tax Base 4
TXBSERT5TC BCD*10.3 Tax Base 5
TXAMTRT1TC BCD*10.3 Tax Amount 1
TXAMTRT2TC BCD*10.3 Tax Amount 2
TXAMTRT3TC BCD*10.3 Tax Amount 3
TXAMTRT4TC BCD*10.3 Tax Amount 4
TXAMTRT5TC BCD*10.3 Tax Amount 5
IDSHIPNBR String*22 Shipment Number Mask: %-22C
DATEFRSTBK Date Earliest Backdated Activity Date
DATELSTRVL Date Last Revaluation Date
ORATE BCD*8.7 Orig. Exchange Rate
ORATETYPE String*2 Orig. Rate Type
ORATEDATE Date Orig. Rate Date
ORATEOP Integer Orig. Rate Operator
OSWRATE Integer Orig. Rate Override Flag List:2 entries
0 = No
1 = Yes
IDACCTSET String*6 Account Set Mask: %-6N
DATEPAID Date Date Paid
SWNONRCVBL Integer Misc. Receipt Flag
CODETERR String*6 Territoty Code Mask: %-6N
OAMTWHT1TC BCD*10.3 Orig Est Tax Withheld Amount 1
OAMTWHT2TC BCD*10.3 Orig Est Tax Withheld Amount 2
OAMTWHT3TC BCD*10.3 Orig Est Tax Withheld Amount 3
OAMTWHT4TC BCD*10.3 Orig Est Tax Withheld Amount 4
OAMTWHT5TC BCD*10.3 Orig Est Tax Withheld Amount 5

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