TRANSACTION_GROUPCM_ACCTGRPIUXVW(SQL View) |
Index Back |
|---|---|
Acctg Setup Info - Other BU VW07/01 tw CN#R-BKELLY-CQ58J Used in record cm_acctg_dist_d field business_unit SaveEdit peoplecode. |
| SELECT TRANSACTION_GROUP , CM_SOURCE_RECORD , CM_DR_LOC_ACCT_ON , CM_CR_LOC_ACCT_ON , CM_DR_LOC_ACCT_OFF , CM_CR_LOC_ACCT_OFF , CM_RULE_GROUP FROM PS_CM_ACCTG_GRP_D WHERE CM_PRIME_TRAN <> 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSACTION_GROUP |
Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 2 | CM_SOURCE_RECORD | Character(18) | VARCHAR2(18) NOT NULL | CM Transaction Source Record |
| 3 | CM_DR_LOC_ACCT_ON | Character(18) | VARCHAR2(18) NOT NULL | CM Dr Definition; Loc Acct On |
| 4 | CM_CR_LOC_ACCT_ON | Character(18) | VARCHAR2(18) NOT NULL | CM Cr Definition; Loc Acct On |
| 5 | CM_DR_LOC_ACCT_OFF | Character(18) | VARCHAR2(18) NOT NULL | CM Dr Definition; Loc Acct Off |
| 6 | CM_CR_LOC_ACCT_OFF | Character(18) | VARCHAR2(18) NOT NULL | CM Cr Definition; Loc Acct Off |
| 7 | CM_RULE_GROUP | Character(3) | VARCHAR2(3) NOT NULL | Accounting Rule Group |