BudgetByCostCenter: itgen_twinfield_budget_by_cost_center |
Name: BudgetByCostCenter
Catalog: Twinfield
Schema: Twinfield
Label: itgen_twinfield_budget_by_cost_center
Partition-specific: true
Select: true
Insert: false
Update: false
Delete: false
Action (SOAP-specific): GetBudgetByCostCenter
Service URL (XML-specific): webservices/BudgetService.svc
Topic (XML-specific): http://www.twinfield.com/BudgetService/Query
Parameters
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
Code |
string |
☑ |
|
Code of the budget to be retrieved. |
Dim1From |
string |
☐ |
|
General ledger start code. |
Dim1To |
string |
☐ |
|
General ledger end code. |
Dim2From |
string |
☐ |
|
Cost center start code. |
Dim2To |
string |
☐ |
|
Cost center end code. |
Dim3From |
string |
☐ |
|
Project start code. |
Dim3To |
string |
☐ |
|
Project end code. |
IncludeFinal |
boolean |
☐ |
True |
Include final transactions. |
IncludeProvisional |
boolean |
☐ |
|
Include provisional transactions. |
PeriodFrom |
int32 |
☐ |
|
Start period to be retrieved. |
PeriodTo |
int32 |
☐ |
|
End period to be retrieved. |
Year |
int32 |
☐ |
|
Year to be retrieved. |
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ACTUALCREDIT |
decimal |
itgen_twinfield_actualcredit |
☐ |
|
ACTUALDEBIT |
decimal |
itgen_twinfield_actualdebit |
☐ |
|
ACTUALTOTAL |
decimal |
itgen_twinfield_actualtotal |
☐ |
|
BUDGETCREDIT |
decimal |
itgen_twinfield_budgetcredit |
☐ |
|
BUDGETDEBIT |
decimal |
itgen_twinfield_budgetdebit |
☐ |
|
BUDGETTOTAL |
decimal |
itgen_twinfield_budgettotal |
☐ |
|
DIM1 |
string |
itgen_twinfield_dim1 |
☐ |
|
DIM2 |
string |
itgen_twinfield_dim2 |
☐ |
|
DIM3 |
string |
itgen_twinfield_dim3 |
☐ |
|
GROUP1 |
string |
itgen_twinfield_group1 |
☐ |
|
GROUP2 |
string |
itgen_twinfield_group2 |
☐ |
|
GROUP3 |
string |
itgen_twinfield_group3 |
☐ |
|
PARTITIONID |
string |
Company ID |
☑ |
|
PERIOD |
int32 |
itgen_twinfield_period |
☐ |
|
YEAR |
int32 |
itgen_twinfield_year |
☐ |
|
25-11-2019 21:0317.33.205-BETA+2497