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 |
|---|---|---|---|---|
| customerNumber | A | blank if new customer | VARCHAR2(9) | AR_CUST_T |
| customerName | B | Yes | VARCHAR2(60) | AR_CUST_T |
| customerParentCompanyNumber | C | VARCHAR2(9) | AR_CUST_T | |
| 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 | |
| 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 | |
| customerAlias1 | AF | VARCHAR2(60) | UCONN_AR_CUST_EXT_T | |
| customerAlias2Type | AG | VARCHAR2(60) | UCONN_AR_CUST_EXT_T | |
| customerAlias2 | AH | VARCHAR2(60) | UCONN_AR_CUST_EXT_T | |