| # |
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_PARTYTYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Party Type
BY=Buyer
DP=Delivery
IV=Invoice
PE=Payee
SF=Ship From
SU=Supplier
|
| 16 |
MC_PARTYID |
Character(25) |
VARCHAR2(25) NOT NULL |
Party Id
|
| 17 |
MC_NAME1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Name1
|
| 18 |
MC_NAME2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Name2
|
| 19 |
MC_NAME3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Name3
|
| 20 |
MC_STREET1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Street1
|
| 21 |
MC_STREET2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Street2
|
| 22 |
MC_STREET3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Street3
|
| 23 |
MC_STREET4 |
Character(50) |
VARCHAR2(50) NOT NULL |
Street4
|
| 24 |
MC_STREET5 |
Character(50) |
VARCHAR2(50) NOT NULL |
Street5
|
| 25 |
MC_STREET6 |
Character(50) |
VARCHAR2(50) NOT NULL |
Street6
|
| 26 |
MC_CITY |
Character(20) |
VARCHAR2(20) NOT NULL |
City
|
| 27 |
MC_STATEPROVINCE |
Character(10) |
VARCHAR2(10) NOT NULL |
State/Province
|
| 28 |
MC_POSTALCODE |
Character(13) |
VARCHAR2(13) NOT NULL |
Postal Code
|
| 29 |
MC_COUNTRYCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Country Code
|
| 30 |
MC_CONTACTNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Authorized Contact Name
|
| 31 |
MC_CONTACTFUNCTION |
Character(50) |
VARCHAR2(50) NOT NULL |
Contact Function
|
| 32 |
MC_PHONENBR |
Character(25) |
VARCHAR2(25) NOT NULL |
Phone Number
|
| 33 |
MC_EMAILADDRESS |
Character(60) |
VARCHAR2(60) NOT NULL |
EMail Address
|
| 34 |
MC_FUNCTION |
Character(50) |
VARCHAR2(50) NOT NULL |
Function
|