ModifiedBuySellBookings |
Name: ModifiedBuySellBookings
Catalog: Octopus
Schema: OctopusWS
Parameters
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
bookyearKey_id |
int32 |
☐ |
|
|
COMPANY_CODE |
string |
☐ |
|
|
journalKey |
string |
☐ |
|
|
modifiedSince |
datetime |
☐ |
|
|
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
COMPANY_CODE |
string |
Partition Code |
☑ |
|
COMPANY_NAME |
string |
Partition Name |
☑ |
|
MODIFIEDBUYSELLBOOKINGARRAY_AMOUNT |
double |
Amount |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_ACCOUNTKEY |
int32 |
itgen_octopus_modified_buy_sell_booking_array_booking_lines General Ledger Account Key |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_BASEAMOUNT |
double |
itgen_octopus_modified_buy_sell_booking_array_booking_lines Base Amount |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_COMMENT |
string |
itgen_octopus_modified_buy_sell_booking_array_booking_lines Comment |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_COSTCENTREKEY |
string |
itgen_octopus_modified_buy_sell_booking_array_booking_lines Cost Center Key |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_COSTCENTREKEY_ID |
int32 |
ID |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_VATAMOUNT |
double |
itgen_octopus_modified_buy_sell_booking_array_booking_lines VAT Amount |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_VATCODEKEY |
string |
itgen_octopus_modified_buy_sell_booking_array_booking_lines VAT Code Key |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKINGLINES_VATRECUPPERCENTAGE |
double |
itgen_octopus_modified_buy_sell_booking_array_booking_lines itgen_octopus_vat_recup_percentage |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKYEARKEY |
string |
Financial Year Key |
|
|
MODIFIEDBUYSELLBOOKINGARRAY_BOOKYEARKEY_ID |
int32 |
itgen_octopus_modified_buy_sell_booking_array_bookyear_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 |
itgen_octopus_modified_buy_sell_booking_array_relation_key ID |
|
|
RETURN |
int32 |
Return |
|
|
26-03-2019 22:2817.31.54-BETA+1985