# View: Documents

RotoID: AR0130
Protocol: Superview
DLL: ARDOCS

## Compositions: 0

## 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: 122

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: 8 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
5 | = | Unapplied Cash
10 | = | Prepayment
11 | = | Receipt
19 | = | Refund
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*5.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 | Long | 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 | Show Paid Transactions Switch | E A | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2008-May-01

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