invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_ALLOC varchar2(10) Clear balance to
ACCT_BAL int64 Account balance
ACCT_COST varchar2(10) Cost price account
ACCT_LINK decimal Control account type
ACCT_NAME varchar2(40) Account description
ACCT_NR varchar2(10) Account number
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 Date modified
CNG_NR int32 Change number
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 Credit amount
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) Allocation key
DOSS_DESC varchar2(4) Note
DOSS_REF varchar2(10) File reference
DR_AMT int64 Debit amount
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 Entry date
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) Cost type code
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) Subledger 1
SL_CODE2 varchar2(10) Subledger 2
SL_CODE3 varchar2(10) Subledger 3
SPLIT_PA char Split per partner
STAT_ORIG varchar2(5) Original account status
STAT_SELL char Revenue account
SUM_RPT char Summarise on general ledger card report
TRANS_NR int32 Number of transactions
VAT_CODE varchar2(2) Codice IVA
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