| Documentation - Tables -> Fields | Thursday, April 17, 2003 | Page 1 of 54 |
| Table Name: | Briefing Book Codes |
| | Briefing Book Codes contains comments to be place at bottom of Breifing Book report. |
| | Briefing Book Code | Number (Long) | 4 | Briefing Book |
| | Briefing Book Code |
| | Comments | Memo | - | Briefing Book |
| | User Comments in 65k bytes limit memo form. |
| | Creation Date | Date/Time | 8 | Briefing Book |
| | When this record was created. |
| | Creation User ID | Number (Long) | 4 | Briefing Book |
| | Who created this record. |
| | Description | Text | 50 | Briefing Book |
| | Description. |
| | A 50 char long text. |
| | Some are 70, see standard sub-account codes. |
| | Fiscal Year | Number (Integer) | 2 | Briefing Book |
| | Ex: 1998 = April 1 1998 to March 31, 1999 |
| | Ministry Code | Number (Integer) | 2 | Briefing Book |
| | Company or Ministry code, Numeric |
| | This should not be confused with External Ministry Code or external company code. |
| | A client will have many companies or minitries, for many years, for many (budget) phases. |
| | Modified by User ID | Number (Long) | 4 | Briefing Book |
| | Who modified this record. |
| | Modified Date | Date/Time | 8 | Briefing Book |
| | When this record was modified. |
| | Report Sequence | Number (Integer) | 2 | Briefing Book |
| | Used for reporting purpose to sequence the order of modificaiton items. |
| | Various tables use this, just in case the code sequence is not the order you wish to use. |
| | Default value of 9999, user can change it to force a line to appear before any other. |
| | Short Description | Text | 10 | Briefing Book |
| | Short Description normally 10 bytes long. |
| | Some are 20 in length, see standard sub-account codes. |