SF_PACBOM_TMP2(SQL Table) |
Index Back |
---|---|
Component List Phantom WORK 2 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_MG |
2 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Prompt Table: SF_PRDNID_HEADR |
3 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
Prompt Table: MG_ITEM_APPR_VW |
4 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL |
Operation Sequence
Prompt Table: SF_OP_LIST_VW |
5 | SCHED_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Component Scheduled Qty |
6 | COMP_LEVEL | Number(4,0) | SMALLINT NOT NULL | Component Level for Phantom |