View: Documents

RotoID: AR0130

Protocol: Superview
DLL:ARDOCS

Keys: 14

Title Fields
Document Number IDINVC
Order Number IDORDERNBR, IDINVC
PO Number IDCUSTPO, IDINVC
Current Balance AMTDUETC, DATEDUE, IDINVC
Due Date DATEDUE, IDINVC
Document Date DATEINVC, IDINVC
Shipment Number IDSHIPNBR, IDINVC
Customer/Document Number IDCUST, IDINVC
Customer/Order Number IDCUST, IDORDERNBR, IDINVC
Customer/PO Number IDCUST, IDCUSTPO, IDINVC
Customer/Current Balance IDCUST, AMTDUETC, DATEDUE, IDINVC
Customer/Due Date IDCUST, DATEDUE, IDINVC
Customer/Document Date IDCUST, DATEINVC, IDINVC
Customer/Shipment Number IDCUST, IDSHIPNBR, IDINVC

Fields: 123

Field Index Type Title Attributes Presentation
IDCUST 1 String*12 Customer Number E A  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 
IDSHIPNBR 6 String*22 Shipment Number E A  Mask: %-22C
DATEDUE 7 Date Due Date E A 
IDNATACCT 8 String*12 National Account Number E A  Mask: %-12C
IDCUSTSHPT 9 String*6 Ship-To Location E A  Mask: %-6C
TRXTYPEID 10 Integer Transaction Type E A  List:17 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
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
TRXTYPETXT 11 Integer Document Type E A  List:9 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
5 = Unapplied Cash
10 = Prepayment
11 = Receipt
19 = Refund
20 = Misc. Receipt
DATEBTCH 12 Date Batch Date E A 
CNTBTCH 13 BCD*5.0 Batch Number E A 
CNTITEM 14 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 Last Payment Number Paid E A 
CNTLSTPYST 44 BCD*3.0 Payment Number on Last Statement E A 
AMTREMIT 45 BCD*10.3 Receipt Amount Applied E A 
CNTLASTSEQ 46 BCD*3.0 Last Applied Payment Seq. No. E A 
SWTAXINPUT 47 Integer Tax Override Switch 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 90 String*4 Fiscal Year E A  Mask: %04D
FISCPER 91 String*2 Fiscal Period E A  Mask: %02D
IDPREPAID 92 String*22 Prepay. Apply-to Doc. No. E A  Mask: %-22C
DATEBUS 93 Date Posting Date E A 
RATEDATE 94 Date Rate Date E A 
RATEOP 95 Integer Rate Operator E A 
YPLASTACT 96 String*6 Last Activity Year/Period E A 
IDBANK 97 String*8 Bank Code E A  Mask: %-8N
DEPSTNBR 98 BCD*8.0 Deposit Number E A 
POSTSEQNCE 99 BCD*5.0 Posting Sequence No. E A 
SWJOB 100 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
SWRTG 101 Integer Has Retainage E A  List:2 entries
0 = No
1 = Yes
SWRTGOUT 102 Integer Retainage Outstanding E A  List:2 entries
0 = No
1 = Yes
RTGDATEDUE 103 Date Date Retainage Due E A 
RTGOAMTHC 104 BCD*10.3 Func. Curr. Orig. Rtng. Amt. E A 
RTGAMTHC 105 BCD*10.3 Func. Curr. Retainage Amount E A 
RTGOAMTTC 106 BCD*10.3 Cust. Curr. Orig. Rtng. Amt. E A 
RTGAMTTC 107 BCD*10.3 Cust. Curr. Retainage Amount E A 
RTGTERMS 108 String*6 Retainage Terms Code E A  Mask: %-6N
SWRTGRATE 109 Integer Retainage Exchange Rate E A  List:2 entries
0 = No
1 = Yes
RTGAPPLYTO 110 String*22 Original Doc. No. E A  Mask: %-22C
PNDPAYTOTH 111 BCD*10.3 Functional Pending Receipt Amount E A 
PNDDSCTOTH 112 BCD*10.3 Functional Pending Discount Amount E A 
PNDADJTOTH 113 BCD*10.3 Functional Pending Adjustment Amount E A 
PENDNGBALH 114 BCD*10.3 Functional Pending Balance E A 
PNDPAYTOT 115 BCD*10.3 Pending Receipt Amount E A 
PNDDSCTOT 116 BCD*10.3 Pending Discount Amount E A 
PNDADJTOT 117 BCD*10.3 Pending Adjustment Amount E A 
PENDNGBAL 118 BCD*10.3 Pending Balance E A 
IDCUSTPEND 119 String*12 Customer No. Used to Calculate Pending Amount E A  Mask: %-12C
SWSHOWPEND 120 Integer Show Pending Amounts Switch E A  List:2 entries
0 = No
1 = Yes
VALUES 121 Long Optional Fields E A 
SRCEAPPL 122 String*2 Source Application E A  Mask: %-2A
ARVERSION 123 String*3 A/R Version Created In E A 
INVCTYPE 124 Integer Invoice Type E A  List:3 entries
0 = Not Applicable
1 = Item
2 = Summary
DEPSEQ 125 ??? Deposit Serial Number E A 
DEPLINE 126 Long Deposit Line Number E A 
TYPEBTCH 127 String*2 Batch Type E A  Mask: %-2N
CNTOBLJ 128 Long Number of OBLJ Details E A 
SWSHOWPAID 129 Integer Obsolete E A  List:2 entries
0 = No
1 = Yes
SWMEMBERS 130 Integer Show Members E A  List:2 entries
0 = No
1 = Yes

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