netclient_file_log_KEY | int (4) | NOT NULL | Primary key; log of NetClient data files |
client_KEY | int (4) | NOT NULL | Foreign key; Client associated with the data file |
creation__staff_KEY | int (4) | NOT NULL | Foreign key; Staff id of the user who created the file |
creation_date | datetime (8, 3) | NOT NULL | Date and time the data file was created |
transmit_date | datetime (8, 3) | | Date and time the file was successfully transmitted to NetClient |
description | nvarchar (100) | NOT NULL | Description the user sees in NetClient |
file_name | nvarchar (100) | NOT NULL | Name of the file |
netclient_file_log_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row |
checkbook_KEY | int (4) | | Client checkbook associated with the data file. |
print_job_KEY | int (4) | | Foreign key to the print job that created the Net Client PDF file. |