INV_FUL_LLS_VW

(SQL View)
 Index Back

Fulfillment Request Loc/Lot/Sr

Stage record containing Location, Lot and Serial detail for a fulfillment request.

SELECT BUSINESS_UNIT ,EIP_CTL_ID ,GRP_SEQ_NBR ,DTL_SEQ_NBR ,LLS_SEQ_NBR ,BCT_DET_STATUS ,DPI_SEQ ,EIP_TRANS_SRC_SEQ ,DEVICE_DTTIME ,EXCLUDE_FLG ,STORAGE_AREA ,STOR_LEVEL_1 ,STOR_LEVEL_2 ,STOR_LEVEL_3 ,STOR_LEVEL_4 ,CONTAINER_ID ,INV_LOT_ID ,SERIAL_ID ,SHIP_CNTR_ID ,TRACKING_NBR ,TRACKING_NBR_FLG ,STAGED_DATE ,QTY ,UNIT_OF_MEASURE ,SHORT_SHIP_OPT ,SUB_ITM_ID ,ALLOCATE_SOURCE FROM PS_INV_FUL_LLS_EC

  • 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_BU_FS_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 EXCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates a line of a request fed to the Fulfillment Engine should be excluded from the selection instead of included.

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: STOR_AREA_VW2

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

    Prompt Table: STOR_LEV1_VW2

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

    Prompt Table: STOR_LEV2_VW2

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

    Prompt Table: STOR_LEV3_VW2

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

    Prompt Table: STOR_LEV4_VW2

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

    Prompt Table: CNTR_ID_INV

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

    Prompt Table: LOT_CONTROL_INV

    18 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    19 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
    20 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
    21 TRACKING_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Clear Tracking Number
    22 STAGED_DATE Date(10) DATE Staged Date

    Prompt Table: %EDITTABLE24

    23 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    24 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

    25 SHORT_SHIP_OPT Character(2) VARCHAR2(2) NOT NULL Short Shipment Option
    01=Scrap the Undershipment
    02=Return to Location Picked From

    Default Value: 02

    26 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
    27 ALLOCATE_SOURCE Character(2) VARCHAR2(2) NOT NULL Allocation Source - Why was the allocation created
    LT=Lot Allocation
    PR=Pre-allocation
    SA=Standard Allocation