OMEC_SCN_HDR_VW

(SQL View)
 Index Back

Sales Contract Hdr by Sold To

Date Init. Issue # Description 01/03/01 JJM R-SGATIG-ZV65C Changed SQL to use new table

SELECT DISTINCT A.SETID , A.SOLD_TO_CUST_ID , A.CNTRCT_ID , B.DESCR , B.START_DT , B.GRACE_END_DT , A.CUSTOMER_GROUP , B.DEFAULT_CNTRCT , B.CONTRACT_TYPE_ID FROM PS_SCON_CUST_CGRP A , PS_SCON_HDR B WHERE A.SETID=B.SETID AND A.CNTRCT_ID=B.CNTRCT_ID AND B.SCON_STATUS = 'A'

  • Related Language Record: OMEC_SCNHDV_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

    Prompt Table: CUST_SLD_VW

    3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 START_DT Date(10) DATE Start Date
    6 GRACE_END_DT Date(10) DATE Grace End Date
    7 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

    Prompt Table: CUSTGP_SCON_VW

    8 DEFAULT_CNTRCT Character(1) VARCHAR2(1) NOT NULL Default Contract

    Y/N Table Edit

    Default Value: N

    9 CONTRACT_TYPE_ID Character(6) VARCHAR2(6) NOT NULL Buying Agreement Type

    Prompt Table: CONTRACT_TYPE