BuySellBookingLinesAll |
Name: BuySellBookingLinesAll
Catalog: Octopus
Schema: Views
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
bke_ACCOUNTKEY |
int32 |
General Ledger Account Key |
|
|
bke_BASEAMOUNT |
double |
Base Amount |
|
|
bke_COMMENT |
string |
Comment |
|
|
bke_COMPANY_CODE |
string |
Partition Code |
☑ |
|
bke_COMPANY_NAME |
string |
Partition Name |
☑ |
|
bke_COSTCENTREKEY |
string |
Cost Center Key |
|
|
bke_COSTCENTREKEY_ID |
int32 |
Cost Center Key ID |
|
|
bke_RETURN_AMOUNT |
double |
Amount |
|
|
bke_RETURN_BOOKYEARKEY |
string |
Financial Year Key |
|
|
bke_RETURN_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
bke_RETURN_BOOKYEARPERIODENR |
int32 |
Period Number |
|
|
bke_RETURN_COMMENT |
string |
Comment |
|
|
bke_RETURN_CURRENCYCODE |
string |
Currency Code |
|
|
bke_RETURN_DOCUMENTDATE |
datetime |
Document Date |
|
|
bke_RETURN_DOCUMENTSEQUENCENR |
int32 |
Document Number |
|
|
bke_RETURN_EXCHANGERATE |
double |
Exchange Rate |
|
|
bke_RETURN_EXPIRYDATE |
datetime |
Expiry Date |
|
|
bke_RETURN_EXTERNALRELATIONID |
int32 |
External Relation ID |
|
|
bke_RETURN_JOURNALKEY |
string |
Journal Key |
|
|
bke_RETURN_REFERENCE |
string |
Reference |
|
|
bke_RETURN_RELATIONKEY |
string |
Relation Key |
|
|
bke_RETURN_RELATIONKEY_ID |
int32 |
Relation Key ID |
|
|
bke_VATAMOUNT |
double |
VAT Amount |
|
|
bke_VATCODEKEY |
string |
VAT Code Key |
|
|
bke_VATRECUPPERCENTAGE |
double |
itgen_octopus_vat_recup_percentage |
|
|
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 |
|
|
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