# PROJECTS: Projects - Name: `PROJECTS` - Catalog: `AccountView` - Label: Projects - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `PROJECTS` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_NAME` | `string(40)` | Company name | ☐ | | | `ACT_COST` | `int64` | Actual costs | ☐ | | | `ACT_DIFF` | `int64` | Difference costs/revenues | ☐ | | | `ACT_PROC` | `int64` | Actual revenues | ☐ | | | `ADV_AMT` | `int64` | Advance amount | ☐ | | | `BB_TYPE` | `decimal` | Year-end processing | ☐ | | | `BEG_DATE` | `datetime` | Project start date | ☐ | | | `BEG_PER` | `int32` | Start period | ☐ | | | `BLK_PCT` | `decimal` | G-account percentage | ☐ | | | `BMA_COST` | `int64` | Budget variance costs | ☐ | | | `BMA_PROC` | `int64` | Budget variance revenues | ☐ | | | `BUD_COST` | `int64` | Budget costs | ☐ | | | `BUD_PROC` | `int64` | Budget revenues | ☐ | | | `BV_PCT` | `decimal` | UWV percentage | ☐ | | | `CALC_NOTE` | `string(4)` | Project calculation note | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `COBLI_AMT` | `int64` | Commitments amount costs | ☐ | | | `COMMENT` | `string(4)` | Note | ☐ | | | `COST_OBLI` | `int64` | Actual costs excluding commitments | ☐ | | | `DTS_CALC` | `string(14)` | Date/time | ☐ | | | `EMP_NAME` | `string(40)` | Project manager full name | ☐ | | | `EMP_NR` | `string(10)` | Project manager | ☐ | | | `END_DATE` | `datetime` | Project end date | ☐ | | | `END_PER` | `int32` | End period | ☐ | | | `EXT_DESC` | `string(40)` | External description | ☐ | | | `FIN_DATE` | `datetime` | Date financially closed | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `INV_AMT` | `int64` | Invoiced amount | ☐ | | | `INV_METH` | `string(10)` | Billing method | ☐ | | | `LB_PCT` | `decimal` | Payroll tax percentage | ☐ | | | `MIN_INV` | `int64` | Minimum invoice amount | ☐ | | | `OMA_COST` | `int64` | Budget variance costs incl. commitments | ☐ | | | `OMA_PROC` | `int64` | Budget variance revenues incl. commitments | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PCT_FIN` | `float` | Project percentage complete | ☐ | | | `PCT_WIP` | `float` | % complete financial | ☐ | | | `PER_PJC` | `decimal` | Last recalculated period | ☐ | | | `PG_CODE` | `string(10)` | Project group | ☐ | | | `PG_DESC` | `string(40)` | Project group description | ☐ | | | `POBLI_AMT` | `int64` | Commitments amount revenues | ☐ | | | `PP_NAME` | `string(40)` | Client contact | ☐ | | | `PRO_STAT` | `decimal` | Project status | ☐ | | | `PROC_OBLI` | `int64` | Actual revenues excluding commitments | ☐ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `PROJ_DESC` | `string(40)` | Project description | ☐ | | | `PROJ_TYPE` | `string(10)` | Project type | ☐ | | | `REL_COST` | `int64` | Realised budget costs | ☐ | | | `REL_PROC` | `int64` | Realised budget revenues | ☐ | | | `REQ_DATE` | `datetime` | Request date | ☐ | | | `SELL_AMT` | `int64` | Amount to be invoiced | ☐ | | | `SUB_NR` | `string(10)` | Customer/supplier number | ☐ | | | `TYPE_DESC` | `string(40)` | Project type description | ☐ | | | `USE_PCT` | `boolean` | Apply percentages below | ☐ | |