Table: dbo.GL_Period_Key_Old_To_New_Map
This is a staging table used only for remapping GL period foreign keys for a particular client. After the foreign keys are remapped, the rows in this map table are removed.
Columns
NameTypeConstraintsDescription
old__gl_period_KEYint (4)NOT NULLPrimary key. The old GL period key value that may shortly be going away.
new__gl_period_KEYint (4)NOT NULLThe new GL period key value. Any data in the database that references the old key should be changed to reference the new key value.
client_KEYint (4)NOT NULLThe foreign key of the client that is remapping their GL periods.
Primary key
NameColumnsDescription
PK_GL_Period_Key_Old_To_New_Map$old__gl_period_KEYold__gl_period_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Period_Key_Old_To_New_Map__Client__client_KEYclient_KEYClient (client_KEY)
FK_GL_Period_Key_Old_To_New_Map__GL_Period__new__gl_period_KEYnew__gl_period_KEYGL_Period (gl_period_KEY)

Schema diagram