OI_GLBU_VW(SQL View) |
Index Back |
|---|---|
GL Business UnitPrimary record for GL Business Unit ChartField |
| SELECT BUG.BUSINESS_UNIT , BUF.DESCR , BUF.DESCRSHORT , BUG.AS_OF_DATE , BUG.BASE_CURRENCY , CC.DESCR CURR_DESCR , CC.DESCRSHORT CURR_DESCRSHORT , CC.COUNTRY , CC.CUR_SYMBOL , BUG.ELIMS_ONLY , XLI1.DESCR JRNL_BALANCE_OPTN , XLI2.DESCR JRNL_EDIT_ERR_OPTN , XLI3.DESCR JRNL_AMT_ERR_OPTN , XLI4.DESCR JRNL_DT_ERR_OPTN , XLI5.DESCR JRNL_DT_ERR_OPTN2 , XLI6.DESCR ADJ_YEAR_OPTN , XLI7.DESCR CONTROL_TOTAL_OPTN , XLI8.DESCR CURRENCY_BAL_OPTN , XLI9.DESCR EXCHANGE_RATE_OPTN , XLI10.DESCR BASE_CUR_ADJ_OPTN , XLI11.DESCR JRNL_FOREIGN_OPTN , BUG.ENABLE_UNPOST_DT ENABLE_UNPOST_DT , XLI13.DESCR JRNL_APPRVL_OPTN , XLI14.DESCR BD_JRNL_APPR_OPTN , BUG.BUSPROCNAME , BPD1.DESCR60 BPN_DESCR , BUG.APPR_RULE_SET , BUG.BUSPROCNAME_BD , BPD2.DESCR60 BPN_BUD_DESCR , BUG.APPR_RULE_SET_BD , BUG.TR_RVL_RATE_INDEX , RI.DESCR RI_DESCR , BUG.TR_RVL_RT_TYPE , RT.DESCR RT_DESCR , RT.DESCRSHORT RT_DESCRSHORT , BUG.INT_ENTITYCD , IEC.DESCR IEC_DESC , BUG.EXT_ENTITYCD , EEC.DESCR EEC_DESC , BUG.PYMNT_METHOD , PM.XLATLONGNAME , BUG.DOC_SEQ , BUG.DOC_TYPE , DT.DESCR DT_DESCR , BUG.VAT_NRCVR_PRO_FLG , BUG.VAT_NRCVR_ALL_FLG , BUG.HOLIDAY_LIST_ID , HL.DESCR HL_DESCR , XLI15.DESCR POST_DATE_OPTN , BUG.PROCESS_DATE , BUG.IU_INTER_TMPLT_CD , INTER.DESCR INTER_DESCR , BUG.IU_INTRA_TMPLT_CD , INTRA.DESCR INTRA_DESCR , BUG.IU_LEGAL_ENT_BU , BUG.BUSINESS_UNIT_AP , BUAP.DESCR BUAP_DESCR , BUAP.DESCRSHORT BUAP_DESCRSHORT , BUG.VENDOR_SETID , BUG.VENDOR_ID , VR.VENDOR_NAME_SHORT , VR.VNDR_AFFILIATE , BUG.LOCATION , BUG.BUSINESS_UNIT_BI , BUBI.DESCR BUF_DESCR , BUBI.DESCRSHORT BUF_DESCRSHORT , BUG.CUST_ID , CR.NAME1 , CR.NAMESHORT , BUG.CUST_VNDR_AFFILIAT , XLI16.DESCR PHY_NATURE_DESC , BUG.LED_GRP_DEFAULT FROM PS_BUS_UNIT_TBL_GL BUG LEFT OUTER JOIN PS_BUS_UNIT_TBL_FS BUF ON BUG.BUSINESS_UNIT = BUF.BUSINESS_UNIT LEFT OUTER JOIN PS_CURRENCY_CD_TBL CC ON BUG.BASE_CURRENCY = CC.CURRENCY_CD LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = BUG.JRNL_BALANCE_OPTN AND XLI1.CODESETGROUPNAME ='JRNL_BALANCE_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI2 ON XLI2.CODESETNAME = BUG.JRNL_EDIT_ERR_OPTN AND XLI2.CODESETGROUPNAME ='JRNL_EDIT_ERR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI3 ON XLI3.CODESETNAME = BUG.JRNL_AMT_ERR_OPTN AND XLI3.CODESETGROUPNAME ='JRNL_AMT_ERR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI4 ON XLI4.CODESETNAME = BUG.JRNL_DT_ERR_OPTN AND XLI4.CODESETGROUPNAME ='JRNL_DT_ERR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI5 ON XLI5.CODESETNAME = BUG.JRNL_DT_ERR_OPTN2 AND XLI5.CODESETGROUPNAME ='JRNL_DT_ERR_OPTN2' LEFT OUTER JOIN PS_OI_COMMON_VW XLI6 ON XLI6.CODESETNAME = BUG.ADJ_YEAR_OPTN AND XLI6.CODESETGROUPNAME ='ADJ_YEAR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI7 ON XLI7.CODESETNAME = BUG.CONTROL_TOTAL_OPTN AND XLI7.CODESETGROUPNAME ='CONTROL_TOTAL_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI8 ON XLI8.CODESETNAME = BUG.CURRENCY_BAL_OPTN AND XLI8.CODESETGROUPNAME ='CURRENCY_BAL_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI9 ON XLI9.CODESETNAME = BUG.EXCHANGE_RATE_OPTN AND XLI9.CODESETGROUPNAME ='EXCHANGE_RATE_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI10 ON XLI10.CODESETNAME = BUG.BASE_CUR_ADJ_OPTN AND XLI10.CODESETGROUPNAME ='BASE_CUR_ADJ_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI11 ON XLI11.CODESETNAME = BUG.JRNL_FOREIGN_OPTN AND XLI11.CODESETGROUPNAME ='JRNL_FOREIGN_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI13 ON XLI13.CODESETNAME = BUG.JRNL_APPRVL_OPTN AND XLI13.CODESETGROUPNAME ='JRNL_APPRVL_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI14 ON XLI14.CODESETNAME = BUG.BD_JRNL_APPR_OPTN AND XLI14.CODESETGROUPNAME ='BD_JRNL_APPR_OPTN' LEFT OUTER JOIN PSBUSPROCDEFN BPD1 ON BUG.BUSPROCNAME = BPD1.BUSPROCNAME LEFT OUTER JOIN PSBUSPROCDEFN BPD2 ON BUG.BUSPROCNAME_BD=BPD2.BUSPROCNAME LEFT OUTER JOIN PS_RT_INDEX_TBL RI ON BUG.TR_RVL_RATE_INDEX = RI.RT_RATE_INDEX LEFT OUTER JOIN PS_RT_TYPE_TBL RT ON BUG.TR_RVL_RT_TYPE=RT.RT_TYPE LEFT OUTER JOIN PS_ECENTITYCDS IEC ON BUG.INT_ENTITYCD=IEC.ECENTITYCD LEFT OUTER JOIN PS_ECENTITYCDS EEC ON BUG.EXT_ENTITYCD=EEC.ECENTITYCD LEFT OUTER JOIN PS_PYMNT_MTHD_VW PM ON BUG.PYMNT_METHOD=PM.PYMNT_METHOD LEFT OUTER JOIN PS_SET_CNTRL_REC SCR1 ON BUG.BUSINESS_UNIT=SCR1.SETCNTRLVALUE AND SCR1.RECNAME = 'DOC_TYPE_TBL' LEFT OUTER JOIN PS_DOC_TYPE_TBL DT ON DT.SETID =SCR1.SETID AND BUG.DOC_TYPE = DT.DOC_TYPE LEFT OUTER JOIN PS_BUS_CAL_HOL_DFN HL ON BUG.HOLIDAY_LIST_ID=HL.HOLIDAY_LIST_ID LEFT OUTER JOIN PS_OI_COMMON_VW XLI15 ON XLI15.CODESETNAME = BUG.POST_DATE_OPTN AND XLI15.CODESETGROUPNAME ='POST_DATE_OPTN' LEFT OUTER JOIN PS_SET_CNTRL_REC SCR2 ON BUG.BUSINESS_UNIT=SCR2.SETCNTRLVALUE AND SCR2.RECNAME = 'IU_INTER_TMPLT' LEFT OUTER JOIN PS_IU_INTER_TMPLT INTER ON INTER.SETID =SCR2.SETID AND BUG.IU_INTER_TMPLT_CD = INTER.IU_INTER_TMPLT_CD LEFT OUTER JOIN PS_SET_CNTRL_REC SCR3 ON BUG.BUSINESS_UNIT=SCR3.SETCNTRLVALUE AND SCR3.RECNAME = 'IU_INTRA_TMPLT' LEFT OUTER JOIN PS_IU_INTRA_TMPLT INTRA ON INTRA.SETID =SCR3.SETID AND BUG.IU_INTRA_TMPLT_CD = INTRA.IU_INTRA_TMPLT_CD LEFT OUTER JOIN PS_BUS_UNIT_TBL_FS BUAP ON BUG.BUSINESS_UNIT_AP=BUAP.BUSINESS_UNIT LEFT OUTER JOIN PS_BUS_UNIT_TBL_FS BUBI ON BUG.BUSINESS_UNIT_BI=BUBI.BUSINESS_UNIT LEFT OUTER JOIN PS_VENDOR VR ON BUG.VENDOR_SETID=VR.SETID AND BUG.VENDOR_ID =VR.VENDOR_ID LEFT OUTER JOIN PS_SET_CNTRL_REC SCR4 ON BUG.BUSINESS_UNIT=SCR4.SETCNTRLVALUE AND SCR4.RECNAME = 'CUSTOMER' LEFT OUTER JOIN PS_CUSTOMER CR ON CR.SETID =SCR4.SETID AND BUG.CUST_ID = CR.CUST_ID LEFT OUTER JOIN PS_OI_COMMON_VW XLI16 ON XLI16.CODESETNAME = BUG.PHYSICAL_NATURE AND XLI16.CODESETGROUPNAME ='PHYSICAL_NATURE' WHERE (CC.EFFDT = ( SELECT MAX(ED1.EFFDT) FROM PS_CURRENCY_CD_TBL ED1 WHERE ED1.CURRENCY_CD =CC.CURRENCY_CD AND ED1.EFFDT <= CC.EFFDT ) OR CC.CURRENCY_CD IS NULL) AND (PM.EFFDT = ( SELECT MAX(ED2.EFFDT) FROM PS_PYMNT_MTHD_VW ED2 WHERE ED2.PYMNT_METHOD =PM.PYMNT_METHOD AND ED2.EFFDT <= PM.EFFDT ) OR PM.PYMNT_METHOD IS NULL) UNION SELECT ' ' , 'Not Available' , '-' , %DateIn('1900-01-01') , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , %DateIn('1900-01-01') , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 5 | 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. " |
| 6 | BASECUR_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Base currency descr |
| 7 | BASECUR_DESCRSHORT | Character(30) | VARCHAR2(30) NOT NULL | Base currency descr short |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 9 | CUR_SYMBOL | Character(4) | VARCHAR2(4) NOT NULL | Currency Symbol |
| 10 | ELIMS_ONLY | Character(1) | VARCHAR2(1) NOT NULL | For Eliminations Only |
| 11 | JL_BAL_OPTN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Journal Balance Option Descr |
| 12 | JL_ED_ER_OPTN_DESR | Character(30) | VARCHAR2(30) NOT NULL | Journal Edit Errors Option |
| 13 | JL_AM_ER_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Journal Amount Errors Option |
| 14 | JL_DT_ER_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | JRNL Dt Less Than Open From Dt |
| 15 | JLDT_ER_OPTN2_DESC | Character(30) | VARCHAR2(30) NOT NULL | JRNL Dt Less Than Open To Dt |
| 16 | ADJ_YEAR_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Adjustment Year option descr |
| 17 | CTL_TOT_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Control Total Option |
| 18 | CURR_BAL_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Currency Balancing Option |
| 19 | EX_RT_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Translate Ledger Exchange Rate |
| 20 | BCUR_ADJ_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Base currency Adjusment option |
| 21 | JL_FOR_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Foreign Currencies per Journal |
| 22 | ENABLE_UP_DT_DESC | Character(30) | VARCHAR2(30) NOT NULL | Allow Different Unpost Date |
| 23 | JL_APPRL_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Journal Approval Option |
| 24 | BD_JLAPR_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Unit of measure description |
| 25 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 26 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 27 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| 28 | BUSPROCNAME_BD | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name - Budget |
| 29 | BPN_BUD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Budget Ref Description |
| 30 | APPR_RULE_SET_BD | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set - Budgets |
| 31 | TR_RVL_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | The market rate index selected as applicable to mark-to-market revaluation events. |
| 32 | MR_INX_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Market Rate Index Description |
| 33 | TR_RVL_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | The market rate type selected as applicable to mark-to-market revaluation events. |
| 34 | RR_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Revaluation Rate Type Descript |
| 35 | RR_TYPE_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Revaluation Rate Type Short |
| 36 | INT_ENTITYCD | Character(4) | VARCHAR2(4) NOT NULL | Represents the EDI Manager internal entity code associated with a given general ledger business un |
| 37 | IE_CODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Internal Entity Code Desc |
| 38 | EXT_ENTITYCD | Character(4) | VARCHAR2(4) NOT NULL | Represents the EDI Manager external entity code associated with a given general ledger business un |
| 39 | EE_CODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | External Entity Code Desc |
| 40 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 41 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 42 | DOC_SEQ | Character(1) | VARCHAR2(1) NOT NULL | Enable Document Sequencing |
| 43 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. |
| 44 | DOC_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Document Type Description |
| 45 | VAT_NRCVR_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Non-Recoverable VAT |
| 46 | VAT_NRCVR_ALL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allocate Non-Recoverable VAT |
| 47 | HOLIDAY_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL | This is used to identify what holiday calendar to use. This is the access field for all financials groups. |
| 48 | HOLI_LIST_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Holiday List Description |
| 49 | POST_DT_OPTN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Journal Process Date Option |
| 50 | PROCESS_DATE | Date(10) | DATE | Process Date |
| 51 | IU_INTER_TMPLT_CD | Character(5) | VARCHAR2(5) NOT NULL | Key to the interunit template record. Assigned to a GLBU on the GL business unit table. |
| 52 | INTERUNIT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | InterUnit Template Desc |
| 53 | IU_INTRA_TMPLT_CD | Character(5) | VARCHAR2(5) NOT NULL | Key field for IntraUnit Template |
| 54 | INTRAUNIT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | IntraUnit Template Desc |
| 55 | IU_LEGAL_ENT_BU | Character(5) | VARCHAR2(5) NOT NULL | The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity. |
| 56 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 57 | AP_BU_DESCR | Character(30) | VARCHAR2(30) NOT NULL | AP Business Unit descr |
| 58 | AP_BU_DESCRSHORT | Character(30) | VARCHAR2(30) NOT NULL | AP Business Unit Short Description |
| 59 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 60 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 61 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 62 | VNDR_AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Vendor Affiliate |
| 63 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 64 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 65 | BI_BU_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Business Unit Decription |
| 66 | BI_BU_DESCRSHORT | Character(30) | VARCHAR2(30) NOT NULL | Business Unit Short Decription |
| 67 | 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. |
| 68 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 69 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
| 70 | CUST_VNDR_AFFILIAT | Character(1) | VARCHAR2(1) NOT NULL | Customer Vendor Affiliate |
| 71 | PHY_NATURE_DESC | Character(30) | VARCHAR2(30) NOT NULL | Physical Nature Description |
| 72 | LED_GRP_DEFAULT | Character(10) | VARCHAR2(10) NOT NULL | Default Journal Generator Ledger Group of a Business Unit |