ProjectBudgets: Twinfield Project Budgets
read only
- Catalog:
Twinfield - Schema:
Views - Label: Project Budgets
Can only retrieve data.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 54 |
| Full scan rows per minute | 1,690 |
| Point query rows per minute | 1,111 |
| Write rows per minute | 378 |
The result can be cached on the client.
Table Columns
The columns of the table ProjectBudgets are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACTUALCREDIT |
decimal |
Actual Credit | |||
ACTUALDEBIT |
decimal |
Actual Debit | |||
ACTUALTOTAL |
decimal |
Actual Total | |||
BUDGETCREDIT |
decimal |
Budget Credit | |||
BUDGETDEBIT |
decimal |
Budget Debit | |||
BUDGETTOTAL |
decimal |
Budget Total | |||
Budget |
varchar2 |
Name | Budget |
||
COMPANY_ |
varchar2 |
Company ID | |||
COMPANY_ |
varchar2 |
Company Name | |||
DIM1 |
varchar2 |
Dimension 1 | |||
DIM2 |
varchar2 |
Dimension 2 | |||
DIM3 |
varchar2 |
Dimension 3 | |||
GROUP1 |
varchar2 |
Group 1 | |||
GROUP2 |
varchar2 |
Group 2 | |||
GROUP3 |
varchar2 |
Group 3 | |||
PERIOD |
int32 |
Period | |||
YEAR |
decimal |
||||
budget_ |
varchar2 |
Code | budget_ |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: