CC_VISA_TAO06

#	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_COMPANY_ID	Character(10)	VARCHAR2(10) NOT NULL	Company Identification
4	VS_COMPANY_NAME	Character(80)	VARCHAR2(80) NOT NULL	Company Name
5	VS_ADDRESS_LINE1	Character(80)	VARCHAR2(80) NOT NULL	Address Line 1
6	VS_ADDRESS_LINE2	Character(80)	VARCHAR2(80) NOT NULL	Address Line 2
7	VS_CITY	Character(20)	VARCHAR2(20) NOT NULL	City
8	VS_STATE_CODE	Character(4)	VARCHAR2(4) NOT NULL	State/Province Code
9	VS_COUNTRY_CODE	Character(5)	VARCHAR2(5) NOT NULL	ISO Country Code
10	VS_POSTAL_CODE	Character(14)	VARCHAR2(14) NOT NULL	Postal Code
11	CC_FISCALYEARDATE	Date(10)	DATE	Fiscal Year Date
12	CC_SPEND_LIMIT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Spending Limit
13	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
14	VS_ISSUER_NAME	Character(40)	VARCHAR2(40) NOT NULL	Issuer Name
15	VS_ORG_HIER_MGMT	Character(1)	VARCHAR2(1) NOT NULL	Org. Hierarchy Management
16	CC_EFF_DATE	Date(10)	DATE	Effective Date
17	VS_ADDRESS_LINE3	Character(80)	VARCHAR2(80) NOT NULL	Address Line 3
18	VS_FEDERAL_ORG_IND	Character(1)	VARCHAR2(1) NOT NULL	Federal Organization Indicator
19	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
20	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
21	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
22	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4