ModifiedBalancingRelations |
Name: ModifiedBalancingRelations
Catalog: Octopus
Schema: OctopusWS
Parameters
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
COMPANY_CODE |
string |
☐ |
|
|
modifiedSince |
datetime |
☐ |
|
|
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
COMPANY_CODE |
string |
Partition Code |
☑ |
|
COMPANY_NAME |
string |
Partition Name |
☑ |
|
DELETEDBALANCINGARRAY_CREDITBALANCEDBOOKINGAMOUNT |
double |
itgen_octopus_deleted_balancing_array itgen_octopus_credit_balanced_booking_amount |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_BOOKYEARKEY |
string |
itgen_octopus_deleted_balancing_array_credit_document_balancing_key Financial Year Key |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_deleted_balancing_array_credit_document_balancing_key_bookyear_key ID |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_DOCUMENTSEQUENCENR |
int32 |
itgen_octopus_deleted_balancing_array_credit_document_balancing_key Document Number |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_JOURNALKEY |
string |
itgen_octopus_deleted_balancing_array_credit_document_balancing_key Journal Key |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_LINESEQUENCENR |
int32 |
itgen_octopus_deleted_balancing_array_credit_document_balancing_key Line Sequence Number |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_COMMENT |
string |
itgen_octopus_deleted_balancing_array_credit_document Comment |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_CREDITBOOKINGAMOUNT |
double |
itgen_octopus_deleted_balancing_array_credit_document Credit Booking Amount |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_CREDITDOCUMENTAMOUNT |
double |
itgen_octopus_deleted_balancing_array_credit_document Credit Document Amount |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_CURRENCYCODE |
string |
itgen_octopus_deleted_balancing_array_credit_document Currency Code |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_DEBETBOOKINGAMOUNT |
double |
itgen_octopus_deleted_balancing_array_credit_document Debit Booking Amount |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_DEBETDOCUMENTAMOUNT |
double |
itgen_octopus_deleted_balancing_array_credit_document Debet Document Amount |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_DOCUMENTDATE |
datetime |
itgen_octopus_deleted_balancing_array_credit_document Document Date |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_EXCHANGERATE |
double |
itgen_octopus_deleted_balancing_array_credit_document Exchange Rate |
|
|
DELETEDBALANCINGARRAY_CREDITDOCUMENT_REFERENCE |
string |
itgen_octopus_deleted_balancing_array_credit_document Reference |
|
|
DELETEDBALANCINGARRAY_DEBETBALANCEDBOOKINGAMOUNT |
double |
itgen_octopus_deleted_balancing_array itgen_octopus_debet_balanced_booking_amount |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_BOOKYEARKEY |
string |
itgen_octopus_deleted_balancing_array_debet_document_balancing_key Financial Year Key |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_deleted_balancing_array_debet_document_balancing_key_bookyear_key ID |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_DOCUMENTSEQUENCENR |
int32 |
itgen_octopus_deleted_balancing_array_debet_document_balancing_key Document Number |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_JOURNALKEY |
string |
itgen_octopus_deleted_balancing_array_debet_document_balancing_key Journal Key |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_LINESEQUENCENR |
int32 |
itgen_octopus_deleted_balancing_array_debet_document_balancing_key Line Sequence Number |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_COMMENT |
string |
itgen_octopus_deleted_balancing_array_debet_document Comment |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_CREDITBOOKINGAMOUNT |
double |
itgen_octopus_deleted_balancing_array_debet_document Credit Booking Amount |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_CREDITDOCUMENTAMOUNT |
double |
itgen_octopus_deleted_balancing_array_debet_document Credit Document Amount |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_CURRENCYCODE |
string |
itgen_octopus_deleted_balancing_array_debet_document Currency Code |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_DEBETBOOKINGAMOUNT |
double |
itgen_octopus_deleted_balancing_array_debet_document Debit Booking Amount |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_DEBETDOCUMENTAMOUNT |
double |
itgen_octopus_deleted_balancing_array_debet_document Debet Document Amount |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_DOCUMENTDATE |
datetime |
itgen_octopus_deleted_balancing_array_debet_document Document Date |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_EXCHANGERATE |
double |
itgen_octopus_deleted_balancing_array_debet_document Exchange Rate |
|
|
DELETEDBALANCINGARRAY_DEBETDOCUMENT_REFERENCE |
string |
itgen_octopus_deleted_balancing_array_debet_document Reference |
|
|
DELETEDBALANCINGARRAY_TYPE_ACCOUNTNR |
int32 |
itgen_octopus_deleted_balancing_array_type itgen_octopus_account_nr |
|
|
DELETEDBALANCINGARRAY_TYPE_EXTERNALRELATIONID |
int32 |
itgen_octopus_deleted_balancing_array_type External Relation ID |
|
|
DELETEDBALANCINGARRAY_TYPE_RELATIONKEY |
string |
itgen_octopus_deleted_balancing_array_type Relation Key |
|
|
DELETEDBALANCINGARRAY_TYPE_RELATIONKEY_ID |
int32 |
itgen_octopus_deleted_balancing_array_type_relation_key ID |
|
|
MODIFIEDBALANCINGARRAY_CREDITBALANCEDBOOKINGAMOUNT |
double |
itgen_octopus_modified_balancing_array itgen_octopus_credit_balanced_booking_amount |
|
|
MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_BOOKYEARKEY |
string |
itgen_octopus_modified_balancing_array_credit_document_balancing_key Financial Year Key |
|
|
MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_modified_balancing_array_credit_document_balancing_key_bookyear_key ID |
|
|
MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_DOCUMENTSEQUENCENR |
int32 |
itgen_octopus_modified_balancing_array_credit_document_balancing_key Document Number |
|
|
MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_JOURNALKEY |
string |
itgen_octopus_modified_balancing_array_credit_document_balancing_key Journal Key |
|
|
MODIFIEDBALANCINGARRAY_CREDITDOCUMENT_BALANCINGKEY_LINESEQUENCENR |
int32 |
itgen_octopus_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 |
itgen_octopus_modified_balancing_array itgen_octopus_debet_balanced_booking_amount |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_BOOKYEARKEY |
string |
itgen_octopus_modified_balancing_array_debet_document_balancing_key Financial Year Key |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_modified_balancing_array_debet_document_balancing_key_bookyear_key ID |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_DOCUMENTSEQUENCENR |
int32 |
itgen_octopus_modified_balancing_array_debet_document_balancing_key Document Number |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_JOURNALKEY |
string |
itgen_octopus_modified_balancing_array_debet_document_balancing_key Journal Key |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_BALANCINGKEY_LINESEQUENCENR |
int32 |
itgen_octopus_modified_balancing_array_debet_document_balancing_key Line Sequence Number |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_COMMENT |
string |
itgen_octopus_modified_balancing_array_debet_document Comment |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_CREDITBOOKINGAMOUNT |
double |
itgen_octopus_modified_balancing_array_debet_document Credit Booking Amount |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_CREDITDOCUMENTAMOUNT |
double |
itgen_octopus_modified_balancing_array_debet_document Credit Document Amount |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_CURRENCYCODE |
string |
itgen_octopus_modified_balancing_array_debet_document Currency Code |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_DEBETBOOKINGAMOUNT |
double |
itgen_octopus_modified_balancing_array_debet_document Debit Booking Amount |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_DEBETDOCUMENTAMOUNT |
double |
itgen_octopus_modified_balancing_array_debet_document Debet Document Amount |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_DOCUMENTDATE |
datetime |
itgen_octopus_modified_balancing_array_debet_document Document Date |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_EXCHANGERATE |
double |
itgen_octopus_modified_balancing_array_debet_document Exchange Rate |
|
|
MODIFIEDBALANCINGARRAY_DEBETDOCUMENT_REFERENCE |
string |
itgen_octopus_modified_balancing_array_debet_document Reference |
|
|
MODIFIEDBALANCINGARRAY_TYPE_ACCOUNTNR |
int32 |
itgen_octopus_modified_balancing_array_type itgen_octopus_account_nr |
|
|
MODIFIEDBALANCINGARRAY_TYPE_EXTERNALRELATIONID |
int32 |
itgen_octopus_modified_balancing_array_type External Relation ID |
|
|
MODIFIEDBALANCINGARRAY_TYPE_RELATIONKEY |
string |
itgen_octopus_modified_balancing_array_type Relation Key |
|
|
MODIFIEDBALANCINGARRAY_TYPE_RELATIONKEY_ID |
int32 |
itgen_octopus_modified_balancing_array_type_relation_key ID |
|
|
RETURN |
int32 |
Return |
|
|
26-03-2019 22:2817.31.54-BETA+1985