PRODKIT_HEADER (SQL Table)	Index Back
Product Kit Header This record holds the Product Kit Header information as well as the associated text. A child of this record will be the detail component list of the product kit.

PRODKIT_HEADER

(SQL Table)

Product Kit Header

This record holds the Product Kit Header information as well as the associated text. A child of this record will be the detail component list of the product kit.

Related Language Record: PRODKIT_HDR_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: PROD_KIT_VW

3 PAC_IN_PAC_FLAG Character(1) VARCHAR2(1) NOT NULL Package within Package
Y/N Table Edit
Default Value: N

4 LT_CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Litely configured package flag
Default Value: N

5 MIN_COMP Number(17,0) DECIMAL(17) NOT NULL Minimum Component Quantity
Default Value: 0

6 MAX_COMP Number(17,0) DECIMAL(17) NOT NULL Maximum Component Quantity
Default Value: 0

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

8 VAT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL This field is a flag to determine whether VAT is applicable or not.
Y/N Table Edit
Default Value: N

9 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label

10 DATE_OBSOLETE Date(10) DATE Obsolete Date

11 MARKET Character(3) VARCHAR2(3) NOT NULL Market

12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

16 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: PROD_KIT_VW
3	PAC_IN_PAC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Package within Package Y/N Table Edit Default Value: N
4	LT_CFG_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Litely configured package flag Default Value: N
5	MIN_COMP	Number(17,0)	DECIMAL(17) NOT NULL	Minimum Component Quantity Default Value: 0
6	MAX_COMP	Number(17,0)	DECIMAL(17) NOT NULL	Maximum Component Quantity Default Value: 0
7	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
8	VAT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is a flag to determine whether VAT is applicable or not. Y/N Table Edit Default Value: N
9	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label
10	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date
11	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
12	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
13	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
14	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
15	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
16	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
17	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time