magnetic_media_file_client_KEY | int (4) | NOT NULL | Key for the Magnetic Media File Client |
magnetic_media_file_KEY | int (4) | NOT NULL | Key into the associated Magnetic Media File table for the current row |
client_KEY | int (4) | NOT NULL | The client id for this client record |
description | nvarchar (60) | NOT NULL | The description of the client to display in the client listing. This is different from the client name. |
magnetic_media_file_client_type_KEY | int (4) | NOT NULL | |
payment_date | smalldatetime (4) | | The payment date for files that include a payment. Will be null for any files that do not include a payment. |
client_id | nvarchar (22) | NOT NULL | Column value populates the Client ID that exists on the client at the time the v2023.2.0 release was applied or the form was processed, whichever is the latter. For internet files created prior to the release of v.2023.2.0, the value will be set to . |