PROD_UOM_UP_AET

(SQL Table)
Index Back

Product Unit of Measure

Date Initials Issue Description 090401 dms 8.4 Delete min_price

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
4 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
5 DFLT_UOM Character(1) VARCHAR2(1) NOT NULL Vendor Default UOM

Y/N Table Edit

Default Value: N

6 PROD_PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Pricing Option
0=Regular
1=KVI
2=NDP
7 PRICING_UOM_FLG Character(1) VARCHAR2(1) NOT NULL Pricing UOM Flag
0=No
1=Yes
2=Default
8 MIN_ORDER_QTY Number(15,4) DECIMAL(14,4) NOT NULL Minimum Order Quantity
9 MAX_ORDER_QTY Number(15,4) DECIMAL(14,4) NOT NULL Maximum Order Quantity
10 ORDER_INCREMENT Number(15,4) DECIMAL(14,4) NOT NULL Order Increment
11 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID