| Documentation - Tables -> Fields | Thursday, April 17, 2003 | Page 2 of 54 |
| Table Name: | Budget Codes |
| | Category of Budget, ex: Initital Budget (1), In-year Budget (2) , Forecast Budget (3) |
| | Revenues are be represented here as Initital Revenue (4), etc. |
| | Expenditures are represented here too, because the user may have to alter actual expenditures to include more |
| | than just Corporate expenditures, i.e. programs taken over by other ministries/companies. |
| | Controls freeze for year and budget phase. |
| | Budget Codes is not just about budgets but about revenues and expenditures. |
| | Revenues are represented under its own set of Bufget Codes. |
| | Expenditures are represented under its own set of Bufget Codes. |
| | Budget Category | Budget Codes |
| | Budget Code | Number (Integer) | 2 | Budget Codes |
| | Category of Budget, ex: Initital Budget (1), In-year Budget (2) , Forecast Budget (3) (To control |
| | Comments | Memo | - | Budget Codes |
| | User Comments in 65k bytes limit memo form. |
| | Creation Date | Date/Time | 8 | Budget Codes |
| | When this record was created. |
| | Creation User ID | Number (Long) | 4 | Budget Codes |
| | Who created this record. |
| | Description | Text | 50 | Budget Codes |
| | Description. |
| | A 50 char long text. |
| | Some are 70, see standard sub-account codes. |
| | Fiscal Year | Number (Integer) | 2 | Budget Codes |
| | Ex: 1998 = April 1 1998 to March 31, 1999 |
| | Frozen Date | Date/Time | 8 | Budget Codes |
| | After this date, no records for this fiscal year cannot be altered. |
| | Access control. |
| | Ministry Code | Number (Integer) | 2 | Budget Codes |
| | 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 | Budget Codes |
| | Who modified this record. |
| | Modified Date | Date/Time | 8 | Budget Codes |
| | When this record was modified. |
| | Report Sequence | Number (Integer) | 2 | Budget Codes |
| | 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 | Budget Codes |
| | Short Description normally 10 bytes long. |
| | Some are 20 in length, see standard sub-account codes. |
| | Year Category | Budget Codes |
| | Year Offset | Budget Codes |