PRDKTCMP_DE_TAO (SQL Table)	Index Back
Product Kit Components Delete Temp table to be used to delete product kit components. Date Initials Issue Description 032601 dms SP2 (DI-EDWONG-14)

PRDKTCMP_DE_TAO

(SQL Table)

Product Kit Components Delete

Temp table to be used to delete product kit components. Date Initials Issue Description 032601 dms SP2 (DI-EDWONG-14)

# 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

3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

4 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Product Component ID

5 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label

6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

7 DATE_OBSOLETE Date(10) DATE Obsolete Date

8 DTTM_IN_EFFECT DateTime(26) TIMESTAMP Effective Date-Time

9 DTTM_OBSOLETE DateTime(26) TIMESTAMP Obsolete Date-Time

10 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity

11 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
Default Value: ASY

12 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without
Y/N Table Edit
Default Value: N

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

14 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 1

15 VAT_KIT_PCT Number(3,0) SMALLINT NOT NULL % of Kit Value for VAT

16 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

17 COMP_PRC_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Contract Price %

18 MAX_QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Maximum allowable quantity for a kit component

19 MIN_QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Minimum allowable quantity for a kit component

#	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
3	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
4	PROD_COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Component ID
5	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
6	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
7	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date
8	DTTM_IN_EFFECT	DateTime(26)	TIMESTAMP	Effective Date-Time
9	DTTM_OBSOLETE	DateTime(26)	TIMESTAMP	Obsolete Date-Time
10	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity
11	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order Default Value: ASY
12	OPTIONAL_SHIP	Character(1)	VARCHAR2(1) NOT NULL	OK to Ship Without Y/N Table Edit Default Value: N
13	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
14	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
15	VAT_KIT_PCT	Number(3,0)	SMALLINT NOT NULL	% of Kit Value for VAT
16	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
17	COMP_PRC_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Contract Price %
18	MAX_QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Maximum allowable quantity for a kit component
19	MIN_QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Minimum allowable quantity for a kit component