INV_RSV_DTL_VW

(SQL View)
 Index Back

Fulfillment Request Details

Stage record containing detail information within a fulfillment request group (such as a line on an order).

SELECT BUSINESS_UNIT ,EIP_CTL_ID ,GRP_SEQ_NBR ,DTL_SEQ_NBR ,BCT_DET_STATUS ,EIP_TRANS_SRC_SEQ ,DEVICE_DTTIME ,EXCLUDE_FLG ,SL_DEMAND_SOURCE ,SL_SOURCE_BUS_UNIT ,SL_ORDER_NO ,TO_ORDER_NO ,SL_ORDER_INT_LINE ,TO_ORDER_INT_LINE ,SL_SCHED_LINE_NBR ,TO_SCHED_LINE_NBR ,SL_INV_ITEM_ID ,SL_DEMAND_LINE_NO ,SL_SHIP_TO_CUST_ID ,SL_CUST_ID ,SL_ADDRESS_SEQ_NUM ,SL_LOCATION ,SL_LOAD_ID ,SL_SHIP_TYPE_ID ,TO_SHIP_TYPE_ID ,SL_CARRIER_ID ,TO_CARRIER_ID ,SL_ROUTE_CD ,SL_WAVE_CD ,TO_WAVE_CD ,SL_PRODUCT_ID ,SL_DEMAND_DATE ,TO_DEMAND_DATE ,SL_SCHED_SHIP_DATE ,SL_SCHED_SHIP_TIME ,TO_SCHED_SHIP_DATE ,TO_SCHED_SHIP_TIME ,SL_SHIP_EARLY_DATE ,SL_SHIP_EARLY_TIME ,TO_SHIP_EARLY_DATE ,TO_SHIP_EARLY_TIME ,SL_CUSTOMER_PO ,SL_CNTRCT_ID , SL_PRIORITY_NBR , TO_PRIORITY_NBR , SL_PARENT_PROD_ID ,AUTO_PICK_SEL ,AUTO_SHIP_SEL ,QTY ,UNIT_OF_MEASURE , SL_DELIVERY_ID , TO_DELIVERY_ID FROM PS_INV_FUL_DTL_EC

  • Parent record: INV_FUL_GRP_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 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
    0=Open
    1=Error
    2=Complete
    3=Cancel

    Default Value: 0

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

    Default Value: %DateTime

    8 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

    9 SL_DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source selection
    IN=Material Request
    OM=Sales Order
    PL=Planning Requisition
    PO=Sourced Demand
    PR=Purchasing Requisition
    RT=Material Return
    SF=Production Request
    WM=Work Order Demand
    10 SL_SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Business Unit selection

    Prompt Table: SP_BUIN_NONVW

    11 SL_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection

    Prompt Table: INRSV_DMDORD_VW

    12 TO_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection

    Prompt Table: INRSV_DMDORD_VW

    13 SL_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection

    Prompt Table: INRSV_DMDOLN_VW

    14 TO_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection

    Prompt Table: INRSV_DMDOLN_VW

    15 SL_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for new 8.9 data model changes

    Prompt Table: INRSV_DMDSLN_VW

    16 TO_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for 8.9 data model changes

    Prompt Table: INRSV_DMDSLN_VW

    17 SL_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item selection

    Prompt Table: INRSV_DMDITM_VW

    18 SL_DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line Number selection

    Prompt Table: INRSV_DMDDLN_VW

    19 SL_SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer selection

    Prompt Table: INV_CST_SHP_VW

    20 SL_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID selection

    Prompt Table: INV_CUST_SLD_VW

    21 SL_ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number selection

    Prompt Table: INV_CST_ADDR_VW

    22 SL_LOCATION Character(10) VARCHAR2(10) NOT NULL Location selection

    Prompt Table: LOCATION_VW

    23 SL_LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load selection

    Prompt Table: INRSV_DMDLOD_VW

    24 SL_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection

    Prompt Table: SHIP_METHOD_VW

    25 TO_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection

    Prompt Table: SHIP_METHOD_VW

    26 SL_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection

    Prompt Table: CARRIER_VW

    27 TO_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection

    Prompt Table: CARRIER_VW

    28 SL_ROUTE_CD Character(6) VARCHAR2(6) NOT NULL Route selection

    Prompt Table: INRSV_DMDRT_VW

    29 SL_WAVE_CD Character(6) VARCHAR2(6) NOT NULL Route Group selection

    Prompt Table: INRSV_DMDWAV_VW

    30 TO_WAVE_CD Character(6) VARCHAR2(6) NOT NULL Route Group selection

    Prompt Table: INRSV_DMDWAV_VW

    31 SL_PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product selection
    32 SL_DEMAND_DATE Date(10) DATE Demand Date selection
    33 TO_DEMAND_DATE Date(10) DATE Demand Date selection
    34 SL_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
    35 SL_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time
    36 TO_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
    37 TO_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time selection
    38 SL_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
    39 SL_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection
    40 TO_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
    41 TO_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection
    42 SL_CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer Purchase Order selection
    43 SL_CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Contract ID selection
    44 SL_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
    45 TO_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
    46 SL_PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
    47 AUTO_PICK_SEL Character(1) VARCHAR2(1) NOT NULL The field is used to select the auto pick options for fulfillment.
    0=Use Default Values
    1=Override to "Yes"
    2=Override to "No"

    Default Value: 0

    48 AUTO_SHIP_SEL Character(1) VARCHAR2(1) NOT NULL Used to capture the auto ship options for fulfillment.
    0=Use Default Values
    1=Override to "Yes"
    2=Override to "No"

    Default Value: 0

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

    51 SL_DELIVERY_ID Character(15) VARCHAR2(15) NOT NULL From Delivery ID

    Prompt Table: IN_FW_DELIV_VW

    52 TO_DELIVERY_ID Character(15) VARCHAR2(15) NOT NULL To Delivery ID

    Prompt Table: IN_FW_DELIV_VW