CC_VISA_TAO10

#	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_HIERARCHY_NODE	Character(40)	VARCHAR2(40) NOT NULL	Hierarchy Node
5	VS_PARENT_HIR_NODE	Character(40)	VARCHAR2(40) NOT NULL	Parent Hierarchy Node
6	CC_EFF_DATE	Date(10)	DATE	Effective Date
7	VS_DESCRIPTION	Character(40)	VARCHAR2(40) NOT NULL	Description
8	VS_MGR_LAST_NAME	Character(20)	VARCHAR2(20) NOT NULL	Manager Last Name
9	VS_MGR_FIRST_NAME	Character(20)	VARCHAR2(20) NOT NULL	Manager First Name
10	VS_MGR_TITLE	Character(40)	VARCHAR2(40) NOT NULL	Manager Title
11	CC_MGR_TRAIN_DATE	Date(10)	DATE	Manager Training Date
12	VS_MGR_PHONE	Character(14)	VARCHAR2(14) NOT NULL	Manager Phone Number
13	VS_TASK_ORDER_NO	Character(26)	VARCHAR2(26) NOT NULL	Task Order Number
14	VS_CONTACT_FNAME	Character(20)	VARCHAR2(20) NOT NULL	Contact First Name
15	VS_CONTACT_LNAME	Character(20)	VARCHAR2(20) NOT NULL	Contact Last Name
16	VS_CONTACT_ADDR1	Character(40)	VARCHAR2(40) NOT NULL	Contact Address Line 1
17	VS_CONTACT_ADDR2	Character(40)	VARCHAR2(40) NOT NULL	Contact Address Line 2
18	VS_CONTACT_ADDR3	Character(40)	VARCHAR2(40) NOT NULL	Contact Address Line 3
19	VS_CONTACT_CITY	Character(20)	VARCHAR2(20) NOT NULL	Contact City
20	VS_CONTACT_STATE	Character(4)	VARCHAR2(4) NOT NULL	Contact State
21	VS_CONTACT_COUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Contact Country
22	VS_CONTACT_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Contact Postal Code
23	VS_CONTACT_PHONE	Character(16)	VARCHAR2(16) NOT NULL	Contact Phone
24	VS_CONTACT_FAX	Character(16)	VARCHAR2(16) NOT NULL	Contact Fax
25	VS_CONTACT_EMAILID	Character(140)	VARCHAR2(140) NOT NULL	Contact Email Address
26	VS_HIERNODEREP2	Character(56)	VARCHAR2(56) NOT NULL	Second Hierarchy Node Rep
27	VS_HIERNODEREP3	Character(56)	VARCHAR2(56) NOT NULL	Second Hierarchy Node Rep
28	VS_TREE_ID	Character(2)	VARCHAR2(2) NOT NULL	Tree ID
29	VS_COST_CENTER	Character(50)	VARCHAR2(50) NOT NULL	Cost Center
30	VS_GL_ACCT_NO	Character(76)	VARCHAR2(76) NOT NULL	G/L Sub-account No.
31	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
32	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
33	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
34	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4