CREATION_DTAMEX_REC_TYPE1=Detail Billing Data
2=CM Billing Summary
3=BCA or SE Billing Summary
4=Overall Billing Summary
BASIC_CNTRL_ACCTAMEX_CM_ACCT_NBREX_KR1024_SUMM(SQL Table) |
Index Back |
|---|---|
Amex KR-1024 SummaryAMEX KR_1024 summary totals. The meaning of the debits and credits amount fields are derived from the value of the Record Type. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CREATION_DT |
Date(10) | DATE | Creation Date |
| 2 | AMEX_REC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
AMEX Record Type
1=Detail Billing Data 2=CM Billing Summary 3=BCA or SE Billing Summary 4=Overall Billing Summary |
| 3 | BASIC_CNTRL_ACCT |
Character(15) | VARCHAR2(15) NOT NULL | Basic Control Account |
| 4 | AMEX_CM_ACCT_NBR |
Character(15) | VARCHAR2(15) NOT NULL | Amex Cardmember Number |
| 5 | RUN_DT | Date(10) | DATE | Run Date |
| 6 | DEBIT_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Debit Amount |
| 7 | AMEX_DEBIT_CNT | Number(7,0) | INTEGER NOT NULL | Total Number of Debits |
| 8 | CREDIT_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Credit Amount |
| 9 | AMEX_CREDIT_CNT | Number(7,0) | INTEGER NOT NULL | Total Number of Credits |