PV_PO_CREAT_AET

(SQL Table)
 Index Back

Cache Record for PV_PO_CREATE

This cache record is used to hold cache values for the process which creates a PO. This is mainly used in Procureville

# 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).

Default Value: OPR_DEF_TBL_FS.OPRID

Prompt Table: OPR_DEF_TBL_FS

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BLD_APPR_PO Character(1) VARCHAR2(1) NOT NULL Build POs as Approved

Y/N Table Edit

Default Value: Y

5 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_TBL

6 CALC_LINE_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Calculate PO Line Numbers

Y/N Table Edit

Default Value: N

7 CONSOLIDATE_TYPE Character(1) VARCHAR2(1) NOT NULL Consolidation Method
B=Business Unit, Supplier, Buyer
V=Business Unit, Supplier

Default Value: V

8 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr

Default Value: Y

9 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
10 LEAD_TIME_IMP Number(6,2) DECIMAL(5,2) NOT NULL Lead Time Factor %
11 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

Prompt Table: ORIGIN_PO_VW
Set Control Field: ITM_SETID

12 PO_DT Date(10) DATE Date
13 PRE_APPR_VNDR Character(1) VARCHAR2(1) NOT NULL Pre-Approve Supplier

Y/N Table Edit

Default Value: Y

14 PRICE_IMP Number(6,2) DECIMAL(5,2) NOT NULL Price Factor %
15 PV_PROCESS_EXPEDT Character(1) VARCHAR2(1) NOT NULL Expedite Staged POs

Y/N Table Edit

Default Value: N

16 SELECT_PARM Character(254) VARCHAR2(254) NOT NULL Dynamic Where Clause Sel Parms
17 SHIPTO_PR_IMP Number(6,2) DECIMAL(5,2) NOT NULL Ship to Priority Factor %
18 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
19 VNDR_PR_IMP Number(6,2) DECIMAL(5,2) NOT NULL Vendor Priority Factor %
20 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID