This table contains information needed for describing a folder in the engagement binder tree. |
folder_KEY | int (4) | NOT NULL | Primary key. The column that identifies each folder record. |
description | nvarchar (250) | NOT NULL | Folder description, the display name of the folder, cannot be null or empty. |
engagement_binder_KEY | int (4) | NOT NULL | Foreign key. The link to the engagement binder this folder belongs to, cannot be null. |
workpaper_reference_prefix | nvarchar (40) | NOT NULL | The default workpaper reference string. This value is used to generate unique references for workpapers added to this folder. ["BR"] This column acts as a prefix for the reference being generated and digits(the value from workpaper_reference_suffix_increment column)will be appended to the end to create a unique workpaper reference. |
workpaper_reference_suffix_increment | int (4) | NOT NULL | This increment value will be added to the workpaper_reference_last_used_suffix value to determine the next suffix that will be appended to the workpaper_reference_prefix in order to generate a hopefully unique workpaper reference. |
workpaper_reference_last_used_suffix | int (4) | NOT NULL | The hghest value by which the workpaper reference was incremented by.["BR"] This column always stores the last used suffix value. If the value is -1, it indicates a suffix value has not been used for this folder yet, no workpaper references were generated. ["BR"] A zero value means one workpaper reference was generated but without appending a suffix value (the workpaper_reference_prefix value was used as the workpaper’s reference. |
engagement_folder_type_KEY | int (4) | NOT NULL | Determines which type of folder this record represents. |