# ModifiedFinancialDiversBookings - Name: `ModifiedFinancialDiversBookings` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `bookyearKey_id` | `int32` | ☐ | | | | `COMPANY_CODE` | `string` | ☐ | | | | `journalKey` | `string` | ☐ | | | | `modifiedSince` | `datetime` | ☐ | | | ## Table Columns The columns of the table `ModifiedFinancialDiversBookings` 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 | ☑ | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKINGLINES_ACCOUNTKEY` | `int32` | General Ledger Account Key | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKINGLINES_AMOUNT` | `double` | Amount | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKINGLINES_CODAINFO_CODAMOVELINEDATA` | `string` | Modified Financial Miscellaneous Booking Array Booking Lines CODA Info CODA Move Line Data | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKINGLINES_CODAINFO_CODAVERSION` | `string` | Modified Financial Miscellaneous Booking Array Booking Lines CODA Info CODA Version | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKINGLINES_COSTCENTREKEY` | `string` | Cost Center Key | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKINGLINES_COSTCENTREKEY_ID` | `int32` | Modified Financial Miscellaneous Booking Array Booking Lines Cost Centre Key ID | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKINGLINES_EXTERNALRELATIONID` | `int32` | External Relation ID | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKINGLINES_REFERENCE` | `string` | Reference | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKINGLINES_TYPE` | `string` | Type | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKYEARKEY` | `string` | Modified Financial Miscellaneous Booking Array Financial Year Key | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKYEARKEY_ID` | `int32` | Modified Financial Miscellaneous Booking Array Book Year Key ID | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_BOOKYEARPERIODENR` | `int32` | Modified Financial Miscellaneous Booking Array Period Number | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_DOCUMENTDATE` | `datetime` | Modified Financial Miscellaneous Booking Array Document Date | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_DOCUMENTSEQUENCENR` | `int32` | Modified Financial Miscellaneous Booking Array Document Number | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_EXCHANGERATE` | `double` | Modified Financial Miscellaneous Booking Array Exchange Rate | | | | `MODIFIEDFINANCIALDIVERSBOOKINGARRAY_JOURNALKEY` | `string` | Modified Financial Miscellaneous Booking Array Journal Key | | | | `RETURN` | `int32` | Return | | |