View: Customers

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

Compositions: 2

RotoID Tables Title DLL
AR0400 ARCUSO Customer Optional Field Values ARCUSO
AR0222 Customer Contact Selection ARCUSMT

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

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: (%-3C) %-3C-%-24C
TEXTPHON2 25 String*30 Fax Number E A P  Mask: (%-3C) %-3C-%-24C
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 
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 P  List:4 entries
0 = Mail
2 = Email (customer)
4 = Email (contact)
5 = Email (multiple contacts)
PRIMSHIPTO 140 String*6 Primary Ship-To Location E A C  Mask: %-6C
CTACPHONE 141 String*30 Contact's Phone E A P  Mask: (%-3C) %-3C-%-24C
CTACFAX 142 String*30 Contact's Fax E A P  Mask: (%-3C) %-3C-%-24C
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:2 entries
0 = Insert Optional Fields
1 = Check Outstanding Docs
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 C 
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 
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
EWSUPPRESS 169 Boolean Suppress Integration E A 
EWARVER 170 String*3 A/R Version A 
EWORGID 171 String*6 Database A 
EWMODE 172 Integer Mode E A  List:2 entries
0 = Normal Mode
1 = Unconditional Inserts/Updates
CATEGORY 173 Integer Sage Billing and Payment Customer E A  List:2 entries
0 = No
1 = Yes
BRN 174 String*30 Business Registration Number E A 
EWCTACMODE 175 Integer CRM Update Mode E A  List:3 entries
1 = Update
2 = Replace
3 = New

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