ModifiedRelations |
Name: ModifiedRelations
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 |
☑ |
|
DELETEDRELATIONS_ACTIVE |
boolean |
itgen_octopus_deleted_relations Active |
|
|
DELETEDRELATIONS_BANKACCOUNTNR |
string |
itgen_octopus_deleted_relations Bank Account Number |
|
|
DELETEDRELATIONS_BICCODE |
string |
itgen_octopus_deleted_relations BIC Code |
|
|
DELETEDRELATIONS_CITY |
string |
itgen_octopus_deleted_relations City |
|
|
DELETEDRELATIONS_CLIENT |
boolean |
itgen_octopus_deleted_relations Client |
|
|
DELETEDRELATIONS_CONTACTPERSON |
string |
itgen_octopus_deleted_relations Contact Person |
|
|
DELETEDRELATIONS_CORPORATIONTYPE |
int32 |
itgen_octopus_deleted_relations Corporation Type |
|
|
DELETEDRELATIONS_COUNTRY |
string |
itgen_octopus_deleted_relations Country |
|
|
DELETEDRELATIONS_DEFAULTBOOKINGACCOUNTCLIENT |
int32 |
itgen_octopus_deleted_relations Default Booking Account Client |
|
|
DELETEDRELATIONS_DEFAULTBOOKINGACCOUNTSUPPLIER |
int32 |
itgen_octopus_deleted_relations Default Booking Account Supplier |
|
|
DELETEDRELATIONS_EMAIL |
string |
itgen_octopus_deleted_relations Email |
|
|
DELETEDRELATIONS_EXPIRATIONDAYS |
int32 |
itgen_octopus_deleted_relations Expiration Days |
|
|
DELETEDRELATIONS_EXPIRATIONTYPE |
int32 |
itgen_octopus_deleted_relations Expiration Type |
|
|
DELETEDRELATIONS_EXTERNALRELATIONNR |
int32 |
itgen_octopus_deleted_relations External Relation Number |
|
|
DELETEDRELATIONS_FACTLANGUAGE |
int32 |
itgen_octopus_deleted_relations Invoice Language |
|
|
DELETEDRELATIONS_FAX |
string |
itgen_octopus_deleted_relations Fax |
|
|
DELETEDRELATIONS_FIRSTNAME |
string |
itgen_octopus_deleted_relations First Name |
|
|
DELETEDRELATIONS_IBANACCOUNTNR |
string |
itgen_octopus_deleted_relations IBAN Account Number |
|
|
DELETEDRELATIONS_MOBILE |
string |
itgen_octopus_deleted_relations Mobile |
|
|
DELETEDRELATIONS_NAME |
string |
itgen_octopus_deleted_relations Name |
|
|
DELETEDRELATIONS_POSTALCODE |
string |
itgen_octopus_deleted_relations Postal Code |
|
|
DELETEDRELATIONS_RELATIONKEY |
string |
itgen_octopus_deleted_relations Relation Key |
|
|
DELETEDRELATIONS_RELATIONKEY_ID |
int32 |
itgen_octopus_deleted_relations_relation_key ID |
|
|
DELETEDRELATIONS_REMARKS |
string |
itgen_octopus_deleted_relations Remarks |
|
|
DELETEDRELATIONS_SEARCHFIELD1 |
string |
itgen_octopus_deleted_relations Search Field 1 |
|
|
DELETEDRELATIONS_SEARCHFIELD2 |
string |
itgen_octopus_deleted_relations Search Field 2 |
|
|
DELETEDRELATIONS_STREETANDNR |
string |
itgen_octopus_deleted_relations Street and House Number |
|
|
DELETEDRELATIONS_SUPPLIER |
boolean |
itgen_octopus_deleted_relations Supplier |
|
|
DELETEDRELATIONS_TELEPHONE |
string |
itgen_octopus_deleted_relations Telephone |
|
|
DELETEDRELATIONS_URL |
string |
itgen_octopus_deleted_relations URL |
|
|
DELETEDRELATIONS_VATNR |
string |
itgen_octopus_deleted_relations VAT Number |
|
|
DELETEDRELATIONS_VATTYPE |
int32 |
itgen_octopus_deleted_relations VAT Type |
|
|
MODIFIEDRELATIONS_ACTIVE |
boolean |
Active |
|
|
MODIFIEDRELATIONS_BANKACCOUNTNR |
string |
Bank Account Number |
|
|
MODIFIEDRELATIONS_BICCODE |
string |
BIC Code |
|
|
MODIFIEDRELATIONS_CITY |
string |
City |
|
|
MODIFIEDRELATIONS_CLIENT |
boolean |
Client |
|
|
MODIFIEDRELATIONS_CONTACTPERSON |
string |
Contact Person |
|
|
MODIFIEDRELATIONS_CORPORATIONTYPE |
int32 |
Corporation Type |
|
|
MODIFIEDRELATIONS_COUNTRY |
string |
Country |
|
|
MODIFIEDRELATIONS_DEFAULTBOOKINGACCOUNTCLIENT |
int32 |
Default Booking Account Client |
|
|
MODIFIEDRELATIONS_DEFAULTBOOKINGACCOUNTSUPPLIER |
int32 |
Default Booking Account Supplier |
|
|
MODIFIEDRELATIONS_EMAIL |
string |
|
|
|
MODIFIEDRELATIONS_EXPIRATIONDAYS |
int32 |
Expiration Days |
|
|
MODIFIEDRELATIONS_EXPIRATIONTYPE |
int32 |
Expiration Type |
|
|
MODIFIEDRELATIONS_EXTERNALRELATIONNR |
int32 |
External Relation Number |
|
|
MODIFIEDRELATIONS_FACTLANGUAGE |
int32 |
Invoice Language |
|
|
MODIFIEDRELATIONS_FAX |
string |
Fax |
|
|
MODIFIEDRELATIONS_FIRSTNAME |
string |
First Name |
|
|
MODIFIEDRELATIONS_IBANACCOUNTNR |
string |
IBAN Account Number |
|
|
MODIFIEDRELATIONS_MOBILE |
string |
Mobile |
|
|
MODIFIEDRELATIONS_NAME |
string |
Name |
|
|
MODIFIEDRELATIONS_POSTALCODE |
string |
Postal Code |
|
|
MODIFIEDRELATIONS_RELATIONKEY |
string |
Relation Key |
|
|
MODIFIEDRELATIONS_RELATIONKEY_ID |
int32 |
itgen_octopus_modified_relations_relation_key ID |
|
|
MODIFIEDRELATIONS_REMARKS |
string |
Remarks |
|
|
MODIFIEDRELATIONS_SEARCHFIELD1 |
string |
Search Field 1 |
|
|
MODIFIEDRELATIONS_SEARCHFIELD2 |
string |
Search Field 2 |
|
|
MODIFIEDRELATIONS_STREETANDNR |
string |
Street and House Number |
|
|
MODIFIEDRELATIONS_SUPPLIER |
boolean |
Supplier |
|
|
MODIFIEDRELATIONS_TELEPHONE |
string |
Telephone |
|
|
MODIFIEDRELATIONS_URL |
string |
URL |
|
|
MODIFIEDRELATIONS_VATNR |
string |
VAT Number |
|
|
MODIFIEDRELATIONS_VATTYPE |
int32 |
VAT Type |
|
|
RETURN |
int32 |
Return |
|
|
26-03-2019 22:2817.31.54-BETA+1985