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
Name | Type | Constraints | Description
old__gl_period_KEY | int (4) | NOT NULL | Primary key. The old GL period key value that may shortly be going away.
new__gl_period_KEY | int (4) | NOT NULL | The 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_KEY | int (4) | NOT NULL | The foreign key of the client that is remapping their GL periods.

Primary key
Name | Columns | Description
PK_GL_Period_Key_Old_To_New_Map$old__gl_period_KEY | old__gl_period_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_GL_Period_Key_Old_To_New_Map__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_GL_Period_Key_Old_To_New_Map__GL_Period__new__gl_period_KEY | new__gl_period_KEY | GL_Period (gl_period_KEY) |