BUSINESS_UNIT_GLEX_EXC1500_VW(SQL View) |
Index Back |
|---|---|
Business Units |
| SELECT A.BUSINESS_UNIT_GL , C.DESCR , A.BU_ADV_MAX_AMT , A.DST_CNTRL_ID , A.MIN_RCPT_AMT , A.BASE_CURRENCY , A.DB_NUMBER , A.LOCATION , B.DESCR , A.VAT_NRCVR_PRO_FLG FROM PS_BUS_UNIT_TBL_EX A , PS_LOCATION_TBL B , PS_SET_CNTRL_REC B2 , PS_BUS_UNIT_TBL_FS 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 B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_LOCATION_TBL WHERE B.SETID = SETID AND B.LOCATION = LOCATION AND EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | BU_ADV_MAX_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Max Advance Amount for BU |
| 4 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Accounting Template |
| 5 | MIN_RCPT_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Minimum Receipt Amount |
| 6 | 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. " |
| 7 | DB_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 8 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 9 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location |
| 10 | VAT_NRCVR_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Non-Recoverable VAT |