SL_BUSINESS_UNITPrompt Table: FSS_BU_IN_VW
TO_BUSINESS_UNITPrompt Table: FSS_BU_IN_VW
BUSINESS_UNITPrompt Table: FSS_BU_IN_VW
ORDER_NO10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled
FSS_MSR_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.BUSINESS_UNIT , A.BUSINESS_UNIT , A.BUSINESS_UNIT , A.ORDER_NO , A.IN_FULFILL_STATE FROM PS_IN_RLS_PRMT_VW A , PS_FSS_BU_IN_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.DEMAND_SOURCE = 'IN' AND A.IN_FULFILL_STATE < '60' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SL_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table: FSS_BU_IN_VW |
| 2 | TO_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table: FSS_BU_IN_VW |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: FSS_BU_IN_VW |
| 4 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 5 | IN_FULFILL_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Inventory Fulfillment State
10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Confirmed 60=Shipped 70=Depleted 90=Canceled |