# Table: Customers

Table: ARCUS
View: AR0024
Record length: 2028
Flags: A R

## Keys: 13

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

## Fields: 161

Field | Type | Title | Presentation
--- | --- | --- | ---
IDCUST | String*12 | Customer Number | Mask: %-12C
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
TEXTSNAM | String*10 | Short Name |
IDGRP | String*6 | Group Code | Mask: %-6N
IDNATACCT | String*12 | National Account | Mask: %-12C
SWACTV | Integer | Status | List: 2 entries
0 | = | Inactive
1 | = | Active
DATEINAC | Date | Inactive Date |
DATELASTMN | Date | Date Last Maintained |
SWHOLD | Integer | On Hold | List: 2 entries
0 | = | No
1 | = | Yes
DATESTART | Date | Start Date |
IDPPNT | String*12 | Reserved |
CODEDAB | String*9 | Credit Bureau Number |
CODEDABRTG | String*5 | Credit Bureau Rating |
DATEDAB | Date | Credit Bureau Date |
NAMECUST | String*60 | Customer Name |
TEXTSTRE1 | String*60 | Address Line 1 |
TEXTSTRE2 | String*60 | Address Line 2 |
TEXTSTRE3 | String*60 | Address Line 3 |
TEXTSTRE4 | String*60 | Address Line 4 |
NAMECITY | String*30 | City |
CODESTTE | String*30 | State/Prov. |
CODEPSTL | String*20 | Zip/Postal Code |
CODECTRY | String*30 | Country |
NAMECTAC | String*60 | Contact Name |
TEXTPHON1 | String*30 | Phone Number | Mask: (%-3C) %-3C-%-24C
TEXTPHON2 | String*30 | Fax Number | Mask: (%-3C) %-3C-%-24C
CODETERR | String*6 | Territory Code | Mask: %-6N
IDACCTSET | String*6 | Account Set | Mask: %-6N
IDAUTOCASH | String*6 | Autocash Profile |
IDBILLCYCL | String*6 | Billing Cycle | Mask: %-6N
IDSVCCHRG | String*6 | Interest Profile | Mask: %-6N
IDDLNQ | String*6 | Reserved |
CODECURN | String*3 | Currency Code | Mask: %-3N
SWPRTSTMT | Integer | Print Statements | List: 2 entries
0 | = | No
1 | = | Yes
SWPRTDLNQ | Integer | Reserved |
SWBALFWD | Integer | Account Type | List: 2 entries
0 | = | Open Item
1 | = | Balance Forward
CODETERM | String*6 | Terms | Mask: %-6N
IDRATETYPE | String*2 | Rate Type | Mask: %-2N
CODETAXGRP | String*12 | Tax Group | Mask: %-12N
IDTAXREGI1 | String*20 | Tax Registration No. 1 |
IDTAXREGI2 | String*20 | Tax Registration No. 2 |
IDTAXREGI3 | String*20 | Tax Registration No. 3 |
IDTAXREGI4 | String*20 | Tax Registration No. 4 |
IDTAXREGI5 | String*20 | Tax Registration No. 5 |
TAXSTTS1 | Integer | Tax Class Code 1 |
TAXSTTS2 | Integer | Tax Class Code 2 |
TAXSTTS3 | Integer | Tax Class Code 3 |
TAXSTTS4 | Integer | Tax Class Code 4 |
TAXSTTS5 | Integer | Tax Class Code 5 |
AMTCRLIMT | BCD*10.3 | Credit Limit (Cust. Curr.) |
AMTBALDUET | BCD*10.3 | Balance Due in Cust. Curr. |
AMTBALDUEH | BCD*10.3 | Balance Due in Func. Curr. |
DATELASTST | Date | Date of Last Statement |
AMTLASTSTT | BCD*10.3 | Last Statement Total Cust. Curr. |
AMTLASTSTH | BCD*10.3 | Reserved |
DTBEGBALFW | Date | Date of Last Bal. Fwd. Statement |
AMTBALFWDT | BCD*10.3 | Beginning Bal. on Last Statement |
AMTBALFWDH | BCD*10.3 | Reserved |
DTLASTRVAL | Date | Date of Last Revaluation |
AMTBALLARV | BCD*10.3 | Last Revaluation Balance |
CNTOPENINV | BCD*4.0 | Number of Open Documents |
CNTINVPAID | BCD*4.0 | Number of Paid Invoices |
DAYSTOPAY | BCD*4.0 | Number of Days to Pay |
DATEINVCHI | Date | Date of Largest Invoice |
DATEBALHI | Date | Date of Highest Balance |
DATEINVHIL | Date | Date of Largest Invoice Last Yr. |
DATEBALHIL | Date | Date of Highest Balance Last Yr. |
DATELASTAC | Date | Date of Last Activity |
DATELASTIV | Date | Date of Last Invoice |
DATELASTCR | Date | Date of Last Credit Note |
DATELASTDR | Date | Date of Last Debit Note |
DATELASTPA | Date | Date of Last Receipt |
DATELASTDI | Date | Date of Last Discount |
DATELASTAD | Date | Date of Last Adjustment |
DATELASTWR | Date | Date of Last Write-Off |
DATELASTRI | Date | Date of Last Returned Check |
DATELASTIN | Date | Date of Last Interest Charge |
DATELASTDQ | Date | Reserved |
IDINVCHI | String*22 | Largest Invoice Number |
IDINVCHILY | String*22 | Largest Invoice Number Last Yr. |
AMTINVHIT | BCD*10.3 | Largest Invoice - Cust. Curr. |
AMTBALHIT | BCD*10.3 | Highest Balance - Cust. Curr. |
AMTINVHILT | BCD*10.3 | Lgst. Inv. Last Yr. Cust. Curr. |
AMTBALHILT | BCD*10.3 | High Bal. Last Yr. - Cust. Curr. |
AMTLASTIVT | BCD*10.3 | Last Invoice Amt. - Cust. Curr. |
AMTLASTCRT | BCD*10.3 | Last Cr. Note Amt. - Cust. Curr. |
AMTLASTDRT | BCD*10.3 | Last Dr. Note Amt. - Cust. Curr. |
AMTLASTPYT | BCD*10.3 | Last Receipt - Cust. Curr. |
AMTLASTDIT | BCD*10.3 | Last Discount Amt. - Cust. Curr. |
AMTLASTADT | BCD*10.3 | Last Adj. Amt. - Cust. Curr. |
AMTLASTWRT | BCD*10.3 | Last Write-Off Amt. Cust. Curr. |
AMTLASTRIT | BCD*10.3 | Last Ret'd. Chk. Amt. Cust. Curr |
AMTLASTINT | BCD*10.3 | Last Int. Charge - Cust. Curr. |
AMTINVHIH | BCD*10.3 | Largest Invoice - Func. Curr. |
AMTBALHIH | BCD*10.3 | Highest Balance - Func. Curr. |
AMTINVHILH | BCD*10.3 | Lgst. Inv. Last Yr. Func. Curr. |
AMTBALHILH | BCD*10.3 | High Bal. Last Yr. - Func. Curr. |
AMTLASTIVH | BCD*10.3 | Last Invoice Amt. - Func. Curr. |
AMTLASTCRH | BCD*10.3 | Last Cr. Note Amt. - Func. Curr. |
AMTLASTDRH | BCD*10.3 | Last Dr. Note Amt. - Func. Curr. |
AMTLASTPYH | BCD*10.3 | Last Receipt - Func. Curr. |
AMTLASTDIH | BCD*10.3 | Last Discount Amt. - Func. Curr. |
AMTLASTADH | BCD*10.3 | Last Adj. Amt. - Func. Curr. |
AMTLASTWRH | BCD*10.3 | Last Write-Off Amt. Func. Curr. |
AMTLASTRIH | BCD*10.3 | Last Ret'd. Chk. Amt. Func. Curr |
AMTLASTINH | BCD*10.3 | Last Int. Charge - Func. Curr. |
CODESLSP1 | String*8 | Salesperson 1 | Mask: %-8N
CODESLSP2 | String*8 | Salesperson 2 | Mask: %-8N
CODESLSP3 | String*8 | Salesperson 3 | Mask: %-8N
CODESLSP4 | String*8 | Salesperson 4 | Mask: %-8N
CODESLSP5 | String*8 | Salesperson 5 | Mask: %-8N
PCTSASPLT1 | BCD*5.5 | Sales-Split Percentage 1 |
PCTSASPLT2 | BCD*5.5 | Sales-Split Percentage 2 |
PCTSASPLT3 | BCD*5.5 | Sales-Split Percentage 3 |
PCTSASPLT4 | BCD*5.5 | Sales-Split Percentage 4 |
PCTSASPLT5 | BCD*5.5 | Sales-Split Percentage 5 |
PRICLIST | String*6 | Customer Price List | Mask: %-6C
CUSTTYPE | Integer | Customer Discount Type | List: 6 entries
0 | = | Base
1 | = | A
2 | = | B
3 | = | C
4 | = | D
5 | = | E
AMTPDUE | BCD*10.3 | Amount Past Due |
EMAIL1 | String*50 | Contact's E-mail |
EMAIL2 | String*50 | E-mail |
WEBSITE | String*100 | Web Site |
BILLMETHOD | Integer | Billing Method |
CCNUMBER | Binary*32 | Credit Card Number |
CCEXP | Date | Expiry Date (mm/yy) |
CCNAME | String*60 | Credit Card Name |
PAYMCODE | String*12 | Payment Code | Mask: %-12N
FOB | String*60 | Free On Board |
SHPVIACODE | String*6 | Ship Via Code | Mask: %-6N
SHPVIADESC | String*60 | Ship Via Description |
DELMETHOD | Integer | Delivery Method | List: 3 entries
0 | = | Mail
2 | = | E-mail
4 | = | Contact's E-mail
PRIMSHIPTO | String*6 | Primary Ship-To Location | Mask: %-6C
CTACPHONE | String*30 | Contact's Phone | Mask: (%-3C) %-3C-%-24C
CTACFAX | String*30 | Contact's Fax | Mask: (%-3C) %-3C-%-24C
SWPARTSHIP | Integer | Allow Partial Shipments | List: 2 entries
0 | = | No
1 | = | Yes
SWWEBSHOP | Integer | Allow Web Store Shopping | List: 2 entries
0 | = | No
1 | = | Yes
RTGPERCENT | BCD*5.5 | Percent Retained |
RTGDAYS | Integer | Days Retained |
RTGTERMS | String*6 | Retainage Terms Code | Mask: %-6N
RTGAMTTC | BCD*10.3 | Amount Retained - Cust. Curr. |
RTGAMTHC | BCD*10.3 | Amount Retained - Func. Curr. |
VALUES | Long | Optional Fields |
CNTPPDINVC | BCD*4.0 | Number of Open Prepayments |
AMTPPDINVT | BCD*10.3 | Amount Prepaid - Cust. Curr. |
AMTPPDINVH | BCD*10.3 | Amount Prepaid - Func. Curr. |
DATELASTRF | Date | Date of Last Refund. |
AMTLASTRFT | BCD*10.3 | Last Refund Amt. - Cust. Curr. |
AMTLASTRFH | BCD*10.3 | Last Refund Amt. - Func. Curr. |
CODECHECK | String*3 | Check Language | List: 7 entries
1 | = | ENG
2 | = | FRA
3 | = | ESN
4 | = | AUS
5 | = | MEX
6 | = | CHN
7 | = | CHT
NEXTCUID | Long | Next Client Unique ID |
LOCATION | String*6 | Inventory Location | Mask: %-6N
SWCHKLIMIT | Integer | Check Credit Limit | List: 2 entries
0 | = | No
1 | = | Yes
SWCHKOVER | Integer | Check Overdue Amounts | List: 2 entries
0 | = | No
1 | = | Yes
OVERDAYS | Integer | Days Overdue |
OVERAMT | BCD*10.3 | Amount Overdue |
CCTYPE | String*12 | Credit Card Type | Mask: %-12N
SWBACKORDR | Integer | Allow Backorder Quantities | List: 2 entries
0 | = | No
1 | = | Yes
SWCHKDUPPO | Integer | Check for Duplicate POs | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error

This page was generated on 2008-May-01

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