LEDGER: AccountView General ledger
read only per partition
- Catalogo:
AccountView - Label: General ledger
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella LEDGER. 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 |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Clear balance to | |||
ACCT_ |
int64 |
Account balance | |||
ACCT_ |
varchar2 |
Cost price account | |||
ACCT_ |
decimal |
Control account type | |||
ACCT_ |
varchar2 |
Account description | |||
ACCT_ |
varchar2 |
Account number | |||
ACCT_ |
char |
Project account | |||
ACCT_ |
decimal |
Account type | |||
ACT_PY |
int64 |
Balance prior year | |||
BAL_ |
int64 |
Balance sheet | |||
BAL_PL |
int64 |
P&L | |||
CLT_ |
char |
Blocked for client | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
CO_ |
char |
Clearing account | |||
CON_ |
varchar2 |
Statutory consolidation account | |||
CON_ |
varchar2 |
Internal consolidation account | |||
COR_ |
int64 |
Balance of prior-year items | |||
COR_ |
int64 |
Adjustments credit amount | |||
COR_ |
int64 |
Adjustments debit amount | |||
COST_ |
varchar2 |
Cost centre code | |||
COST_ |
char |
Cost centre code required | |||
CR_AMT |
int64 |
Credit amount | |||
CR_ |
int64 |
Negative credit amount | |||
CUR_ |
int64 |
Currency amount credit | |||
CUR_ |
varchar2 |
Currency code | |||
CUR_ |
int64 |
Currency amount debit | |||
DIST_ |
varchar2 |
Allocation key | |||
DOSS_ |
varchar2 |
Note | |||
DOSS_ |
varchar2 |
File reference | |||
DR_AMT |
int64 |
Debit amount | |||
EFS_ |
varchar2 |
Element of taxonomy to be checked | |||
EFS_ |
varchar2 |
Element of accounting taxonomy | |||
FA_ |
char |
Asset account | |||
FA_ |
char |
Asset sales account | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
JRNL_ |
char |
Number of journal lines to check | |||
LDG_ |
varchar2 |
Account status | |||
NORM_ |
decimal |
Normal balance | |||
NOT_ |
char |
Exclude from dashboard charts | |||
PART_ |
decimal |
Partner required | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PC_ |
varchar2 |
Cost type code | |||
PRE_ |
int64 |
For prior-year items | |||
PRE_ |
int64 |
For prior-year items credit | |||
PRE_ |
int64 |
For prior-year items debit | |||
PRO_ |
varchar2 |
Linked project dimensions | |||
PROJ_ |
char |
Billable project costs/revenues | |||
PROJ_ |
char |
Project commitments | |||
QTY_ |
decimal |
Quantity required | |||
REC_ |
char |
Blocked | |||
REC_ |
char |
System record | |||
REV_ |
char |
Revalue currency | |||
RUBRIEKEN |
varchar2 |
Categories | |||
SL_ |
varchar2 |
Subledger 1 | |||
SL_ |
varchar2 |
Subledger 2 | |||
SL_ |
varchar2 |
Subledger 3 | |||
SPLIT_ |
char |
Split per partner | |||
STAT_ |
varchar2 |
Original account status | |||
STAT_ |
char |
Revenue account | |||
SUM_ |
char |
Summarise on general ledger card report | |||
TRANS_ |
int32 |
Number of transactions | |||
VAT_ |
varchar2 |
Codice IVA | |||
VAT_ |
char |
VAT code required | |||
WF_ |
char |
Account suitable for use in IFA | |||
WGT_ |
decimal |
Weight required | |||
WKR_ |
char |
Transaction charged to free allowance WKR | |||
XBRL_ |
char |
XBRL specification |