# View: Customers

RotoID: AR0024
Table: ARCUS
Protocol: Header
DLL: ARCUS

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
AR0400 | ARCUSO | Customer Optional Field Values | ARCUSO

## Keys: 13

Title | Fields
--- | ---
Customer Number | IDCUST
Customer Short Name | TEXTSNAM
Group Code | IDGRP
National Account Number | IDNATACCT
Billing Cycle | IDBILLCYCL
Natl. Acct./Account Set | IDNATACCT, IDACCTSET
Natl. Acct./Billing Cycle | IDNATACCT, IDBILLCYCL
Natl. Acct./Interest Profile | IDNATACCT, IDSVCCHRG
Natl. Acct./Cust. Type | IDNATACCT, SWBALFWD
Natl. Acct./Group Code | IDNATACCT, IDGRP
Account Sets/Customer Number | IDACCTSET, IDCUST
Currency Code/Interest Profile | CODECURN, IDSVCCHRG, IDCUST
Terms Code/Customer Number | CODETERM, IDCUST

## Fields: 160

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
IDCUST | 1 | String*12 | Customer Number | E A K R | Mask: %-12C
TEXTSNAM | 2 | String*10 | Short Name | E A |
IDGRP | 3 | String*6 | Group Code | E A | Mask: %-6N
IDNATACCT | 4 | String*12 | National Account | E A | Mask: %-12C
SWACTV | 5 | Integer | Status | E A | List: 2 entries
0 | = | Inactive
1 | = | Active
DATEINAC | 6 | Date | Inactive Date | E A C |
DATELASTMN | 7 | Date | Date Last Maintained | E A C |
SWHOLD | 8 | Integer | On Hold | E A | List: 2 entries
0 | = | No
1 | = | Yes
DATESTART | 9 | Date | Start Date | E A |
IDPPNT | 10 | String*12 | Reserved | E |
CODEDAB | 11 | String*9 | Credit Bureau Number | E A |
CODEDABRTG | 12 | String*5 | Credit Bureau Rating | E A |
DATEDAB | 13 | Date | Credit Bureau Date | E A |
NAMECUST | 14 | String*60 | Customer Name | E A |
TEXTSTRE1 | 15 | String*60 | Address Line 1 | E A |
TEXTSTRE2 | 16 | String*60 | Address Line 2 | E A |
TEXTSTRE3 | 17 | String*60 | Address Line 3 | E A |
TEXTSTRE4 | 18 | String*60 | Address Line 4 | E A |
NAMECITY | 19 | String*30 | City | E A |
CODESTTE | 20 | String*30 | State/Prov. | E A |
CODEPSTL | 21 | String*20 | Zip/Postal Code | E A |
CODECTRY | 22 | String*30 | Country | E A |
NAMECTAC | 23 | String*60 | Contact Name | E A |
TEXTPHON1 | 24 | String*30 | Phone Number | E A P | Mask: %-30c
TEXTPHON2 | 25 | String*30 | Fax Number | E A P | Mask: %-30c
CODETERR | 26 | String*6 | Territory Code | E A | Mask: %-6N
IDACCTSET | 27 | String*6 | Account Set | E A | Mask: %-6N
IDAUTOCASH | 28 | String*6 | Autocash Profile | E A |
IDBILLCYCL | 29 | String*6 | Billing Cycle | E A | Mask: %-6N
IDSVCCHRG | 30 | String*6 | Interest Profile | E A | Mask: %-6N
IDDLNQ | 31 | String*6 | Reserved | E |
CODECURN | 32 | String*3 | Currency Code | E A C | Mask: %-3N
SWPRTSTMT | 33 | Integer | Print Statements | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWPRTDLNQ | 34 | Integer | Reserved | E |
SWBALFWD | 35 | Integer | Account Type | E A | List: 2 entries
0 | = | Open Item
1 | = | Balance Forward
CODETERM | 36 | String*6 | Terms | E A | Mask: %-6N
IDRATETYPE | 37 | String*2 | Rate Type | E A | Mask: %-2N
CODETAXGRP | 38 | String*12 | Tax Group | E A | Mask: %-12N
IDTAXREGI1 | 39 | String*20 | Tax Registration No. 1 | E A |
IDTAXREGI2 | 40 | String*20 | Tax Registration No. 2 | E A |
IDTAXREGI3 | 41 | String*20 | Tax Registration No. 3 | E A |
IDTAXREGI4 | 42 | String*20 | Tax Registration No. 4 | E A |
IDTAXREGI5 | 43 | String*20 | Tax Registration No. 5 | E A |
TAXSTTS1 | 44 | Integer | Tax Class Code 1 | E A |
TAXSTTS2 | 45 | Integer | Tax Class Code 2 | E A |
TAXSTTS3 | 46 | Integer | Tax Class Code 3 | E A |
TAXSTTS4 | 47 | Integer | Tax Class Code 4 | E A |
TAXSTTS5 | 48 | Integer | Tax Class Code 5 | E A |
AMTCRLIMT | 49 | BCD*10.3 | Credit Limit (Cust. Curr.) | E A |
AMTBALDUET | 50 | BCD*10.3 | Balance Due in Cust. Curr. | E A C |
AMTBALDUEH | 51 | BCD*10.3 | Balance Due in Func. Curr. | E A C |
DATELASTST | 52 | Date | Date of Last Statement | E A C |
AMTLASTSTT | 53 | BCD*10.3 | Last Statement Total Cust. Curr. | E A C |
AMTLASTSTH | 54 | BCD*10.3 | Reserved | E |
DTBEGBALFW | 55 | Date | Date of Last Bal. Fwd. Statement | E A C |
AMTBALFWDT | 56 | BCD*10.3 | Beginning Bal. on Last Statement | E A C |
AMTBALFWDH | 57 | BCD*10.3 | Reserved | E |
DTLASTRVAL | 58 | Date | Date of Last Revaluation | E A |
AMTBALLARV | 59 | BCD*10.3 | Last Revaluation Balance | E A |
CNTOPENINV | 60 | BCD*4.0 | Number of Open Documents | E A C |
CNTINVPAID | 61 | BCD*4.0 | Number of Paid Invoices | E A |
DAYSTOPAY | 62 | BCD*4.0 | Number of Days to Pay | E A |
DATEINVCHI | 63 | Date | Date of Largest Invoice | E A |
DATEBALHI | 64 | Date | Date of Highest Balance | E A |
DATEINVHIL | 65 | Date | Date of Largest Invoice Last Yr. | E A |
DATEBALHIL | 66 | Date | Date of Highest Balance Last Yr. | E A |
DATELASTAC | 67 | Date | Date of Last Activity | E A |
DATELASTIV | 68 | Date | Date of Last Invoice | E A |
DATELASTCR | 69 | Date | Date of Last Credit Note | E A |
DATELASTDR | 70 | Date | Date of Last Debit Note | E A |
DATELASTPA | 71 | Date | Date of Last Receipt | E A |
DATELASTDI | 72 | Date | Date of Last Discount | E A |
DATELASTAD | 73 | Date | Date of Last Adjustment | E A |
DATELASTWR | 74 | Date | Date of Last Write-Off | E A |
DATELASTRI | 75 | Date | Date of Last Returned Check | E A |
DATELASTIN | 76 | Date | Date of Last Interest Charge | E A |
DATELASTDQ | 77 | Date | Reserved | E |
IDINVCHI | 78 | String*22 | Largest Invoice Number | E A C |
IDINVCHILY | 79 | String*22 | Largest Invoice Number Last Yr. | E A C |
AMTINVHIT | 80 | BCD*10.3 | Largest Invoice - Cust. Curr. | E A |
AMTBALHIT | 81 | BCD*10.3 | Highest Balance - Cust. Curr. | E A |
AMTINVHILT | 82 | BCD*10.3 | Lgst. Inv. Last Yr. Cust. Curr. | E A |
AMTBALHILT | 83 | BCD*10.3 | High Bal. Last Yr. - Cust. Curr. | E A |
AMTLASTIVT | 84 | BCD*10.3 | Last Invoice Amt. - Cust. Curr. | E A |
AMTLASTCRT | 85 | BCD*10.3 | Last Cr. Note Amt. - Cust. Curr. | E A |
AMTLASTDRT | 86 | BCD*10.3 | Last Dr. Note Amt. - Cust. Curr. | E A |
AMTLASTPYT | 87 | BCD*10.3 | Last Receipt - Cust. Curr. | E A |
AMTLASTDIT | 88 | BCD*10.3 | Last Discount Amt. - Cust. Curr. | E A |
AMTLASTADT | 89 | BCD*10.3 | Last Adj. Amt. - Cust. Curr. | E A |
AMTLASTWRT | 90 | BCD*10.3 | Last Write-Off Amt. Cust. Curr. | E A |
AMTLASTRIT | 91 | BCD*10.3 | Last Ret'd. Chk. Amt. Cust. Curr | E A |
AMTLASTINT | 92 | BCD*10.3 | Last Int. Charge - Cust. Curr. | E A |
AMTINVHIH | 93 | BCD*10.3 | Largest Invoice - Func. Curr. | E A |
AMTBALHIH | 94 | BCD*10.3 | Highest Balance - Func. Curr. | E A |
AMTINVHILH | 95 | BCD*10.3 | Lgst. Inv. Last Yr. Func. Curr. | E A |
AMTBALHILH | 96 | BCD*10.3 | High Bal. Last Yr. - Func. Curr. | E A |
AMTLASTIVH | 97 | BCD*10.3 | Last Invoice Amt. - Func. Curr. | E A |
AMTLASTCRH | 98 | BCD*10.3 | Last Cr. Note Amt. - Func. Curr. | E A |
AMTLASTDRH | 99 | BCD*10.3 | Last Dr. Note Amt. - Func. Curr. | E A |
AMTLASTPYH | 100 | BCD*10.3 | Last Receipt - Func. Curr. | E A |
AMTLASTDIH | 101 | BCD*10.3 | Last Discount Amt. - Func. Curr. | E A |
AMTLASTADH | 102 | BCD*10.3 | Last Adj. Amt. - Func. Curr. | E A |
AMTLASTWRH | 103 | BCD*10.3 | Last Write-Off Amt. Func. Curr. | E A |
AMTLASTRIH | 104 | BCD*10.3 | Last Ret'd. Chk. Amt. Func. Curr | E A |
AMTLASTINH | 105 | BCD*10.3 | Last Int. Charge - Func. Curr. | E A |
CODESLSP1 | 106 | String*8 | Salesperson 1 | E A | Mask: %-8N
CODESLSP2 | 107 | String*8 | Salesperson 2 | E A | Mask: %-8N
CODESLSP3 | 108 | String*8 | Salesperson 3 | E A | Mask: %-8N
CODESLSP4 | 109 | String*8 | Salesperson 4 | E A | Mask: %-8N
CODESLSP5 | 110 | String*8 | Salesperson 5 | E A | Mask: %-8N
PCTSASPLT1 | 111 | BCD*5.5 | Sales-Split Percentage 1 | E A |
PCTSASPLT2 | 112 | BCD*5.5 | Sales-Split Percentage 2 | E A |
PCTSASPLT3 | 113 | BCD*5.5 | Sales-Split Percentage 3 | E A |
PCTSASPLT4 | 114 | BCD*5.5 | Sales-Split Percentage 4 | E A |
PCTSASPLT5 | 115 | BCD*5.5 | Sales-Split Percentage 5 | E A |
AVGDAYSPAY | 124 | BCD*5.1 | Average Days to Pay | A C |
PRICLIST | 125 | String*6 | Customer Price List | E A | Mask: %-6C
CUSTTYPE | 126 | Integer | Customer Discount Type | E A | List: 6 entries
0 | = | Base
1 | = | A
2 | = | B
3 | = | C
4 | = | D
5 | = | E
AMTPDUE | 127 | BCD*10.3 | Amount Past Due | E A C |
EMAIL1 | 128 | String*50 | Contact's E-mail | E A |
EMAIL2 | 129 | String*50 | E-mail | E A |
WEBSITE | 130 | String*100 | Web Site | E A |
BILLMETHOD | 131 | Integer | Billing Method | E A |
CCNUMBER | 132 | Binary*32 | Credit Card Number | E A C X |
CCEXP | 133 | Date | Expiry Date (mm/yy) | E A |
CCNAME | 134 | String*60 | Credit Card Name | E A |
PAYMCODE | 135 | String*12 | Payment Code | E A | Mask: %-12N
FOB | 136 | String*60 | Free On Board | E A |
SHPVIACODE | 137 | String*6 | Ship Via Code | E A | Mask: %-6N
SHPVIADESC | 138 | String*60 | Ship Via Description | E A |
DELMETHOD | 139 | Integer | Delivery Method | E A | List: 3 entries
0 | = | Mail
2 | = | E-mail
4 | = | Contact's E-mail
PRIMSHIPTO | 140 | String*6 | Primary Ship-To Location | E A C | Mask: %-6C
CTACPHONE | 141 | String*30 | Contact's Phone | E A P | Mask: %-30c
CTACFAX | 142 | String*30 | Contact's Fax | E A P | Mask: %-30c
SWPARTSHIP | 143 | Integer | Allow Partial Shipments | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWWEBSHOP | 144 | Integer | Allow Web Store Shopping | E A | List: 2 entries
0 | = | No
1 | = | Yes
RTGPERCENT | 145 | BCD*5.5 | Percent Retained | E A |
RTGDAYS | 146 | Integer | Days Retained | E A |
RTGTERMS | 147 | String*6 | Retainage Terms Code | E A | Mask: %-6N
RTGAMTTC | 148 | BCD*10.3 | Amount Retained - Cust. Curr. | E A C |
RTGAMTHC | 149 | BCD*10.3 | Amount Retained - Func. Curr. | E A C |
VALUES | 150 | Long | Optional Fields | E A C |
PROCESSCMD | 151 | Integer | Process Command Code | E A C | List: 1 entries
0 | = | Insert Optional Fields
CNTPPDINVC | 152 | BCD*4.0 | Number of Open Prepayments | E A C |
AMTPPDINVT | 153 | BCD*10.3 | Amount Prepaid - Cust. Curr. | E A C |
AMTPPDINVH | 154 | BCD*10.3 | Amount Prepaid - Func. Curr. | E A C |
DATELASTRF | 155 | Date | Date of Last Refund. | E A |
AMTLASTRFT | 156 | BCD*10.3 | Last Refund Amt. - Cust. Curr. | E A |
AMTLASTRFH | 157 | BCD*10.3 | Last Refund Amt. - Func. Curr. | E A |
CODECHECK | 158 | String*3 | Check Language | E A P | List: 7 entries
1 | = | ENG
2 | = | FRA
3 | = | ESN
4 | = | AUS
5 | = | MEX
6 | = | CHN
7 | = | CHT
NEXTCUID | 159 | Long | Next Client Unique ID | E A |
LOCATION | 160 | String*6 | Inventory Location | E A | Mask: %-6N
SWCHKLIMIT | 161 | Integer | Check Credit Limit | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWCHKOVER | 162 | Integer | Check Overdue Amounts | E A | List: 2 entries
0 | = | No
1 | = | Yes
OVERDAYS | 163 | Integer | Days Overdue | E A |
OVERAMT | 164 | BCD*10.3 | Amount Overdue | E A |
CCTYPE | 165 | String*12 | Credit Card Type | E A | Mask: %-12N
XCCNUMBER | 166 | String*32 | Credit Card Number | E A | Mask: %-32D
SWBACKORDR | 167 | Integer | Allow Backorder Quantities | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWCHKDUPPO | 168 | Integer | Check for Duplicate POs | E A | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error

This page was generated on 2009-Nov-19

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