CM_IUNONPAIR_VW(SQL View) |
Index Back |
|---|
| SELECT S.BUSINESS_UNIT , D.BUSINESS_UNIT , A.IU_SYS_TRAN_CD , A.IU_TRAN_CD , S.IU_LEGAL_ENT_BU AS S_IU_LEGAL_ENT_BU , D.IU_LEGAL_ENT_BU AS D_IU_LEGAL_ENT_BU , S.IU_INTER_TMPLT_CD , S.IU_INTRA_TMPLT_CD , B.DEFAULT_FLAG , A.IU_TYPE , A.INTERCOMPANY_FLG , A.IU_OWNERSHIP FROM PS_IU_TRAN_MAP_OPT A , PS_IU_TRAN_MAP_TBL B , PS_BUS_UNIT_TBL_GL S , PS_BUS_UNIT_TBL_GL D , PS_INSTALLATION_FS I WHERE A.IU_SYS_TRAN_CD = B.IU_SYS_TRAN_CD AND A.IU_TRAN_CD = B.IU_TRAN_CD AND B.DEFAULT_FLAG = 'Y' AND ( (A.IU_TYPE = 'IE' AND D.BUSINESS_UNIT <> S.BUSINESS_UNIT AND I.IU_LEGAL_ENT_FLG = 'Y' AND D.IU_LEGAL_ENT_BU <> S.IU_LEGAL_ENT_BU ) OR (A.IU_TYPE = 'AE' AND D.BUSINESS_UNIT <> S.BUSINESS_UNIT AND I.IU_LEGAL_ENT_FLG = 'Y' AND D.IU_LEGAL_ENT_BU = S.IU_LEGAL_ENT_BU ) OR (A.IU_TYPE = 'AU' AND D.BUSINESS_UNIT = S.BUSINESS_UNIT ) OR (A.IU_TYPE = 'IU' AND D.BUSINESS_UNIT <> S.BUSINESS_UNIT AND I.IU_LEGAL_ENT_FLG = 'N' ) ) AND I.IU_METHOD IN ('D','I') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CM_BU_SOURCE_GL | Character(5) | VARCHAR2(5) NOT NULL | 07/99 GMG CN800-9.0: |
| 2 | CM_BU_DESTIN_GL | Character(5) | VARCHAR2(5) NOT NULL | 07/99 GMG CN800-9.0: |
| 3 | IU_SYS_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL | System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries. |
| 4 | IU_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL | Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction. |
| 5 | CM_BU_SOURCE_LBU | Character(5) | VARCHAR2(5) NOT NULL | Source GL Legal Bus Unit |
| 6 | CM_BU_DESTIN_LBU | Character(5) | VARCHAR2(5) NOT NULL | Destination GL Legal Bus Unit |
| 7 | 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. |
| 8 | IU_INTRA_TMPLT_CD | Character(5) | VARCHAR2(5) NOT NULL | Key field for IntraUnit Template |
| 9 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Default |
| 10 | IU_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Used for interunit bill options, to distinguish the different types of inter/intraunit entries.
AE=IntraEntity AU=IntraUnit IE=InterEntity IU=InterUnit |
| 11 | INTERCOMPANY_FLG | Character(1) | VARCHAR2(1) NOT NULL | /* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/ |
| 12 | IU_OWNERSHIP | Character(1) | VARCHAR2(1) NOT NULL |
Ownership Unit
D=Destination S=Source |