invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

LEDGER: AccountView General ledger

read only per partition

  • Catalogus: AccountView
  • Label: General ledger

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel LEDGER worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
ACCT_ALLOC varchar2(10) Clear balance to
ACCT_BAL int64 Account balance
ACCT_COST varchar2(10) Cost price account
ACCT_LINK decimal Type controleaccount
ACCT_NAME varchar2(40) Account description
ACCT_NR varchar2(10) Rekeningnummer
ACCT_PROJ char Project account
ACCT_TYPE decimal Account type
ACT_PY int64 Balance prior year
BAL_BAL int64 Balance sheet
BAL_PL int64 P&L
CLT_BLK char Blocked for client
CNG_DATE datetime Datum van wijziging
CNG_NR int32 Nummer wijzigen
CNG_USR varchar2(20) Employee last modified
CO_ACCT char Clearing account
CON_ACCT varchar2(10) Statutory consolidation account
CON_ACCT2 varchar2(10) Internal consolidation account
COR_BAL int64 Balance of prior-year items
COR_CAMT int64 Adjustments credit amount
COR_DAMT int64 Adjustments debit amount
COST_CODE varchar2(10) Cost centre code
COST_MAND char Cost centre code required
CR_AMT int64 Kredietbedrag
CR_AMTMIN int64 Negative credit amount
CUR_CAMT int64 Currency amount credit
CUR_CODE varchar2(3) Currency code
CUR_DAMT int64 Currency amount debit
DIST_CODE varchar2(10) Toewijzingssleutel
DOSS_DESC varchar2(4) Note
DOSS_REF varchar2(10) File reference
DR_AMT int64 Afschrijvingsbedrag
EFS_CHK varchar2(25) Element of taxonomy to be checked
EFS_LEDG varchar2(25) Element of accounting taxonomy
FA_ACCT char Asset account
FA_SELL char Asset sales account
INP_DATE datetime Datum van inschrijving
INP_USR varchar2(20) Entered by employee
JRNL_QTY char Number of journal lines to check
LDG_STAT varchar2(5) Account status
NORM_STAT decimal Normal balance
NOT_DASH char Exclude from dashboard charts
PART_MAND decimal Partner required
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PC_CODE varchar2(5) Kostensoortcode
PRE_COR int64 For prior-year items
PRE_CORC int64 For prior-year items credit
PRE_CORD int64 For prior-year items debit
PRO_ATTR varchar2(4) Linked project dimensions
PROJ_EXP char Billable project costs/revenues
PROJ_OBLI char Project commitments
QTY_MAND decimal Quantity required
REC_BLK char Blocked
REC_SYS char System record
REV_ACCT char Revalue currency
RUBRIEKEN varchar2(40) Categories
SL_CODE1 varchar2(10) Hulpboek 1
SL_CODE2 varchar2(10) Hulpboek 2
SL_CODE3 varchar2(10) Hulpboek 3
SPLIT_PA char Split per partner
STAT_ORIG varchar2(5) Original account status
STAT_SELL char Opbrengstenrekening
SUM_RPT char Summarise on general ledger card report
TRANS_NR int32 Number of transactions
VAT_CODE varchar2(2) BTW-code
VAT_MAND char VAT code required
WF_ALLOW char Account suitable for use in IFA
WGT_MAND decimal Weight required
WKR_TRN char Transaction charged to free allowance WKR
XBRL_SPEC char XBRL specification