| # |
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_PURCHASE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Type
1=Fuel
2=Non-fuel
3=Both
|
| 6 |
VS_FUEL_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Fuel Type
00=Other
01=Unlead 86
02=Unlead 87
03=Unlead 88
04=Unlead 89
05=Unlead 90
06=Unlead 91
07=Unlead 92
08=Unlead 93
09=Unlead 94
11=Leaded
12=Diesel
13=D. Premium
14=Kerosene
15=LPG
16=Gasohol
17=CNG
18=Meth 85
19=Meth 10
20=Meth 7
21=Meth 5
22=Ethanol 85
23=Ethanol 10
24=Ethanol 7
25=Ethanol 5
26=Jet Fuel
27=Aviation F
28=Off-Road D
29=Marine
|
| 7 |
VS_FUEL_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Fuel Unit of Measure Code
G=US Gallon
I=Imperial G
K=Kilo
L=Liter
P=Pound
|
| 8 |
CC_FUEL_QTY |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Four decimal places are implied (ex 123456 = 12.3456).
|
| 9 |
CC_FUEL_UNIT_COST |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Four decimal places are implied (ex 123456 = 12.3456).
|
| 10 |
CC_FUEL_GROSS_AMT |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Four decimal places are implied (ex 123456 = 12.3456).
|
| 11 |
CC_FUEL_NET_AMT |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Four decimal places are implied (ex 123456 = 12.3456).
|
| 12 |
CC_NONFUEL_GROSS |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Four decimal places are implied (ex 123456 = 12.3456).
|
| 13 |
CC_NONFUEL_NET |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Four decimal places are implied (ex 123456 = 12.3456).
|
| 14 |
VS_ODOMETER_READ |
Character(8) |
VARCHAR2(8) NOT NULL |
Odometer Reading
|
| 15 |
CC_VAT_TAX_RATE |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Four decimal places are implied (ex 123456 = 12.3456).
|
| 16 |
CC_FUEL_MISC_TAX |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Four decimal places are implied (ex 123456 = 12.3456).
|
| 17 |
CC_NONFUEL_MISCTAX |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Four decimal places are implied (ex 123456 = 12.3456).
|
| 18 |
VS_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Type
F=Full Serv
S=Self Serv
|
| 19 |
VS_FUEL_MSC_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Fuel Miscellaneous Tax Exempt
0=Non-Exempt
1=Exempt
|
| 20 |
VS_NONFUEL_MSCXMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Fuel Misc Tax Exempt
0=Non-Exempt
1=Exempt
|
| 21 |
VS_MESSAGE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Message Identifier
|
| 22 |
VS_FED_NF_EXCISE_X |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Non-Fuel Excise Exempt
0=Non-Exempt
1=Exempt
|
| 23 |
CC_FED_NF_EXCISE_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 24 |
VS_FED_F_EXCISE_X |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Fuel Excise Exempt
0=Non-Exempt
1=Exempt
|
| 25 |
CC_FED_F_EXCISE_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 26 |
VS_STA_MTR_F_TAX_X |
Character(1) |
VARCHAR2(1) NOT NULL |
State Motor Fuel Tax Exempt
0=Non-Exempt
1=Exempt
|
| 27 |
CC_STA_MTR_F_TAX_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 28 |
VS_CNTY_FUEL_TAX_X |
Character(1) |
VARCHAR2(1) NOT NULL |
County Fuel Sales Tax Exempt
0=Non-Exempt
1=Exempt
|
| 29 |
CC_CNTY_FUEL_TAX_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 30 |
VS_STALCL_NF_TAX_X |
Character(1) |
VARCHAR2(1) NOT NULL |
State&Local Non-Fuel Tx Exempt
0=Non-Exempt
1=Exempt
|
| 31 |
CC_STALCL_NF_TAX_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 32 |
VS_CNTY_MTR_F_TX_X |
Character(1) |
VARCHAR2(1) NOT NULL |
County Motor Fuel Tax Exempt
0=Non-Exempt
1=Exempt
|
| 33 |
CC_CNTY_MTR_F_TX_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 34 |
VS_CITY_FUEL_TAX_X |
Character(1) |
VARCHAR2(1) NOT NULL |
City Fuel Sales Tax Exempt
0=Non-Exempt
1=Exempt
|
| 35 |
CC_CITY_FUEL_TAX_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 36 |
VS_CITY_MTR_F_TX_X |
Character(1) |
VARCHAR2(1) NOT NULL |
City Motor Fuel Tax Exempt
0=Non-Exempt
1=Exempt
|
| 37 |
CC_CITY_MTR_F_TX_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 38 |
VS_STA_2ND_F_TAX_X |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary State Fuel Tx Exempt
0=Non-Exempt
1=Exempt
|
| 39 |
CC_STA_2ND_F_TAX_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 40 |
VS_FED_SALES_TAX_X |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Sales Tax Exempt
0=Non-Exempt
1=Exempt
|
| 41 |
CC_FED_SALES_TAX_A |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 42 |
VS_PURCH_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Visa/Infospan Purchase ID
|
| 43 |
CC_SOURCE_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Two decimal places are implied (ex 1234 = 12.34).
|
| 44 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 45 |
VS_MERCHANT_CAT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Merchant Category Code
|
| 46 |
VS_SUPPLIER_NAME |
Character(26) |
VARCHAR2(26) NOT NULL |
Visa Supplier Name
|
| 47 |
VS_SUPPLIER_POSTAL |
Character(14) |
VARCHAR2(14) NOT NULL |
Supplier Postal Code
|
| 48 |
VS_PROCESSOR_KEY |
Character(52) |
VARCHAR2(52) NOT NULL |
Processor Addendum Key
|
| 49 |
VS_OPTIONAL_01 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 1
|
| 50 |
VS_OPTIONAL_02 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 2
|
| 51 |
VS_OPTIONAL_03 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 3
|
| 52 |
VS_OPTIONAL_04 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 4
|