RMA_MSRSHPHS_VW

(SQL View)
 Index Back

RMA MSR Ship Hist View

This record contains one row for every shipment made for an MSR issued from an internal customer/location. Date Initials Issue # Description 120800 dms R-ED.WON-3S567 Add project fields 062601 JJM F-FSELK-11 Proj Gemini chartfield changes 032802 dms 71948009 Remove dflt for business unit 052504 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND

SELECT DISTINCT SH.SOURCE_BUS_UNIT , SH.DEMAND_SOURCE , SH.SOURCE_BUS_UNIT , SH.LOCATION , SH.ORDER_NO , SH.ORDER_INT_LINE_NO , SH.SCHED_LINE_NBR , SH.INV_ITEM_ID , SH.DEMAND_LINE_NO , SH.BUSINESS_UNIT , SH.ACCOUNT , SH.ALTACCT , SH.DEPTID , SH.PROJECT_ID , %subrec(CF16_AN_SBR, SH) , BI.BILLING_STATUS , SH.BILL_OF_LADING , SH.CARRIER_ID , M.DESCR , SH.DISTRIB_TYPE , SH.FREIGHT_TERMS , SH.KIT_LINE_NBR , M.LOT_CONTROL , SH.PARENT_PROD_ID , SH.PRODUCT_ID , SH.PRODUCT_ID , SH.QTY_SHIP_BASE , SH.QTY_SHIPPED , SH.QTY_SHIPPED_CONV , M.SERIAL_CONTROL , M.SHIP_SERIAL_CNTRL , %DatePart(SH.SHIP_DTTM) , SH.SHIP_ID , SH.SHIP_LINE_NO , %TimePart(SH.SHIP_DTTM) , SH.SHIP_TYPE_ID , SH.UNIT_MEASURE_SHIP , SH.UNIT_OF_MEASURE , BI.BUSINESS_UNIT_BI , BI.INVOICE , BI.LINE_SEQ_NUM , SH.ACTIVITY_ID , SH.BUSINESS_UNIT_PC , SH.RESOURCE_TYPE , SH.RESOURCE_CATEGORY , SH.RESOURCE_SUB_CAT , SH.DESTIN_GL_BU FROM PS_IN_DEMAND SH , PS_ISSUE_HDR_INV H , PS_SET_CNTRL_REC SC , PS_MASTER_ITEM_TBL M , PS_IN_DEMAND_BI BI WHERE %Join(COMMON_KEYS, IN_DEMAND SH, ISSUE_HDR_INV H) AND SH.DEMAND_SOURCE <> 'OM' AND SH.IN_FULFILL_STATE IN ('60', '70') AND H.REQUEST_TYPE = 'I' AND SC.SETCNTRLVALUE = SH.SOURCE_BUS_UNIT AND SC.RECNAME = 'MASTER_ITEM_TBL' AND M.SETID = SC.SETID AND M.INV_ITEM_ID = SH.INV_ITEM_ID AND BI.BUSINESS_UNIT(+) = SH.BUSINESS_UNIT AND BI.DEMAND_SOURCE(+) = SH.DEMAND_SOURCE AND BI.SOURCE_BUS_UNIT(+) = SH.SOURCE_BUS_UNIT AND BI.ORDER_NO(+) = SH.ORDER_NO AND BI.ORDER_INT_LINE_NO(+) = SH.ORDER_INT_LINE_NO AND BI.SCHED_LINE_NBR(+) = SH.SCHED_LINE_NBR AND BI.INV_ITEM_ID(+) = SH.INV_ITEM_ID AND BI.DEMAND_LINE_NO(+) = SH.DEMAND_LINE_NO

  • Related Language Record: RMA_MSRSHPVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
    IN=Material Request
    OM=Sales Order
    PL=Planning Requisition
    PO=Purchase Order
    PR=Purchasing Requisition
    RT=Material Return
    SF=Production Request
    WM=Work Order
    3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
    4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    5 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
    6 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    7 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    9 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

    Default Value: 1

    10 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
    11 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    12 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    14 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    15 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

    Prompt Table: OPERUNT_BUGL_VW

    16 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

    Prompt Table: PRODUCT_BUGL_VW

    17 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_BUGL_VW

    18 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

    Prompt Table: CLASSCF_BUGL_VW

    19 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

    Prompt Table: PROGRAM_BUGL_VW

    20 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

    Prompt Table: BUD_REF_BUGL_VW

    21 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

    Prompt Table: AFFILIATE_VW

    22 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

    Prompt Table: %EDIT_INTRA01

    23 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

    Prompt Table: %EDIT_INTRA02

    24 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

    Prompt Table: CF1_BUGL_VW

    25 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

    Prompt Table: CF2_BUGL_VW

    26 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

    Prompt Table: CF3_BUGL_VW

    27 BILLING_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Status
    A=Available
    B=In Billing
    C=Contract
    I=Invoiced
    N=Not Avail
    P=In Process
    S=Staged

    Default Value: N

    28 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    29 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    30 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    31 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
    32 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    33 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
    34 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y
    35 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
    36 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
    37 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    38 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
    39 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
    40 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
    41 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    42 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control
    43 SHIP_DATE Date(10) DATE Item Shipping Date
    44 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
    45 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
    46 SHIP_TIME Time(15) TIMESTAMP Ship Time
    47 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    48 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
    49 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    50 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
    51 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    52 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
    53 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    54 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    55 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
    56 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
    57 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
    58 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit