DeliveryNotesAll |
Name: DeliveryNotesAll
Catalog: Octopus
Schema: Views
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
byr_BOOKYEARDESCRIPTION |
string |
Financial Year Description |
|
|
byr_BOOKYEARKEY |
string |
Financial Year Key |
|
|
byr_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
byr_CLOSED |
boolean |
Closed |
|
|
byr_COMPANY_CODE |
string |
Partition Code |
☑ |
|
byr_COMPANY_NAME |
string |
Partition Name |
☑ |
|
byr_ENDDATE |
datetime |
End Date |
|
|
byr_PERIODS_BOOKYEARPERIOD |
int32 |
Period |
|
|
byr_PERIODS_ENDDATE |
datetime |
End Date |
|
|
byr_PERIODS_STARTDATE |
datetime |
Start Date |
|
|
byr_STARTDATE |
datetime |
Start Date |
|
|
dne_BOOKYEARKEY |
string |
Financial Year Key |
|
|
dne_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
dne_BOOKYEARPERIODENR |
int32 |
Period Number |
|
|
dne_COMMENT |
string |
Comment |
|
|
dne_COMPANY_CODE |
string |
Partition Code |
☑ |
|
dne_COMPANY_NAME |
string |
Partition Name |
☑ |
|
dne_CURRENCYCODE |
string |
Currency Code |
|
|
dne_DELIVERYNOTELINES_BOOKINGACCOUNTNR |
int32 |
Delivery Note Lines Account Number |
|
|
dne_DELIVERYNOTELINES_COSTCENTREKEY |
string |
Delivery Note Lines Cost Center Key |
|
|
dne_DELIVERYNOTELINES_COSTCENTREKEY_ID |
int32 |
Delivery Note Lines Cost Center Key ID |
|
|
dne_DELIVERYNOTELINES_COUNT |
double |
Delivery Note Lines Count |
|
|
dne_DELIVERYNOTELINES_DESCRIPTION |
string |
Delivery Note Lines Description |
|
|
dne_DELIVERYNOTELINES_DISCOUNTPERCENTAGE |
double |
Delivery Note Lines Discount Percentage |
|
|
dne_DELIVERYNOTELINES_EXTERNPRODUCTNR |
string |
Delivery Note Lines External Product Number |
|
|
dne_DELIVERYNOTELINES_UNIT |
string |
Delivery Note Lines Unit |
|
|
dne_DELIVERYNOTELINES_UNITPRICE |
double |
Delivery Note Lines Unit Price |
|
|
dne_DELIVERYNOTELINES_VATCODEKEY |
string |
Delivery Note Lines VAT Code Key |
|
|
dne_DOCUMENTDATE |
datetime |
Document Date |
|
|
dne_DOCUMENTSEQUENCENR |
int32 |
Document Number |
|
|
dne_EXCHANGERATE |
double |
Exchange Rate |
|
|
dne_EXPIRYDATE |
datetime |
Expiry Date |
|
|
dne_EXTERNALRELATIONID |
int32 |
External Relation ID |
|
|
dne_FINANCIALDISCOUNT |
double |
Financial Discount |
|
|
dne_JOURNALKEY |
string |
Journal Key |
|
|
dne_REFERENCE |
string |
Reference |
|
|
jnl_BOOKYEARKEY |
string |
Financial Year Key |
|
|
jnl_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
jnl_CLOSED |
boolean |
Closed |
|
|
jnl_CLOSEDPERIOD |
int32 |
Closed Period |
|
|
jnl_COMPANY_CODE |
string |
Partition Code |
☑ |
|
jnl_COMPANY_NAME |
string |
Partition Name |
☑ |
|
jnl_CURRENCYCODE |
string |
Currency Code |
|
|
jnl_INSERTIONTYPE |
int32 |
Insertion Type |
|
|
jnl_JOURNALKEY |
string |
Journal Key |
|
|
jnl_LASTBOOKEDDOCUMENTNR |
int32 |
Last Book Document Number |
|
|
jnl_NAME |
string |
Name |
|
|
jnl_PROTECTEDPERIOD |
int32 |
Protected Period |
|
|
26-03-2019 22:2817.31.54-BETA+1985