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 | ||
, multiple selections available,
Related content
Customer Test Files and Templates
Customer Test Files and Templates
More like this
AR Customer and Invoice Upload Process
AR Customer and Invoice Upload Process
Read with this
Disbursement Voucher .csv File Format
Disbursement Voucher .csv File Format
More like this
Disbursement Voucher Unit Test Files
Disbursement Voucher Unit Test Files
More like this
DV Uploads - formatting issues
DV Uploads - formatting issues
More like this
KFS Integrations (Interfaces)
KFS Integrations (Interfaces)
More like this