PROCESS_INSTANCEMC_PROCESS_TRANSIDMC_PROCESS_DTMC_ACCT_NUMTRANS_NBRSEQ_NBRTRANS_DATEEX_LVL3_MSTG2(SQL Table) |
Index Back |
|---|---|
Table used in Master Card LoadTable used in Master Card Load -- Table used to hold summary data. XML File. Copy of EX_MC_5030_TA1 |
| # | 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 | TRANS_DATE |
Date(10) | DATE | Transaction Date |
| 8 | MC_ARRIVE_DT | Date(10) | DATE | Arrival Date |
| 9 | MC_DEPART_DT | Date(10) | DATE | Departure Date |
| 10 | MC_ROOM_RT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Room Rate |
| 11 | MC_TOTRM_TAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Room Tax |
| 12 | MC_TOTAL_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Charges |
| 13 | MC_TOT_NONRM | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total NonRoom Charges |
| 14 | MC_PHONE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Telephone Charges |
| 15 | MC_REST_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Restaurant Charges |
| 16 | MC_ROOM_SRVC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Room Service Charges |
| 17 | MC_MINIBAR_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Mini Bar Charges |
| 18 | MC_LOUNGE_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | LoungeBar Charges |
| 19 | MC_GIFTSHOP_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gift Shop Charges |
| 20 | MC_LAUNDRY_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Laundry Charge |
| 21 | MC_OTHER_SVC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Service |
| 22 | MC_OTHER_SVC2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Service 2 |
| 23 | MC_OTHER_SVC3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Service 3 |
| 24 | MC_OTHER_SVC4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Service 4 |
| 25 | MC_OTHER_SVC5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Service 5 |
| 26 | MC_OTHER_SVC6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Service 6 |
| 27 | MC_TOTAL_TAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Tax Amount |
| 28 | MC_NBR_NIGHTS | Number(4,0) | SMALLINT NOT NULL | Number of Nights |
| 29 | MC_PPD_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Prepaid Expenses Amount |
| 30 | MC_TOT_NONRMTX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total NonRoom Tax |
| 31 | MC_VALET_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Valet Charges |
| 32 | MC_MOVIE_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Movie Charges |
| 33 | MC_BUSCENT_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Business Center Charges |
| 34 | MC_HEALTH_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | HealthClub Charges |
| 35 | MC_GRAT_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gratuity Charges |
| 36 | MC_CONFROOM_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Conference Room Charges |
| 37 | MC_AUDIO_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | AudioVisual Charges |
| 38 | MC_BANQUET_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Banquet Charges |
| 39 | MC_INTERNET_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Internet Access Charge Amount |
| 40 | MC_EARLYDPT_CHRG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Early Departure Charges |
| 41 | TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount |
| 42 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
| 43 | ENHC_NAME_EX | Character(125) | VARCHAR2(125) NOT NULL | Renter Name |
| 44 | EX_ENHC_TYPE_NBR | Character(50) | VARCHAR2(50) NOT NULL | Hotel Folio |