SETIDIU_INTRA_TMPLT_CDIU_TRAN_CDACT_BAL_GRPPrompt Table: ACT_BAL_GRP_VW2
IU_INTRAGRP_NVW(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.IU_INTRA_TMPLT_CD , A.IU_TRAN_CD , A.ACT_BAL_GRP FROM PS_IU_INTRA_GRP A WHERE EXISTS ( SELECT 'X' FROM PS_ACT_BAL_GRP B WHERE A.ACT_BAL_GRP = B.ACT_BAL_GRP AND B.DEFAULT_FLAG = 'N' AND B.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | IU_INTRA_TMPLT_CD |
Character(5) | VARCHAR2(5) NOT NULL | Key field for IntraUnit Template |
| 3 | 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. |
| 4 | ACT_BAL_GRP |
Character(10) | VARCHAR2(10) NOT NULL |
Account Balancing Group
Prompt Table: ACT_BAL_GRP_VW2 |