PL_SRC_PUR_TMP

(SQL Table)
Index Back

PL Sourcing Purchase Options

11/13/01 EGS (CN#PL900-1): Added

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 SEL Character(1) VARCHAR2(1) NOT NULL Apply Selected

Y/N Table Edit

4 PL_ROW_EXIST Character(1) VARCHAR2(1) NOT NULL Row Exist

Y/N Table Edit

5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
8 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
9 ITM_VNDR_PRIORITY Number(3,0) SMALLINT NOT NULL Item Vendor Priority
10 ITMV_PRIORITY_LOC Character(10) VARCHAR2(10) NOT NULL Item Supplier Priority Loc
11 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
12 PRICE_LIST Number(16,5) DECIMAL(15,5) NOT NULL Standard Price
13 PRICE_VNDR Number(16,5) DECIMAL(15,5) NOT NULL Vendor Price
14 PUR_MIN_ORDER Number(16,4) DECIMAL(15,4) NOT NULL CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Ord Qty to Min Order Qty. jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/23/02: Added label PUR_MIN_ORDER2
15 PUR_MAX_ORDER Number(16,4) DECIMAL(15,4) NOT NULL jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/23/02: Added label PUR_MAX_ORDER2
16 PUR_ORDER_MULTIPLE Number(12,4) DECIMAL(11,4) NOT NULL jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
17 PURCHASE_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Purchase Yield
18 STD_LEAD Number(3,0) SMALLINT NOT NULL Purchase Lead Time Days
19 USE_STD_LEAD_TIME Character(1) VARCHAR2(1) NOT NULL Use Item Standard Lead Time

Default Value: Y

20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
21 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
22 PL_UNIT_COST Signed Number(19,4) DECIMAL(17,4) NOT NULL 09/27/02 EGS (CN#PL880-1): Changed to 13.4
23 PL_OPTION_TYPE Character(2) VARCHAR2(2) NOT NULL Option Type
10=Production
20=Transfer
30=Purchase

Default Value: 30

24 ROW_EXISTS Character(1) VARCHAR2(1) NOT NULL 12/11/01 EGS (CN#PL900-1): Added.
25 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
26 QTY_MAX Number(16,4) DECIMAL(15,4) NOT NULL Maximum Quantity
27 ORDER_MULTIPLE Number(6,0) INTEGER NOT NULL Order Quantity Multiple