Customer Voucher .csv file format.
See Customer Test Files and Templates for a sample unit test file.
| Column Header | column letters |
|---|
column number | Required field? | Max Length | Table |
|---|
customerNmber1 | B | 2 | C | 3 | D | 4 | E | 5 | F | 6 | 7| blank if new customer |
| AR_CUST_T |
| customerName | B | Yes | 60 | AR_CUST_T |
| customerParentCompanyNumber | C |
| 9 | AR_CUST_T |
| customerTypeCode | D | Yes | 2 | AR_CUST_T |
| customerLastActivityDate | E |
| 10 | AR_CUST_T |
| customerTaxTypeCode | F |
| 4 | AR_CUST_T |
| customerTaxNbr | G |
| 255 | AR_CUST_T |
| customerActiveIndicator | H | Yes | 1 | AR_CUST_T |
| customerPhoneNumber | I |
| 20 | AR_CUST_T |
| customer800PhoneNumber | J |
| 20 | AR_CUST_T |
| customerContactName | K |
| 40 | AR_CUST_T |
| customerContactPhoneNumber | L |
| 20 | AR_CUST_T |
| customerFaxNumber | M |
| 20 | AR_CUST_T |
| customerBirthDate | N |
| 10 | AR_CUST_T |
| customerTaxExemptIndicator | O |
| 1 | AR_CUST_T |
| customerCreditLimitAmount | P |
| 19 (includes 2 decimal points) | AR_CUST_T |
| customerCreditApproveByName | Q |
| 40 | AR_CUST_T |
| customerEmailAddress | R |
| 60 | AR_CUST_T |
| customerAddressName | S | Yes | 40 | AR_CUST_ADDR_T |
| customerLine1StreetAddress | T | Yes | 30 | AR_CUST_ADDR_T |
| customerLine2StreetAddress | U |
| 30 | AR_CUST_ADDR_T |
| customerCityName | V | Yes | 25 | AR_CUST_ADDR_T |
| customerStateCode | W | Yes | 2 | AR_CUST_ADDR_T |
| customerZipCOde | X | Yes | 20 | AR_CUST_ADDR_T |
| customerCountryCode | Y | Yes | 2 | AR_CUST_ADDR_T |
| customerAddressInternationalProvinceName | Z | Yes, if international | 45 | AR_CUST_ADDR_T |
| customerInternationalMailCode | AA | Yes, if international | 20 | AR_CUST_ADDR_T |
| customerAddressEmail | AB |
| 60 | AR_CUST_ADDR_T |
| customerAddressTypeCode | AC | Yes | 2 | AR_CUST_ADDR_T |
| collectionStatusType | AD | Yes | 60 | UCONN_AR_CUST_EXT_T |
| customerAlias1Type | AE |
| 60 | UCONN_AR_CUST_EXT_T |
| customerAlias1 | AF |
| 60 | UCONN_AR_CUST_EXT_T |
| customerAlias2Type | AG |
| 60 | UCONN_AR_CUST_EXT_T |
| customerAlias2 | AH |
| 60 | UCONN_AR_CUST_EXT_T |
|
|
|
|
|