ReportModifiedBooking |
Name: ReportModifiedBooking
Catalog: Octopus
Schema: OctopusWS
Parameters
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
bookyearKey_id |
int32 |
☐ |
|
|
COMPANY_CODE |
string |
☐ |
|
|
journalTypeId |
int32 |
☐ |
|
|
modifiedSince |
datetime |
☐ |
|
|
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
COMPANY_CODE |
string |
Partition Code |
☑ |
|
COMPANY_NAME |
string |
Partition Name |
☑ |
|
DELETEDBOOKINGLIST_BOOKYEARKEY |
string |
Deleted Financial Year Key |
|
|
DELETEDBOOKINGLIST_BOOKYEARKEY_ID |
int32 |
itgen_octopus_deleted_booking_list_bookyear_key ID |
|
|
DELETEDBOOKINGLIST_DOCUMENTSEQUENCENR |
int32 |
Deleted Document Number |
|
|
DELETEDBOOKINGLIST_JOURNALSEQUENCENR |
int32 |
Deleted Journal Sequence Number |
|
|
DELETEDBOOKINGLIST_JOURNALTYPE |
int32 |
Deleted Journal Type |
|
|
MODIFIEDBOOKINGLIST_ACCOUNTKEY |
int32 |
General Ledger Account Key |
|
|
MODIFIEDBOOKINGLIST_BOOKINGAMOUNT |
double |
Booking Amount |
|
|
MODIFIEDBOOKINGLIST_BOOKYEARKEY |
string |
Financial Year Key |
|
|
MODIFIEDBOOKINGLIST_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
MODIFIEDBOOKINGLIST_BOOKYEARPERIODENR |
int32 |
Period Number |
|
|
MODIFIEDBOOKINGLIST_COMMENT |
string |
Comment |
|
|
MODIFIEDBOOKINGLIST_COSTCENTREKEY |
string |
Cost Center Key |
|
|
MODIFIEDBOOKINGLIST_COSTCENTREKEY_ID |
int32 |
itgen_octopus_modified_booking_list_cost_centre_key ID |
|
|
MODIFIEDBOOKINGLIST_CURRENCYCODE |
string |
Currency Code |
|
|
MODIFIEDBOOKINGLIST_DOCUMENTAMOUNT |
double |
Document Amount |
|
|
MODIFIEDBOOKINGLIST_DOCUMENTDATE |
datetime |
Document Date |
|
|
MODIFIEDBOOKINGLIST_DOCUMENTSEQUENCENR |
int32 |
Document Number |
|
|
MODIFIEDBOOKINGLIST_EXCHANGERATE |
double |
Exchange Rate |
|
|
MODIFIEDBOOKINGLIST_EXPIRYDATE |
datetime |
Expiry Date |
|
|
MODIFIEDBOOKINGLIST_JOURNALNR |
int32 |
Journal Number |
|
|
MODIFIEDBOOKINGLIST_JOURNALTYPE |
int32 |
Journal Type |
|
|
MODIFIEDBOOKINGLIST_LINESEQUENCENR |
int32 |
Line Sequence Number |
|
|
MODIFIEDBOOKINGLIST_REFERENCE |
string |
Reference |
|
|
MODIFIEDBOOKINGLIST_RELATIONKEY |
string |
Relation Key |
|
|
MODIFIEDBOOKINGLIST_RELATIONKEY_ID |
int32 |
itgen_octopus_modified_booking_list_relation_key ID |
|
|
MODIFIEDBOOKINGLIST_VATRECUPERATIONPERCENTAGE |
double |
itgen_octopus_vat_recuperation_percentage |
|
|
MODIFIEDBOOKINGLIST_VATSECTIONCODE |
string |
VAT Section Code |
|
|
RETURN |
int32 |
Return |
|
|
26-03-2019 22:2817.31.54-BETA+1985