GM_MLS_DUE_VW

(SQL View)
 Index Back

Milestones Dues

Award Milestones Due

SELECT AWD.OPRID , MLS.BUSINESS_UNIT , MLS.CONTRACT_NUM , AWD.TITLE56 , AWD.EMPLID , AWD.NAME , AWD.CUST_ID , AWD.NAME1 , MLS.MILESTONE_ID , MLS.MILESTONE_TYPE , MLS.DESCR , MLS.MILESTONE_CODE , MLS.DESCR1 , MLS.MILESTONE_STAT , MLS_STAT.DESCR , MLS.GM_MLST_PRI , MLS.DUE_DT , MLS.DAYS_DUE , MLS.GM_DUE_INDICATOR FROM PS_GM_PREF_AWD_VW AWD , PS_GM_AWD_MLS_VW MLS LEFT OUTER JOIN PS_GM_MILE_STAT_VW MLS_STAT ON MLS.SETID = MLS_STAT.SETID AND MLS.MILESTONE_STAT = MLS_STAT.MILESTONE_STAT WHERE AWD.CONTRACT_NUM = MLS.CONTRACT_NUM AND AWD.BUSINESS_UNIT = MLS.BUSINESS_UNIT

  • Related Language Record: GM_AWD_MLS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Award ID
    4 TITLE56 Character(56) VARCHAR2(56) NOT NULL TITLE56
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 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.
    8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    9 MILESTONE_ID Character(6) VARCHAR2(6) NOT NULL Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
    10 MILESTONE_TYPE Character(5) VARCHAR2(5) NOT NULL Milestone Type
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 MILESTONE_CODE Character(15) VARCHAR2(15) NOT NULL Milestone Code
    13 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    14 MILESTONE_STAT Character(3) VARCHAR2(3) NOT NULL Milestone Status
    15 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    16 GM_MLST_PRI Character(1) VARCHAR2(1) NOT NULL GM_MLST_PRI
    H=High
    L=Low
    M=Medium
    17 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
    18 DAYS_DUE Signed Number(5,0) DECIMAL(4) NOT NULL Due Days
    19 GM_DUE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Due Indicator
    0=Overdue
    1=0-30
    2=31-60
    3=61-90