AP_UNDOMTCH_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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 MTCHX_RUN_OPT Character(1) VARCHAR2(1) NOT NULL Match Run Option
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 DRIVER_REC_NAME Character(15) VARCHAR2(15) NOT NULL Driver Record Name
8 INTER_REC_NAME Character(15) VARCHAR2(15) NOT NULL Intermediate Record Name
9 OUTPUT_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
10 MTCH_SELECT_CLS Character(254) VARCHAR2(254) NOT NULL Select Clause
11 MTCH_FROM_CLS Character(254) VARCHAR2(254) NOT NULL From Clause
12 MTCH_WHERE_CLS Character(254) VARCHAR2(254) NOT NULL Where Clause
13 MTCH_WHERE_CLS2 Character(254) VARCHAR2(254) NOT NULL Where Clause2
14 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
15 DECIMALPOS1 Number(4,0) SMALLINT NOT NULL Decimal Positions1
16 DECIMALPOS2 Number(5,0) INTEGER NOT NULL Decimal Positions2
17 DECIMALPOS3 Number(8,0) INTEGER NOT NULL Decimal Positions3
18 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
19 WHERE_CLAUSE_AE Character(254) VARCHAR2(254) NOT NULL Where Clause AE
20 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
21 MESSAGE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Message Clause
22 DELETE_MTCH_FLG Character(1) VARCHAR2(1) NOT NULL Delete match work tables
23 VCHR_COUNT Number(6,0) INTEGER NOT NULL Count of Vouchers