CM_ACCTG_GRP_D

#	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	ADJUST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Type 0=CM Only A=VMI Return D=Decrease I=Increase M=Misc Issue R=Misc Return S=Scrap V=Scrap RTV
3	CM_PRIME_TRAN	Character(1)	VARCHAR2(1) NOT NULL	Primary Transaction for Group
4	CM_COST_PROC_GROUP	Character(18)	VARCHAR2(18) NOT NULL	Cost Flow Record
5	RECNAME_TRANS	Character(18)	VARCHAR2(18) NOT NULL	Selected Transactions Prompt Table: RECDEFN_VW
6	RECNAME_UPDATE	Character(15)	VARCHAR2(15) NOT NULL	Record to Update Prompt Table: RECDEFN_VW
7	CM_SOURCE_RECORD	Character(18)	VARCHAR2(18) NOT NULL	CM Transaction Source Record
8	CM_DR_LOC_ACCT_ON	Character(18)	VARCHAR2(18) NOT NULL	CM Dr Definition; Loc Acct On
9	CM_CR_LOC_ACCT_ON	Character(18)	VARCHAR2(18) NOT NULL	CM Cr Definition; Loc Acct On
10	CM_DR_LOC_ACCT_OFF	Character(18)	VARCHAR2(18) NOT NULL	CM Dr Definition; Loc Acct Off
11	CM_CR_LOC_ACCT_OFF	Character(18)	VARCHAR2(18) NOT NULL	CM Cr Definition; Loc Acct Off
12	CM_CF_OVRRID_DR_CR	Character(2)	VARCHAR2(2) NOT NULL	CM Override DR or CR CR=Credit DR=Debit
13	CM_RULE_GROUP	Character(3)	VARCHAR2(3) NOT NULL	Accounting Rule Group
14	CONS_RULE_GROUP	Character(3)	VARCHAR2(3) NOT NULL	Consignment Rule Group
15	CM_EXTEND_COST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Extend Cost? Y/N Table Edit Default Value: Y
16	CM_MFG_ONLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mfg only transaction? Y/N Table Edit Default Value: N
17	CM_SIGN	Signed Number(2,0)	DECIMAL(1) NOT NULL	This field is used in cm_acctg_grp_d and can be multiplied by the qty_base in transaction_inv to get a true movement direction (- for depletions of inventory and + for receipts of inventory). Join cm_acctg_grp_d by the transaction_group and adjust type.
18	CM_QTY_DIRECTION	Signed Number(2,0)	DECIMAL(1) NOT NULL	This field shows the movement direction for the transactions in transaction_inv based on transaction group and adjust type. Positive for receipts of inventory and negative for depletions of inventory.s
19	CM_RECNAME_UPDATE	Character(15)	VARCHAR2(15) NOT NULL	Record to Update
20	CM_SQL_EXPLODE	Character(18)	VARCHAR2(18) NOT NULL	Explode Table
21	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.
22	CM_IU_ANCHOR	Character(2)	VARCHAR2(2) NOT NULL	GMG added 8/2001. Defines if the Inter/Intra Unit anchor row will be the DR or the CR.
23	CM_DR_TMP	Character(18)	VARCHAR2(18) NOT NULL	Debit Temp Table
24	CM_CR_TMP	Character(18)	VARCHAR2(18) NOT NULL	Credit Temp Table
25	CM_MFG_PROC_GROUP	Character(18)	VARCHAR2(18) NOT NULL	MFG Cost Flow Record