| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 VAT_CONTEXT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
VAT Context ID
|
| 2 |
PRODUCT_INST |
Character(3) |
VARCHAR2(3) NOT NULL |
Product
AM=Asset Management
AP=Accounts Payable
AR=Accounts Receivable
BI=Billing
EX=Expenses
GL=General Ledger
OM=Order Management
PO=Purchase Order
RE=Real Estate Management
SP=Service Procurement
TR=Treasury
Prompt Table:
VAT_PRODUCT_VW
|
| 3 |
LABEL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
PSRECDEFN
|
| 5 |
RECNAME_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Level 1 Record
Prompt Table:
PSRECDEFN
|
| 6 |
RECNAME_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Level 2 Record
Prompt Table:
PSRECDEFN
|
| 7 |
RECNAME_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
Level 3 Record
Prompt Table:
PSRECDEFN
|
| 8 |
VAT_CONTEXT_CHILD |
Character(30) |
VARCHAR2(30) NOT NULL |
Child Context Id
|
| 9 |
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
|
| 10 |
VALIDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Validate Flag
Y/N Table Edit
|
| 11 |
APPCLASSID_INIT |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID - Init
Prompt Table:
VAT_ALGO
|
| 12 |
APPCLASSID_END |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID - End
Prompt Table:
VAT_ALGO
|
| 13 |
VAT_OPT_GRP_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Update All VAT Defaults
Y/N Table Edit
Default Value: N
|
| 14 |
VAT_OPT_GRP_CON |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Only the VAT Control Defaults
Y/N Table Edit
Default Value: N
|
| 15 |
VAT_OPT_GRP_DET |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Only Detail VAT Defaults
Y/N Table Edit
Default Value: N
|
| 16 |
VAT_OPT_GRP_LIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Only the Line VAT Defaults
Y/N Table Edit
Default Value: N
|
| 17 |
VAT_OPT_GRP_ACC |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Only the Accounting VAT Defaults
Y/N Table Edit
Default Value: N
|
| 18 |
VAT_OPT_GRP_DIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Only the Distribution VAT Defaults
Y/N Table Edit
|
| 19 |
VAT_OPT_GRP_SCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Only the Schedule VAT
|
| 20 |
VAT_OPT_MSGCAT |
Number(5,0) |
INTEGER NOT NULL |
Option Message Catalog
|
| 21 |
VAT_OPT_MSG_ALL |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
|
| 22 |
VAT_OPT_MSG_CON |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
|
| 23 |
VAT_OPT_MSG_DET |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
|
| 24 |
VAT_OPT_MSG_LIN |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
|
| 25 |
VAT_OPT_MSG_ACC |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
|
| 26 |
VAT_OPT_MSG_DIS |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
|
| 27 |
VAT_OPT_MSG_SCH |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
|
| 28 |
VAT_OPT_SER_DRIVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Service VAT Treatment Drivers from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 29 |
VAT_OPT_RPT_CNTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude VAT Reporting Country from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 30 |
VAT_OPT_VNDR_REG |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Vendor Registration from VAT Defaults Update
Y/N Table Edit
Default Value: N
|
| 31 |
VAT_OPT_CUST_REG |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Customer VAT Registration from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 32 |
VAT_OPT_PLACE_SUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude VAT Service Place of Supply from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 33 |
VAT_OPT_LINE_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Line from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 34 |
VAT_OPT_ACC_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Accounting Line from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 35 |
VAT_OPT_BANK_REG |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Bank Registration from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 36 |
VAT_OPT_DIST_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Distribution Line from Update of VAT Defaults
Y/N Table Edit
|
| 37 |
VAT_OPT_LINE_DET |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Line VAT from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 38 |
VAT_OPT_APPLICA |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude VAT Applicability from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 39 |
VAT_OPT_ACC_DET |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Accounting Line from Update of VAT Defaults
Y/N Table Edit
Default Value: N
|
| 40 |
VAT_OPT_DIST_DET |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Distribution Line from Update of VAT Defaults
Y/N Table Edit
|
| 41 |
VAT_OPT_SCHD_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude schedule from update of VAT defaults
Y/N Table Edit
|
| 42 |
VAT_OPT_SCHD_DET |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude schedule from update of VAT defaults
Y/N Table Edit
|
| 43 |
VAT_OPT_UPD_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Update VAT Defaults Pushbutton
Y/N Table Edit
Default Value: N
|
| 44 |
VAT_OPT_SCHD_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for VAT Update Options
Y/N Table Edit
Default Value: N
|
| 45 |
VAT_OPT_ADVPAY_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments
Y/N Table Edit
Default Value: N
|
| 46 |
VAT_OPT_ADVPAY_CON |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments
Y/N Table Edit
Default Value: N
|