PHYSINV_VMI_VW1

(SQL View)
 Index Back

VMI Pysical INV VW

Used for processing the FIFO logic for the VMI QOH EIP.

SELECT A.BUSINESS_UNIT , A.STAGED_DATE , A.INV_LOT_ID , A.SERIAL_ID , A.INV_ITEM_ID , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONTAINER_ID , A.UNIT_OF_MEASURE , A.LAST_TRANSACT_TYPE , A.LAST_ISSUE_DATE , A.QTY , A.QTY_BASE , A.QTY_RESERVED , A.QTY_RESERVED_BASE , B.LOT_BIRTHDATE FROM PS_PHYSICAL_INV A , PS_LOT_CONTROL_INV B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.INV_LOT_ID = B.INV_LOT_ID AND A.AVAIL_STATUS = '1' AND A.QTY > 0

# 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 STAGED_DATE Date(10) DATE NOT NULL Staged Date

Default Value: %DATE

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

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

Prompt Table: %EDIT_LOT_ID

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

Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

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

Prompt Table: BU_ITM_INV_VW

6 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_AREA_VW2

7 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: STOR_LEV1_VW2

8 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: STOR_LEV2_VW2

9 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: STOR_LEV3_VW2

10 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: STOR_LEV4_VW2

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

Prompt Table: CNTR_ID_INV

12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: INV_STCK_UOM_VW

13 LAST_TRANSACT_TYPE Character(5) VARCHAR2(5) NOT NULL Last Transaction
14 LAST_ISSUE_DATE Date(10) DATE Last Issue Date
15 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
16 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
17 QTY_RESERVED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Reserved
18 QTY_RESERVED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Reserved Base
19 LOT_BIRTHDATE Date(10) DATE Lot Creation Dt