CC_VISA_TAO28

(SQL Table)
Index Back

Visa - (28) Allocation

Visa Commercial - (28) Allocation

# 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_ALLOCATESEQNBR Number(5,0) INTEGER NOT NULL Allocation Sequence Number
8 VS_GL_ACCT_NO Character(76) VARCHAR2(76) NOT NULL G/L Sub-account No.
9 VS_GL_ACCT_DESCR Character(50) VARCHAR2(50) NOT NULL G/L Sub-account Description
10 VS_COST_CENTER_CD Character(76) VARCHAR2(76) NOT NULL Cost Center Code
11 VS_COST_CENTERDESC Character(50) VARCHAR2(50) NOT NULL Cost Center Description
12 CC_ALLOCATEAMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Allocated Amount
13 VS_ALLOCATEPCT Number(3,0) SMALLINT NOT NULL Allocated Percentage
14 CC_ALLOCATETAX1 Signed Number(18,2) DECIMAL(16,2) NOT NULL Tax 1 Amount
15 CC_ALLOCATETAX2 Signed Number(18,2) DECIMAL(16,2) NOT NULL Tax 2 Amount
16 VS_FINALALLOCATE Character(1) VARCHAR2(1) NOT NULL Final Allocation Flag
0=Extracted
1=Not Extrct
17 VS_ALLOCATEDESCR Character(100) VARCHAR2(100) NOT NULL Description
18 ALLOCATE_DT Date(10) DATE Allocated Date
19 VS_ALLOCATEACCT Character(150) VARCHAR2(150) NOT NULL Allocation Accounting Code
20 VS_ORIGINALACCT Character(150) VARCHAR2(150) NOT NULL Original Accounting Code
21 VS_OPTIONAL_01 Character(26) VARCHAR2(26) NOT NULL Optional Field 1
22 VS_OPTIONAL_02 Character(26) VARCHAR2(26) NOT NULL Optional Field 2
23 VS_OPTIONAL_03 Character(26) VARCHAR2(26) NOT NULL Optional Field 3
24 VS_OPTIONAL_04 Character(26) VARCHAR2(26) NOT NULL Optional Field 4
25 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number