VAT_CONTEXT_ID2=Batch - BV2 Codeline
A=Algorithm - Testing Only
B=Batch - Row by Row Processing
T=Transaction
X=Transfer
VAT_ALGOTEST_VW(SQL View) |
Index Back |
|---|---|
VAT Algorithms |
| SELECT A.APPCLASSID ,'A' FROM PS_VAT_ALGO A WHERE EXISTS ( SELECT 'X' FROM PS_VAT_ALGO_IO WHERE APPCLASSID = A.APPCLASSID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VAT_CONTEXT_ID |
Character(30) | VARCHAR2(30) NOT NULL | VAT Context ID |
| 2 | VAT_CNTXT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Context Type
2=Batch - BV2 Codeline A=Algorithm - Testing Only B=Batch - Row by Row Processing T=Transaction X=Transfer |