Table: Customers

Table: ARCUS
View: AR0024
Record Length: 1951

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: 159

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
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:4 entries
0 = Mail
2 = Email (customer)
4 = Email (contact)
5 = Email (multiple contacts)
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
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
CATEGORY Integer Sage Billing and Payment Customer List:2 entries
0 = No
1 = Yes
BRN String*30 Business Registration Number

This page was generated on 2022-Aug-18

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