PV_POCREAT_PARM(SQL Table) |
Index Back |
|---|---|
Parms for pv_POBUILD process03/11/2015 LEYE 20699015 We ensured that eProcurement Quick Source Requisitions will run Document Tolerance check. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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 |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BLD_APPR_PO | Character(1) | VARCHAR2(1) NOT NULL |
Build POs as Approved
Y/N Table Edit Default Value: Y |
| 4 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_TBL |
| 5 | CALC_LINE_NBR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Calculate PO Line Numbers
Y/N Table Edit Default Value: N |
| 6 | CONSOLIDATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Consolidation Method
B=Business Unit, Supplier, Buyer V=Business Unit, Supplier Default Value: V |
| 7 | DISP_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Allow Dispatch When Appr
Y/N Table Edit Default Value: Y |
| 8 | HOLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Hold From Further Processing
Y/N Table Edit Default Value: N |
| 9 | LEAD_TIME_IMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Lead Time Factor % |
| 10 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Origin
Prompt Table:
ORIGIN_PO_VW
|
| 11 | PO_DT | Date(10) | DATE | Date |
| 12 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 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 | VNDR_PR_IMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Vendor Priority Factor % |
| 19 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL |
Work Order ID
Prompt Table: SPF_WO_NOPO_VW |
| 20 | RUN_BUDGET_CHECK | Character(1) | VARCHAR2(1) NOT NULL | Budget Check (FS_BP) |
| 21 | RUN_DOC_TOL | Character(1) | VARCHAR2(1) NOT NULL |
03/11/2015 LEYE 20594862 We ensured that PO Auto Sourcing will run Document Tolerance check.
Default Value: N |
| 22 | RUN_PO_DISPATCH | Character(1) | VARCHAR2(1) NOT NULL | PO Dispatch (PO_DISPATCH) |