SAC_POEIP_AET

(SQL Table)
Index Back

AE State Record

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

6 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
7 AE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Application
8 SAC_CHNG_ORDER_FLG Character(1) VARCHAR2(1) NOT NULL Change Order indicator
9 SAC_REPROCESS_ERR Character(1) VARCHAR2(1) NOT NULL Re-Process flag
10 SAC_PO_CANCEL_FLG Character(1) VARCHAR2(1) NOT NULL Cancelled PO Flag
11 SAC_UPDATED_PO Character(1) VARCHAR2(1) NOT NULL Updated PO select
12 SAC_SEND_ALL Character(1) VARCHAR2(1) NOT NULL Send All Flag
13 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
14 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
15 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description