INV_DTL_DAT_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 ,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 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 SL_DEMAND_DATE Date(10) DATE Demand Date selection
    8 TO_DEMAND_DATE Date(10) DATE Demand Date selection
    9 SL_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
    10 SL_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time
    11 TO_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
    12 TO_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time selection
    13 SL_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
    14 SL_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection
    15 TO_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
    16 TO_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection