BUSINESS_UNITHOLD_FIELDOM_BU_FSS_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.HOLD_FIELD , A.HOLD_CD , A.PASS_HOLD_TO_BI , A.PASS_HOLD_TO_ID , A.PASS_HOLD_TO_IP , A.PASS_HOLD_TO_IR , A.PASS_HOLD_TO_IS , A.PASS_HOLD_TO_IU , A.PASS_TO_PURCH , A.INCL_IN_PLAN , B.BU_FSS_FLG FROM PS_OM_BU_HOLD_FLGS A , PS_BUS_UNIT_TBL_OM B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | HOLD_FIELD |
Character(18) | VARCHAR2(18) NOT NULL | Hold Field |
| 3 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL | Hold Code |
| 4 | PASS_HOLD_TO_BI | Character(1) | VARCHAR2(1) NOT NULL | Pass to Billing |
| 5 | PASS_HOLD_TO_ID | Character(1) | VARCHAR2(1) NOT NULL | Pass to Released |
| 6 | PASS_HOLD_TO_IP | Character(1) | VARCHAR2(1) NOT NULL | Pass to Picked/Confirmed |
| 7 | PASS_HOLD_TO_IR | Character(1) | VARCHAR2(1) NOT NULL | Pass to Releasable |
| 8 | PASS_HOLD_TO_IS | Character(1) | VARCHAR2(1) NOT NULL | Pass to Shipped |
| 9 | PASS_HOLD_TO_IU | Character(1) | VARCHAR2(1) NOT NULL | Pass to Unfulfilled |
| 10 | PASS_TO_PURCH | Character(1) | VARCHAR2(1) NOT NULL | Pass to Purchasing |
| 11 | INCL_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL | Include in Planning |
| 12 | BU_FSS_FLG | Character(1) | VARCHAR2(1) NOT NULL | 02/15/06 EGS: Created |