| # |
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_TAXAMOUNTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Amount Indicator
Y/N Table Edit
|
| 16 |
MC_TAXAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Tax Amount
|
| 17 |
MC_TAXRATE |
Number(26,9) |
DECIMAL(25,9) NOT NULL |
Tax Rate
|
| 18 |
MC_TAXTYPEAPPLIED |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Type Applied
|
| 19 |
MC_TAXTYPEIDENTIFI |
Character(2) |
VARCHAR2(2) NOT NULL |
Tax Type Identifier
00=Unknown
01=Fed/Nad
02=State
03=City
04=Local
05=Municipal
06=Other
10=VAT
11=GST
12=Provincial
20=Room
21=Occupancy
22=Energy
|
| 20 |
MC_TAXLOCATION |
Character(35) |
VARCHAR2(35) NOT NULL |
Tax Location
|
| 21 |
MC_CA_TAXID |
Character(20) |
VARCHAR2(20) NOT NULL |
Tax Id
|
| 22 |
MC_TAXPOINTDATE |
Date(10) |
DATE |
Tax Point Date
|
| 23 |
MC_NETAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Net Amount
|
| 24 |
MC_DISCOUNTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Indicator
Y/N Table Edit
|
| 25 |
MC_DISCOUNTAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Transaction Discount Amount
|
| 26 |
MC_TAXABLEAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Taxable Amount
|
| 27 |
MC_TAXTREATMENT |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Treatment
GIL=Items are Gross - Invoice
GLL=Items are Gross - Line
NIL=Items are Net - Invoice
NLL=Items are Net - Line
NON=Tax does not apply
|