RMA_INVSHPHS_VW

(SQL View)
 Index Back

RMA Cust Ship Hist View

This record contains one row for every shipment made for an MSR from an external customer. Date Initials Issue # Description 120800 dms R-ED.WON-3S567 Add project fields 062601 JJM F-FSELK-11 Project Gemini chartfield chgs 032802 dms 71948009 Delete default for business_unit, reset value returned for bu 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.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 , SH.CONFIG_CODE , SH.CUST_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) , %DateTimeNull , SH.SHIP_ID , SH.SHIP_LINE_NO , %TimePart(SH.SHIP_DTTM) , SH.SHIP_TO_CUST_ID , 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.ADDR_OVRD_LEVEL , SH.ADDRESS_SEQ_NUM 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.IN_FULFILL_STATE IN ('60', '70') AND H.REQUEST_TYPE = 'E' 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_INVSHPVWLNG

    • # 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 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
    5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

    Default Value: 1

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

    Prompt Table: OPERUNT_BUGL_VW

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

    Prompt Table: PRODUCT_BUGL_VW

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

    Prompt Table: FUND_BUGL_VW

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

    Prompt Table: CLASSCF_BUGL_VW

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

    Prompt Table: PROGRAM_BUGL_VW

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

    Prompt Table: BUD_REF_BUGL_VW

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA02

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

    Prompt Table: CF1_BUGL_VW

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

    Prompt Table: CF2_BUGL_VW

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

    Prompt Table: CF3_BUGL_VW

    26 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

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