InsertBuySellBooking |
Name: InsertBuySellBooking
Catalog: Octopus
Schema: OctopusWS
Parameters
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
booking_amount |
double |
☐ |
|
|
booking_bookingLines_accountKey |
int32 |
☐ |
|
|
booking_bookingLines_baseAmount |
double |
☐ |
|
|
booking_bookingLines_comment |
string |
☐ |
|
|
booking_bookingLines_costCentreKey |
string |
☐ |
|
|
booking_bookingLines_costCentreKey_id |
int32 |
☐ |
|
|
booking_bookingLines_vatAmount |
double |
☐ |
|
|
booking_bookingLines_vatCodeKey |
string |
☐ |
|
|
booking_bookingLines_vatRecupPercentage |
double |
☐ |
|
|
booking_bookyearKey |
string |
☐ |
|
|
booking_bookyearKey_id |
int32 |
☐ |
|
|
booking_bookyearPeriodeNr |
int32 |
☐ |
|
|
booking_comment |
string |
☐ |
|
|
booking_currencyCode |
string |
☐ |
|
|
booking_documentDate |
datetime |
☐ |
|
|
booking_documentSequenceNr |
int32 |
☐ |
|
|
booking_exchangeRate |
double |
☐ |
|
|
booking_expiryDate |
datetime |
☐ |
|
|
booking_externalRelationId |
int32 |
☐ |
|
|
booking_journalKey |
string |
☐ |
|
|
booking_reference |
string |
☐ |
|
|
booking_relationKey |
string |
☐ |
|
|
booking_relationKey_id |
int32 |
☐ |
|
|
COMPANY_CODE |
string |
☐ |
|
|
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
COMPANY_CODE |
string |
Partition Code |
☑ |
|
COMPANY_NAME |
string |
Partition Name |
☑ |
|
RETURN |
int32 |
Return |
|
|
26-03-2019 22:2817.31.54-BETA+1985