Customer .csv File Format
- Kathleen Avery (Deactivated)
Owned by Kathleen Avery (Deactivated)
Customer Voucher .csv file format.
See Customer Test Files and Templates for a sample unit test file.
| Column Header | column letters | Required field? | Type, Length, Format | Table | Description |
|---|---|---|---|---|---|
| customerNumber | A | blank if new customer | VARCHAR2(9) | AR_CUST_T | Blank, if new |
| customerName | B | Yes | VARCHAR2(60) | AR_CUST_T | |
| customerParentCompanyNumber | C | VARCHAR2(9) | AR_CUST_T | Must match an existing Customer Number | |
| customerTypeCode | D | Yes | VARCHAR2(2) | AR_CUST_T | |
| customerLastActivityDate | E | DATE | AR_CUST_T | ||
| customerTaxTypeCode | F | VARCHAR2(4) | AR_CUST_T | ||
| customerTaxNbr | G | VARCHAR2(255) | AR_CUST_T | ||
| customerActiveIndicator | H | Yes | VARCHAR2(1) | AR_CUST_T | |
| customerPhoneNumber | I | VARCHAR2(20) | AR_CUST_T | ||
| customer800PhoneNumber | J | VARCHAR2(20) | AR_CUST_T | ||
| customerContactName | K | VARCHAR2(40) | AR_CUST_T | ||
| customerContactPhoneNumber | L | VARCHAR2(20) | AR_CUST_T | ||
| customerFaxNumber | M | VARCHAR2(20) | AR_CUST_T | ||
| customerBirthDate | N | DATE | AR_CUST_T | YYYY-MM-DD | |
| customerTaxExemptIndicator | O | VARCHAR2(1) | AR_CUST_T | ||
| customerCreditLimitAmount | P | NUMBER(19,2) | AR_CUST_T | ||
| customerCreditApproveByName | Q | VARCHAR2(40) | AR_CUST_T | ||
| customerEmailAddress | R | VARCHAR2(60) | AR_CUST_T | ||
| customerAddressName | S | Yes | VARCHAR2(40) | AR_CUST_ADDR_T | |
| customerLine1StreetAddress | T | Yes | VARCHAR2(30) | AR_CUST_ADDR_T | |
| customerLine2StreetAddress | U | VARCHAR2(30) | AR_CUST_ADDR_T | ||
| customerCityName | V | Yes | VARCHAR2(25) | AR_CUST_ADDR_T | |
| customerStateCode | W | Yes | VARCHAR2(2) | AR_CUST_ADDR_T | |
| customerZipCOde | X | Yes | VARCHAR2(20) | AR_CUST_ADDR_T | |
| customerCountryCode | Y | Yes | VARCHAR2(2) | AR_CUST_ADDR_T | |
| customerAddressInternationalProvinceName | Z | Yes, if international | VARCHAR2(45) | AR_CUST_ADDR_T | |
| customerInternationalMailCode | AA | Yes, if international | VARCHAR2(20) | AR_CUST_ADDR_T | |
| customerAddressEmail | AB | VARCHAR2(60) | AR_CUST_ADDR_T | ||
| customerAddressTypeCode | AC | Yes | VARCHAR2(2) | AR_CUST_ADDR_T | |
| collectionStatusType | AD | Yes | VARCHAR2(60) | UCONN_AR_CUST_EXT_T | |
| customerAlias1Type | AE | VARCHAR2(60) | UCONN_AR_CUST_EXT_T | usually VENFAC | |
| customerAlias1 | AF | VARCHAR2(60) | UCONN_AR_CUST_EXT_T | ||
| customerAlias2Type | AG | VARCHAR2(60) | UCONN_AR_CUST_EXT_T | usually PEOPLESOFT | |
| customerAlias2 | AH | VARCHAR2(60) | UCONN_AR_CUST_EXT_T | ||