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. |
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. |