Customer Master Record

This documentation defines the Customer Master Record (ARCUSTMN) schema fields.

Please Note This documentation defines the most relevant fields. Treat the response from the View Table Schema (XMGETFMT) endpoint as the authoritative field list for any specific site.

Date formats

NTD is a timestamp format used by DICE. NTD dates are used when defining time frames within endpoint calls. See the Date Format documentation for information on converting NTD to UNIX and vice versa if needed.

Field definitions

#NameDescriptionLengthPadding Type
1AR_NUMBERThe unique accounting identifier assigned to the customer.10Pad with trailing spaces.
2BRANCH_IDThe ID of the branch the customer belongs to.3Pad with trailing spaces.
3AR_COMPANY_NAMEThe company name or the name of the individual responsible for the customer.28Pad with trailing spaces.
4AR_SORT_BY_NAMEThe name the system will use when sorting the customer. This is the name users can use within account lookups when searching for the customer.15Pad with trailing spaces.
5AR_STREET_NOThe building number of the customer’s address.8Pad with trailing spaces.
6AR_STREET_NAME1The street direction of the customer’s address.2Pad with trailing spaces.
7AR_STREET_NAME2The street name of the customer’s address.28Pad with trailing spaces.
8AR_ADDTL_ADDRESSAdditional address information such as P.O. box or apartment number.28Pad with trailing spaces.
9AR_ADDTL_ADDRESS_2Additional address information for international accounts.28Pad with trailing spaces.
10AR_ADDTL_ADDRESS_3Additional address information for international accounts.28Pad with trailing spaces.
11AR_CITYThe city name of the customer’s address.18Pad with trailing spaces.
12AR_STATEThe state or province abbreviation of the customer’s address.3Pad with trailing spaces.
13AR_COUNTRYThe country code of the customer’s address.3Pad with trailing spaces.
14AR_ZIPCODEThe postal code of the customer’s address.10Pad with trailing spaces.
15MIRROR_ACCOUNTIf applicable, the account number of the specified customer’s Mirrored Account.9Right justify data and pad with leading spaces.
16DUNS_NUMBERBilling custom identifier 4.10Pad with trailing spaces.
17SIC_CODEBilling custom identifier 6.12Pad with trailing spaces.
18VENDOR_REFBilling custom identifier 5.10Pad with trailing spaces.
19PO_REQUIREDDetermines if a PO Number is required when entering an invoice. Accepts: Y or N.1Pad with trailing spaces.
20OPEN_BALANCE_FORWARDDetermines the type of cash application that should be applied to specific invoices.
Y: Use balance forward cash application.
O: Use open item cash application.		1Pad with trailing spaces.
21SEND_STATEMENTSDetermines if the customer can be sent statements. Accepts: Y or N.1Pad with trailing spaces.
22DUNNING_CLASSClass code to drive the dunning messages that this customer should receive.1Pad with trailing spaces.
23PRNT_DUNNING_MSGDetermines if the associated dunning class message should be included when printing customer invoices. Accepts: Y or N.1Pad with trailing spaces.
24PRNT_DUNNING_LTRDetermines if the customer can receive dunning letters. Accepts: Y or N.1Pad with trailing spaces.
25DAYS_BEFORE_SENDThe number of days after which a customer is past due to qualify for a dunning letter.3Right justify data and pad with leading spaces.
26STATEMENT_CYCLEDetermines the statement cycle code assigned to the customer.1Pad with trailing spaces.
27FINANCE_CHARGE_RATEDetermines the charge rate code assigned to the customer for past due invoices.3Pad with trailing spaces.
28DISCOUNT_CODEDetermines the discount code used to apply discounts on invoices with billing codes allowing for discounts.6Pad with trailing spaces.
29CREDIT_LIMITDetermines the allowed amount of credit assigned to the customer. If an invoice exceeds the allowed/remaining credit amount, a warning will display.5Pad with trailing spaces.
30TERMS_CODEDetermines the terms code assigned to the customer for determining the due date of invoices.6Pad with trailing spaces.
31POSTING_CODEDetermines which receivables GL, prepayment, and deposit GL accounts will be used for the customer.6Pad with trailing spaces.
32LAST_OPERATORThe operator code of the individual who last updated the customer’s account.3Pad with trailing spaces.
33LAST_ENTRY_TIMEThe NTD date and time of the last update made to the customer’s account.12Pad with trailing spaces.
34AR_IDENTIFIER_1Billing custom identifier 1.9Pad with trailing spaces.
35AR_IDENTIFIER_2Billing custom identifier 2.9Pad with trailing spaces.
36AR_IDENTIFIER_3Billing custom identifier 3.9Pad with trailing spaces.
37INCREASE_STATUSUsed with rate increase process on recurring lines.1Pad with trailing spaces.
38GETS_BILLDetermines which customer address will receive a mailed bill.1Pad with trailing spaces.
39SALESREP_GROUPINGThe sales representative assigned to the customer account.6Pad with trailing spaces.
40NTD_STATEMENT_DATEThe NTD date when the customer’s last statement was generated.6Pad with trailing spaces.
41USE_ATTN_LINEDetermines if invoices with attention lines will include the first contact’s name as part of the address for the invoice. Accepts: Y or N.1Pad with trailing spaces.
42AR_TIME_ZNThe time zone where the billing customer is located.3Pad with trailing spaces.
43WARRANTY_CODEThe warranty code assigned to the customer account.6Pad with trailing spaces.
44SALES_TAX_GROUPThe sales tax code assigned to the customer account.6Pad with trailing spaces.
45AR_ADDRESSThe short code representing the customer’s address.4Pad with trailing spaces.
46DAYS_BEFORE_FINANCEThe number of days that must elapse after the invoice date before finance charges or late fees apply.2Pad with trailing spaces.
47LEAD_NUMBERIf applicable, the most recent sales lead associated with the customer account.12Pad with trailing spaces.
48AR_LATITUDEThe latitude coordinates (distance of a place north or south of the earth’s equator) of the customer’s location.12Pad with trailing spaces.
49AR_LONGITUDEThe longitude coordinate (distance of a place east or west of the meridian at Greenwich, England) of the customer’s location.13Pad with trailing spaces.

