CC_VISA_TAO20

#	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_ACCT_NBR	Character(19)	VARCHAR2(19) NOT NULL	Account Number
4	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
5	VS_CCTRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
6	VS_CCSEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Visa Sequence Number
7	VS_ITEM_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Item Sequence Number
8	VS_MESSAGE_ID	Character(16)	VARCHAR2(16) NOT NULL	Message Identifier
9	START_DT	Date(10)	DATE	Start Date
10	END_DT	Date(10)	DATE	End Date
11	VS_ACCOUNTCODE	Character(18)	VARCHAR2(18) NOT NULL	Account Code/Cost Center
12	VS_DESCR1	Character(26)	VARCHAR2(26) NOT NULL	Description
13	VS_EMPL_NAME	Character(26)	VARCHAR2(26) NOT NULL	Employee/Temp Name
14	VS_EMPL_SSN	Character(9)	VARCHAR2(9) NOT NULL	Employee/Temp Social Security
15	CC_RATE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Rate Indicator 1=Hour 2=Flat amount 3=Daily 4=Other
16	CC_RATE_REGULAR	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	Regular Rate
17	CC_HOURS_REGULAR	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Regular Hours Worked
18	CC_RATE_OVERTIME	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	Overtime Rate
19	CC_HOURS_OVERTIME	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Overtime Hours Worked
20	VS_JOB_CODE	Character(12)	VARCHAR2(12) NOT NULL	Job Code
21	CC_MISCEXPAMT	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	Misc Expense Amount
22	CC_MISCEXPCODE	Character(4)	VARCHAR2(4) NOT NULL	Misc Expense Code AT=Air GT=Groud H=Hotel I=Insurance M=Meals O=Other PD=Per Diem
23	VS_REQUESTERNAME	Character(16)	VARCHAR2(16) NOT NULL	Requester Name or ID
24	CC_SUBTOTAMT	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	Subtotal Amount
25	CC_SALESTAXAMT	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	Sales Tax Amount
26	CC_DISCOUNTAMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Discount Amount
27	VS_REPORTEDTO	Character(26)	VARCHAR2(26) NOT NULL	Supervisor/Reported To
28	VS_TIMESHEETNBR	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Number
29	VS_COMMODITYCODE	Character(12)	VARCHAR2(12) NOT NULL	Commodity Code
30	VS_REIMBURSEATTR	Character(2)	VARCHAR2(2) NOT NULL	Reimbursement Attribute
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
35	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number