invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

ADM_PRF3: AccountView Administration settings table 3

read only per partition

  • Catálogo: AccountView
  • Label: Administration settings table 3

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla ADM_PRF3. 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
ACCR_BAL char Allow accruals and deferrals on balance sheet accounts
ACCT_PA_AL varchar2(10) Private settlements clearing account
ACCT_POPO varchar2(10) Orders to be received account
ACCT_TBA varchar2(10) Costs to be authorised
AD_BAT_NR int32 Advisor import batch number
AI_ALLOWPR char Invoices via print service AutoInvoice possible
AI_API varchar2(36) API key (admin) AutoInvoice
AI_DJP varchar2(3) System journal purchase invoices AutoInvoice
AI_DJPD varchar2(3) System journal purchase invoices AutoInvoice, no workflow
APUB_FNAM varchar2(20) First name contact person annual accounts publication
APUB_LNAM varchar2(40) Last name contact person annual accounts publication
APUB_MAIL varchar2(60) Email contact person annual accounts publication
AUTO_AG char Schedule automatically
AUTO_PICK char Report back automatically when printing delivery note
AUTO_RECV char Receive automatically when processing purchase invoices
BLK_LEDGER char General ledger accounts add/modify/delete not allowed
CHK_EFSCOD varchar2(10) Taxonomy code
CLINK_ACCT varchar2(10) Default account new suppliers
CRED_ID varchar2(35) Creditor ID
DAILY_DESC char Descriptions based on journal settings
DCALC_STCK datetime Last sales calculation per week
DEPR_REG int32 Depreciation regime
DESC_LDG char Modifying general ledger account description allowed
DIS_SEVER2 char Disable Severa Plus link
DIS_SEVER3 char Disable Severa Complete link
DISC_CRED varchar2(2) Payment term new suppliers
DISC_DEB varchar2(2) Payment term new customers
DJ_EXT_SI varchar2(3) Sales invoices Invoicing
DJ_EXTGOC varchar2(3) Write-offs of open items
DJ_EXTGOP varchar2(3) Purchase invoices
DJ_EXTGOS varchar2(3) Sales invoices Basic
DJ_EXTPUW varchar2(3) Payments in transit
DJ_NMBRS varchar2(3) Payroll journal
DJ_WF varchar2(3) Journal (purchase)
DJIM_NOVAT char Skip VAT when importing journal messages
DJIM_VAT varchar2(2) VAT code for journal import
DJIMAP_REF char Take journal message headers from reference administration
DLINK_ACCT varchar2(10) Default account new customers
DPH_CHECK char Period/date check for projects and hours
EBNK_SEPA char Use SEPA guidelines for direct bank link
EIA varchar2(30) Electronic Invoice Address
EV_DJP varchar2(3) Purchase invoices journal (eVerbinding)
EV_DJS varchar2(3) Sales invoices journal (eVerbinding)
EXT_SV_P_P varchar2(250) Additional status 'Partially paid' (Severa)
EXT_SV_PAD varchar2(250) Additional payment statuses (Severa)
EXT_SV_REV varchar2(250) Additional retrieval statuses (Severa)
FAH_AUTO_N char Number fixed assets automatically
GLSTPY_CNG int32 Change number for comparative annual figures
HRS_CNG varchar2(17) Last modified time hours registration
IN2_EXT char Extended stock management
INCL_OBLI char Costs and revenues including commitments
ISAH_ADMIN varchar2(20) Isah administration
ISAH_PSWD varchar2(20) Isah password
ISAH_USR varchar2(20) Isah user name
KPI_EFS varchar2(10) Taxonomy project scorecard controller
LEAD_WAGE varchar2(10) Heading code payroll total
LNG_CRED varchar2(5) Language code new suppliers
LNG_DEB varchar2(5) Language code new customers
MAIL_UBL char Also create UBL format for electronic invoicing
NMBRS_LVL int32 Nmbrs import level
OBLI_STAT int32 Commitment from status
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PAY_DAY int32 Fixed day
PAY_MOMENT int32 Payment day
PRN_PICK char Print packing list when generating issue order
PROF_CODE varchar2(10) Email profile
PST_ORD char Post orders to be received
REC_ID varchar2(10) Primary key
REGCH_ACCT varchar2(10) Account number system change
RELV_CNG varchar2(17) Relevance changed
RISK_ORG int32 Organisation risk
SCAN_ACCC varchar2(10) Credit card payments account
SCAN_ACPP varchar2(10) Debit card payments account
SCAN_DJC varchar2(3) System journal cash purchases/sales
SCAN_DJCC varchar2(3) System journal credit card payments
SCAN_DJP varchar2(3) System journal purchase invoices
SCAN_DJPC varchar2(3) System journal debit card payments
SCAN_DJS varchar2(3) System journal sales invoices
SDEL_CON char Synchronise deleted relations
SETUP_CNG varchar2(17) Last modified time master data
SHIP_CA char Deliver composite items complete
STAT_MAT varchar2(5) Status tangible
STAT_NAPPL varchar2(5) Status n/a
STAT_NMAT varchar2(5) Status intangible
SV_API varchar2(32) API key (Severa)
SV_BUNIT varchar2(32) Department (Severa)
SV_C_EMP varchar2(10) Employee code (Severa)
SV_C_OW varchar2(10) Hour type code own work (Severa)
SV_C_TMT varchar2(10) Hour type code (Severa)
SV_C_TMTH varchar2(10) Hour type code hours (Severa)
SV_C_TRV varchar2(10) Hour type code travel expenses (Severa)
SV_PAID varchar2(20) Invoice status Paid (Severa)
SV_PART_P varchar2(20) Invoice status 'Partially paid' (Severa)
SV_REV varchar2(20) Invoice status Retrieve (Severa)
SV_SPL_EMP char Split hours by employee (Severa)
SV_SPL_TMH char Split hours by hour type (Severa)
SV_SPL_TRV char Split travel expenses by hour type (Severa)
UBL_TYPE int32 UBL variant for electronic invoicing
WF_DIRECT char Post directly to cost accounts
WF_EMP varchar2(10) Invoice distributor
WF_STGY varchar2(25) Workflow for organisation
WKR_PERC decimal Work-related costs scheme percentage
WKST_RNG int32 Weeks sales history
YEAR_WAGE int64 Estimated payroll total