AccountsAll |
Name: AccountsAll
Catalog: Octopus
Schema: Views
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
act_ACCOUNTKEY |
string |
General Ledger Account Key |
|
|
act_ACCOUNTKEY_BOOKYEARKEY |
string |
General Ledger Account Key Financial Year Key |
|
|
act_ACCOUNTKEY_BOOKYEARKEY_ID |
int32 |
Financial Year Key ID |
|
|
act_ACCOUNTKEY_ID |
int32 |
General Ledger Account Key ID |
|
|
act_COMPANY_CODE |
string |
Partition Code |
☑ |
|
act_COMPANY_NAME |
string |
Partition Name |
☑ |
|
act_COSTCENTRETYPE |
int32 |
Cost Center Type |
|
|
act_DEFAULTCOSTCENTREKEY |
string |
Default Cost Centre Key |
|
|
act_DEFAULTCOSTCENTREKEY_ID |
int32 |
Default Cost Centre Key ID |
|
|
act_DESCRIPTION_DESCRIPTION_FR |
string |
Description Description (FR) |
|
|
act_DESCRIPTION_DESCRIPTION_NL |
string |
Description Description (NL) |
|
|
act_FISCPROFESSIONALPERCENTAGE |
double |
itgen_octopus_fisc_professional_percentage |
|
|
act_FISCRECUPPERCENTAGE |
double |
itgen_octopus_fisc_recup_percentage |
|
|
act_PURCHASEVATCODE |
string |
Purchase VAT Code |
|
|
act_SALESVATCODE |
string |
Sales VAT Code |
|
|
act_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 |
|
|
26-03-2019 22:2817.31.54-BETA+1985