LEDGER: AccountView General ledger
read only per partition
- Catálogo:
AccountView - Label: General ledger
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla LEDGER. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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 |
Código VAT | |||
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 |