BUSINESS_UNITPrompt Table: SP_BUMGOP_NONVW
INV_ITEM_RTGRTG_TYPEPR=Production
RW=Rework
TD=Teardown
RTG_CODE2OP_SEQUENCEN=No
Y=Yes
Y/N Table Edit
Default Value: N
SF_RTG_CNTPT_VW(SQL View) |
Index Back |
|---|---|
Item Routing Op count point Vw01/13/99 CN#SF800-17.0 created for count point 07/24/00 MDS CN#SF800-31.0: Removed search attribute from op seq to avoid search lookup on prompt table dropdown. |
| select a.business_unit, a.inv_item_id, b.rtg_type, b.rtg_code, b.op_sequence, b.task_code, b.work_center_code, b.count_point from PS_BU_ITEMS_INV a, ps_en_rtg_ops b where b.business_unit = a.business_unit and b.inv_item_id = a.ref_routing_item and b.rtg_state = 'PR' and b.count_point = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 2 | INV_ITEM_RTG |
Character(18) | VARCHAR2(18) NOT NULL | Inv_item_id for sf_rtg_ops_vw |
| 3 | RTG_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
| 4 | RTG_CODE2 |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 5 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 6 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Task Code |
| 7 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 8 | COUNT_POINT | Character(1) | VARCHAR2(1) NOT NULL |
3/22/2000 dfl - Change short name from cnt ptr to cnt pt, more std.
N=No Y=Yes Y/N Table Edit Default Value: N |