| # |
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_RENTALAGREEMENT |
Character(9) |
VARCHAR2(9) NOT NULL |
Rental Agreement Number
|
| 16 |
MC_RENTERNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Renter Name
|
| 17 |
MC_RETURNCITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Return City
|
| 18 |
MC_RETURNSTATECODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Return State Province
|
| 19 |
MC_RETURNCOUNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Return Country
|
| 20 |
MC_RETURNLOCID |
Character(10) |
VARCHAR2(10) NOT NULL |
Return Location Id
|
| 21 |
RETURN_DATE |
Date(10) |
DATE |
Return Date
|
| 22 |
CHECKOUT_DT |
Date(10) |
DATE |
Check Out Date
|
| 23 |
MC_CUSTSERVICETEL |
Character(17) |
VARCHAR2(17) NOT NULL |
Customer Service Toll Free Num
|
| 24 |
MC_RENTALRATEIND |
Character(1) |
VARCHAR2(1) NOT NULL |
Rental Rate Indicator
D=Daily
M=Monthly
W=Weekly
|
| 25 |
MC_RENTALRATE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Rental Rate
|
| 26 |
MC_RATEPERMILE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Rate Per Mile
|
| 27 |
MC_TOTALMILES |
Number(6,0) |
INTEGER NOT NULL |
Total Miles
|
| 28 |
MC_MAXFREEMILES |
Number(5,0) |
INTEGER NOT NULL |
Maximum Free Miles
|
| 29 |
MC_UNITOFDISTANCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Unit Of Distance Code
|
| 30 |
MC_INSURANCEFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance Indicator
Y/N Table Edit
|
| 31 |
MC_INSURANCECHARGS |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Insurance Charges
|
| 32 |
MC_ADJAMTINDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusted Amount Indicator
A=Drop-off
B=Delivery
C=Parking
D=Extra
E=Violations
X=Multiple
|
| 33 |
MC_ADJUSTEDAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Adjusted Amount
|
| 34 |
MC_PROGRAMCODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Program Code
|
| 35 |
MC_CHECKOUTCITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Check Out City
|
| 36 |
MC_CHECKOUTSTATE |
Character(10) |
VARCHAR2(10) NOT NULL |
Check Out State Province
|
| 37 |
MC_CHECKOUTCOUNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Check Out Country
|
| 38 |
MC_CHECKOUTLOCID |
Character(10) |
VARCHAR2(10) NOT NULL |
Check Out Location Id
|
| 39 |
MC_RENTALCLASS |
Character(4) |
VARCHAR2(4) NOT NULL |
Rental Class
|
| 40 |
MC_COMMODITYCODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Commodity Code
|
| 41 |
MC_TAXEXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Indicator
0=Not Applicable
1=Tax Exempt
|
| 42 |
MC_CORPORATEID |
Character(12) |
VARCHAR2(12) NOT NULL |
Corporate Identifier
|
| 43 |
MC_NOSHOWFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
No Show Indicator
0=N/A
1=No Show
|
| 44 |
MC_DAYSRENTED |
Number(4,0) |
SMALLINT NOT NULL |
Days Rented
|
| 45 |
MC_WEEKLYRATE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Weekly Rental Rate
|
| 46 |
MC_TOTALAUTHAMT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Total Authorized Amount
|
| 47 |
MC_ONEWAYDROPOFF |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
One Way Drop Off Charge
|
| 48 |
MC_REGULARMILEAMT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Regular Mileage Charge
|
| 49 |
MC_EXTRAMILEAMT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Extra Mileage Charge
|
| 50 |
MC_LATECHARGE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Late Charge
|
| 51 |
MC_FUELCHARGE |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Fuel Charge
|
| 52 |
MC_TOWINGCHARGES |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Towing Charges Amount
|
| 53 |
MC_EXTRACHARGES |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Extra Charges Amount
|
| 54 |
MC_OTHERCHARGESAMT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Other Charges Amount
|
| 55 |
MC_RESERVATIONNBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Reservation Number
|
| 56 |
MC_REGISTRATIONNBR |
Character(17) |
VARCHAR2(17) NOT NULL |
Vehicle Registration Number
|
| 57 |
MC_CHECKOUTLOC |
Character(50) |
VARCHAR2(50) NOT NULL |
Check Out Location
|
| 58 |
MC_RETURNLOCATION |
Character(50) |
VARCHAR2(50) NOT NULL |
Return Location
|
| 59 |
MC_GROUPCHARGED |
Character(4) |
VARCHAR2(4) NOT NULL |
Group Charged
|
| 60 |
MC_PHONECHARGES |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Telephone Charges
|
| 61 |
MC_OTHERVEHICLEINF |
Character(50) |
VARCHAR2(50) NOT NULL |
Other Vehicle Data
|