GLAccountClassificationsLevel9: Exact Online General Ledger Account Classifications (Level 9)
insert update per partition XML
- Catalogo:
ExactOnlineXML - Schema:
XML - Label: General Ledger Account Classifications (Level 9)
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile recuperare e modificare i dati utilizzando insert e update.
Riepilogo
Additional where-clause columns supported:
- division
- glschemeid
- glschemecode (1 )
- glclassificationtree (0 )
- glclassificationcode
- oldstyle
Codice sorgente dell'API
- Servizio XML:
GLAccountClassifications - Argomento XML:
GLAccountClassifications - Percorso XML:
/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification/GLClassification
Colonne della tabella
Di seguito sono riportate le colonne della tabella GLAccountClassificationsLevel9. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CALCULATIONTYPE_ |
varchar2 |
Tipo di calcolo | / |
||
CODE_ |
varchar2 |
Code | / |
||
DESCRIPTION |
varchar2 |
Description | / |
||
DESCRIPTION_ |
number |
Descrizione ID termine | / |
||
DIVISION_ |
varchar2 |
ID amministrativo | Numero univoco interno dell'amministrazione di Exact Online. | ||
DIVISION_ |
int64 |
Administration | Number of the Exact Online administration.Not guaranteed to be unique. | ||
DIVISION_ |
varchar2 |
Nome dell'amministrazione | 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 |
URL dell'interfaccia | URL utilizzato per collegare questa riga a Exact Online. | ||
ROWNUM |
int64 |
Numero di riga | Numero della riga all'interno dei risultati, a partire da 1. | ||
TRANSLATIONS_ |
varchar2 |
Translations Term ID | / |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: