...
See Customer Test Files and Templates for a sample unit test file.
| Column Header | column letters | Required field? | Type, Length, Format |
|---|
Max LengthTable| Description |
|---|
| customerNumber | A | blank if new customer | VARCHAR2(9) |
9 | | AR_CUST_T | Blank, if new |
| customerName | B | Yes | VARCHAR2( |
960 | 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 |
10
| 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 |
10
| DATE | AR_CUST_T | YYYY-MM-DD |
| customerTaxExemptIndicator | O |
| VARCHAR2(1) | AR_CUST_T |
|
| customerCreditLimitAmount | P |
| NUMBER(19 |
(includes decimal points| ) | 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 |
|
|
|
|
|
|
|