VMMT_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
6 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
7 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
11 CHNKSIZE Number(10,0) DECIMAL(10) NOT NULL This fields defines the size of the Chunk for Voucher mass Maintenance.