EN_SSBOMPRIV_VW (SQL View)	Index Back
Supplier Access Created on 09/29/00 RML View references supplier_setid instead of setid in en_ic_bom_priv - the field is specifically used for display control field in self service pages to get to supplier_vw1 for supplier name

EN_SSBOMPRIV_VW

(SQL View)

Supplier Access

Created on 09/29/00 RML View references supplier_setid instead of setid in en_ic_bom_priv - the field is specifically used for display control field in self service pages to get to supplier_vw1 for supplier name

SELECT SETID , VENDOR_ID , BUSINESS_UNIT , INV_ITEM_ID , BOM_TYPE , BOM_CODE , EN_IC_MGBOM_READ , EN_IC_MGBOM_UPD , EN_IC_BOM_READ , EN_IC_ECR_VIEW , EN_IC_ECR_UPD , EN_IC_ECO_VIEW , EN_VND_APPR_ECO , EN_VND_NEW_ECO FROM PS_EN_IC_BOM_PRIV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

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: BUS_UNIT_TBL_MG

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	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
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: BUS_UNIT_TBL_MG
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