EX_AMEX_MNT_ERR(SQL Table) |
Index Back |
---|---|
Stage Maintenance ErrorsHolds errors encountered in the Amex maintenance load. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
2 | AMEX_PROCESS_DT | Date(10) | DATE | Load Date |
3 | AMEX_CM_ACCT_NBR | Character(15) | VARCHAR2(15) NOT NULL | Amex Cardmember Number |
4 | AMX_CRDHLDR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Cardholder's Name |
5 | AMEX_EXPIRE_DATE | Date(10) | DATE | Expiry Date |
6 | AMEX_ANNIV_DT | Date(10) | DATE | Date Issued |
7 | AMEX_COST_CENTER | Character(13) | VARCHAR2(13) NOT NULL | AMEX Cost Center |
8 | AMEX_STATUS_CD | Character(2) | VARCHAR2(2) NOT NULL | Status Code |
9 | AMX_STATUS_DATE | Date(10) | DATE | Amex Status Date |
10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
11 | PROFILE_EXISTS | Character(1) | VARCHAR2(1) NOT NULL | Profile Exists |
12 | INV_EXP_DT | Character(1) | VARCHAR2(1) NOT NULL | Invalid Expiry Date |
13 | INV_BUS_UNIT | Character(1) | VARCHAR2(1) NOT NULL | Invalid Business Unit |
14 | INV_CUR_CD | Character(1) | VARCHAR2(1) NOT NULL | Invalid Currency Code |
15 | EX_COMP_FLAG | Character(3) | VARCHAR2(3) NOT NULL |
Complete
CMP=Complete NCP=Not Complete Default Value: NCP |
16 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
17 | AMEX_EMPID | Character(11) | VARCHAR2(11) NOT NULL | AMEX Employee ID |
18 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
19 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
20 | CREDIT_CARD_VENDOR | Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |