EX_EXC1500_L_VW

(SQL View)
 Index Back

Business Units


SELECT A.BUSINESS_UNIT_GL , C.LANGUAGE_CD , C.DESCR , A.BU_ADV_MAX_AMT , A.DST_CNTRL_ID , A.MIN_RCPT_AMT , A.BASE_CURRENCY , A.DB_NUMBER , A.LOCATION , B1.DESCR , A.VAT_NRCVR_PRO_FLG FROM PS_BUS_UNIT_TBL_EX A , PS_LOCATION_TBL B , PS_LOCATION_LANG B1 , PS_SET_CNTRL_REC B2 , PS_BUS_UNIT_LANG C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT_GL AND B.LOCATION = A.LOCATION AND B2.SETID = B.SETID AND B2.SETCNTRLVALUE = A.BUSINESS_UNIT_GL AND B2.RECNAME = 'LOCATION_TBL' AND B1.SETID=B.SETID AND B1.LOCATION=B.LOCATION AND B1.EFFDT=B.EFFDT AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_LOCATION_TBL WHERE B.SETID = SETID AND B.LOCATION = LOCATION AND B.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A'

  • Related Language Record for EX_EXC1500_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 BU_ADV_MAX_AMT Number(27,3) DECIMAL(26,3) NOT NULL Max Advance Amount for BU
    5 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
    6 MIN_RCPT_AMT Number(27,3) DECIMAL(26,3) NOT NULL Minimum Receipt Amount
    7 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
    8 DB_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
    9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    10 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location
    11 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT