PO_RUN_UPDIVUOM

(SQL Table)
Index Back

Item Supplier UOM Update Run C

Item Supplier UOM Update Run Control table to App Engine process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

Prompt Table: SP_SETID_NONVW

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_FS

5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SP_SETID_NONVW

6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_VNDSET_VW

7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_VW1

8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

9 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

10 SELECT_PARM Character(254) VARCHAR2(254) NOT NULL Dynamic Where Clause Sel Parms