InvoiceLinesAll |
Name: InvoiceLinesAll
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 |
|
|
ile_BOOKINGACCOUNTNR |
int32 |
Account Number |
|
|
ile_COMPANY_CODE |
string |
Partition Code |
☑ |
|
ile_COMPANY_NAME |
string |
Partition Name |
☑ |
|
ile_COSTCENTREKEY |
string |
Cost Center Key |
|
|
ile_COSTCENTREKEY_ID |
int32 |
Cost Center Key ID |
|
|
ile_COUNT |
double |
Count |
|
|
ile_DESCRIPTION |
string |
Description |
|
|
ile_DISCOUNTPERCENTAGE |
double |
Discount Percentage |
|
|
ile_EXTERNPRODUCTNR |
string |
External Product Number |
|
|
ile_RETURN_BOOKYEARKEY |
string |
Financial Year Key |
|
|
ile_RETURN_BOOKYEARKEY_ID |
int32 |
Financial Year ID |
|
|
ile_RETURN_BOOKYEARPERIODENR |
int32 |
Period Number |
|
|
ile_RETURN_COMMENT |
string |
Comment |
|
|
ile_RETURN_CURRENCYCODE |
string |
Currency Code |
|
|
ile_RETURN_DOCUMENTDATE |
datetime |
Document Date |
|
|
ile_RETURN_DOCUMENTSEQUENCENR |
int32 |
Document Number |
|
|
ile_RETURN_EXCHANGERATE |
double |
Exchange Rate |
|
|
ile_RETURN_EXPIRYDATE |
datetime |
Expiry Date |
|
|
ile_RETURN_EXTERNALRELATIONID |
int32 |
External Relation ID |
|
|
ile_RETURN_FINANCIALDISCOUNT |
double |
Financial Discount |
|
|
ile_RETURN_JOURNALKEY |
string |
Journal Key |
|
|
ile_RETURN_REFERENCE |
string |
Reference |
|
|
ile_UNIT |
string |
Unit |
|
|
ile_UNITPRICE |
double |
Unit Price |
|
|
ile_VATCODEKEY |
string |
VAT Code Key |
|
|
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