IN_FW_BCT_3_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). /* 06/09/2004 PWF Change reference from SCHED_LINE_NO to SCHED_LINE_NBR */

SELECT BUSINESS_UNIT ,EIP_CTL_ID ,GRP_SEQ_NBR ,DTL_SEQ_NBR ,BCT_DET_STATUS ,EIP_TRANS_SRC_SEQ ,DEVICE_DTTIME ,EXCLUDE_FLG ,SELECT_UNFULFILLED ,SELECT_RELEASABLE ,SELECT_RELEASED ,SELECT_CONFIRMED ,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_PARENT_PROD_ID ,SL_PRIORITY_NBR ,TO_PRIORITY_NBR ,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_SHIP_ID ,SL_CUSTOMER_PO ,SL_CNTRCT_ID ,SL_PICK_BATCH_ID ,TO_PICK_BATCH_ID ,SL_PICKLIST_LINE ,TO_PICKLIST_LINE ,SL_SHIP_CNTR_ID ,SL_TMS_EXT_REF_ID ,SL_TMS_EXT_REF_LN ,SL_EXT_REF_NBR ,SL_EXT_REF_LN_NBR ,AUTO_PICK_SEL ,AUTO_SHIP_SEL ,QTY ,UNIT_OF_MEASURE , ' ' , ' ' , ' ' , ' ' , ' ' ,' ' ,' ' ,' ' ,SL_SHIP_EARLY_DATE ,0 ,' ' ,'0' ,SL_SHIP_EARLY_DATE ,SL_SHIP_EARLY_DATE ,SL_INV_ITEM_ID , SHIP_ID , SHIP_ID_FLG , CARRIER_ID , CARRIER_ID_FLG , SHIP_TYPE_ID , SHIP_TYPE_ID_FLG , SHIP_DATE , SHIP_DATE_FLG , SHIP_TIME , SHIP_TIME_FLG , BILL_OF_LADING , BILL_OF_LADING_FLG , PRO_NUMBER , PRO_NUMBER_FLG , FREIGHT_AMT , FREIGHT_AMT_FLG ,FREIGHT_CALC_FLAG , FREIGHT_TERMS , FREIGHT_TERMS_FLG ,TRACKING_NBR ,TRACKING_NBR_FLG ,COMPLETE_FLG ,SHORT_SHIP_OPT ,SHIP_CNTR_ID ,IN_DFR_DPL_OVRD ,'N' , DELIVERY_ID , AMOUNT_ACTION , FRT_TYPE_CODE 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 SELECT_UNFULFILLED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.

    Y/N Table Edit

    Default Value: N

    10 SELECT_RELEASABLE Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in a releasable state.

    Y/N Table Edit

    Default Value: N

    11 SELECT_RELEASED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an Released state.

    Default Value: N

    12 SELECT_CONFIRMED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.

    Y/N Table Edit

    Default Value: N

    13 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
    14 SL_SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Business Unit selection
    15 SL_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection
    16 TO_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection
    17 SL_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection
    18 TO_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection
    19 SL_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for new 8.9 data model changes
    20 TO_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for 8.9 data model changes
    21 SL_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item selection

    Prompt Table: MST_ITM_PRPT_VW

    22 SL_DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line Number selection
    23 SL_SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer selection
    24 SL_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID selection

    Prompt Table: DMND_CUST_ID_VW

    25 SL_ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number selection
    26 SL_LOCATION Character(10) VARCHAR2(10) NOT NULL Location selection
    27 SL_LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load selection

    Prompt Table: SHIP_PRMPT13_VW

    28 SL_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection
    29 TO_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection
    30 SL_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection
    31 TO_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection
    32 SL_ROUTE_CD Character(6) VARCHAR2(6) NOT NULL Route selection
    33 SL_WAVE_CD Character(6) VARCHAR2(6) NOT NULL Route Group selection
    34 TO_WAVE_CD Character(6) VARCHAR2(6) NOT NULL Route Group selection
    35 SL_PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product selection
    36 SL_PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
    37 SL_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
    38 TO_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
    39 SL_DEMAND_DATE Date(10) DATE Demand Date selection
    40 TO_DEMAND_DATE Date(10) DATE Demand Date selection
    41 SL_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
    42 SL_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time
    43 TO_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
    44 TO_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time selection
    45 SL_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
    46 SL_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection
    47 TO_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
    48 TO_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection
    49 SL_SHIP_ID Character(10) VARCHAR2(10) NOT NULL Ship ID Selection
    50 SL_CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer Purchase Order selection
    51 SL_CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Contract ID selection
    52 SL_PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID selection
    53 TO_PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID selection
    54 SL_PICKLIST_LINE Number(7,0) INTEGER NOT NULL Pick List Line Number selection
    55 TO_PICKLIST_LINE Number(7,0) INTEGER NOT NULL Pick List Line Number selection
    56 SL_SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Ship Container selection
    57 SL_TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL Transportation Management System (TMS) Reference ID selection
    58 SL_TMS_EXT_REF_LN Number(7,0) INTEGER NOT NULL Transportation Management System (TMS) Reference Line
    59 SL_EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number selection
    60 SL_EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line selection
    61 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"
    62 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"
    63 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    64 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

    65 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
    66 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
    67 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
    68 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
    69 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
    70 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

    Prompt Table: CNTR_ID_INV

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

    Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

    Prompt Table: LOT_CONTROL_INV

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

    Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

    73 STAGED_DATE Date(10) DATE Staged Date

    Default Value: INSTALLATION_IN.DFLT_STAGED_DATE

    Prompt Table: STAGED_DT2IN_VW

    74 LEAD_DAYS Number(4,0) SMALLINT NOT NULL Lead Days for Calendar
    75 USE_LEAD_DAYS Character(1) VARCHAR2(1) NOT NULL Use Lead Days
    1=Use Fulfillment Lead Days
    2=Override Fulfillment Lead Days
    3=Ignore Lead Days

    Default Value: 1

    76 ORDER_REQUEST Character(1) VARCHAR2(1) NOT NULL Choose the Orders to Process
    1=Schedule Date
    2=Order Date
    3=Ship Early Date
    4=Orders Placed Today
    77 FROM_DATE Date(10) DATE From Date
    78 TO_DATE Date(10) DATE To Date
    79 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    80 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

    Prompt Table: SHIP_HDR_INV_VW

    81 SHIP_ID_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Id should be overridden with a blank value

    Y/N Table Edit

    Default Value: N

    82 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

    Prompt Table: SHIP_PRMPT9_VW

    83 CARRIER_ID_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Carrier ID should be overridden with a blank value

    Y/N Table Edit

    Default Value: N

    84 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    85 SHIP_TYPE_ID_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Via should be overridden with a blank value

    Y/N Table Edit

    Default Value: N

    86 SHIP_DATE Date(10) DATE Item Shipping Date
    87 SHIP_DATE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Date should be overridden with a blank value

    Y/N Table Edit

    Default Value: N

    88 SHIP_TIME Time(15) TIMESTAMP Ship Time
    89 SHIP_TIME_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Time should be overridden with a blank value

    Y/N Table Edit

    Default Value: N

    90 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.

    Prompt Table: SHIP_PRMPT11_VW

    91 BILL_OF_LADING_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Bill of Lading should be overridden with a blank value

    Y/N Table Edit

    Default Value: N

    92 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
    93 PRO_NUMBER_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Pro Number should be overridden with a blank value

    Y/N Table Edit

    Default Value: N

    94 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    95 FREIGHT_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Freight Amount should be overridden with a blank (zero) value

    Y/N Table Edit

    Default Value: N

    96 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag
    97 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    98 FREIGHT_TERMS_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Freight Terms should be overridden with a blank value

    Y/N Table Edit

    Default Value: N

    99 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
    100 TRACKING_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Clear Tracking Number
    101 COMPLETE_FLG Character(1) VARCHAR2(1) NOT NULL Complete Flag
    0=Process Location
    1=Pick Line Complete
    2=Pick Batch Complete
    3=Pick Line as Planned
    4=Pick Batch as Planned
    5=Process Location - Incomplete
    6=Complete Pick - Zero Quantity
    7=Complete Pick - Leave Alone
    8=Complete Pick - Dft Ship Loc
    A=Use Defaults
    B=No Action
    102 SHORT_SHIP_OPT Character(2) VARCHAR2(2) NOT NULL Short Shipment Option
    01=Scrap the Undershipment
    02=Return to Location Picked From
    103 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
    104 IN_DFR_DPL_OVRD Character(1) VARCHAR2(1) NOT NULL used to override the defer depletions field on in_demand
    1=Override to Yes
    2=Override to No
    105 ALLOW_SUB_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether item substitutions are allowed on the order schedule.
    106 SL_DELIVERY_ID Character(15) VARCHAR2(15) NOT NULL From Delivery ID
    107 AMOUNT_ACTION Character(1) VARCHAR2(1) NOT NULL 10/29/08 EGS: Created
    1=Override
    2=Increment
    108 FRT_TYPE_CODE Character(10) VARCHAR2(10) NOT NULL Freight Type Code