InvoicesAll |
Name: InvoicesAll
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 |
|
|
ive_BOOKYEARKEY |
string |
Financial Year Key |
|
|
ive_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
ive_BOOKYEARPERIODENR |
int32 |
Period Number |
|
|
ive_COMMENT |
string |
Comment |
|
|
ive_COMPANY_CODE |
string |
Partition Code |
☑ |
|
ive_COMPANY_NAME |
string |
Partition Name |
☑ |
|
ive_CURRENCYCODE |
string |
Currency Code |
|
|
ive_DOCUMENTDATE |
datetime |
Document Date |
|
|
ive_DOCUMENTSEQUENCENR |
int32 |
Document Number |
|
|
ive_EXCHANGERATE |
double |
Exchange Rate |
|
|
ive_EXPIRYDATE |
datetime |
Expiry Date |
|
|
ive_EXTERNALRELATIONID |
int32 |
External Relation ID |
|
|
ive_FINANCIALDISCOUNT |
double |
Financial Discount |
|
|
ive_INVOICELINES_BOOKINGACCOUNTNR |
int32 |
Invoice Lines Account Number |
|
|
ive_INVOICELINES_COSTCENTREKEY |
string |
Invoice Lines Cost Center Key |
|
|
ive_INVOICELINES_COSTCENTREKEY_ID |
int32 |
itgen_octopus_invoice_lines_cost_centre_key ID |
|
|
ive_INVOICELINES_COUNT |
double |
Invoice Lines Count |
|
|
ive_INVOICELINES_DESCRIPTION |
string |
Invoice Lines Description |
|
|
ive_INVOICELINES_DISCOUNTPERCENTAGE |
double |
Invoice Lines Discount Percentage |
|
|
ive_INVOICELINES_EXTERNPRODUCTNR |
string |
Invoice Lines External Product Number |
|
|
ive_INVOICELINES_UNIT |
string |
Invoice Lines Unit |
|
|
ive_INVOICELINES_UNITPRICE |
double |
Invoice Lines Unit Price |
|
|
ive_INVOICELINES_VATCODEKEY |
string |
Invoice Lines VAT Code Key |
|
|
ive_JOURNALKEY |
string |
Journal Key |
|
|
ive_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