C360_PMT_ST_LVW

(SQL View)
 Index Back

AR payment status lang view


SELECT C.SETID , A.BUSINESS_UNIT , C.CUST_ID , B.DEPOSIT_BU , B.DEPOSIT_ID , B.PAYMENT_SEQ_NUM , X.LANGUAGE_CD , X.XLATLONGNAME FROM PS_CUSTOMER C , PS_BUS_UNIT_TBL_AR A , PS_PAYMENT B , PSXLATITEMLANG X WHERE X.FIELDNAME = 'PAYMENT_STATUS' AND X.FIELDVALUE = B.PAYMENT_STATUS AND X.EFFDT = ( SELECT MAX(effdt) FROM PSXLATITEMLANG WHERE FIELDNAME = 'PAYMENT_STATUS' AND FIELDVALUE = B.PAYMENT_STATUS AND effdt <= %CurrentDateIn)

  • Related Language Record for C360_PNDPMT_VW C360_PND_PMT_VW C360_PYIT_PN_VW C360_PYWS_PN_VW

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BUARDS_NONVW

    3 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.

    Prompt Table: CUST_SRCH_VW
    Set Control Field: BUSINESS_UNIT

    4 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
    5 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
    6 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL Status Description