CC_VISA_TAO30(SQL Table) |
Index Back |
|---|---|
Visa - (30) RelationshipVisa Commercial - (30) Relationship |
| # | 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_OBJECT_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Object Type
03=Card Account 04=Cardholder 10=Organization |
| 4 | VS_FIELDVALUE |
Character(40) | VARCHAR2(40) NOT NULL | Field Value |
| 5 | VS_TREE_ID |
Character(2) | VARCHAR2(2) NOT NULL | Tree ID |
| 6 | VS_PARENTOBJTYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Parent Object Type
03=Card Account 04=Cardholder 10=Organization |
| 7 | VS_PARENTFLDVALUE | Character(40) | VARCHAR2(40) NOT NULL | Parent Field Value |
| 8 | VS_PARENTTREEID |
Character(2) | VARCHAR2(2) NOT NULL | Parent Tree ID |
| 9 | CC_EFF_DATE | Date(10) | DATE | Effective Date |
| 10 | VS_OPTIONAL_01 | Character(26) | VARCHAR2(26) NOT NULL | Optional Field 1 |
| 11 | VS_OPTIONAL_02 | Character(26) | VARCHAR2(26) NOT NULL | Optional Field 2 |
| 12 | VS_OPTIONAL_03 | Character(26) | VARCHAR2(26) NOT NULL | Optional Field 3 |
| 13 | VS_OPTIONAL_04 | Character(26) | VARCHAR2(26) NOT NULL | Optional Field 4 |