C360_DRF_ST_LVW

(SQL View)
 Index Back

AR draft status lang view


SELECT C.SETID , A.BUSINESS_UNIT , C.CUST_ID , B.DRAFT_BU , B.DRAFT_ID , X.LANGUAGE_CD , X.XLATLONGNAME FROM PS_CUSTOMER C , PS_BUS_UNIT_TBL_AR A , PS_DRAFT_CONTROL B , PSXLATITEMLANG X WHERE X.FIELDNAME = 'DRAFT_STATUS' AND X.FIELDVALUE = B.DRAFT_STATUS AND X.EFFDT = ( SELECT MAX(effdt) FROM PSXLATITEMLANG WHERE FIELDNAME = 'DRAFT_STATUS' AND FIELDVALUE = B.DRAFT_STATUS AND effdt <= %CurrentDateIn)

  • Related Language Record for C360_IT_PNDR_VW C360_PNDR_WS_VW C360_PND_DRF_VW C360_WS_PNDR_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL Status Description