SHIP_INV_TMP (SQL Table)	Index Back
Demand Picking Locations

SHIP_INV_TMP

(SQL Table)

Demand Picking Locations

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

9 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

10 SEQ_NBR2 Number(15,0) DECIMAL(15) NOT NULL Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.

11 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
Prompt Table: STOR_AR_INSP_VW

12 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
Prompt Table: STOR_L1_INSP_VW

13 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
Prompt Table: STOR_L2_INSP_VW

14 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
Prompt Table: STOR_L3_INSP_VW

15 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
Prompt Table: STOR_L4_INSP_VW

16 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

17 STAGED_DATE Date(10) DATE Staged Date

18 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

19 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

20 QTY_UNSHIPPED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Used as temporary storage for the short shipped quantity (in shipping UOM) on the Short Shipment Secondary Panel.

21 QTY_UNSHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Used as temporary storage for the short shipped quantity (in stocking UOM) on the Short Shipment Secondary Panel.

22 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure
Prompt Table: INV_STCK_UOM_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
6	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
7	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
8	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
9	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
10	SEQ_NBR2	Number(15,0)	DECIMAL(15) NOT NULL	Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
11	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area Prompt Table: STOR_AR_INSP_VW
12	STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 1 Prompt Table: STOR_L1_INSP_VW
13	STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 2 Prompt Table: STOR_L2_INSP_VW
14	STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 3 Prompt Table: STOR_L3_INSP_VW
15	STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 4 Prompt Table: STOR_L4_INSP_VW
16	CONTAINER_ID	Character(10)	VARCHAR2(10) NOT NULL	Container ID
17	STAGED_DATE	Date(10)	DATE	Staged Date
18	INV_LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
19	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
20	QTY_UNSHIPPED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Used as temporary storage for the short shipped quantity (in shipping UOM) on the Short Shipment Secondary Panel.
21	QTY_UNSHIPPED_CONV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Used as temporary storage for the short shipped quantity (in stocking UOM) on the Short Shipment Secondary Panel.
22	UNIT_MEASURE_PICK	Character(3)	VARCHAR2(3) NOT NULL	Phys Location Unit of Measure Prompt Table: INV_STCK_UOM_VW