FULSTS_INV_TMP(SQL Table) |
Index Back |
|---|---|
Fulfillment Status Temp TableThis table is used as a holding record by the Fulfillment Status Inquiry panels. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 2 | DEMAND_SOURCE |
Character(2) | VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order |
| 3 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 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 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 6 | FULFILL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | OK to Pick |
| 7 | CONFIRMED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Confirm |
| 8 | SHIPPED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Shipped
B=Both N=No Y=Yes |
| 9 | CANCEL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Cancel PO
B=Both N=No Y=Yes |
| 10 | HOLD_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Hold
N=Hold Y=Hold |
| 11 | PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID |
| 12 | RESERVED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Reserved Flag
B=Both N=No Y=Yes |
| 13 | LOT_ALLOC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Lot Allocation |
| 14 | PSSH_COMPLETE | Character(1) | VARCHAR2(1) NOT NULL | Post Ship Complete |
| 15 | CANCELLED_LINES | Number(6,0) | INTEGER NOT NULL | Total number of cancelled demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel. |
| 16 | CONFIRMED_LINES | Number(6,0) | INTEGER NOT NULL | Total number of picked confirmed demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel. |
| 17 | DEPLETED_LINES | Number(6,0) | INTEGER NOT NULL | Total number of depleted demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel. |
| 18 | ON_HOLD_LINES | Number(6,0) | INTEGER NOT NULL | Total number of on hold demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel. |
| 19 | RELEASED_LINES | Number(6,0) | INTEGER NOT NULL | Released Lines |
| 20 | RELEASABLE_LINES | Number(6,0) | INTEGER NOT NULL | Releasable Lines |
| 21 | SHIPPED_LINES | Number(6,0) | INTEGER NOT NULL | Total number of shipped demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel. |
| 22 | UNFULFILLED_LINES | Number(6,0) | INTEGER NOT NULL | Total number of unfulfilled demand lines for a particular order number satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel. |
| 23 | PENDING_LINES | Number(6,0) | INTEGER NOT NULL | Pending Lines |
| 24 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 25 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 26 | 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 |
| 27 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 28 | IN_DEFER_DEPLETION | Character(1) | VARCHAR2(1) NOT NULL | Defer Depletions |
| 29 | DEFERRED_LINES | Number(4,0) | SMALLINT NOT NULL | Number with Deferred Depletion |