ModifiedAccountAmounts |
Name: ModifiedAccountAmounts
Catalog: Octopus
Schema: OctopusWS
Parameters
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
COMPANY_CODE |
string |
☐ |
|
|
modifiedSince |
datetime |
☐ |
|
|
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
COMPANY_CODE |
string |
Partition Code |
☑ |
|
COMPANY_NAME |
string |
Partition Name |
☑ |
|
DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY |
string |
Deleted Account Amount Key |
|
|
DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY |
string |
General Ledger Account Key |
|
|
DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_BOOKYEARKEY |
string |
Deleted Financial Year Key |
|
|
DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_deleted_account_amounts_account_amount_key_account_key_bookyear_key ID |
|
|
DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_ID |
int32 |
Deleted ID |
|
|
DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY |
string |
Financial Period Key |
|
|
DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARKEY |
string |
itgen_octopus_deleted_account_amounts_account_amount_key_bookyear_period_key Financial Year Key |
|
|
DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_deleted_account_amounts_account_amount_key_bookyear_period_key_bookyear_key ID |
|
|
DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARPERIODNR |
int32 |
itgen_octopus_deleted_account_amounts_account_amount_key_bookyear_period_key Financial Period Number |
|
|
DELETEDACCOUNTAMOUNTS_BALANCE |
double |
Deleted Balance |
|
|
MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY |
string |
Account Amount Key |
|
|
MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY |
string |
itgen_octopus_modified_account_amounts_account_amount_key General Ledger Account Key |
|
|
MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_BOOKYEARKEY |
string |
itgen_octopus_modified_account_amounts_account_amount_key_account_key Financial Year Key |
|
|
MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_modified_account_amounts_account_amount_key_account_key_bookyear_key ID |
|
|
MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_ID |
int32 |
itgen_octopus_modified_account_amounts_account_amount_key_account_key ID |
|
|
MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY |
string |
itgen_octopus_modified_account_amounts_account_amount_key Financial Period Key |
|
|
MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARKEY |
string |
itgen_octopus_modified_account_amounts_account_amount_key_bookyear_period_key Financial Year Key |
|
|
MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_modified_account_amounts_account_amount_key_bookyear_period_key_bookyear_key ID |
|
|
MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARPERIODNR |
int32 |
itgen_octopus_modified_account_amounts_account_amount_key_bookyear_period_key Financial Period Number |
|
|
MODIFIEDACCOUNTAMOUNTS_BALANCE |
double |
Balance |
|
|
RETURN |
int32 |
Return |
|
|
26-03-2019 22:2817.31.54-BETA+1985