CM_IUPAIR_VW(SQL View) |
Index Back |
|---|
| SELECT S.BUSINESS_UNIT , D.BUSINESS_UNIT , B.IU_SYS_TRAN_CD , B.IU_TRAN_CD , S.IU_LEGAL_ENT_BU , D.IU_LEGAL_ENT_BU , S.IU_INTER_TMPLT_CD , S.IU_INTRA_TMPLT_CD , B.DEFAULT_FLAG , A.INTERCOMPANY_FLG , A.IU_OWNERSHIP FROM PS_IU_INTER_PR_TR 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_TRAN_CD = B.IU_TRAN_CD AND B.DEFAULT_FLAG = 'Y' AND A.IU_FROM_GLBU = S.BUSINESS_UNIT AND A.IU_TO_GLBU = D.BUSINESS_UNIT AND I.IU_METHOD IN ('P') |
| # | 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 | INTERCOMPANY_FLG | Character(1) | VARCHAR2(1) NOT NULL | /* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/ |
| 11 | IU_OWNERSHIP | Character(1) | VARCHAR2(1) NOT NULL |
Ownership Unit
D=Destination S=Source |