IN_FW_BCT_4_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 ,DPI_SEQ ,SUB_ITM_ID ,BCT_DET_STATUS ,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 ,STAGED_DATE ,QTY ,UNIT_OF_MEASURE ,SHORT_SHIP_OPT ,SUB_ITM_ID ,SHIP_CNTR_ID ,TRACKING_NBR ,TRACKING_NBR_FLG ,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 DPI_SEQ Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    8 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
    0=Open
    1=Error
    2=Complete
    3=Cancel

    Default Value: 0

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

    Default Value: %DateTime

    11 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

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

    Prompt Table: STOR_AREA_VW2

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

    Prompt Table: STOR_LEV1_VW2

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

    Prompt Table: STOR_LEV2_VW2

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

    Prompt Table: STOR_LEV3_VW2

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

    Prompt Table: STOR_LEV4_VW2

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

    Prompt Table: CNTR_ID_INV

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

    Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

    Prompt Table: LOT_CONTROL_INV

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

    Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

    20 STAGED_DATE Date(10) DATE Staged Date

    Default Value: INSTALLATION_IN.DFLT_STAGED_DATE

    Prompt Table: STAGED_DT2IN_VW

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

    23 SHORT_SHIP_OPT Character(2) VARCHAR2(2) NOT NULL Short Shipment Option
    01=Scrap the Undershipment
    02=Return to Location Picked From
    24 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"

    Prompt Table: IN_FW_SUBITM_VW

    25 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
    26 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
    27 TRACKING_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Clear Tracking Number
    28 ALLOCATE_SOURCE Character(2) VARCHAR2(2) NOT NULL Allocation Source - Why was the allocation created
    LT=Lot Allocation
    PR=Pre-allocation
    SA=Standard Allocation