# ModifiedAccounts - Name: `ModifiedAccounts` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `modifiedSince` | `datetime` | ☐ | | | ## Table Columns The columns of the table `ModifiedAccounts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `COMPANY_CODE` | `string` | Partition Code | ☑ | | | `COMPANY_NAME` | `string` | Partition Name | ☑ | | | `DELETEDACCOUNTS_ACCOUNTKEY` | `string` | Deleted Accounts General Ledger Account Key | | | | `DELETEDACCOUNTS_ACCOUNTKEY_BOOKYEARKEY` | `string` | Deleted Financial Year Key | | | | `DELETEDACCOUNTS_ACCOUNTKEY_BOOKYEARKEY_ID` | `int32` | Deleted Accounts Account Key Book Year Key ID | | | | `DELETEDACCOUNTS_ACCOUNTKEY_ID` | `int32` | Deleted ID | | | | `DELETEDACCOUNTS_COSTCENTRETYPE` | `int32` | Deleted Accounts Cost Center Type | | | | `DELETEDACCOUNTS_DEFAULTCOSTCENTREKEY` | `string` | Deleted Accounts Default Cost Centre Key | | | | `DELETEDACCOUNTS_DEFAULTCOSTCENTREKEY_ID` | `int32` | Deleted Accounts Default Cost Centre Key ID | | | | `DELETEDACCOUNTS_DESCRIPTION_DESCRIPTION_FR` | `string` | Deleted Accounts Description Description (FR) | | | | `DELETEDACCOUNTS_DESCRIPTION_DESCRIPTION_NL` | `string` | Deleted Accounts Description Description (NL) | | | | `DELETEDACCOUNTS_FISCPROFESSIONALPERCENTAGE` | `double` | Deleted Accounts Fiscal Professional Percentage | | | | `DELETEDACCOUNTS_FISCRECUPPERCENTAGE` | `double` | Deleted Accounts Fiscal Recovery Percentage | | | | `DELETEDACCOUNTS_PURCHASEVATCODE` | `string` | Deleted Accounts Purchase VAT Code | | | | `DELETEDACCOUNTS_SALESVATCODE` | `string` | Deleted Accounts Sales VAT Code | | | | `DELETEDACCOUNTS_VATRECUPPERCENTAGE` | `double` | Deleted Accounts VAT Recovery Percentage | | | | `MODIFIEDACCOUNTS_ACCOUNTKEY` | `string` | Modified Accounts General Ledger Account Key | | | | `MODIFIEDACCOUNTS_ACCOUNTKEY_BOOKYEARKEY` | `string` | Modified Financial Year Key | | | | `MODIFIEDACCOUNTS_ACCOUNTKEY_BOOKYEARKEY_ID` | `int32` | Modified Accounts Account Key Book Year Key ID | | | | `MODIFIEDACCOUNTS_ACCOUNTKEY_ID` | `int32` | Modified ID | | | | `MODIFIEDACCOUNTS_COSTCENTRETYPE` | `int32` | Modified Accounts Cost Center Type | | | | `MODIFIEDACCOUNTS_DEFAULTCOSTCENTREKEY` | `string` | Modified Accounts Default Cost Centre Key | | | | `MODIFIEDACCOUNTS_DEFAULTCOSTCENTREKEY_ID` | `int32` | Modified Accounts Default Cost Centre Key ID | | | | `MODIFIEDACCOUNTS_DESCRIPTION_DESCRIPTION_FR` | `string` | Modified Accounts Description Description (FR) | | | | `MODIFIEDACCOUNTS_DESCRIPTION_DESCRIPTION_NL` | `string` | Modified Accounts Description Description (NL) | | | | `MODIFIEDACCOUNTS_FISCPROFESSIONALPERCENTAGE` | `double` | Modified Accounts Fiscal Professional Percentage | | | | `MODIFIEDACCOUNTS_FISCRECUPPERCENTAGE` | `double` | Modified Accounts Fiscal Recovery Percentage | | | | `MODIFIEDACCOUNTS_PURCHASEVATCODE` | `string` | Modified Accounts Purchase VAT Code | | | | `MODIFIEDACCOUNTS_SALESVATCODE` | `string` | Modified Accounts Sales VAT Code | | | | `MODIFIEDACCOUNTS_VATRECUPPERCENTAGE` | `double` | Modified Accounts VAT Recovery Percentage | | | | `RETURN` | `int32` | Return | | |