# ReportModifiedBooking - Name: `ReportModifiedBooking` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `bookyearKey_id` | `int32` | ☐ | | | | `COMPANY_CODE` | `string` | ☐ | | | | `journalTypeId` | `int32` | ☐ | | | | `modifiedSince` | `datetime` | ☐ | | | ## Table Columns The columns of the table `ReportModifiedBooking` 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 | ☑ | | | `DELETEDBOOKINGLIST_BOOKYEARKEY` | `string` | Deleted Financial Year Key | | | | `DELETEDBOOKINGLIST_BOOKYEARKEY_ID` | `int32` | Deleted Booking List Book Year Key ID | | | | `DELETEDBOOKINGLIST_DOCUMENTSEQUENCENR` | `int32` | Deleted Document Number | | | | `DELETEDBOOKINGLIST_JOURNALSEQUENCENR` | `int32` | Deleted Journal Sequence Number | | | | `DELETEDBOOKINGLIST_JOURNALTYPE` | `int32` | Deleted Journal Type | | | | `MODIFIEDBOOKINGLIST_ACCOUNTKEY` | `int32` | General Ledger Account Key | | | | `MODIFIEDBOOKINGLIST_BOOKINGAMOUNT` | `double` | Booking Amount | | | | `MODIFIEDBOOKINGLIST_BOOKYEARKEY` | `string` | Financial Year Key | | | | `MODIFIEDBOOKINGLIST_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `MODIFIEDBOOKINGLIST_BOOKYEARPERIODENR` | `int32` | Period Number | | | | `MODIFIEDBOOKINGLIST_COMMENT` | `string` | Comment | | | | `MODIFIEDBOOKINGLIST_COSTCENTREKEY` | `string` | Cost Center Key | | | | `MODIFIEDBOOKINGLIST_COSTCENTREKEY_ID` | `int32` | Modified Booking List Cost Centre Key ID | | | | `MODIFIEDBOOKINGLIST_CURRENCYCODE` | `string` | Currency Code | | | | `MODIFIEDBOOKINGLIST_DOCUMENTAMOUNT` | `double` | Document Amount | | | | `MODIFIEDBOOKINGLIST_DOCUMENTDATE` | `datetime` | Document Date | | | | `MODIFIEDBOOKINGLIST_DOCUMENTSEQUENCENR` | `int32` | Document Number | | | | `MODIFIEDBOOKINGLIST_EXCHANGERATE` | `double` | Exchange Rate | | | | `MODIFIEDBOOKINGLIST_EXPIRYDATE` | `datetime` | Expiry Date | | | | `MODIFIEDBOOKINGLIST_JOURNALNR` | `int32` | Journal Number | | | | `MODIFIEDBOOKINGLIST_JOURNALTYPE` | `int32` | Journal Type | | | | `MODIFIEDBOOKINGLIST_LINESEQUENCENR` | `int32` | Line Sequence Number | | | | `MODIFIEDBOOKINGLIST_REFERENCE` | `string` | Reference | | | | `MODIFIEDBOOKINGLIST_RELATIONKEY` | `string` | Relation Key | | | | `MODIFIEDBOOKINGLIST_RELATIONKEY_ID` | `int32` | Modified Booking List Relation Key ID | | | | `MODIFIEDBOOKINGLIST_VATRECUPERATIONPERCENTAGE` | `double` | VAT Recovery Percentage | | | | `MODIFIEDBOOKINGLIST_VATSECTIONCODE` | `string` | VAT Section Code | | | | `RETURN` | `int32` | Return | | |