CNTRCT_PPACT_VW

(SQL View)
 Index Back

AP Acctg Entry Template Detail


SELECT A.SETID , A.DST_CNTRL_ID , A.EFFDT , A.DST_ACCT_TYPE , A.ACCOUNT FROM PS_DST_DETL_CNTRL A , PS_CNTRCT_HDR B WHERE A.SETID = B.SETID AND A.DST_ACCT_TYPE = 'PPD' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_DST_DETL_CNTRL C WHERE C.SETID = A.SETID AND C.ACCOUNT = A.ACCOUNT AND C.EFFDT = A.EFFDT)

  • Parent record: DST_CNTRL_TBL

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

    Default Value: CNTRCT_HDR.SETID

    2 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
    5 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: %EDIT_ACCOUNT