| # |
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_USERNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
User Name
|
| 16 |
MC_USERACCOUNTNBR |
Character(19) |
VARCHAR2(19) NOT NULL |
User Account Number
|
| 17 |
MC_BILLINGSTARTDT |
Date(10) |
DATE |
Billing Statement Start Date
|
| 18 |
MC_BILLINGENDDT |
Date(10) |
DATE |
Billing Statement End Date
|
| 19 |
MC_BILLEVENTDESC1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description1
|
| 20 |
MC_BILLEVENTAMT1 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount1
|
| 21 |
MC_BILLEVENTDESC2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description2
|
| 22 |
MC_BILLEVENTAMT2 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount2
|
| 23 |
MC_BILLEVENTDESC3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description3
|
| 24 |
MC_BILLEVENTAMT3 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount3
|
| 25 |
MC_BILLEVENTDESC4 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description4
|
| 26 |
MC_BILLEVENTAMT4 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount4
|
| 27 |
MC_BILLEVENTDESC5 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description5
|
| 28 |
MC_BILLEVENTAMT5 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount5
|
| 29 |
MC_BILLEVENTDESC6 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description6
|
| 30 |
MC_BILLEVENTAMT6 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount6
|
| 31 |
MC_BILLEVENTDESC7 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description7
|
| 32 |
MC_BILLEVENTAMT7 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount7
|
| 33 |
MC_BILLEVENTDESC8 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description8
|
| 34 |
MC_BILLEVENTAMT8 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount8
|
| 35 |
MC_BILLEVENTDESC9 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description9
|
| 36 |
MC_BILLEVENTAMT9 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount9
|
| 37 |
MC_BILLEVENTDESC10 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description10
|
| 38 |
MC_BILLEVENTAMT10 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount10
|
| 39 |
MC_BILLEVENTDESC11 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description11
|
| 40 |
MC_BILLEVENTAMT11 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount11
|
| 41 |
MC_BILLEVENTDESC12 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description12
|
| 42 |
MC_BILLEVENTAMT12 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount12
|
| 43 |
MC_BILLEVENTDESC13 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description13
|
| 44 |
MC_BILLEVENTAMT13 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount13
|
| 45 |
MC_BILLEVENTDESC14 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description14
|
| 46 |
MC_BILLEVENTAMT14 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount14
|
| 47 |
MC_BILLEVENTDESC15 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description15
|
| 48 |
MC_BILLEVENTAMT15 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount15
|
| 49 |
MC_BILLEVENTDESC16 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description16
|
| 50 |
MC_BILLEVENTAMT16 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount16
|
| 51 |
MC_BILLEVENTDESC17 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description17
|
| 52 |
MC_BILLEVENTAMT17 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount17
|
| 53 |
MC_BILLEVENTDESC18 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description18
|
| 54 |
MC_BILLEVENTAMT18 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount18
|
| 55 |
MC_BILLEVENTDESC19 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description19
|
| 56 |
MC_BILLEVENTAMT19 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount19
|
| 57 |
MC_BILLEVENTDESC20 |
Character(40) |
VARCHAR2(40) NOT NULL |
Billing Event Description20
|
| 58 |
MC_BILLEVENTAMT20 |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Billing Event Amount20
|
| 59 |
MC_LINEITEMTOTAL |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Line Item Total Amount
|
| 60 |
MC_TOTALTAXAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
TotalAmount of all Taxcalculated for this transaction. In original currency. Implied decimal alignment is based on the exponent.
|