INV_FUL_GRP_EC

(SQL Table)
 Index Back

Fulfillment Request Groups

Stage record containing grouping information for a fulfillment request (such as order or pick plan).

  • Parent record: BCT_CTL

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

    Default Value: 0

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

    Default Value: %DateTime

    7 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

    8 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

    9 SELECT_RELEASED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an Released state.
    10 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

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

    Prompt Table: MST_ITM_PRPT_VW

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

    Prompt Table: DMND_CUST_ID_VW

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

    Prompt Table: SHIP_PRMPT13_VW

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

    Default Value: 0

    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"

    Default Value: 0

    63 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

    Prompt Table: SHIP_HDR_INV_VW

    64 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

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

    Prompt Table: SHIP_PRMPT9_VW

    66 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

    67 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    68 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

    69 SHIP_DATE Date(10) DATE Item Shipping Date
    70 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

    71 SHIP_TIME Time(15) TIMESTAMP Ship Time
    72 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

    73 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
    74 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
    75 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
    76 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
    77 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
    78 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

    79 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

    80 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
    81 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

    82 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    83 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

    84 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag
    85 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    86 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

    87 LEAD_DAYS Number(4,0) SMALLINT NOT NULL Lead Days for Calendar
    88 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

    89 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
    90 TRACKING_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Clear Tracking Number
    91 SHORT_SHIP_OPT Character(2) VARCHAR2(2) NOT NULL Short Shipment Option
    01=Scrap the Undershipment
    02=Return to Location Picked From
    92 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
    93 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
    94 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
    95 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    96 REQUEST_TYPE Character(1) VARCHAR2(1) NOT NULL Request Type
    E=External Order
    I=Internal Issue
    U=InterUnit Transfer
    V=Supplier Returns
    97 DEMAND_DATE Date(10) DATE Demand Date
    98 REQUEST_DATE Date(10) DATE Requested
    99 SCHED_DATE Date(10) DATE Schedule Date
    100 SCHED_TIME Time(15) TIMESTAMP Schedule Time
    101 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
    102 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
    103 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date
    104 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time
    105 SHIP_LATE_DATE Date(10) DATE Latest Ship Date
    106 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time
    107 SCHED_ARRV_DATE Date(10) DATE Scheduled Arrival Date
    108 SCHED_ARRV_TIME Time(15) TIMESTAMP Scheduled Arrival Time
    109 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
    110 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
    111 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

    Y/N Table Edit

    112 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
    113 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
    0=Calculate Cost at Depletions
    1=Transfer at Zero Cost
    114 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    115 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    116 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
    117 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
    118 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
    119 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    120 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit
    121 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
    N=No
    Y=Yes
    122 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule
    123 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule
    124 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder
    125 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule
    126 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

    Y/N Table Edit

    127 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold
    128 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code
    129 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
    130 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    131 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
    132 IN_FRT_P_BILFRT Character(1) VARCHAR2(1) NOT NULL Commit Billable Freight
    133 IN_FRT_P_CMPFRT Character(1) VARCHAR2(1) NOT NULL Freight Complete
    134 IN_FRT_P_MANFRT Character(1) VARCHAR2(1) NOT NULL External Manifest
    135 IN_BEST_WAY_BTN Character(2) VARCHAR2(2) NOT NULL Best Way Freight Option
    10=Least Cost
    20=By Commit Date
    136 IN_FRT_OPTION Character(2) VARCHAR2(2) NOT NULL Freight Options
    10=Shop For Rates
    20=Best Way
    30=Use Specified Carrier
    40=Carrier with Best Way
    137 FRT_TYPE_CODE Character(10) VARCHAR2(10) NOT NULL Freight Type Code
    138 AMOUNT_ACTION Character(1) VARCHAR2(1) NOT NULL 10/29/08 EGS: Created
    1=Override
    2=Increment
    139 LINE_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User Defined C1 A
    140 LINE_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User Defined C1 B
    141 LINE_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User Defined C1 C
    142 LINE_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User Defined C1 D
    143 LINE_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User Defined C2
    144 LINE_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User Defined C4
    145 LINE_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User Defined C6
    146 LINE_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User Defined C8
    147 LINE_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User Defined C10 A
    148 LINE_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User Defined C10 B
    149 LINE_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User Defined C10 C
    150 LINE_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Line Fld C10 D
    151 LINE_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User Defined C30 A
    152 LINE_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User Defined C30 B
    153 LINE_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User Defined C30 C
    154 LINE_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User Defined C30 D
    155 LINE_FIELD_DTTM_A DateTime(26) TIMESTAMP User Defined DTTM A
    156 LINE_FIELD_DTTM_B DateTime(26) TIMESTAMP User Defined DTTM B
    157 LINE_FIELD_DTTM_C DateTime(26) TIMESTAMP User Defined DTTM C
    158 LINE_FIELD_DTTM_D DateTime(26) TIMESTAMP User Defined DTTM D
    159 LINE_FIELD_N11_A Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 A
    160 LINE_FIELD_N11_B Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 B
    161 LINE_FIELD_N11_C Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 C
    162 LINE_FIELD_N11_D Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 D
    163 LINE_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 A
    164 LINE_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 B
    165 LINE_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 C
    166 LINE_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 D