CC_MC_TBL5022(SQL Table) |
Index Back |
---|---|
MasterCard 5022Passenger Rail Detail Addendum |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
2 | POST_DT | Date(10) | DATE | The Date a transaction was Posted. |
3 | TRANS_NBR | Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
4 | CC_MC_PARENTREC | Character(4) | VARCHAR2(4) NOT NULL |
MasterCard Parent Recrd Type
4300=Account Information 5000=Financial Transaction 5001=Card Acceptor 5010=Line Item Detail 5020=Passenger Transport - General 5021=Passenger Transport - Trip Leg 5030=Lodging Summary Addendum 5040=Vehicle Rental Detail Addendum 5050=Generic Addendum 5060=Fleet Card Addendum 5070=Medical Services Detail 5080=Temporary Services Detail 5090=Shipping Courier Service 5100=Global Invoice 5110=Party Detail Addendum 5120=Telephony Billing Summary 5121=Telephony Billing Detail 5300=Tax Addendum CUST=Custom Financial Data |
5 | CC_MC_PARENTSEQNO | Number(10,0) | DECIMAL(10) NOT NULL | Parent Sequence Number |
6 | CC_MC_SEQNO | Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
7 | CC_MC_REC_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
MasterCard Record Type
4300=Account Information 5000=Financial Transaction 5001=Card Acceptor 5010=Line Item Detail 5020=Passenger Transport - General 5021=Passenger Transport - Trip Leg 5030=Lodging Summary Addendum 5040=Vehicle Rental Detail Addendum 5050=Generic Addendum 5060=Fleet Card Addendum 5070=Medical Services Detail 5080=Temporary Services Detail 5090=Shipping Courier Service 5100=Global Invoice 5110=Party Detail Addendum 5120=Telephony Billing Summary 5121=Telephony Billing Detail 5300=Tax Addendum CUST=Custom Financial Data |
8 | MC_MAINTAINCODE | Character(1) | VARCHAR2(1) NOT NULL |
Maintenance Code
A=Add U=Update |
9 | MC_RECSEQNUM | Character(7) | VARCHAR2(7) NOT NULL | Record Sequence Number |
10 | MC_LOADDATE | Date(10) | DATE | Load Date |
11 | MC_LOADTIME | Character(12) | VARCHAR2(12) NOT NULL | Load Time |
12 | MC_REJECTREASON1 | Character(6) | VARCHAR2(6) NOT NULL | Rejection Reason 1 |
13 | MC_REJECTREASON2 | Character(6) | VARCHAR2(6) NOT NULL | Rejection Reason 2 |
14 | MC_REJECTREASON3 | Character(6) | VARCHAR2(6) NOT NULL | Rejection Reason 3 |
15 | MC_TICKETNBR | Character(15) | VARCHAR2(15) NOT NULL | Ticket Number |
16 | MC_SEQNUM | Character(3) | VARCHAR2(3) NOT NULL | SequenceNumber |
17 | MC_TRVLOFFICENUM | Character(8) | VARCHAR2(8) NOT NULL | TravelOfficeNumber |
18 | MC_TRVLOFFICENAME | Character(25) | VARCHAR2(25) NOT NULL | TravelOfficeName |
19 | MC_PROCEDUREID | Character(9) | VARCHAR2(9) NOT NULL | ProcedureID |
20 | MC_SRVTYPE | Character(2) | VARCHAR2(2) NOT NULL | ServiceType |
21 | MC_SRVNATURE | Character(2) | VARCHAR2(2) NOT NULL | ServiceNature |
22 | TRAVEL_DT | Date(10) | DATE | Travel Date |
23 | MC_SRVAMT | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | |
24 | MC_CURRENCYCD | Character(3) | VARCHAR2(3) NOT NULL | CurrencyCode |
25 | MC_FULLVATAMT | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | FullVATAmount |
26 | MC_HALFVATAMT | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | HalfVATAmount |
27 | MC_FULLVATGROSSAMT | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | FullVATGrossAmount |
28 | MC_HALFVATGROSSAMT | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | HalfVATGrossAmount |
29 | MC_SAMPLENBR | Number(4,0) | SMALLINT NOT NULL | SampleNumber |
30 | MC_STARTSTATION | Character(30) | VARCHAR2(30) NOT NULL | StartStation |
31 | MC_DESTSTATION | Character(30) | VARCHAR2(30) NOT NULL | DestinationStation |
32 | MC_TRAFFICCD | Number(3,0) | SMALLINT NOT NULL | TrafficCode |
33 | MC_GENERICCD | Number(3,0) | SMALLINT NOT NULL | GenericCode |
34 | MC_REDUCTCD | Number(3,0) | SMALLINT NOT NULL | ReductCode |
35 | MC_GENERICNBR | Character(20) | VARCHAR2(20) NOT NULL | GenericNumber |
36 | MC_REDUCTNBR | Character(10) | VARCHAR2(10) NOT NULL | ReductNumber |
37 | MC_TRANSOTHERCD | Number(3,0) | SMALLINT NOT NULL | TransportationOtherCode |
38 | MC_GENERICOTHERCD | Number(3,0) | SMALLINT NOT NULL | GenericOtherCode |
39 | MC_REDUCTOTHERCD | Number(3,0) | SMALLINT NOT NULL | ReductOtherCode |
40 | MC_GENERICOTHERNBR | Character(20) | VARCHAR2(20) NOT NULL | GenericOtherNumber |
41 | MC_REDUCTOTHERNBR | Character(10) | VARCHAR2(10) NOT NULL | ReductOtherNumber |
42 | MC_NUMOFADULTS | Number(2,0) | SMALLINT NOT NULL | NumberOfAdults |
43 | MC_NUMOFCHILDREN | Number(2,0) | SMALLINT NOT NULL | NumberOfChildren |
44 | MC_SRVPROV | Character(40) | VARCHAR2(40) NOT NULL | ServiceProvider |
45 | MC_SRVOFFERED | Character(40) | VARCHAR2(40) NOT NULL | ServiceOffered |
46 | MC_CLASS | Character(1) | VARCHAR2(1) NOT NULL | Class |
47 | MC_PASSENGERNAME | Character(50) | VARCHAR2(50) NOT NULL | Passenger Name |