IN_FL_OVR_VW

(SQL View)
 Index Back

Fulfillment Groups Temp

Dedicated temp table containing grouping information for a fulfillment request (such as order or pick plan).

SELECT BUSINESS_UNIT , EIP_CTL_ID , GRP_SEQ_NBR , 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 , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , BILL_OF_LADING , BILL_OF_LADING_FLG , PRO_NUMBER , PRO_NUMBER_FLG , FREIGHT_AMT , FREIGHT_AMT_FLG , FREIGHT_TERMS , FREIGHT_TERMS_FLG , LEAD_DAYS , USE_LEAD_DAYS , COMPLETE_FLG , FREIGHT_CALC_FLAG , TRACKING_NBR , TRACKING_NBR_FLG , SHIP_CNTR_ID FROM PS_INV_FUL_GRP_EC

  • Parent record: IN_FL_HDR_TAO

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

    Prompt Table: SHIP_HDR_INV_VW

    5 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

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

    Prompt Table: SHIP_PRMPT9_VW

    7 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

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

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

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

    14 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
    15 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
    16 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
    17 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
    18 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
    19 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

    20 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

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

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

    25 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    26 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

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

    29 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
    30 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag
    31 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
    32 TRACKING_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Clear Tracking Number
    33 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID