CC_VISA_TAO01

#	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	CC_CLOSING_DATE	Date(10)	DATE	Closing Date
5	VS_PERIOD	Character(5)	VARCHAR2(5) NOT NULL	Period
6	CC_PREVIOUSBALANCE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Previous Balance
7	CC_CURRENTBALANCE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Current Balance
8	CC_CREDIT_LIMIT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Credit Limit
9	CC_CURRENTAMTDUE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Current Amount Due
10	CC_PASTDUECOUNT	Number(5,0)	INTEGER NOT NULL	Past Due Count
11	CC_PASTDUEAMT	Number(17,2)	DECIMAL(16,2) NOT NULL	Past Due Amount
12	CC_DISPUTE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency
14	CC_AMTPASTDUE1	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Amount Past Due 1 Bill Cycle
15	CC_AMTPASTDUE2	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Amount Past Due 2 Bill Cycle
16	CC_AMTPASTDUE3	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Amount Past Due 3 Bill Cycle
17	CC_AMTPASTDUE4	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Amount Past Due 4 Bill Cycle
18	CC_AMTPASTDUE5	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Amount Past Due 5 Bill Cycle
19	CC_AMTPASTDUE6	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Amount Past Due 6 Bill Cycle
20	CC_AMTPASTDUEPLUS	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Amount Past Due + Bill Cycle
21	VS_CNT_PSTDUE1	Number(5,0)	INTEGER NOT NULL	Past Due 1 Bill Cycle Count
22	VS_CNT_PSTDUE2	Number(5,0)	INTEGER NOT NULL	Past Due 2 Bill Cycle Count
23	VS_CNT_PSTDUE3	Number(5,0)	INTEGER NOT NULL	Past Due 3 Bill Cycle Count
24	VS_CNT_PSTDUE4	Number(5,0)	INTEGER NOT NULL	Past Due 4 Bill Cycle Count
25	VS_CNT_PSTDUE5	Number(5,0)	INTEGER NOT NULL	Past Due 5 Bill Cycle Count
26	VS_CNT_PSTDUE6	Number(5,0)	INTEGER NOT NULL	Past Due 6 Bill Cycle Count
27	VS_CNT_PSTDUEPLUS	Number(5,0)	INTEGER NOT NULL	Past Due + Bill Cycle Count
28	VS_PSTDUEPLUSCYCLE	Number(5,0)	INTEGER NOT NULL	Plus Cycle Identifier
29	CC_LASTPAYMENTAMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Last Payment Amount
30	CC_LASTPAYMENTDATE	Date(10)	DATE	Last Payment Date
31	CC_PAYMENTDUEDATE	Date(10)	DATE	Payment Due Date
32	CC_HIGHBALANCE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	High Balance
33	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
34	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
35	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
36	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4
37	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number