# ModifiedAccountAmounts - Name: `ModifiedAccountAmounts` - 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 `ModifiedAccountAmounts` 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 | ☑ | | | `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` | Deleted Account Amounts Account Amount Key Account Key Book Year Key ID | | | | `DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_ID` | `int32` | Deleted ID | | | | `DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY` | `string` | Financial Period Key | | | | `DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARKEY` | `string` | Deleted Account Amounts Account Amount Key Book Year Period Key Financial Year Key | | | | `DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARKEY_ID` | `int32` | Deleted Account Amounts Account Amount Key Book Year Period Key Book Year Key ID | | | | `DELETEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARPERIODNR` | `int32` | Deleted Account Amounts Account Amount Key Book Year Period Key Financial Period Number | | | | `DELETEDACCOUNTAMOUNTS_BALANCE` | `double` | Deleted Balance | | | | `MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY` | `string` | Account Amount Key | | | | `MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY` | `string` | Modified Account Amounts Account Amount Key General Ledger Account Key | | | | `MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_BOOKYEARKEY` | `string` | Modified Account Amounts Account Amount Key Account Key Financial Year Key | | | | `MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_BOOKYEARKEY_ID` | `int32` | Modified Account Amounts Account Amount Key Account Key Book Year Key ID | | | | `MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_ACCOUNTKEY_ID` | `int32` | Modified Account Amounts Account Amount Key Account Key ID | | | | `MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY` | `string` | Modified Account Amounts Account Amount Key Financial Period Key | | | | `MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARKEY` | `string` | Modified Account Amounts Account Amount Key Book Year Period Key Financial Year Key | | | | `MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARKEY_ID` | `int32` | Modified Account Amounts Account Amount Key Book Year Period Key Book Year Key ID | | | | `MODIFIEDACCOUNTAMOUNTS_ACCOUNTAMOUNTKEY_BOOKYEARPERIODKEY_BOOKYEARPERIODNR` | `int32` | Modified Account Amounts Account Amount Key Book Year Period Key Financial Period Number | | | | `MODIFIEDACCOUNTAMOUNTS_BALANCE` | `double` | Balance | | | | `RETURN` | `int32` | Return | | |