LEDGER: AccountView General ledger
read only per partition
- Catalog:
AccountView - Label: General ledger
Can only retrieve data.
Table Columns
The columns of the table LEDGER are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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 |
VAT Code | |||
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 |