Example request 

curl --request GET \
--url 'https://global-rest.ci.matrixmcloud.com/rest/rest.php?dataSource=dice&*view=arcustmn&*limit=1&*blanks=all' \
--header 'X-DICE-APPKEY: {{X-DICE-APPKEY}}' \
--header 'X-DICE-USERNAME: {{X-DICE-USERNAME}}' \
--header 'X-DICE-DATE: {{X-DICE-DATE}}' \
--header 'X-DICE-NONCE: {{X-DICE-NONCE}}' \
--header 'X-DICE-DIGEST: {{X-DICE-DIGEST}}' \
--header 'Accept: application/json' \

Example response 

{
  "ARCUSTMN": [
    {
      "AR_NUMBER": "0000000010",
      "BRANCH_ID": "PRO",
      "AR_COMPANY_NAME": "WESTREICH, MR. M.",
      "AR_SORT_BY_NAME": "WESTREICH, MR.",
      "AR_STREET_NO": "18",
      "AR_STREET_NAME1": "N",
      "AR_STREET_NAME2": "OLD LYME RD",
      "AR_ADDTL_ADDRESS": "",
      "AR_ADDTL_ADDRESS_2": "",
      "AR_ADDTL_ADDRESS_3": "",
      "AR_CITY": "SCARSDALE",
      "AR_STATE": "NY",
      "AR_COUNTRY": "USA",
      "AR_ZIPCODE": "10583",
      "MIRROR_ACCOUNT": "        a",
      "DUNS_NUMBER": "",
      "SIC_CODE": "",
      "VENDOR_REF": "",
      "PO_REQUIRED": "",
      "OPEN_BALANCE_FORWARD": "Y",
      "SEND_STATEMENTS": "Y",
      "DUNNING_CLASS": "A",
      "PRNT_DUNNING_MSG": "Y",
      "PRNT_DUNNING_LTR": "Y",
      "DAYS_BEFORE_SEND": " 30",
      "STATEMENT_CYCLE": "1",
      "FINANCE_CHARGE_RATE": 1.5,
      "DISCOUNT_CODE": "DISCOU",
      "CREDIT_LIMIT": 0,
      "TERMS_CODE": "10DAY",
      "POSTING_CODE": "ALL",
      "LAST_OPERATOR": "BJO",
      "LAST_ENTRY_TIME": "732898.46152",
      "AR_IDENTIFIER_1": "b",
      "AR_IDENTIFIER_2": "a",
      "AR_IDENTIFIER_3": "test",
      "INCREASE_STATUS": "A",
      "GETS_BILL": "Y",
      "SALESREP_GROUPING": "000142",
      "NTD_STATEMENT_DATE": "10/19/",
      "USE_ATTN_LINE": "Y",
      "AR_TIME_ZN": "EST",
      "WARRANTY_CODE": "1YEAR",
      "SALES_TAX_GROUP": "IN",
      "AR_ADDRESS": "",
      "DAYS_BEFORE_FINANCE": 60,
      "LEAD_NUMBER": "000000002835",
      "AR_LATITUDE": "a",
      "AR_LONGITUDE": "a"
    }
  ],
  "totalRecords": 1
}
← Customer Contacts
Customer Emails →