| # |
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_OILCOMPANYBRAND |
Character(4) |
VARCHAR2(4) NOT NULL |
Oil Company Brand
|
| 16 |
MC_TIMEOFPURCHASE |
Character(12) |
VARCHAR2(12) NOT NULL |
Time Of Purchase
|
| 17 |
MC_MTRFUELSERVTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Motor Fuel Service Type
1=Self
2=Full
3=Nonfuel
|
| 18 |
MC_MTRFUELPRODCODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Motor Fuel Product Code
|
| 19 |
MC_MTRFUELPRICE |
Signed Number(27,9) |
DECIMAL(25,9) NOT NULL |
Motor Fuel Unit Price
|
| 20 |
MC_MTRFUELUOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Motor Fuel Unit Of Measure
1=Gallons
2=Liters
3=Pounds
4=Kilos
5=Imperial G
|
| 21 |
MC_MTRFUELQUANTITY |
Signed Number(27,9) |
DECIMAL(25,9) NOT NULL |
Motor Fuel Quantity
|
| 22 |
MC_MTRFUELSALEAMT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Motor Fuel Sale Amount
|
| 23 |
MC_ODOMETERREADING |
Number(7,0) |
INTEGER NOT NULL |
Odometer Reading
|
| 24 |
MC_VEHICLENBR |
Character(17) |
VARCHAR2(17) NOT NULL |
Vehicle Number
|
| 25 |
MC_DRIVERORIDNBR |
Character(17) |
VARCHAR2(17) NOT NULL |
Driver Or Id Number
|
| 26 |
MC_PRODUCTTYPECODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Type Code
1=ID/Odo
2=VNo/Odo
3=Driver/Odo
4=Odometer
5=None
|
| 27 |
MC_COUPONDISCOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Coupon Discount Amount
|
| 28 |
MC_COMMODITYCODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Commodity Code
|
| 29 |
MC_TAXEXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Indicator
0=Not Applicable
1=Tax Exempt
|
| 30 |
MC_NETFUELPRICE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Net Fuel Price
|
| 31 |
MC_ADDFUELLOCINFO |
Character(14) |
VARCHAR2(14) NOT NULL |
Additional Fuel Location Info
|
| 32 |
MC_TXXMPFEDSALE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Fed Sales
0=Not Applicable
1=Tax Exempt
|
| 33 |
MC_TXAMTFEDSALE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount Fed Sales
|
| 34 |
MC_TXXMPFEDXCFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Fed Excise Fuel
0=Not Applicable
1=Tax Exempt
|
| 35 |
MC_TXAMTFEDXCFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount Fed Excise Fuel
|
| 36 |
MC_TXXMPFEDXCNOFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Fed Excise Non Fuel
0=Not Applicable
1=Tax Exempt
|
| 37 |
MC_TXAMTFEDXCNOFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount Fed Excise NonFuel
|
| 38 |
MC_TXXMPFEDXC |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Fed Excise
0=Not Applicable
1=Tax Exempt
|
| 39 |
MC_TXAMTFEDXC |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount Fed Excise
|
| 40 |
MC_COMPCODEFEDXC |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code Fed Excise
|
| 41 |
MC_REASONFEDXC |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code Fed Excise
|
| 42 |
MC_ISSRULEFEDXC |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule Fed Excise
|
| 43 |
MC_TXXMPSTEMTRFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt State Motor Fuel
0=Not Applicable
1=Tax Exempt
|
| 44 |
MC_TXAMTSTEMTRFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount State Motor Fuel
|
| 45 |
MC_TXXMPSTEENV1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt State Env Tax1
0=Not Applicable
1=Tax Exempt
|
| 46 |
MC_TXAMTSTEENV1 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount State Env Tax1
|
| 47 |
MC_COMPCODESTEENV1 |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code State Env Tax1
|
| 48 |
MC_REASONSTEENV1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code State Env Tax1
|
| 49 |
MC_ISSRULESTEENV1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule State Env Tax1
|
| 50 |
MC_TXXMPSTEENV2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt State Env Tax2
0=Not Applicable
1=Tax Exempt
|
| 51 |
MC_TXAMTSTEENV2 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount State Env Tax2
|
| 52 |
MC_COMPCODESTEENV2 |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code State Env Tax2
|
| 53 |
MC_REASONSTEENV2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code State Env Tax2
|
| 54 |
MC_ISSRULESTEENV2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule State Env Tax2
|
| 55 |
MC_TXXMPSTEXC1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt State Excise Tax1
0=Not Applicable
1=Tax Exempt
|
| 56 |
MC_TXAMTSTEXC1 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount State Excise1
|
| 57 |
MC_COMPCODESTEXC1 |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code State Excise1
|
| 58 |
MC_REASONSTEXC1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code State Excise1
|
| 59 |
MC_ISSRULESTEXC1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule State Excise1
|
| 60 |
MC_TXXMPSTEXC2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt State Excise Tax2
0=Not Applicable
1=Tax Exempt
|
| 61 |
MC_TXAMTSTEXC2 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount State Excise2
|
| 62 |
MC_COMPCODESTEXC2 |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code State Excise2
|
| 63 |
MC_REASONSTEXC2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code State Excise2
|
| 64 |
MC_ISSRULESTEXC2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule State Excise2
|
| 65 |
MC_TXXMPSTESALE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt State Sales
0=Not Applicable
1=Tax Exempt
|
| 66 |
MC_TXAMTSTESALE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount State Sales
|
| 67 |
MC_COMPCODESTESALE |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code State Sales
|
| 68 |
MC_REASONSTESALE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code State Sales
|
| 69 |
MC_ISSRULESTESALE |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule State Sales
|
| 70 |
MC_TXXMPSTELCNOFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt State/Local NonFuel
0=Not Applicable
1=Tax Exempt
|
| 71 |
MC_TXAMTSTELCNOFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount State/Local NonFuel
|
| 72 |
MC_TXXMP2NDSTEFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt 2nd State Fuel
0=Not Applicable
1=Tax Exempt
|
| 73 |
MC_TXAMT2NDSTEFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount 2nd State Fuel
|
| 74 |
MC_TXXMPCNTMTRFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt County Motor Fuel
0=Not Applicable
1=Tax Exempt
|
| 75 |
MC_TXAMTCNTMTRFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount County Motor Fuel
|
| 76 |
MC_TXXMPCNTSALE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt County Sales
0=Not Applicable
1=Tax Exempt
|
| 77 |
MC_TXAMTCNTSALE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount County Sales
|
| 78 |
MC_COMPCODECNTSALE |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code County Sales
|
| 79 |
MC_REASONCNTSALE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code County Sales
|
| 80 |
MC_ISSRULECNTSALE |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule County Sales
|
| 81 |
MC_TXXMPCNTXC |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt County Excise
0=Not Applicable
1=Tax Exempt
|
| 82 |
MC_TXAMTCNTXC |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount County Excise
|
| 83 |
MC_COMPCODECNTXC |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code County Excise
|
| 84 |
MC_REASONCNTXC |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code County Excise
|
| 85 |
MC_ISSRULECNTXC |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule County Excise
|
| 86 |
MC_TXXMPLCSALE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Local Sales
0=Not Applicable
1=Tax Exempt
|
| 87 |
MC_TXAMTLCSALE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount Local Sales
|
| 88 |
MC_TXXMPCTYMTRFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt City Motor Fuel
0=Not Applicable
1=Tax Exempt
|
| 89 |
MC_TXAMTCTYMTRFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount City Motor Fuel
|
| 90 |
MC_TXXMPCTYSALEFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt City Sales Fuel
0=Not Applicable
1=Tax Exempt
|
| 91 |
MC_TXAMTCTYSALEFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount City Sales Fuel
|
| 92 |
MC_TXXMPCTYLCXC |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt City Local Excise
0=Not Applicable
1=Tax Exempt
|
| 93 |
MC_TXAMTCTYLCXC |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount City Local Excise
|
| 94 |
MC_COMPCODECTYLCXC |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code City Local Exc
|
| 95 |
MC_REASONCTYLCXC |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code City Local Excise
|
| 96 |
MC_ISSRULECTYLCXC |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule City Local Excise
|
| 97 |
MC_TXXMPCTYLC |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt City Local Sales
0=Not Applicable
1=Tax Exempt
|
| 98 |
MC_TXAMTCTYLC |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount City Local Sales
|
| 99 |
MC_COMPCODECTYLC |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code City Local
|
| 100 |
MC_REASONCTYLC |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code City Local Sales
|
| 101 |
MC_ISSRULECTYLC |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule City Local Sales
|
| 102 |
MC_TXXMPMSCFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Misc Fuel
0=Not Applicable
1=Tax Exempt
|
| 103 |
MC_TXAMTMSCFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount Misc Fuel
|
| 104 |
MC_TXXMPMSCNOFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Misc NonFuel
0=Not Applicable
1=Tax Exempt
|
| 105 |
MC_TXAMTMSCNOFUL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount Misc NonFuel
|
| 106 |
MC_TXXMPGRSRCPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Gross Receipts
0=Not Applicable
1=Tax Exempt
|
| 107 |
MC_TXAMTGRSRCPT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount Gross Receipts
|
| 108 |
MC_COMPCODEGRSRCPT |
Number(4,0) |
SMALLINT NOT NULL |
Completion Code Gross Receipts
|
| 109 |
MC_REASONGRSRCPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Code Gross Receipts
|
| 110 |
MC_ISSRULEGRSRCPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Issuers Rule Gross Receipts
|
| 111 |
MC_CAPSCARDFINNBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Caps/Card Finance Number
|
| 112 |
MC_MAINTENANCEPONO |
Character(9) |
VARCHAR2(9) NOT NULL |
Maintainance Purchase Order No
|
| 113 |
MC_VOYAGERACCTNBR |
Character(14) |
VARCHAR2(14) NOT NULL |
Voyager Account Number
|
| 114 |
MC_DISCOUNTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Indicator
Y/N Table Edit
|
| 115 |
MC_DISCOUNTAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Transaction Discount Amount
|
| 116 |
MC_ITEMSEQUENCENBR |
Number(3,0) |
SMALLINT NOT NULL |
Item Sequence Number
|
| 117 |
MC_REIMBURSEMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reimbursement Indicator
Y/N Table Edit
|
| 118 |
MC_MESSAGEID |
Character(15) |
VARCHAR2(15) NOT NULL |
Message Id
|
| 119 |
MC_NETNONFUELPRICE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Net NonFuel Price
|
| 120 |
MC_VATTAXRATE |
Number(15,9) |
DECIMAL(14,9) NOT NULL |
VAT Tax Rate
|