# ModifiedBalancingRelations - Name: `ModifiedBalancingRelations` - 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 `ModifiedBalancingRelations` 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 | ☑ | | | `DELETEDBALANCINGARRAY_CREDITBALANCEDBOOKINGAMOUNT` | `double` | Deleted Balancing Array Credit Balanced Booking Amount | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_BOOKYEARKEY` | `string` | Deleted Balancing Array Credit Document Balancing Key Financial Year Key | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_BOOKYEARKEY_ID` | `int32` | Deleted Balancing Array Credit Document Balancing Key Book Year Key ID | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_DOCUMENTSEQUENCENR` | `int32` | Deleted Balancing Array Credit Document Balancing Key Document Number | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_JOURNALKEY` | `string` | Deleted Balancing Array Credit Document Balancing Key Journal Key | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_LINESEQUENCENR` | `int32` | Deleted Balancing Array Credit Document Balancing Key Line Sequence Number | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_COMMENT` | `string` | Deleted Balancing Array Credit Document Comment | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_CREDITBOOKINGAMOUNT` | `double` | Deleted Balancing Array Credit Document Credit Booking Amount | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_CREDITDOCUMENTAMOUNT` | `double` | Deleted Balancing Array Credit Document Credit Document Amount | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_CURRENCYCODE` | `string` | Deleted Balancing Array Credit Document Currency Code | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_DEBETBOOKINGAMOUNT` | `double` | Deleted Balancing Array Credit Document Debit Booking Amount | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_DEBETDOCUMENTAMOUNT` | `double` | Deleted Balancing Array Credit Document Debet Document Amount | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_DOCUMENTDATE` | `datetime` | Deleted Balancing Array Credit Document Document Date | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_EXCHANGERATE` | `double` | Deleted Balancing Array Credit Document Exchange Rate | | | | `DELETEDBALANCINGARRAY_CREDITDOCUMENT_REFERENCE` | `string` | Deleted Balancing Array Credit Document Reference | | | | `DELETEDBALANCINGARRAY_DEBETBALANCEDBOOKINGAMOUNT` | `double` | Deleted Balancing Array Debit Balanced Booking Amount | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_BOOKYEARKEY` | `string` | Deleted Balancing Array Debit Document Balancing Key Financial Year Key | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_BOOKYEARKEY_ID` | `int32` | Deleted Balancing Array Debit Document Balancing Key Book Year Key ID | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_DOCUMENTSEQUENCENR` | `int32` | Deleted Balancing Array Debit Document Balancing Key Document Number | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_JOURNALKEY` | `string` | Deleted Balancing Array Debit Document Balancing Key Journal Key | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_LINESEQUENCENR` | `int32` | Deleted Balancing Array Debit Document Balancing Key Line Sequence Number | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_COMMENT` | `string` | Deleted Balancing Array Debit Document Comment | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_CREDITBOOKINGAMOUNT` | `double` | Deleted Balancing Array Debit Document Credit Booking Amount | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_CREDITDOCUMENTAMOUNT` | `double` | Deleted Balancing Array Debit Document Credit Document Amount | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_CURRENCYCODE` | `string` | Deleted Balancing Array Debit Document Currency Code | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_DEBETBOOKINGAMOUNT` | `double` | Deleted Balancing Array Debit Document Debit Booking Amount | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_DEBETDOCUMENTAMOUNT` | `double` | Deleted Balancing Array Debit Document Debet Document Amount | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_DOCUMENTDATE` | `datetime` | Deleted Balancing Array Debit Document Document Date | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_EXCHANGERATE` | `double` | Deleted Balancing Array Debit Document Exchange Rate | | | | `DELETEDBALANCINGARRAY_DEBETDOCUMENT_REFERENCE` | `string` | Deleted Balancing Array Debit Document Reference | | | | `DELETEDBALANCINGARRAY_TYPE_ACCOUNTNR` | `int32` | Deleted Balancing Array Type Account Number | | | | `DELETEDBALANCINGARRAY_TYPE_EXTERNALRELATIONID` | `int32` | Deleted Balancing Array Type External Relation ID | | | | `DELETEDBALANCINGARRAY_TYPE_RELATIONKEY` | `string` | Deleted Balancing Array Type Relation Key | | | | `DELETEDBALANCINGARRAY_TYPE_RELATIONKEY_ID` | `int32` | Deleted Balancing Array Type Relation Key ID | | | | `MODIFIEDBALANCINGARRAY_CREDITBALANCEDBOOKINGAMOUNT` | `double` | Modified Balancing Array Credit Balanced Booking Amount | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_BOOKYEARKEY` | `string` | Modified Balancing Array Credit Document Balancing Key Financial Year Key | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_BOOKYEARKEY_ID` | `int32` | Modified Balancing Array Credit Document Balancing Key Book Year Key ID | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_DOCUMENTSEQUENCENR` | `int32` | Modified Balancing Array Credit Document Balancing Key Document Number | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_JOURNALKEY` | `string` | Modified Balancing Array Credit Document Balancing Key Journal Key | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_LINESEQUENCENR` | `int32` | Modified Balancing Array Credit Document Balancing Key Line Sequence Number | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_COMMENT` | `string` | Modified Comment | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_CREDITBOOKINGAMOUNT` | `double` | Modified Credit Booking Amount | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_CREDITDOCUMENTAMOUNT` | `double` | Modified Credit Document Amount | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_CURRENCYCODE` | `string` | Modified Currency Code | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_DEBETBOOKINGAMOUNT` | `double` | Modified Debit Booking Amount | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_DEBETDOCUMENTAMOUNT` | `double` | Modified Debet Document Amount | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_DOCUMENTDATE` | `datetime` | Modified Document Date | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_EXCHANGERATE` | `double` | Modified Exchange Rate | | | | `MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_REFERENCE` | `string` | Modified Reference | | | | `MODIFIEDBALANCINGARRAY_DEBETBALANCEDBOOKINGAMOUNT` | `double` | Modified Balancing Array Debit Balanced Booking Amount | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_BOOKYEARKEY` | `string` | Modified Balancing Array Debit Document Balancing Key Financial Year Key | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_BOOKYEARKEY_ID` | `int32` | Modified Balancing Array Debit Document Balancing Key Book Year Key ID | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_DOCUMENTSEQUENCENR` | `int32` | Modified Balancing Array Debit Document Balancing Key Document Number | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_JOURNALKEY` | `string` | Modified Balancing Array Debit Document Balancing Key Journal Key | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_LINESEQUENCENR` | `int32` | Modified Balancing Array Debit Document Balancing Key Line Sequence Number | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_COMMENT` | `string` | Modified Balancing Array Debit Document Comment | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_CREDITBOOKINGAMOUNT` | `double` | Modified Balancing Array Debit Document Credit Booking Amount | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_CREDITDOCUMENTAMOUNT` | `double` | Modified Balancing Array Debit Document Credit Document Amount | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_CURRENCYCODE` | `string` | Modified Balancing Array Debit Document Currency Code | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_DEBETBOOKINGAMOUNT` | `double` | Modified Balancing Array Debit Document Debit Booking Amount | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_DEBETDOCUMENTAMOUNT` | `double` | Modified Balancing Array Debit Document Debet Document Amount | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_DOCUMENTDATE` | `datetime` | Modified Balancing Array Debit Document Document Date | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_EXCHANGERATE` | `double` | Modified Balancing Array Debit Document Exchange Rate | | | | `MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_REFERENCE` | `string` | Modified Balancing Array Debit Document Reference | | | | `MODIFIEDBALANCINGARRAY_TYPE_ACCOUNTNR` | `int32` | Modified Balancing Array Type Account Number | | | | `MODIFIEDBALANCINGARRAY_TYPE_EXTERNALRELATIONID` | `int32` | Modified Balancing Array Type External Relation ID | | | | `MODIFIEDBALANCINGARRAY_TYPE_RELATIONKEY` | `string` | Modified Balancing Array Type Relation Key | | | | `MODIFIEDBALANCINGARRAY_TYPE_RELATIONKEY_ID` | `int32` | Modified Balancing Array Type Relation Key ID | | | | `RETURN` | `int32` | Return | | |