GLAccountClassificationsLevel9: Exact Online General Ledger Account Classifications (Level 9)
insert update per partition XML
- Katalog:
ExactOnlineXML - Schema:
XML - Label: General Ledger Account Classifications (Level 9)
Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.
Mit insert und update können Daten abgerufen und geändert werden.
Zusammenfassung
Additional where-clause columns supported:
- division
- glschemeid
- glschemecode (1 )
- glclassificationtree (0 )
- glclassificationcode
- oldstyle
API-Quelle
- XML-Dienst:
GLAccountClassifications - XML-Thema:
GLAccountClassifications - XML-Pfad:
/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification
Tabellenspalten
Die Spalten der Tabelle GLAccountClassificationsLevel9 sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CALCULATIONTYPE_ |
varchar2 |
Berechnungsart | / |
||
CODE_ |
varchar2 |
Code | / |
||
DESCRIPTION |
varchar2 |
Description | / |
||
DESCRIPTION_ |
number |
Beschreibung Begriffs-ID | / |
||
DIVISION_ |
varchar2 |
Verwaltung ID | Interne einzigartige Nummer der Exact Online-Verwaltung. | ||
DIVISION_ |
int64 |
Administration | Number of the Exact Online administration.Not guaranteed to be unique. | ||
DIVISION_ |
varchar2 |
Verwaltung Name | Name of the Exact Online administration.Not guaranteed to be unique. | ||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification Calculation Type | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification Code | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification Description | / |
||
GLCLASSIFICATION_ |
number |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_description Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification Calculation Type | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification Code | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification Description | / |
||
GLCLASSIFICATION_ |
number |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_description Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification Calculation Type | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification Code | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification Description | / |
||
GLCLASSIFICATION_ |
number |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_description Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification Calculation Type | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification Code | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification Description | / |
||
GLCLASSIFICATION_ |
number |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_description Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification Calculation Type | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification Code | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification Description | / |
||
GLCLASSIFICATION_ |
number |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_description Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification Calculation Type | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification Code | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification Description | / |
||
GLCLASSIFICATION_ |
number |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_description Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification Calculation Type | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification Code | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification Description | / |
||
GLCLASSIFICATION_ |
number |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_description Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification Calculation Type | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification Code | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification Description | / |
||
GLCLASSIFICATION_ |
number |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_description Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme Code | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme Description | / |
||
GLCLASSIFICATION_ |
number |
itgen_eol_glaccount_classifications_glaccount_scheme_description Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme Main | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_translations Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme Type | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_translations Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_translations Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_translations Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_translations Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_translations Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_translations Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_translations Term ID | / |
||
GLCLASSIFICATION_ |
varchar2 |
itgen_eol_glaccount_classifications_glaccount_scheme_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_glclassification_translations Term ID | / |
||
INTERFACE_ |
varchar2 |
Schnittstelle URL | URL, die zum Verbinden dieser Reihe mit Exact Online verwendet wird. | ||
ROWNUM |
int64 |
Zeilennummer | Nummer der Reihe innerhalb der Ergebnisse, startend bei 1. | ||
TRANSLATIONS_ |
varchar2 |
Translations Term ID | / |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: