CC_MC_TBL5022

(SQL Table)
Index Back

MasterCard 5022

Passenger 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