SH Database
The following describes the fields in the SH (Document Manager) database.
| Field | Contents | Description |
|---|---|---|
| A_CODE | 1 character centered | Flag for Include in Document Manager index (Y, N, *, or blank) |
| A1 | 4 characters right aligned | Initials of User 1 |
| A2 | 4 characters right aligned | Initials of User 2 |
| A3 | 4 characters right aligned | Initials of User 3 |
| A4 | 4 characters right aligned | Initials of User 4 |
| A5 | 4 characters right aligned | Initials of User 5 |
| A6 | 4 characters right aligned | Initials of User 6 |
| A7 | 4 characters right aligned | Initials of User 7 |
| A8 | 4 characters right aligned | Initials of User 8 |
| AC_FROM | 40 characters centered | Account from for filtering of certain automatic reports |
| AC_TO | 40 characters centered | Account to for filtering of certain automatic reports |
| AC1 through to AC8 | - | For internal purposes only. Stores a generated checksum (a value representing the current state of the document) when a role is being signed of (e.g., if signing off role 1, then a checksum value is written to AC1). This value is used internally by the history/milestone system for doing document change comparisons. |
| ACCESS | 4 characters right aligned | Employee number who can access document (not used) |
| ACT_TYPE | 1 character, left aligned | Type of account. S for Cash Flow, P for Performance Measure, " " (space) for Financial. |
| AD1 | 8 characters in date format | Date of completion |
| AD2 | 8 characters in date format | Date of completion |
| AD3 | 8 characters in date format | Date of completion |
| AD4 | 8 characters in date format | Date of completion |
| AD5 | 8 characters in date format | Date of completion |
| AD6 | 8 characters in date format | Date of completion |
| AD7 | 8 characters in date format | Date of completion |
| AD8 | 8 characters in date format | Date of completion |
| ADJ | 1 character left aligned | Combine adjustments into one column (Y or N) |
| AMT_FROM | 19 digits and 2 decimal places | Amount From for filtering of certain automatic reports |
| AMT_TO | 19 digits and 2 decimal places | Amount To for filtering of certain automatic reports |
| AMTCHG | 1 character | Indicates whether the amount change column is displayed(Y or N). |
| ANFLG | 1 character right aligned | And flag for variance analysis threshold AND/OR property.Returns 1 for OR and 0 for AND. |
| ARCHIVE | 1 character left aligned | (Y or N) whether document will be archived during a client file Archive operation |
| ARRANGE | 1 character left aligned | Auto arrange numbers on the document (Y or N) |
| B_PRT | 1 character centered | Flag for batch printing (Y, N or blank) |
| BALTYPE | 1 characters left aligned | Balance type |
| CREATEDON | 14 characters | Marks date and time record was created. |
| CVDIST | 4 characters left aligned | CaseView distributor code (hidden) |
| CVGROUP | 12 characters left aligned | CaseView Group |
| CVID | 8 characters left aligned | Code for the identifier for a CaseView document |
| CWDATE | 14 characters | Marks date and time of database changes. |
| CWGUID | 22 characters | Unique identifier, created when the record is appended. |
| DATE_FROM | 8 characters in date format | Date From for filtering of certain automatic reports |
| DATE_TO | 8 characters in date format | Date To for filtering of certain automatic reports |
| DELETED | 14 characters | Marks date and time record was deleted. |
| DGN | 10 characters centered | Document Index - display code |
| DISCRETE | 1 characters left aligned | Whether balance is discrete to a single period or YTD (N) |
| ENTITY | 40 characters left aligned | Code for the entity in a consolidated file |
| EXINFO | 10 characters | Memo used for reports |
| FE | 1 character centered | Foreign exchange translation to be displayed on the document |
| GROUP | 1 character left aligned | The grouping type to display on the report, which can be S for L/S, G for Group 2, H for Group 3, I for Group 4, M for Map No, T for Tax Code, A for Account, and D for Report |
| H1 | 50 characters left aligned | Heading 1 for automatic type documents |
| H2 | 50 characters left aligned | Heading 2 for automatic type documents |
| INITIALS | 1 character centered | Location of preparer and reviewer initials, which can be T for Top, B for bottom, and blank for Use default |
| LINENO | 6 digits right aligned | Line number or the order in which the document was entered. The numbers in the database start at 1000. |
| MASK | 40 characters left aligned | Group number or wildcard when creating documents such as leadsheets or grouping schedules |
| MEMO | 10 character centered | Extended Description |
| NAME | 2 characters left aligned | Code for the type of automatic document being created (non CaseView documents only) |
| ORIENT | 1 character left aligned | Landscape printing (Y) |
| OTHER | 200 characters centered | Filter information for external document links and automatic documents |
| PARENTONLY | 1 character left aligned | Limits number to parent entity only (N) |
| PERIOD | 3 characters | Period Type |
| PRG | 2 characters, centered | External Program module. That means the program used to access the document, which is by default AC. If you create an external program, this would represent the program name. |
| RND | 1 character centered | Rounding code for financial statement documents, which can be D for currencies, T for thousands of currencies, M for millions of currencies, and blank for no rounding |
| ROLL | 1 character left aligned | For internal purposes only. (Y or N) whether document will be rolled forward during a Year End Close |
| S1 | 20 characters right aligned | Assigned User 1 |
| S2 | 20 characters right aligned | Assigned User 2 |
| S3 | 20 characters right aligned | Assigned User 3 |
| S4 | 20 characters right aligned | Assigned User 4 |
| S5 | 20 characters right aligned | Assigned User 5 |
| S6 | 20 characters right aligned | Assigned User 6 |
| S7 | 20 characters right aligned | Assigned User 7 |
| S8 | 20 characters right aligned | Assigned User 8 |
| SCH_DESC | 50 characters left aligned | Document description |
| SCHEDULE | 12 characters centered | Document Number |
| SD1 | 8 characters in date format | Date User 1 was assigned (not used) |
| SD2 | 8 characters in date format | Date User 2 was assigned (not used) |
| SD3 | 8 characters in date format | Date User 3 was assigned (not used) |
| SD4 | 8 characters in date format | Date User 4 was assigned (not used) |
| SD5 | 8 characters in date format | Date User 5 was assigned (not used) |
| SD6 | 8 characters in date format | Date User 6 was assigned (not used) |
| SD7 | 8 characters in date format | Date User 7 was assigned (not used) |
| SD8 | 8 characters in date format | Date User 8 was assigned (not used) |
| SIGN | 1 character centered | To take into account the normal sign for the account when presented certain automatic documents (y/n) |
| SORT | 1 character left aligned | Order of presentation for certain automatic documents, which can be A for Account, D for Report, S for L/S, G for Group 2, H for Group 3, I for Group 4, M for Map No, T for Tax Code |
| TASKUSER | 22 characters | The selected user displayed on issues automatic documents |
| TYPE | 1 character left aligned | Document Type, which can be A for automatic, F for CaseView, H for folder, M for manual, and E for external document link. |
| UPD | 1 character centered | System code (Y, N, or blank) |
| VIEW | 2 characters centered | Document format for automatic documents |
| ZBAL | 1 character right aligned | Include zero balances (unused) |
