ModifiedAccounts |
Name: ModifiedAccounts
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 |
☑ |
|
DELETEDACCOUNTS_ACCOUNTKEY |
string |
itgen_octopus_deleted_accounts General Ledger Account Key |
|
|
DELETEDACCOUNTS_ACCOUNTKEY_BOOKYEARKEY |
string |
Deleted Financial Year Key |
|
|
DELETEDACCOUNTS_ACCOUNTKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_deleted_accounts_account_key_bookyear_key ID |
|
|
DELETEDACCOUNTS_ACCOUNTKEY_ID |
int32 |
Deleted ID |
|
|
DELETEDACCOUNTS_COSTCENTRETYPE |
int32 |
itgen_octopus_deleted_accounts Cost Center Type |
|
|
DELETEDACCOUNTS_DEFAULTCOSTCENTREKEY |
string |
itgen_octopus_deleted_accounts Default Cost Centre Key |
|
|
DELETEDACCOUNTS_DEFAULTCOSTCENTREKEY_ID |
int32 |
itgen_octopus_deleted_accounts_default_cost_centre_key ID |
|
|
DELETEDACCOUNTS_DESCRIPTION_DESCRIPTION_FR |
string |
itgen_octopus_deleted_accounts_description Description (FR) |
|
|
DELETEDACCOUNTS_DESCRIPTION_DESCRIPTION_NL |
string |
itgen_octopus_deleted_accounts_description Description (NL) |
|
|
DELETEDACCOUNTS_FISCPROFESSIONALPERCENTAGE |
double |
itgen_octopus_deleted_accounts itgen_octopus_fisc_professional_percentage |
|
|
DELETEDACCOUNTS_FISCRECUPPERCENTAGE |
double |
itgen_octopus_deleted_accounts itgen_octopus_fisc_recup_percentage |
|
|
DELETEDACCOUNTS_PURCHASEVATCODE |
string |
itgen_octopus_deleted_accounts Purchase VAT Code |
|
|
DELETEDACCOUNTS_SALESVATCODE |
string |
itgen_octopus_deleted_accounts Sales VAT Code |
|
|
DELETEDACCOUNTS_VATRECUPPERCENTAGE |
double |
itgen_octopus_deleted_accounts itgen_octopus_vat_recup_percentage |
|
|
MODIFIEDACCOUNTS_ACCOUNTKEY |
string |
itgen_octopus_modified_accounts General Ledger Account Key |
|
|
MODIFIEDACCOUNTS_ACCOUNTKEY_BOOKYEARKEY |
string |
Modified Financial Year Key |
|
|
MODIFIEDACCOUNTS_ACCOUNTKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_modified_accounts_account_key_bookyear_key ID |
|
|
MODIFIEDACCOUNTS_ACCOUNTKEY_ID |
int32 |
Modified ID |
|
|
MODIFIEDACCOUNTS_COSTCENTRETYPE |
int32 |
itgen_octopus_modified_accounts Cost Center Type |
|
|
MODIFIEDACCOUNTS_DEFAULTCOSTCENTREKEY |
string |
itgen_octopus_modified_accounts Default Cost Centre Key |
|
|
MODIFIEDACCOUNTS_DEFAULTCOSTCENTREKEY_ID |
int32 |
itgen_octopus_modified_accounts_default_cost_centre_key ID |
|
|
MODIFIEDACCOUNTS_DESCRIPTION_DESCRIPTION_FR |
string |
itgen_octopus_modified_accounts_description Description (FR) |
|
|
MODIFIEDACCOUNTS_DESCRIPTION_DESCRIPTION_NL |
string |
itgen_octopus_modified_accounts_description Description (NL) |
|
|
MODIFIEDACCOUNTS_FISCPROFESSIONALPERCENTAGE |
double |
itgen_octopus_modified_accounts itgen_octopus_fisc_professional_percentage |
|
|
MODIFIEDACCOUNTS_FISCRECUPPERCENTAGE |
double |
itgen_octopus_modified_accounts itgen_octopus_fisc_recup_percentage |
|
|
MODIFIEDACCOUNTS_PURCHASEVATCODE |
string |
itgen_octopus_modified_accounts Purchase VAT Code |
|
|
MODIFIEDACCOUNTS_SALESVATCODE |
string |
itgen_octopus_modified_accounts Sales VAT Code |
|
|
MODIFIEDACCOUNTS_VATRECUPPERCENTAGE |
double |
itgen_octopus_modified_accounts itgen_octopus_vat_recup_percentage |
|
|
RETURN |
int32 |
Return |
|
|
26-03-2019 22:2817.31.54-BETA+1985