BUSINESS_UNITBU_DFHI_OPT_VW2(SQL View) |
Index Back |
|---|---|
Bus Unit-Lvl Dflt Hier Opt Vw |
| SELECT A.BUSINESS_UNIT , B.BUSINESS_UNIT , B.BASE_CURRENCY , C.USETAX_PRORATE_FLG , C.VAT_NRCVR_PRO_FLG , C.VAT_NRCVR_CHRG_CD , C.FRGHT_PRORATE_FLG , C.SALETX_PRORATE_FLG FROM PS_BUS_UNIT_TBL_AP A , PS_BUS_UNIT_TBL_GL B , PS_BUS_UNIT_INTFC C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT_GL AND C.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 3 | 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. " |
| 4 | USETAX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Use Tax |
| 5 | VAT_NRCVR_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Non-Recoverable VAT |
| 6 | VAT_NRCVR_CHRG_CD | Character(10) | VARCHAR2(10) NOT NULL | ProrateVAT Non-Recovery |
| 7 | FRGHT_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Freight Charges |
| 8 | SALETX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Sales Tax |