| # |
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 |
VS_CCTRANS_NBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Transaction Number
|
| 4 |
VS_CCSEQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Visa Sequence Number
|
| 5 |
VS_PERIOD |
Character(5) |
VARCHAR2(5) NOT NULL |
Period
|
| 6 |
VS_ACQ_BIN |
Number(6,0) |
INTEGER NOT NULL |
Visa/Infospan Acquiring Bin
|
| 7 |
VS_CRD_ACC_ID |
Character(26) |
VARCHAR2(26) NOT NULL |
Visa/Infospan Card Acceptor ID
|
| 8 |
VS_SUPPLIER_NAME |
Character(26) |
VARCHAR2(26) NOT NULL |
Visa Supplier Name
|
| 9 |
VS_SUPPLIER_CITY |
Character(14) |
VARCHAR2(14) NOT NULL |
Visa Supplier City
|
| 10 |
VS_SUPPLIER_STATE |
Character(4) |
VARCHAR2(4) NOT NULL |
Supplier State/Province
|
| 11 |
VS_SUPPLIERCOUNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Supplier Country
|
| 12 |
VS_SUPPLIER_POSTAL |
Character(14) |
VARCHAR2(14) NOT NULL |
Supplier Postal Code
|
| 13 |
CC_SOURCE_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 14 |
CC_BILLING_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 15 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
VS_MERCHANT_CAT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Merchant Category Code
|
| 17 |
VS_CCTRANS_TYP_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Visa Transaction Type Code
10=Purchase
11=Credit Voucher
20=Manual Cash Disbursement
22=ATM Cash Disbursement
30=Payment Reversal - NSF Check
31=Payment
40=Finance Charge
50=Annual Fee
52=Miscellaneous Fees
54=NSF Check Fee
56=Report Fee
61=Credit Adjustment
62=Debit Adjustment
63=Finance Charge Credit Adjust
64=Finance Charge Debit Adjust
65=Other Credits
66=Other Debits
71=Fuel Discount
73=Non-Fuel Discount
80=Convenience Checks
82=Convenience Checks Fees
84=Travelers Checks Fees
86=ATM Fees
88=Late Fees
|
| 18 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 19 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 20 |
CC_TOTAL_TAX_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Total Tax Amount
|
| 21 |
CC_DISPUTE_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 22 |
VS_DISPUTE_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Dispute Reason Code
1=Not req
2=Illegible
3=Incomplete
4=No image
|
| 23 |
DISPUTE_DT |
Date(10) |
DATE |
Specifies the date that an item was placed in dispute status.
|
| 24 |
VS_COMMODITY_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Visa/Infospan Commodity Code
|
| 25 |
VS_SPPLY_VAT_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Visa/Infospan Supplier Vat Nbr
|
| 26 |
VS_SUPPLIER_ORD_NB |
Character(25) |
VARCHAR2(25) NOT NULL |
Supplier Order Number
|
| 27 |
VS_CUST_VAT_NBR |
Character(14) |
VARCHAR2(14) NOT NULL |
Visa/Infospan Cust Vat Nbr
|
| 28 |
CC_TOTAL_VAT_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Total VAT Amount
|
| 29 |
CC_TOTAL_TAX2_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Total Tax2 Amount
|
| 30 |
VS_PURCH_ID_FRMT |
Character(2) |
VARCHAR2(2) NOT NULL |
Visa/Infospan Purchase ID Frmt
0=Contains free item description
1=Contains other numbers
3=Contains Rental Agreement No
4=Contains Hotel Folio No
|
| 31 |
VS_PURCH_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Visa/Infospan Purchase ID
|
| 32 |
VS_CUSTOMER_CODE |
Character(76) |
VARCHAR2(76) NOT NULL |
Customer Code / CRI
|
| 33 |
VS_TRANS_TIME |
Number(4,0) |
SMALLINT NOT NULL |
Transaction Time
|
| 34 |
VS_TAX_INCLUDED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Amount Included
0=Not incl
1=Tax incl
2=No Tax
|
| 35 |
VS_TAX2_INCLUDED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax2 Amount Included
0=Nontaxable
1=Taxable
|
| 36 |
VS_ORDER_TYPE_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Order Type Code
1=Mail/Phone
2=Recurring
3=Installmnt
4=Unknown
5=JET SECT
6=w/ SET
7=w/o SET
8=Non-secure
9=Non-comply
|
| 37 |
VS_MESSAGE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Message Identifier
|
| 38 |
VS_PROCESSOR_KEY |
Character(52) |
VARCHAR2(52) NOT NULL |
Processor Addendum Key
|
| 39 |
VS_MPS_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Merchant Profile Service ID
|
| 40 |
VS_USAGECODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Usage Code
1=First Usage
2=Second Usage
|
| 41 |
VS_ENRICHEDFLAG |
Character(2) |
VARCHAR2(2) NOT NULL |
Enriched Transaction Flag
0=Not Retrns
1=Retrns
|
| 42 |
VS_BILLINGACCTNBR |
Character(19) |
VARCHAR2(19) NOT NULL |
Billing Account Number
|
| 43 |
VS_DDA_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
DDA Number
|
| 44 |
VS_DDA_SAVINGS_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
DDA Savings Number
|
| 45 |
VS_DISPUTE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Dispute Status Code
|
| 46 |
VS_MATCHEDFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Matched Indicator
0=Not Match
1=Match
|
| 47 |
VS_ROUTINGNBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Routing Number
|
| 48 |
VS_AUTHORIZATIONNO |
Character(6) |
VARCHAR2(6) NOT NULL |
Authorization Number
|
| 49 |
VS_APPROVALFLAG |
Character(2) |
VARCHAR2(2) NOT NULL |
Cardholder Approval
|
| 50 |
VS_EXTRACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Extract ID
|
| 51 |
VS_MEMOPOSTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Memo Post Flag
0=Not Posted
1=Posted
|
| 52 |
STATEMENT_DT |
Date(10) |
DATE |
Statement Date
|
| 53 |
VS_USERDATA1 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 1
|
| 54 |
VS_USERDATA1DESC |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 1 Description
|
| 55 |
VS_USERDATA2 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 2
|
| 56 |
VS_USERDATA2DESC |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 2 Description
|
| 57 |
VS_USERDATA3 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 3
|
| 58 |
VS_USERDATA3DESC |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 3 Description
|
| 59 |
VS_USERDATA4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 4
|
| 60 |
VS_USERDATA4DESC |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 4 Description
|
| 61 |
VS_USERDATA5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 5
|
| 62 |
VS_USERDATA5DESC |
Character(20) |
VARCHAR2(20) NOT NULL |
User Data 5 Description
|
| 63 |
VS_BATCH_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Visa Commerce Batch ID
|
| 64 |
CC_PAYINSTRUCTDATE |
Date(10) |
DATE |
Payment Instruction Date
|
| 65 |
VS_ITEMMATCHEDFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Item Matched Indicator
0=Not Match
1=Match
|
| 66 |
VS_ISSUERUSAGECODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Issuer-Defined Usage Code
|
| 67 |
VS_SOURCE |
Character(10) |
VARCHAR2(10) NOT NULL |
Source
|
| 68 |
VS_OPTIONAL_01 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 1
|
| 69 |
VS_OPTIONAL_02 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 2
|
| 70 |
VS_OPTIONAL_03 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 3
|
| 71 |
VS_OPTIONAL_04 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 4
|
| 72 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 73 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 74 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 75 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 76 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 77 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 78 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 79 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 80 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 81 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 82 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 83 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 84 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 85 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 86 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 87 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 88 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 89 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 90 |
BILLING_DATE |
Date(10) |
DATE |
Billing Date
|
| 91 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 92 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 93 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 94 |
SEQUENCENO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
|