BuySellBookingLines: Buy/Sell Transaction Lines |
Name: BuySellBookingLines
Catalog: Octopus
Schema: OctopusWS
Label: Buy/Sell Transaction Lines
Parameters
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
bookyearKey_id |
int32 |
☐ |
|
|
COMPANY_CODE |
string |
☐ |
|
|
documentSequenceNr |
int32 |
☐ |
|
|
journalKey |
string |
☐ |
|
|
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ACCOUNTKEY |
int32 |
General Ledger Account Key |
|
|
BASEAMOUNT |
double |
Base Amount |
|
|
COMMENT |
string |
Comment |
|
|
COMPANY_CODE |
string |
Partition Code |
☑ |
|
COMPANY_NAME |
string |
Partition Name |
☑ |
|
COSTCENTREKEY |
string |
Cost Center Key |
|
|
COSTCENTREKEY_ID |
int32 |
Cost Center Key ID |
|
|
RETURN_AMOUNT |
double |
Amount |
|
|
RETURN_BOOKYEARKEY |
string |
Financial Year Key |
|
|
RETURN_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
RETURN_BOOKYEARPERIODENR |
int32 |
Period Number |
|
|
RETURN_COMMENT |
string |
Comment |
|
|
RETURN_CURRENCYCODE |
string |
Currency Code |
|
|
RETURN_DOCUMENTDATE |
datetime |
Document Date |
|
|
RETURN_DOCUMENTSEQUENCENR |
int32 |
Document Number |
|
|
RETURN_EXCHANGERATE |
double |
Exchange Rate |
|
|
RETURN_EXPIRYDATE |
datetime |
Expiry Date |
|
|
RETURN_EXTERNALRELATIONID |
int32 |
External Relation ID |
|
|
RETURN_JOURNALKEY |
string |
Journal Key |
|
|
RETURN_REFERENCE |
string |
Reference |
|
|
RETURN_RELATIONKEY |
string |
Relation Key |
|
|
RETURN_RELATIONKEY_ID |
int32 |
Relation Key ID |
|
|
VATAMOUNT |
double |
VAT Amount |
|
|
VATCODEKEY |
string |
VAT Code Key |
|
|
VATRECUPPERCENTAGE |
double |
itgen_octopus_vat_recup_percentage |
|
|
26-03-2019 22:2817.31.54-BETA+1985