INV_MSR_LLS_VW

(SQL View)
 Index Back

Create Stock Request LLS

Location / Lot / Serial-level view for "Create Stock Request" BCT transaction, used in Transaction Maintenance

SELECT A.BUSINESS_UNIT , A.EIP_CTL_ID , A.GRP_SEQ_NBR , A.DTL_SEQ_NBR , A.LLS_SEQ_NBR , A.BCT_DET_STATUS , A.DPI_SEQ , A.EIP_TRANS_SRC_SEQ , A.DEVICE_DTTIME , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONTAINER_ID , A.INV_LOT_ID , A.SERIAL_ID , A.STAGED_DATE , A.QTY , A.UNIT_OF_MEASURE FROM %Table(INV_FUL_LLS_EC) A

  • Parent record: INV_FUL_DTL_EC

    • # 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 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    3 GRP_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Group stage table.
    4 DTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Details stage table.
    5 LLS_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Location / :pt / Serial stage table.
    6 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
    0=Open
    1=Error
    2=Complete
    3=Cancel

    Default Value: 0

    7 DPI_SEQ Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    8 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
    9 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time

    Default Value: %DateTime

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

    Prompt Table: STOR_AREA_VW2

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

    Prompt Table: STOR_LEV1_VW2

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

    Prompt Table: STOR_LEV2_VW2

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

    Prompt Table: STOR_LEV3_VW2

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

    Prompt Table: STOR_LEV4_VW2

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

    Prompt Table: CNTR_ID_INV

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

    Prompt Table: LOT_CONTROL_INV

    17 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    18 STAGED_DATE Date(10) DATE Staged Date

    Prompt Table: %EDITTABLE2

    19 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    20 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_UOM_VW3
    Set Control Field: SETID