OI_INUBU_VW

(SQL View)
 Index Back

InterUnit Business Unit

Primary record for InterUnit Business Unit

SELECT BUGL.BUSINESS_UNIT , BU_FS1.DESCR , BU_FS1.DESCRSHORT , BUGL.AS_OF_DATE , BUGL.BASE_CURRENCY , CC_ED.DESCR CUR_DESC , CC_ED.DESCRSHORT CUR_DESCRSHORT , CC_ED.COUNTRY , CC_ED.CUR_SYMBOL , BUGL.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 , BUGL.ENABLE_UNPOST_DT ENABLE_UNPOST_DT , XLI13.DESCR JRNL_APPRVL_OPTN , XLI14.DESCR BD_JRNL_APPR_OPTN , BPD1.BUSPROCNAME , BPD1.DESCR60 , ARH1_ED.APPR_RULE_SET , BPD2.BUSPROCNAME BUSPROCNAME_BD , BPD2.DESCR60 BPN_DESCR60 , ARH2_ED.APPR_RULE_SET APPR_RULE_SET_BD , BUGL.TR_RVL_RATE_INDEX , RTI.DESCR RI_DESCR , BUGL.TR_RVL_RT_TYPE , RTT.DESCR RT_DESCR , RTT.DESCRSHORT RT_DESCRSHORT , BUGL.INT_ENTITYCD , EEC1.DESCR IEC_DESCR , BUGL.EXT_ENTITYCD , EEC2.DESCR EEC_DESCR , BUGL.PYMNT_METHOD , PM_ED.XLATLONGNAME , BUGL.DOC_SEQ , BUGL.DOC_TYPE , DT.DESCR DT_DESCR , BUGL.VAT_NRCVR_PRO_FLG , BUGL.VAT_NRCVR_ALL_FLG , BUGL.HOLIDAY_LIST_ID , BCHD.DESCR HL_DESCR , XLI15.DESCR POST_DATE_OPTN , BUGL.PROCESS_DATE , BUGL.IU_INTER_TMPLT_CD , INTR.DESCR INTR_DESCR , BUGL.IU_INTRA_TMPLT_CD , INTA.DESCR INTA_DESCR , BUGL.IU_LEGAL_ENT_BU , BUGL.BUSINESS_UNIT_AP , BU_FS2.DESCR BUAP_DESCR , BU_FS2.DESCRSHORT BUAP_DESCRSHOT , BUGL.VENDOR_SETID , BUGL.VENDOR_ID , VR.VENDOR_NAME_SHORT , VR.VNDR_AFFILIATE , BUGL.LOCATION , BUGL.BUSINESS_UNIT_BI , BU_FS3.DESCR BUBI_DESCR , BU_FS3.DESCRSHORT BUBI_DESCRSHORT , BUGL.CUST_ID , CR.NAME1 , CR.NAMESHORT , BUGL.CUST_VNDR_AFFILIAT , XLI16.DESCR PHY_NATURE_DESC , BUGL.LED_GRP_DEFAULT FROM PS_BUS_UNIT_TBL_GL BUGL LEFT OUTER JOIN PS_BUS_UNIT_TBL_FS BU_FS1 ON BUGL.BUSINESS_UNIT=BU_FS1.BUSINESS_UNIT LEFT OUTER JOIN ( SELECT CC.CURRENCY_CD , CC.DESCR , CC.DESCRSHORT , CC.COUNTRY , CC.CUR_SYMBOL FROM PS_CURRENCY_CD_TBL CC WHERE CC.EFFDT= ( SELECT MAX(ED1.EFFDT) FROM PS_CURRENCY_CD_TBL ED1 WHERE CC.CURRENCY_CD=ED1.CURRENCY_CD ) ) CC_ED ON BUGL.BASE_CURRENCY=CC_ED.CURRENCY_CD LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = BUGL.JRNL_BALANCE_OPTN AND XLI1.CODESETGROUPNAME ='JRNL_BALANCE_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI2 ON XLI2.CODESETNAME = BUGL.JRNL_EDIT_ERR_OPTN AND XLI2.CODESETGROUPNAME ='JRNL_EDIT_ERR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI3 ON XLI3.CODESETNAME = BUGL.JRNL_AMT_ERR_OPTN AND XLI3.CODESETGROUPNAME ='JRNL_AMT_ERR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI4 ON XLI4.CODESETNAME = BUGL.JRNL_DT_ERR_OPTN AND XLI4.CODESETGROUPNAME ='JRNL_DT_ERR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI5 ON XLI5.CODESETNAME = BUGL.JRNL_DT_ERR_OPTN2 AND XLI5.CODESETGROUPNAME ='JRNL_DT_ERR_OPTN2' LEFT OUTER JOIN PS_OI_COMMON_VW XLI6 ON XLI6.CODESETNAME = BUGL.ADJ_YEAR_OPTN AND XLI6.CODESETGROUPNAME ='ADJ_YEAR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI7 ON XLI7.CODESETNAME = BUGL.CONTROL_TOTAL_OPTN AND XLI7.CODESETGROUPNAME ='CONTROL_TOTAL_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI8 ON XLI8.CODESETNAME = BUGL.CURRENCY_BAL_OPTN AND XLI8.CODESETGROUPNAME ='CURRENCY_BAL_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI9 ON XLI9.CODESETNAME = BUGL.EXCHANGE_RATE_OPTN AND XLI9.CODESETGROUPNAME ='EXCHANGE_RATE_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI10 ON XLI10.CODESETNAME = BUGL.BASE_CUR_ADJ_OPTN AND XLI10.CODESETGROUPNAME ='BASE_CUR_ADJ_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI11 ON XLI11.CODESETNAME = BUGL.JRNL_FOREIGN_OPTN AND XLI11.CODESETGROUPNAME ='JRNL_FOREIGN_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI13 ON XLI13.CODESETNAME = BUGL.JRNL_APPRVL_OPTN AND XLI13.CODESETGROUPNAME ='JRNL_APPRVL_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI14 ON XLI14.CODESETNAME = BUGL.BD_JRNL_APPR_OPTN AND XLI14.CODESETGROUPNAME ='BD_JRNL_APPR_OPTN' LEFT OUTER JOIN PSBUSPROCDEFN BPD1 ON BUGL.BUSPROCNAME=BPD1.BUSPROCNAME LEFT OUTER JOIN ( SELECT ARH1.APPR_RULE_SET FROM PS_APPR_RULE_HDR ARH1 WHERE ARH1.EFFDT= ( SELECT MAX(ED.EFFDT) FROM PS_APPR_RULE_HDR ED WHERE ARH1.APPR_RULE_SET=ED.APPR_RULE_SET AND ED.EFFDT <= %CurrentDateIn ) ) ARH1_ED ON BUGL.APPR_RULE_SET=ARH1_ED.APPR_RULE_SET LEFT OUTER JOIN PSBUSPROCDEFN BPD2 ON BUGL.BUSPROCNAME_BD=BPD2.BUSPROCNAME LEFT OUTER JOIN ( SELECT ARH2.APPR_RULE_SET FROM PS_APPR_RULE_HDR ARH2 WHERE ARH2.EFFDT= ( SELECT MAX(ED.EFFDT) FROM PS_APPR_RULE_HDR ED WHERE ARH2.APPR_RULE_SET=ED.APPR_RULE_SET AND ED.EFFDT <= %CurrentDateIn ) ) ARH2_ED ON BUGL.APPR_RULE_SET_BD=ARH2_ED.APPR_RULE_SET LEFT OUTER JOIN PS_RT_INDEX_TBL RTI ON BUGL.TR_RVL_RATE_INDEX=RTI.RT_RATE_INDEX LEFT OUTER JOIN PS_RT_TYPE_TBL RTT ON BUGL.TR_RVL_RT_TYPE=RTT.RT_TYPE LEFT OUTER JOIN PS_ECENTITYCDS EEC1 ON BUGL.INT_ENTITYCD=EEC1.ECENTITYCD LEFT OUTER JOIN PS_ECENTITYCDS EEC2 ON BUGL.EXT_ENTITYCD=EEC2.ECENTITYCD LEFT OUTER JOIN ( SELECT PM.PYMNT_METHOD , PM.XLATLONGNAME FROM PS_PYMNT_MTHD_VW PM WHERE PM.EFFDT= ( SELECT MAX(ED.EFFDT) FROM PS_PYMNT_MTHD_VW ED WHERE PM.PYMNT_METHOD=ED.PYMNT_METHOD AND ED.EFF_STATUS = 'A' AND ED.EFFDT <= %CurrentDateIn ) ) PM_ED ON BUGL.PYMNT_METHOD=PM_ED.PYMNT_METHOD LEFT OUTER JOIN PS_DOC_TYPE_TBL DT ON BUGL.DOC_TYPE=DT.DOC_TYPE LEFT OUTER JOIN PS_BUS_CAL_HOL_DFN BCHD ON BUGL.HOLIDAY_LIST_ID=BCHD.HOLIDAY_LIST_ID LEFT OUTER JOIN PS_OI_COMMON_VW XLI15 ON XLI15.CODESETNAME = BUGL.POST_DATE_OPTN AND XLI15.CODESETGROUPNAME ='POST_DATE_OPTN' LEFT OUTER JOIN PS_SET_CNTRL_REC SCR1 ON BUGL.BUSINESS_UNIT=SCR1.SETCNTRLVALUE AND SCR1.RECNAME = 'IU_INTER_TMPLT' LEFT OUTER JOIN PS_IU_INTER_TMPLT INTR ON BUGL.IU_INTER_TMPLT_CD=INTR.IU_INTER_TMPLT_CD AND SCR1.SETID=INTR.SETID LEFT OUTER JOIN PS_SET_CNTRL_REC SCR2 ON BUGL.BUSINESS_UNIT=SCR2.SETCNTRLVALUE AND SCR2.RECNAME = 'IU_INTER_TMPLT' LEFT OUTER JOIN PS_IU_INTRA_TMPLT INTA ON BUGL.IU_INTRA_TMPLT_CD=INTA.IU_INTRA_TMPLT_CD AND SCR2.SETID=INTA.SETID LEFT OUTER JOIN PS_BUS_UNIT_TBL_FS BU_FS2 ON BUGL.BUSINESS_UNIT_AP=BU_FS2.BUSINESS_UNIT LEFT OUTER JOIN PS_VENDOR VR ON BUGL.VENDOR_ID=VR.VENDOR_ID LEFT OUTER JOIN PS_BUS_UNIT_TBL_FS BU_FS3 ON BUGL.BUSINESS_UNIT_BI=BU_FS3.BUSINESS_UNIT LEFT OUTER JOIN PS_CUSTOMER CR ON BUGL.CUST_ID=CR.CUST_ID LEFT OUTER JOIN PS_OI_COMMON_VW XLI16 ON XLI16.CODESETNAME = BUGL.PHYSICAL_NATURE AND XLI16.CODESETGROUPNAME ='PHYSICAL_NATURE' 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 DESCR60_2 Character(60) VARCHAR2(60) NOT NULL 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 TR_RVL_RTIX_DESCR Character(30) VARCHAR2(30) NOT NULL Activity type 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 TR_RVL_RTTY_DESCR Character(30) VARCHAR2(30) NOT NULL Activity type description
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 INT_ENTITYCD_DESCR Character(30) VARCHAR2(30) NOT NULL Activity type description
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 EXT_ENTITYCD_DESCR Character(30) VARCHAR2(30) NOT NULL Activity type description
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 HOLIDAY_LIST_DESCR Character(30) VARCHAR2(30) NOT NULL Activity type 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 IU_INTER_TMP_DESCR Character(30) VARCHAR2(30) NOT NULL Activity type description
53 IU_INTRA_TMPLT_CD Character(5) VARCHAR2(5) NOT NULL Key field for IntraUnit Template
54 IU_INTRA_TMP_DESCR Character(30) VARCHAR2(30) NOT NULL Activity type description
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 BU_AP_DESCR Character(30) VARCHAR2(30) NOT NULL Business unit PC description
58 BU_AP_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL AP decription
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 BU_BI_DESCR Character(30) VARCHAR2(30) NOT NULL Business unit PC description
66 BU_BI_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL BU Description
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