CC_VISA_TBL28

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
2	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
3	VS_CCTRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
4	VS_CCSEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Visa Sequence Number
5	VS_ALLOCATESEQNBR	Number(5,0)	INTEGER NOT NULL	Allocation Sequence Number
6	VS_GL_ACCT_NO	Character(76)	VARCHAR2(76) NOT NULL	G/L Sub-account No.
7	VS_GL_ACCT_DESCR	Character(50)	VARCHAR2(50) NOT NULL	G/L Sub-account Description
8	VS_COST_CENTER_CD	Character(76)	VARCHAR2(76) NOT NULL	Cost Center Code
9	VS_COST_CENTERDESC	Character(50)	VARCHAR2(50) NOT NULL	Cost Center Description
10	CC_ALLOCATEAMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Allocated Amount
11	VS_ALLOCATEPCT	Number(3,0)	SMALLINT NOT NULL	Allocated Percentage
12	CC_ALLOCATETAX1	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Tax 1 Amount
13	CC_ALLOCATETAX2	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Tax 2 Amount
14	VS_FINALALLOCATE	Character(1)	VARCHAR2(1) NOT NULL	Final Allocation Flag 0=Extracted 1=Not Extrct
15	VS_ALLOCATEDESCR	Character(100)	VARCHAR2(100) NOT NULL	Description
16	ALLOCATE_DT	Date(10)	DATE	Allocated Date
17	VS_ALLOCATEACCT	Character(150)	VARCHAR2(150) NOT NULL	Allocation Accounting Code
18	VS_ORIGINALACCT	Character(150)	VARCHAR2(150) NOT NULL	Original Accounting Code
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