DeliveryNoteLines: Delivery Note Lines |
Name: DeliveryNoteLines
Catalog: Octopus
Schema: OctopusWS
Label: Delivery Note 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 |
---|---|---|---|---|
BOOKINGACCOUNTNR |
int32 |
Account Number |
|
|
COMPANY_CODE |
string |
Partition Code |
☑ |
|
COMPANY_NAME |
string |
Partition Name |
☑ |
|
COSTCENTREKEY |
string |
Cost Center Key |
|
|
COSTCENTREKEY_ID |
int32 |
Cost Center Key ID |
|
|
COUNT |
double |
Count |
|
|
DESCRIPTION |
string |
Description |
|
|
DISCOUNTPERCENTAGE |
double |
Discount Percentage |
|
|
EXTERNPRODUCTNR |
string |
External Product Number |
|
|
RETURN_BOOKYEARKEY |
string |
Delivery Note Financial Year Key |
|
|
RETURN_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
RETURN_BOOKYEARPERIODENR |
int32 |
Delivery Note Period Number |
|
|
RETURN_COMMENT |
string |
Delivery Note Comment |
|
|
RETURN_CURRENCYCODE |
string |
Delivery Note Currency Code |
|
|
RETURN_DOCUMENTDATE |
datetime |
Delivery Note Document Date |
|
|
RETURN_DOCUMENTSEQUENCENR |
int32 |
Delivery Note Document Number |
|
|
RETURN_EXCHANGERATE |
double |
Delivery Note Exchange Rate |
|
|
RETURN_EXPIRYDATE |
datetime |
Delivery Note Expiry Date |
|
|
RETURN_EXTERNALRELATIONID |
int32 |
Delivery Note External Relation ID |
|
|
RETURN_FINANCIALDISCOUNT |
double |
Delivery Note Financial Discount |
|
|
RETURN_JOURNALKEY |
string |
Delivery Note Journal Key |
|
|
RETURN_REFERENCE |
string |
Delivery Note Reference |
|
|
UNIT |
string |
Unit |
|
|
UNITPRICE |
double |
Unit Price |
|
|
VATCODEKEY |
string |
VAT Code Key |
|
|
26-03-2019 22:2817.31.54-BETA+1985