# View: Open Documents

RotoID: AR0036
Tables: AROBL
DLL: AROBL

## Compositions: 0

## Keys: 9

Title | Fields
--- | ---
Customer Number/Doc. Number | IDCUST, IDINVC
Document Number | IDINVC
Sales Order Number | IDORDERNBR, IDCUST, SWPAID, IDINVC
Purchase Order Number | IDCUSTPO, IDCUST, SWPAID, IDINVC
Due Date | DATEDUE, IDCUST, IDINVC
National Account Number | IDNATACCT, IDCUST, IDINVC
Fully Paid Switch | SWPAID, IDCUST, IDPREPAID
Customer No./Document Date | IDCUST, DATEINVC
Retainage Outstanding | SWRTGOUT, IDCUST, IDINVC

## Fields: 104

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 | Sales Order Number | E A | Mask: %-22C
IDCUSTPO | 5 | String*22 | PO Number | E A |
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: 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 | 10 | Integer | Document Type | E A | List: 7 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
5 | = | Unapplied Cash
10 | = | Prepayment
11 | = | Receipt
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 P | 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 | 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 | 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 | Business 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*5.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

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.