PROD_UOM_UP_TAO

(SQL Table)
Index Back

Product Unit of Measure Stagin

Staging table for messaging. Date Initials Issue Description 090401 dms 8.4 Delete min_price

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
6 DFLT_UOM Character(1) VARCHAR2(1) NOT NULL Vendor Default UOM

Y/N Table Edit

Default Value: N

7 PROD_PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Pricing Option
0=Regular
1=KVI
2=NDP
8 PRICING_UOM_FLG Character(1) VARCHAR2(1) NOT NULL Pricing UOM Flag
0=No
1=Yes
2=Default
9 MIN_ORDER_QTY Number(15,4) DECIMAL(14,4) NOT NULL Minimum Order Quantity
10 MAX_ORDER_QTY Number(15,4) DECIMAL(14,4) NOT NULL Maximum Order Quantity
11 ORDER_INCREMENT Number(15,4) DECIMAL(14,4) NOT NULL Order Increment
12 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
13 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.
14 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID