EN_IC_BOM_PRIV (SQL Table)	Index Back
Supplier Access Created on 09/13/99 RML Used by self service application MBOM Read - supplier has read only privilege on a specific bill MBOM Update - supplier does not have privilege to modify a bill BOM Read (engr) - hide if eg is not installed ECR view (engr) ECR Update (engr) ECO View only 09/16/99 RML Added tablespace

EN_IC_BOM_PRIV

(SQL Table)

Supplier Access

Created on 09/13/99 RML Used by self service application MBOM Read - supplier has read only privilege on a specific bill MBOM Update - supplier does not have privilege to modify a bill BOM Read (engr) - hide if eg is not installed ECR view (engr) ECR Update (engr) ECO View only 09/16/99 RML Added tablespace

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VNDR_VNDSET_VW

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: EN_ICBOMITEM_VW

5 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
Default Value: PR

6 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
Default Value: 1
Prompt Table: EN_ICBOMBC_VW

7 EN_IC_MGBOM_READ Character(1) VARCHAR2(1) NOT NULL test
Y/N Table Edit
Default Value: Y

8 EN_IC_MGBOM_UPD Character(1) VARCHAR2(1) NOT NULL Vendor security to update mBOM - used by BOM Access by Vendor; currently not being used
Y/N Table Edit
Default Value: N

9 EN_IC_BOM_READ Character(1) VARCHAR2(1) NOT NULL Vendor security to read BOM
Y/N Table Edit
Default Value: Y

10 EN_IC_ECR_VIEW Character(1) VARCHAR2(1) NOT NULL Vendor security to view ECR - used by BOM Access by Vendor
Y/N Table Edit
Default Value: N

11 EN_IC_ECR_UPD Character(1) VARCHAR2(1) NOT NULL Vendor security to update ECR - used by BOM Access by Vendor
Y/N Table Edit
Default Value: N

12 EN_IC_ECO_VIEW Character(1) VARCHAR2(1) NOT NULL Vendor security to view ECO - used by BOM Access by Vendor
Y/N Table Edit
Default Value: N

13 EN_VND_APPR_ECO Character(1) VARCHAR2(1) NOT NULL Created on 03/02/2000 RML Whether to notify vendor when an ECO is approved in Approve ECO. Option is to be added to BOM Access by Vendor under Maintain BOMs and Revs
Y/N Table Edit
Default Value: N

14 EN_VND_NEW_ECO Character(1) VARCHAR2(1) NOT NULL Created on 03/02/2000 RML Whether to notify vendor when a new ECO is created. Option is to be added to BOM Access by Vendor under Maintain BOMs and Revs
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VNDR_VNDSET_VW
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: EN_ICBOMITEM_VW
5	BOM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	03/26/00 RML Added a label "Type" PR=Production RW=Rework Default Value: PR
6	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database Default Value: 1 Prompt Table: EN_ICBOMBC_VW
7	EN_IC_MGBOM_READ	Character(1)	VARCHAR2(1) NOT NULL	test Y/N Table Edit Default Value: Y
8	EN_IC_MGBOM_UPD	Character(1)	VARCHAR2(1) NOT NULL	Vendor security to update mBOM - used by BOM Access by Vendor; currently not being used Y/N Table Edit Default Value: N
9	EN_IC_BOM_READ	Character(1)	VARCHAR2(1) NOT NULL	Vendor security to read BOM Y/N Table Edit Default Value: Y
10	EN_IC_ECR_VIEW	Character(1)	VARCHAR2(1) NOT NULL	Vendor security to view ECR - used by BOM Access by Vendor Y/N Table Edit Default Value: N
11	EN_IC_ECR_UPD	Character(1)	VARCHAR2(1) NOT NULL	Vendor security to update ECR - used by BOM Access by Vendor Y/N Table Edit Default Value: N
12	EN_IC_ECO_VIEW	Character(1)	VARCHAR2(1) NOT NULL	Vendor security to view ECO - used by BOM Access by Vendor Y/N Table Edit Default Value: N
13	EN_VND_APPR_ECO	Character(1)	VARCHAR2(1) NOT NULL	Created on 03/02/2000 RML Whether to notify vendor when an ECO is approved in Approve ECO. Option is to be added to BOM Access by Vendor under Maintain BOMs and Revs Y/N Table Edit Default Value: N
14	EN_VND_NEW_ECO	Character(1)	VARCHAR2(1) NOT NULL	Created on 03/02/2000 RML Whether to notify vendor when a new ECO is created. Option is to be added to BOM Access by Vendor under Maintain BOMs and Revs Y/N Table Edit Default Value: N