Change Key-Obj Combination - GLUTSUMC

This function will change Key-Object combination(s) in ALL subsystems excluding flat files. This utility is similar to GLUTSUMO and GLUTSUMP. It will change combinations from one value to another based on the GL ledger associated with the user. The utility will prompt for the subsystems to change.

Below is the list of tables and column names changed by GLUTSUMC, GLUTSUMO and GLUTSUMP:

Table	Columns
GLK-KEY-MSTR	GLK-KEY
GLK-LINK-DTL	GLK-KEY
GLO-OBJ-MSTR	GLO-OBJ
GLO-LINK-DTL	GLO-OBJ
GLBA-BUDACT-MSTR	GLBA-KEY, -OBJ
GLM-MO-MSTR	GLM-KEY, -OBJ
GLC-BUDG-DTL	GLC-FROM-KEY, -OBJ
GLQ-QUICK-MSTR	GLQ-KEY, -OBJ
GLF-FULL-MSTR	GLF-KEY, -OBJ
GLT-TRNS-DTL	GLK-KEY, GLO-OBJ
GLD-DEF-DTL	GLD-MAP-GL-KEY, -OBJ, GLD-GL-KEY, -OBJ
GLG-GEN-MSTR*	GLG-INTRA
GLR-RULE-DTL*	GLR-VAL
GLK-KEY-MSTR	GLK-OVER-KEY
OH-DTL	OH-GL-KEY, -OBJ
OHB-SET-DTL	OHB-GL-KEY, -OBJ
OHC-CLASS-DTL*	OHC-ADD-QUAL
EN-DTL	EN-GL-KEY, -OBJ
ENT-TTL-DTL*	ENTF-KEY, -OBJ
POI-ITEM-DTL	POI-JL-KEY, -OBJ
PON-EN-DTL	PON-GL-KEY, -OBJ
POC-CLASS-DTL*	POC-ADD-QUAL
SIT-TRANS-DTL	SIT-GL-KEY, -OBJ
SIM-ITEM-DTL	SIM-GL-KEY, -OBJ
SI-WHSE-MSTR	SI-WHSE-GL-KEY, -OBJ
SIC-CLASS-DTL*	SIC-ADD-QUAL
CD-CODES-MSTR	CD-ASSOC-CODE(1), (2)
US-DB-DTL*	US-DB-SEL-CD1, -CD2
PYN-NUM-DTL	PY-CHR-CD
PYM-CDH-DTL*	PYM-KEY(1), (2), PYM-OBJ(1), (2)
AR-TRNS-DTL	AR-GL-KEY, -OBJ
AR-CODE-MSTR	ARC-PROJ, ARC-OBJ, ARC-DIV-PROJ, ARC-DIV-OBJ
PE-PROD-MSTR*	PE-OBJ, PE-OBJ2

*Skipped by GLUTSUMC

Optionally, this process will only change detail transactions for a selected date range. When this option is chosen, only entries in the ARTRNS- DTL, EN-DTL, GLT-TRNS-DTL, GLA-TRNS-DTL, OH-DTL, OHB-SET-DTL, and SIT-TRANS-DTL with a posting date in the entered date range will be updated. All other datasets will not be changed. This option is useful to change current year entries, but leave prior year entries with their existing account numbers for reporting and audit purposes.