| # |
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_PROCESSTRANSID |
Character(50) |
VARCHAR2(50) NOT NULL |
Processor Transaction ID
|
| 16 |
MC_REVERSALFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal Flag
O=Original
R=Reversal
|
| 17 |
MC_ESTIMATEDTAXIND |
Character(1) |
VARCHAR2(1) NOT NULL |
Estimated Tax Indicator
0=N/A
1=Dest Zip
2=Zip Code
3=City
4=POS
5=Insuff
6=Tax Exempt
7=Province
8=State
|
| 18 |
MC_FINTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Financial Transaction ID
|
| 19 |
MC_ALTACCTNBR1 |
Character(19) |
VARCHAR2(19) NOT NULL |
Alternate Account Number 1
|
| 20 |
MC_ALTACCTTYPE1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Account Type 1
A=Approval
B=Billing
C=Corporate
D=Diversion
F=Finance
I=Individual
O=Other
S=Supplier
T=Transfer
|
| 21 |
MC_ALTACCTNBR2 |
Character(19) |
VARCHAR2(19) NOT NULL |
Alternate Account Number 2
|
| 22 |
MC_ALTACCTTYPE2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Account Type 2
A=Approval
B=Billing
C=Corporate
D=Diversion
F=Finance
I=Individual
O=Other
S=Supplier
T=Transfer
|
| 23 |
MC_ALTACCTNBR3 |
Character(19) |
VARCHAR2(19) NOT NULL |
Alternate Account Number 3
|
| 24 |
MC_ALTACCTTYPE3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Account Type 3
A=Approval
B=Billing
C=Corporate
D=Diversion
F=Finance
I=Individual
O=Other
S=Supplier
T=Transfer
|
| 25 |
MC_ACQREFDATA |
Character(23) |
VARCHAR2(23) NOT NULL |
Acquirer Reference Data
|
| 26 |
MC_TRANSTYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Cardholder Transaction Type
00=Purchase
01=ATM
12=Cash
17=Check
18=Unique
19=Fee
20=Credit
28=Payment
29=Fee
50=Transfer
|
| 27 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 28 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 29 |
BILLING_DATE |
Date(10) |
DATE |
Billing Date
|
| 30 |
MC_APPROVALCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Approval Code
|
| 31 |
MC_BANKNETREFNBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Banknet Reference Num
|
| 32 |
MC_CA_TERMINALID |
Character(8) |
VARCHAR2(8) NOT NULL |
Card Acceptor Terminal ID
|
| 33 |
MC_DEBITORCREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit/Credit Indicator
C=Credit
D=Debit
|
| 34 |
MC_ORIGAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Amount of transaction in original transaction currency. Implied decimal alignment is based on the exponent. Required field.
MC_ORIGAMOUNT (Source Transaction Amount) = TXN_AMOUNT
|
| 35 |
MC_ORIGCURRENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
MC_ORIGCURRENCY (Source Transaction Currency) = TXN_CURRENCY_CD
|
| 36 |
MC_POSTEDAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Amount in Posted Currency
|
| 37 |
MC_POSTEDCURRENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Posted Currency Code
|
| 38 |
MC_POSTEDCONVDATE |
Character(5) |
VARCHAR2(5) NOT NULL |
It contains a Julian Date.
|
| 39 |
MC_POSTEDCONVRATE |
Number(18,9) |
DECIMAL(17,9) NOT NULL |
Posted Curr. Conversion Rate
|
| 40 |
MC_NATLAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Amount in National Currency
|
| 41 |
MC_NATLCURRENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
National Currency Code
|
| 42 |
MC_NATLCONVDATE |
Character(5) |
VARCHAR2(5) NOT NULL |
National Curr. Conversion Date
|
| 43 |
MC_NATLCONVRATE |
Number(18,9) |
DECIMAL(17,9) NOT NULL |
National Curr. Conversion Rate
|
| 44 |
MC_BILLINGAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Amount in Billing Currency
|
| 45 |
MC_BILLINGCURRENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Currency Code
|
| 46 |
MC_BILLINGCONVDATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Curr. Conversion Date
|
| 47 |
MC_BILLINGCONVRATE |
Number(18,9) |
DECIMAL(17,9) NOT NULL |
Billing Curr. Conversion Rate
|
| 48 |
MC_CUSTOMERCODE |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer Code
|
| 49 |
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.
|
| 50 |
MC_TOTALTAXCOLLECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Tax Collected Indicator
0=No
N=No
Y=Yes
|
| 51 |
MC_CORPVATNBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Corporation VAT Number
|
| 52 |
MC_ACCEPTORREFNBR |
Character(17) |
VARCHAR2(17) NOT NULL |
Card Acceptor Reference Number
|
| 53 |
MC_FREIGHTAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Freight Amount
|
| 54 |
MC_DUTYAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Duty Amount
|
| 55 |
MC_DESTPOSTAL |
Character(13) |
VARCHAR2(13) NOT NULL |
Destination Postal Code
|
| 56 |
MC_DESTSTATE |
Character(10) |
VARCHAR2(10) NOT NULL |
Destination State Province
|
| 57 |
MC_DESTCOUNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Country Code
|
| 58 |
MC_SHIPFROMPOSTAL |
Character(13) |
VARCHAR2(13) NOT NULL |
Ship From Postal Code
|
| 59 |
ORDER_DATE |
Date(10) |
DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 60 |
MC_CUSTOMERVATNBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Customer VAT Number
|
| 61 |
MC_UNIQUEINVOICE |
Character(35) |
VARCHAR2(35) NOT NULL |
Unique Invoice Number
|
| 62 |
MC_COMMODITYCODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Commodity Code
|
| 63 |
MC_CONTACTNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Authorized Contact Name
|
| 64 |
MC_CONTACTPHONE |
Character(25) |
VARCHAR2(25) NOT NULL |
Authorized Contact Phone
|
| 65 |
MC_TAXEXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Indicator
0=Not Applicable
1=Tax Exempt
|
| 66 |
MC_DISCOUNTAMOUNT |
Signed Number(22,4) |
DECIMAL(20,4) NOT NULL |
Transaction Discount Amount
|
| 67 |
MC_DISCOUNTTYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction Discount Type
|
| 68 |
MC_MEMOFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Memo Flag
M=Separate
|
| 69 |
MC_CA_ADDITIONNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Card Acceptor Additional Name
|
| 70 |
MC_INTERNETFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Internet Transaction Indicator
Y/N Table Edit
|
| 71 |
MC_MAILORDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Mail/Telephone Order
1=Single
2=Recurring
3=Installmnt
4=Unknown
|
| 72 |
MC_ECOMMERCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Electric Commerce Indicator
5=SET
6=Cert
7=No Cert
8=Non-Secure
|
| 73 |
MC_DISPUTETRACKNBR |
Character(23) |
VARCHAR2(23) NOT NULL |
Dispute Tracking Number
|
| 74 |
MC_ISSUERTRANSCODE |
Character(14) |
VARCHAR2(14) NOT NULL |
Issuer Transaction Code
|
| 75 |
MC_TRANSCATEGORY |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Category
|
| 76 |
MC_TRANSFERFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Flag
|
| 77 |
MC_TRANSLATEFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Translate Flag
|
| 78 |
MC_TRANSCODEQUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Code Qualifier
|
| 79 |
MC_VATELIGIBLE |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Eligible Indicator
|
| 80 |
MC_ACQUIRINGICA |
Character(11) |
VARCHAR2(11) NOT NULL |
Acquiring ICA
|
| 81 |
MC_CARDACCEPTORID |
Character(15) |
VARCHAR2(15) NOT NULL |
Card Acceptor ID
|
| 82 |
SEQUENCENO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
|