| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
VS_LOADTRANSCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Transaction Code
1=Add transaction
2=Delete transaction
3=Update matching transaction
4=Update if existed or add
|
| 3 |
VS_CARDHOLDER_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Visa Cardholder ID
|
| 4 |
VS_ACCT_NBR |
Character(19) |
VARCHAR2(19) NOT NULL |
Account Number
|
| 5 |
VS_HIERARCHY_NODE |
Character(40) |
VARCHAR2(40) NOT NULL |
Hierarchy Node
|
| 6 |
CC_EFF_DATE |
Date(10) |
DATE |
Effective Date
|
| 7 |
CC_ACCT_OPEN_DATE |
Date(10) |
DATE |
Account Open Date
|
| 8 |
CC_ACCT_CLOSE_DATE |
Date(10) |
DATE |
Account Close Date
|
| 9 |
CC_EXPIRE_DATE |
Date(10) |
DATE |
Card Expire Date
|
| 10 |
VS_CARD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Card Type
1=Corporate
2=Purchasing
3=Business Credit
4=Commercial
5=Fleet
6=Distribution
7=Business Debit
|
| 11 |
CC_SPEND_LIMIT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Spending Limit
|
| 12 |
VS_STATEMENT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Frequency No
1=Weekly
2=Biweekly
3=Monthly
4=Automatic Transfer
|
| 13 |
CC_LAST_REV_DATE |
Date(10) |
DATE |
Last Revision Date
|
| 14 |
CC_TRANSSPENDLIMIT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Transaction Spending Limit
|
| 15 |
VS_CORP_PYMNT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Corporation Payment Indicator
0=No
1=Yes
|
| 16 |
VS_BILLING_ACCT_NO |
Character(19) |
VARCHAR2(19) NOT NULL |
Billing Account Number
|
| 17 |
VS_COST_CENTER |
Character(50) |
VARCHAR2(50) NOT NULL |
Cost Center
|
| 18 |
VS_GL_ACCT_NO |
Character(76) |
VARCHAR2(76) NOT NULL |
G/L Sub-account No.
|
| 19 |
VS_TRANS_DAILY_LMT |
Number(8,0) |
INTEGER NOT NULL |
Transaction Daily Limit
|
| 20 |
VS_TRANS_CYCLE_LMT |
Number(8,0) |
INTEGER NOT NULL |
Transaction Cycle Limit
|
| 21 |
CC_CASH_LIMIT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Cash Limit Amount
|
| 22 |
VS_STATUS_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Status Code
|
| 23 |
VS_REASON_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Status Code
1=Canceled
10=Voluntarily
11=Fraud
12=Write-off
13=Write-off Attorney
14=Write-off - Delinquency
15=Write-off - Bankruptcy
16=Write-off - Deceased
17=Write-off - Fraud
18=Write-off - Miscellaneous
2=Transferred from Another Acct
3=Transferred to Another Account
4=Suspended 2 times in 12 month
5=Past Due for Undisputed Amount
6=In Dispute
7=In Collection
8=Stolen or Lost
9=Left Employment
|
| 24 |
CC_STATUS_DATE |
Date(10) |
DATE |
Status Date
|
| 25 |
VS_PREFUNDED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre-funded Indicator
0=No
1=Yes
|
| 26 |
VS_CITY_PAIR_PRGRM |
Character(1) |
VARCHAR2(1) NOT NULL |
City Pair Program Indicator
0=No
1=Yes
|
| 27 |
VS_TASK_ORDER_NO |
Character(26) |
VARCHAR2(26) NOT NULL |
Task Order Number
|
| 28 |
VS_FLEET_SERVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Fleet Service Indicator
0=No
1=Yes
|
| 29 |
VS_CREDITRATING |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Rating
|
| 30 |
CC_CRRATINGDATE |
Date(10) |
DATE |
Credit Rating Date
|
| 31 |
VS_ANNUALFEEFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Annual Fee Flag
0=No Annual Fee
1=Annual Fee
|
| 32 |
VS_ANNUALFEEMONTH |
Character(2) |
VARCHAR2(2) NOT NULL |
Annual Fee Month
|
| 33 |
VS_VERIFYRECEIPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Verification Flag
0=Not Activated
1=Activated
|
| 34 |
VS_CHECKFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Indicator
1=Corporate
2=Individual
3=Diversion
|
| 35 |
VS_ACCOUNTTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Type Flag
1=Corporate
2=Individual
3=Diversion
|
| 36 |
CC_LOST_DATE |
Date(10) |
DATE |
Lost/Stolen Date
|
| 37 |
CC_CHARGEOFFDATE |
Date(10) |
DATE |
Charge-Off Date
|
| 38 |
CC_CHARGEOFFAMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Charge-Off Amount
|
| 39 |
VS_TRANSFERACCOUNT |
Character(19) |
VARCHAR2(19) NOT NULL |
Transfer Account Number
|
| 40 |
VS_CALLINGCARDTYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Calling Card/Phone Type
|
| 41 |
VS_EMBOSSLINE1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Emboss Line 1
|
| 42 |
VS_EMBOSSLINE2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Emboss Line 2
|
| 43 |
CC_CRCHANGEDATE |
Date(10) |
DATE |
Last Credit Limit Change Date
|
| 44 |
CC_MAINTDATE |
Date(10) |
DATE |
Last Maintenance Date NAR
|
| 45 |
VS_OPTIONAL_01 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 1
|
| 46 |
VS_OPTIONAL_02 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 2
|
| 47 |
VS_OPTIONAL_03 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 3
|
| 48 |
VS_OPTIONAL_04 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 4
|
| 49 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
|