VAT_DFLTPRV_AET

(SQL Table)
Index Back

VAT Defaults Private State Fld

This contains fields required internally by the VAT Defaulting program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups
3 VAT_CONTEXT_ID Character(30) VARCHAR2(30) NOT NULL VAT Context ID
4 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
5 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
6 COMMIT_FLAG Character(1) VARCHAR2(1) NOT NULL Flag Reservations for Commits
7 COMMIT_BATCH Number(6,0) INTEGER NOT NULL Commit Batch
8 RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
9 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
10 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
11 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
12 RECNAME_SOURCE Character(15) VARCHAR2(15) NOT NULL Source Recname
13 RECNAME_TARGET Character(15) VARCHAR2(15) NOT NULL Target Recname
14 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
15 RECNAME_1 Character(15) VARCHAR2(15) NOT NULL Record 1 Name
16 RECNAME_2 Character(15) VARCHAR2(15) NOT NULL Record 2 Name
17 RECNAME_3 Character(15) VARCHAR2(15) NOT NULL Rename
18 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
19 APPCLASSID_END Character(30) VARCHAR2(30) NOT NULL Application Class ID - End
20 APPCLASSID_INIT Character(30) VARCHAR2(30) NOT NULL Application Class ID - Init
21 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
22 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
23 VAT_FIELDVALUE_TYP Character(1) VARCHAR2(1) NOT NULL FieldValue Subclass Type
A=ApplicationField
C=AlgorithmField
D=DriverField
H=HardCodedValue
W=WorkField
24 VAT_DEFAULT_USAGE Character(1) VARCHAR2(1) NOT NULL VAT Defaulting Usage
C=Control
H=Handling
N=None
S=Services
25 VAT_DRIVER Character(15) VARCHAR2(15) NOT NULL VAT Driver
26 SEARCH_SEQ Number(4,0) SMALLINT NOT NULL Search Sequence
27 SQL_TEXT Character(254) VARCHAR2(254) NOT NULL SQL Text
28 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
29 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
30 COPY Character(1) VARCHAR2(1) NOT NULL Copy Down
31 SEQ_NBR_3 Number(3,0) SMALLINT NOT NULL Sequence
32 BLANK4 Character(4) VARCHAR2(4) NOT NULL blank
33 BLANK10 Character(10) VARCHAR2(10) NOT NULL 10 blanks
34 DESCR Character(30) VARCHAR2(30) NOT NULL Description
35 VAT_CNTXT_TYPE_OVR Character(1) VARCHAR2(1) NOT NULL VAT Context Type Override
2=Batch - BV2 Codeline
B=Batch - Row by Row Processing