INV_GRP_OVR_VW

(SQL View)
 Index Back

Fulfillment Request Groups

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

SELECT BUSINESS_UNIT ,EIP_CTL_ID ,GRP_SEQ_NBR ,BCT_DET_STATUS ,EIP_TRANS_SRC_SEQ ,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_TERMS ,FREIGHT_TERMS_FLG ,FREIGHT_CALC_FLAG ,TRACKING_NBR ,SHIP_CNTR_ID FROM PS_INV_FUL_GRP_EC

  • 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_BUIN_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 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
    7 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

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

    Prompt Table: CARRIER_VW

    9 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

    10 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD_VW

    11 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

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

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

    16 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    17 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

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

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

    22 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    23 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

    24 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag

    Y/N Table Edit

    Default Value: N

    25 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
    26 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID