BU_ITEMS_CONFIG (SQL Table)	Index Back
BU Items Config Attributes

BU_ITEMS_CONFIG

(SQL Table)

BU Items Config Attributes

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 RULE_BASED_COMP Character(1) VARCHAR2(1) NOT NULL Rule Based Components
N=Standard BOM
Y=Rule Based BOM
Default Value: Y

4 RULE_BASED_OPER Character(1) VARCHAR2(1) NOT NULL Rule Based Operations
N=Standard Routing
Y=Rule Based Routing
Default Value: Y

5 REF_BOM_ITEM Character(18) VARCHAR2(18) NOT NULL Reference BOM Item
Prompt Table: CP_PRDNITEM_VW1

6 CFG_LEAD_TIME Number(12,2) DECIMAL(11,2) NOT NULL Configuration Lead Time Hrs

7 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: CP_SHIP_VIA_VW

8 BUSINESS_UNIT_CP Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUMG_NONVW

9 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	RULE_BASED_COMP	Character(1)	VARCHAR2(1) NOT NULL	Rule Based Components N=Standard BOM Y=Rule Based BOM Default Value: Y
4	RULE_BASED_OPER	Character(1)	VARCHAR2(1) NOT NULL	Rule Based Operations N=Standard Routing Y=Rule Based Routing Default Value: Y
5	REF_BOM_ITEM	Character(18)	VARCHAR2(18) NOT NULL	Reference BOM Item Prompt Table: CP_PRDNITEM_VW1
6	CFG_LEAD_TIME	Number(12,2)	DECIMAL(11,2) NOT NULL	Configuration Lead Time Hrs
7	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: CP_SHIP_VIA_VW
8	BUSINESS_UNIT_CP	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUMG_NONVW
9	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.