...
See Customer Test Files and Templates for a sample unit test file.
| Column Header | column letters | Required field? | Type, Length, Format | Max Length | Table |
|---|---|---|---|---|---|
| customerNumber | A | blank if new customer | VARCHAR2(9) | 9 | AR_CUST_T |
| customerName | B | Yes | VARCHAR2(9) | 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 | ||