View: Documents

RotoID: AR0036
Table: AROBL
Protocol: Flat
DLL:AROBL

Keys: 10

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

Fields: 157

Field Index Type Title Attributes Presentation
IDCUST 1 String*12 Customer Number E A K R  Mask: %-12C
IDINVC 2 String*22 Document Number E A K R  Mask: %-22C
IDRMIT 3 String*24 Check/Receipt No. E A  Mask: %-24C
IDORDERNBR 4 String*22 Order Number E A  Mask: %-22C
IDCUSTPO 5 String*22 PO Number E A  Mask: %-22C
DATEDUE 6 Date Due Date E A 
IDNATACCT 7 String*12 National Account Number E A  Mask: %-12C
IDCUSTSHPT 8 String*6 Ship-To Location E A  Mask: %-6C
TRXTYPEID 9 Integer Transaction Type E A  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 10 Integer Document Type E A  List:8 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
5 = Unapplied Cash
10 = Prepayment
11 = Receipt
19 = Refund
DATEBTCH 11 Date Batch Date E A 
CNTBTCH 12 BCD*5.0 Batch Number E A 
CNTITEM 13 BCD*4.0 Entry Number E A 
IDGRP 15 String*6 Group Code E A  Mask: %-6N
DESCINVC 16 String*60 Document Description E A 
DATEINVC 17 Date Document Date E A 
DATEASOF 18 Date As-of Date E A 
CODETERM 19 String*6 Terms E A  Mask: %-6N
DATEDISC 20 Date Discount Date E A 
CODECURN 21 String*3 Currency Code E A  Mask: %-3N
IDRATETYPE 22 String*2 Rate Type E A  Mask: %-2N
SWRATEOVRD 23 Integer Rate Overridden E A  List:2 entries
0 = No
1 = Yes
EXCHRATEHC 24 BCD*8.7 Exchange Rate E A 
AMTINVCHC 25 BCD*10.3 Func. Currency Invoice Amount E A 
AMTDUEHC 26 BCD*10.3 Func. Currency Amount Due E A 
AMTTXBLHC 27 BCD*10.3 Func. Currency Taxable Amount E A 
AMTNONTXHC 28 BCD*10.3 Func. Currency Non-Taxable Amt. E A 
AMTTAXHC 29 BCD*10.3 Func. Currency Tax Amount E A 
AMTDISCHC 30 BCD*10.3 Func. Currency Discount Amount E A 
AMTINVCTC 31 BCD*10.3 Cust. Currency Invoice Amount E A 
AMTDUETC 32 BCD*10.3 Cust. Currency Amount Due E A 
AMTTXBLTC 33 BCD*10.3 Cust. Currency Taxable Amount E A 
AMTNONTXTC 34 BCD*10.3 Cust. Currency Non-Taxable Amt. E A 
AMTTAXTC 35 BCD*10.3 Cust. Currency Tax Amount E A 
AMTDISCTC 36 BCD*10.3 Cust. Currency Discount Amount E A 
SWPAID 37 Integer Fully Paid E A  List:2 entries
0 = No
1 = Yes
DATELSTACT 38 Date Last Activity Date E A 
DATELSTSTM 39 Date Last Statement Date E A 
DATELSTDLQ 40 Date Reserved E 
CODEDLQSTS 41 Integer Reserved E 
CNTTOTPAYM 42 BCD*3.0 Number of Scheduled Payments E A 
CNTLSTPAID 43 BCD*3.0 Reserved - Last Payment Number Paid E 
CNTLSTPYST 44 BCD*3.0 Payment Number on Last Statement E A 
AMTREMIT 45 BCD*10.3 Reserved - Receipt Amount E 
CNTLASTSEQ 46 BCD*3.0 Last Applied Payment Seq. No. E A 
SWTAXINPUT 47 Integer Do Not Calc. Tax E A  List:2 entries
0 = No
1 = Yes
CODETAX1 48 String*12 Tax Authority 1 E A  Mask: %-12N
CODETAX2 49 String*12 Tax Authority 2 E A  Mask: %-12N
CODETAX3 50 String*12 Tax Authority 3 E A  Mask: %-12N
CODETAX4 51 String*12 Tax Authority 4 E A  Mask: %-12N
CODETAX5 52 String*12 Tax Authority 5 E A  Mask: %-12N
AMTBASE1HC 53 BCD*10.3 Func. Base Amount 1 E A 
AMTBASE2HC 54 BCD*10.3 Func. Base Amount 2 E A 
AMTBASE3HC 55 BCD*10.3 Func. Base Amount 3 E A 
AMTBASE4HC 56 BCD*10.3 Func. Base Amount 4 E A 
AMTBASE5HC 57 BCD*10.3 Func. Base Amount 5 E A 
AMTTAX1HC 58 BCD*10.3 Func. Tax Amount 1 E A 
AMTTAX2HC 59 BCD*10.3 Func. Tax Amount 2 E A 
AMTTAX3HC 60 BCD*10.3 Func. Tax Amount 3 E A 
AMTTAX4HC 61 BCD*10.3 Func. Tax Amount 4 E A 
AMTTAX5HC 62 BCD*10.3 Func. Tax Amount 5 E A 
AMTBASE1TC 63 BCD*10.3 Cust. Base Amount 1 E A 
AMTBASE2TC 64 BCD*10.3 Cust. Base Amount 2 E A 
AMTBASE3TC 65 BCD*10.3 Cust. Base Amount 3 E A 
AMTBASE4TC 66 BCD*10.3 Cust. Base Amount 4 E A 
AMTBASE5TC 67 BCD*10.3 Cust. Base Amount 5 E A 
AMTTAX1TC 68 BCD*10.3 Cust. Tax Amount 1 E A 
AMTTAX2TC 69 BCD*10.3 Cust. Tax Amount 2 E A 
AMTTAX3TC 70 BCD*10.3 Cust. Tax Amount 3 E A 
AMTTAX4TC 71 BCD*10.3 Cust. Tax Amount 4 E A 
AMTTAX5TC 72 BCD*10.3 Cust. Tax Amount 5 E A 
CODESLSP1 73 String*8 Salesperson 1 E A  Mask: %-8N
CODESLSP2 74 String*8 Salesperson 2 E A  Mask: %-8N
CODESLSP3 75 String*8 Salesperson 3 E A  Mask: %-8N
CODESLSP4 76 String*8 Salesperson 4 E A  Mask: %-8N
CODESLSP5 77 String*8 Salesperson 5 E A  Mask: %-8N
PCTSASPLT1 78 BCD*5.5 Sales-Split Percentage 1 E A 
PCTSASPLT2 79 BCD*5.5 Sales-Split Percentage 2 E A 
PCTSASPLT3 80 BCD*5.5 Sales-Split Percentage 3 E A 
PCTSASPLT4 81 BCD*5.5 Sales-Split Percentage 4 E A 
PCTSASPLT5 82 BCD*5.5 Sales-Split Percentage 5 E A 
FISCYR 91 String*4 Fiscal Year E A  Mask: %04D
FISCPER 92 String*2 Fiscal Period E A  Mask: %02D
IDPREPAID 93 String*22 Prepay. Apply-to Doc. No. E A  Mask: %-22C
DATEBUS 94 Date Posting Date E A 
RATEDATE 95 Date Rate Date E A 
RATEOP 96 Integer Rate Operator E A 
YPLASTACT 97 String*6 Last Activity Year/Period E A 
IDBANK 98 String*8 Bank Code E A  Mask: %-8N
DEPSTNBR 99 BCD*8.0 Deposit Number E A 
POSTSEQNCE 100 BCD*5.0 Posting Sequence No. E A 
SWJOB 101 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
SWRTG 102 Integer Has Retainage E A  List:2 entries
0 = No
1 = Yes
SWRTGOUT 103 Integer Retainage Outstanding E A  List:2 entries
0 = No
1 = Yes
RTGDATEDUE 104 Date Date Retainage Due E A 
RTGOAMTHC 105 BCD*10.3 Func. Curr. Orig. Rtng. Amt. E A 
RTGAMTHC 106 BCD*10.3 Func. Curr. Retainage Amount E A 
RTGOAMTTC 107 BCD*10.3 Cust. Curr. Orig. Rtng. Amt. E A 
RTGAMTTC 108 BCD*10.3 Cust. Curr. Retainage Amount E A 
RTGTERMS 109 String*6 Retainage Terms Code E A  Mask: %-6N
SWRTGRATE 110 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGAPPLYTO 111 String*22 Original Doc. No. E A  Mask: %-22C
VALUES 112 Long Optional Fields E A 
SRCEAPPL 113 String*2 Source Application E A  Mask: %-2A
ARVERSION 114 String*3 A/R Version Created In E A 
INVCTYPE 115 Integer Invoice Type E A  List:3 entries
0 = Not Applicable
1 = Item
2 = Summary
DEPSEQ 116 ??? Deposit Serial Number E A 
DEPLINE 117 Long Deposit Line Number E A 
TYPEBTCH 118 String*2 Batch Type E A  Mask: %-2N
CNTOBLJ 119 Long Number of OBLJ Details E A 
CODECURNRC 120 String*3 Tax Reporting Currency Code E A 
RATERC 121 BCD*8.7 Tax Reporting Exchange Rate E A 
RATETYPERC 122 String*2 Tax Reporting Rate Type E A 
RATEDATERC 123 Date Tax Reporting Rate Date E A 
RATEOPRC 124 Integer Tax Reporting Rate Operator E A 
SWRATERC 125 Integer Tax Reporting Rate Override E A  List:2 entries
0 = No
1 = Yes
SWTXRTGRPT 126 Integer Report Retainage Tax E A 
CODETAXGRP 127 String*12 Tax Group E A 
TAXVERSION 128 Long Tax State Version E A 
SWTXCTLRC 129 Integer Tax Reporting Calculate Method E A  List:2 entries
0 = No
1 = Yes
TAXCLASS1 130 Integer Tax Class 1 E A 
TAXCLASS2 131 Integer Tax Class 2 E A 
TAXCLASS3 132 Integer Tax Class 3 E A 
TAXCLASS4 133 Integer Tax Class 4 E A 
TAXCLASS5 134 Integer Tax Class 5 E A 
TXBSERT1TC 135 BCD*10.3 Tax Base 1 E A 
TXBSERT2TC 136 BCD*10.3 Tax Base 2 E A 
TXBSERT3TC 137 BCD*10.3 Tax Base 3 E A 
TXBSERT4TC 138 BCD*10.3 Tax Base 4 E A 
TXBSERT5TC 139 BCD*10.3 Tax Base 5 E A 
TXAMTRT1TC 140 BCD*10.3 Tax Amount 1 E A 
TXAMTRT2TC 141 BCD*10.3 Tax Amount 2 E A 
TXAMTRT3TC 142 BCD*10.3 Tax Amount 3 E A 
TXAMTRT4TC 143 BCD*10.3 Tax Amount 4 E A 
TXAMTRT5TC 144 BCD*10.3 Tax Amount 5 E A 
IDSHIPNBR 145 String*22 Shipment Number E A  Mask: %-22C
DATEFRSTBK 146 Date Earliest Backdated Activity Date E A 
DATELSTRVL 147 Date Last Revaluation Date E A 
ORATE 148 BCD*8.7 Orig. Exchange Rate E A 
ORATETYPE 149 String*2 Orig. Rate Type E A 
ORATEDATE 150 Date Orig. Rate Date E A 
ORATEOP 151 Integer Orig. Rate Operator E A 
OSWRATE 152 Integer Orig. Rate Override Flag E A  List:2 entries
0 = No
1 = Yes
IDACCTSET 153 String*6 Account Set E A  Mask: %-6N
DATEPAID 154 Date Date Paid E A 
SWNONRCVBL 155 Integer Misc. Receipt Flag E A 
CODETERR 156 String*6 Territoty Code E A  Mask: %-6N
OAMTWHT1TC 157 BCD*10.3 Orig Est Tax Withheld Amount 1 E A 
OAMTWHT2TC 158 BCD*10.3 Orig Est Tax Withheld Amount 2 E A 
OAMTWHT3TC 159 BCD*10.3 Orig Est Tax Withheld Amount 3 E A 
OAMTWHT4TC 160 BCD*10.3 Orig Est Tax Withheld Amount 4 E A 
OAMTWHT5TC 161 BCD*10.3 Orig Est Tax Withheld Amount 5 E A 
OAMTWHT1HC 190 BCD*10.3 Orig Func Est Tax Withheld 1 E A 
OAMTWHT2HC 191 BCD*10.3 Orig Func Est Tax Withheld 2 E A 
OAMTWHT3HC 192 BCD*10.3 Orig Func Est Tax Withheld 3 E A 
OAMTWHT4HC 193 BCD*10.3 Orig Func Est Tax Withheld 4 E A 
OAMTWHT5HC 194 BCD*10.3 Orig Func Est Tax Withheld 5 E A 

This page was generated on 2023-Aug-31

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