BuySellBookingsAll |
Name: BuySellBookingsAll
Catalog: Octopus
Schema: Views
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
bkg_AMOUNT |
double |
Amount |
|
|
bkg_BOOKINGLINES_ACCOUNTKEY |
int32 |
General Ledger Account Key |
|
|
bkg_BOOKINGLINES_BASEAMOUNT |
double |
Base Amount |
|
|
bkg_BOOKINGLINES_COMMENT |
string |
Comment |
|
|
bkg_BOOKINGLINES_COSTCENTREKEY |
string |
Cost Center Key |
|
|
bkg_BOOKINGLINES_COSTCENTREKEY_ID |
int32 |
Cost Center Key ID |
|
|
bkg_BOOKINGLINES_VATAMOUNT |
double |
VAT Amount |
|
|
bkg_BOOKINGLINES_VATCODEKEY |
string |
VAT Code Key |
|
|
bkg_BOOKINGLINES_VATRECUPPERCENTAGE |
double |
itgen_octopus_vat_recup_percentage |
|
|
bkg_BOOKYEARKEY |
string |
Financial Year Key |
|
|
bkg_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
bkg_BOOKYEARPERIODENR |
int32 |
Period Number |
|
|
bkg_COMMENT |
string |
Comment |
|
|
bkg_COMPANY_CODE |
string |
Partition Code |
☑ |
|
bkg_COMPANY_NAME |
string |
Partition Name |
☑ |
|
bkg_CURRENCYCODE |
string |
Currency Code |
|
|
bkg_DOCUMENTDATE |
datetime |
Document Date |
|
|
bkg_DOCUMENTSEQUENCENR |
int32 |
Document Number |
|
|
bkg_EXCHANGERATE |
double |
Exchange Rate |
|
|
bkg_EXPIRYDATE |
datetime |
Expiry Date |
|
|
bkg_EXTERNALRELATIONID |
int32 |
External Relation ID |
|
|
bkg_JOURNALKEY |
string |
Journal Key |
|
|
bkg_REFERENCE |
string |
Reference |
|
|
bkg_RELATIONKEY |
string |
Relation Key |
|
|
bkg_RELATIONKEY_ID |
int32 |
Relation Key ID |
|
|
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