PROCESS_INSTANCEMC_PROCESS_TRANSIDMC_PROCESS_DTMC_ACCT_NUMTRANS_NBRSEQ_NBRITEM_SEQ_NBREX_LVL3_MSTG3(SQL Table) |
Index Back |
|---|---|
Table used in Master Card LoadTable used in Master Card Load -- Table used to hold detail data. XML File. Copy of EX_MC_5030_TA2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | MC_PROCESS_TRANSID |
Character(50) | VARCHAR2(50) NOT NULL | MasterCard ProcessorTransId |
| 3 | MC_PROCESS_DT |
Date(10) | DATE | MasterCard Process Date |
| 4 | MC_ACCT_NUM |
Character(19) | VARCHAR2(19) NOT NULL | Master Card Account Number |
| 5 | TRANS_NBR |
Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 6 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | ITEM_SEQ_NBR |
Number(5,0) | INTEGER NOT NULL | Item Sequence Number |
| 8 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 9 | EX_LVL3_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Enhanced Data Type |
| 10 | MC_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | MasterCard Detail Amount |
| 11 | SORT_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Sort Sequence Number |
| 12 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |