KIT_COMPSPRC_MD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_PROGRAM	Character(10)	VARCHAR2(10) NOT NULL	Enterprise Components EIP (enterprise integration point) program field 601=Consumer Sync 701=BOM Sync 801=Item Revision 901=Item Bus Unit Sync 902=Item Sync
2	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
4	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
5	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: %EDITTABLE
6	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Prompt Table: %EDITTABLE2
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
8	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
9	PROD_COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Component ID Prompt Table: PROD_NOTKIT_VW
10	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
11	PRODKIT_COMP_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Product Kit Component Price
12	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
13	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date
14	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values