# ModifiedBuySellBookings - Name: `ModifiedBuySellBookings` - 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 `ModifiedBuySellBookings` 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 | ☑ | | | `MODIFIEDBUYSELLBOOKINGARRAY_AMOUNT` | `double` | Amount | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_ACCOUNTKEY` | `int32` | Modified Buy Sell Booking Array Booking Lines General Ledger Account Key | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_BASEAMOUNT` | `double` | Modified Buy Sell Booking Array Booking Lines Base Amount | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_COMMENT` | `string` | Modified Buy Sell Booking Array Booking Lines Comment | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_COSTCENTREKEY` | `string` | Modified Buy Sell Booking Array Booking Lines Cost Center Key | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_COSTCENTREKEY_ID` | `int32` | ID | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_VATAMOUNT` | `double` | Modified Buy Sell Booking Array Booking Lines VAT Amount | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_VATCODEKEY` | `string` | Modified Buy Sell Booking Array Booking Lines VAT Code Key | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_VATRECUPPERCENTAGE` | `double` | Modified Buy Sell Booking Array Booking Lines VAT Recovery Percentage | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKYEARKEY` | `string` | Financial Year Key | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKYEARKEY_ID` | `int32` | Modified Buy Sell Booking Array Book Year Key ID | | | | `MODIFIEDBUYSELLBOOKINGARRAY_BOOKYEARPERIODENR` | `int32` | Period Number | | | | `MODIFIEDBUYSELLBOOKINGARRAY_COMMENT` | `string` | Comment | | | | `MODIFIEDBUYSELLBOOKINGARRAY_CURRENCYCODE` | `string` | Currency Code | | | | `MODIFIEDBUYSELLBOOKINGARRAY_DOCUMENTDATE` | `datetime` | Document Date | | | | `MODIFIEDBUYSELLBOOKINGARRAY_DOCUMENTSEQUENCENR` | `int32` | Document Number | | | | `MODIFIEDBUYSELLBOOKINGARRAY_EXCHANGERATE` | `double` | Exchange Rate | | | | `MODIFIEDBUYSELLBOOKINGARRAY_EXPIRYDATE` | `datetime` | Expiry Date | | | | `MODIFIEDBUYSELLBOOKINGARRAY_EXTERNALRELATIONID` | `int32` | External Relation ID | | | | `MODIFIEDBUYSELLBOOKINGARRAY_JOURNALKEY` | `string` | Journal Key | | | | `MODIFIEDBUYSELLBOOKINGARRAY_REFERENCE` | `string` | Reference | | | | `MODIFIEDBUYSELLBOOKINGARRAY_RELATIONKEY` | `string` | Relation Key | | | | `MODIFIEDBUYSELLBOOKINGARRAY_RELATIONKEY_ID` | `int32` | Modified Buy Sell Booking Array Relation Key ID | | | | `RETURN` | `int32` | Return | | |