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

ADM_PRF: AccountView Administration settings

read only per partition

  • Catálogo: AccountView
  • Label: Administration settings

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla ADM_PRF. 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_BAMT varchar2(10) Bank charges account
ACCT_CDIF varchar2(10) Exchange rate differences account
ACCT_CSAP varchar2(10) Prepayments account
ACCT_CSAR varchar2(10) Prepayments account
ACCT_DIF varchar2(10) Other differences account
ACCT_DSAP varchar2(10) Supplier payment discount account
ACCT_DSAR varchar2(10) Customer payment discount account
ACCT_DSMS varchar2(10) Discounts account (sales)
ACCT_EDIF varchar2(10) Euro conversion differences account
ACCT_INT varchar2(10) Interest/costs account
ACCT_NAME varchar2(40) Administration company name
ACCT_PDIF varchar2(10) Payment differences account
ACCT_POPI varchar2(10) Invoices to be received account
ACCT_PROF varchar2(10) Previous financial year result
ACCT_RNDB varchar2(10) Balance sheet rounding differences account
ACCT_RNDI varchar2(10) Profit and loss rounding differences account
ACCT_TRCR varchar2(10) Accruals and deferrals credit
ACCT_TRDT varchar2(10) Accruals and deferrals debit
ACCT_TRIR varchar2(10) Report rounding
ACPY_CR varchar2(10) Previous financial year items credit
ACPY_DT varchar2(10) Previous financial year items debit
ADD_ORGLD char Add original heading
ADM_ACC decimal Status
ADM_EXT char External administration
ADM_MODEL varchar2(10) Central administration
AGE_TERM1 decimal Ageing analysis term 1
AGE_TERM2 decimal Ageing analysis term 2
AGE_TERM3 decimal Ageing analysis term 3
APX_DEC decimal Number of decimals prices
ART_DEC decimal Number of decimals quantities
ART_PMSC varchar2(15) Miscellaneous purchase item code
ART_POORD varchar2(15) Purchase order costs item code
ART_POSH varchar2(15) Purchase transport costs item code
ART_SMSC varchar2(15) Miscellaneous sales item code
ART_SOORD varchar2(15) Sales order costs item code
ART_SOSH varchar2(15) Sales transport costs item code
AUTO_CODE char Use auto-coding
AUTO_INV char Post invoice and payment simultaneously
BANK_COST varchar2(10) Bank charges account
BANK_PROC varchar2(10) Interest account
BCK_CINV char Include copy documents in backup
BEG_DATE datetime Financial year start date
CAP_PPS decimal Nominal value of share
CAP_TOT decimal Authorised capital
CAP_USED decimal Paid-up capital
CHK_INI int32 Stock check stock movements
CHK_SOI int32 Stock check sales orders
CINV_PATH varchar2(150) Copy documents folder name
CLT_CPER varchar2(3) Blocked for client use up to period
CN_TYPE decimal Last consolidation performed
CNG_CNT char Country cannot be changed
CNG_DATE datetime Date last modified
CNG_NR int32 Change number
CNT_CUR varchar2(3) Country currency code
COGS_COR char Post cost price corrections
COLL_POB char Collect draft purchase orders
COMP_ACTV varchar2(4) Business activity
COMP_ATTN varchar2(40) Attention of
COMP_DEAR varchar2(40) Salutation
COMP_DIRC varchar2(40) Director
CON_DEBNK char Show Bankleitzahl for relations
COPY_INV char Create copy documents
CPA_NAME varchar2(40) Prepared by
CPA_SIGN varchar2(40) Signature
CTAX_CY decimal Corporate income tax current year
CTAX_PY decimal Corporate income tax previous year
CUR_CODE varchar2(3) Administration currency code
CUR_DEC decimal Number of decimals amounts
CUR_PNT varchar2(1) Decimal separator
CUR_SEP varchar2(1) Thousands separator
DATE_ACT char Create activity when delivery date changes
DATE_LAY varchar2(250) Delivery date email layout
DATE_MAIL char Send email to customer when delivery date changes
DATE_NOT char Send email to salesperson when delivery date changes
DATE_SUB varchar2(10) Activity sub-area delivery date change
DATE_TYP varchar2(10) Activity main area delivery date change
DATE_TYPE decimal Date type
DEL_ACT char Create activity when sales order is delivered
DEL_LAY varchar2(250) Receipts email layout
DEL_MAIL char Send email when sales order is delivered
DEL_NOT char Send email when sales order can be delivered
DEL_POL char Delete fully received order lines
DEL_SOL char Delete delivered order lines
DEL_SUB varchar2(10) Activity sub-area shipment
DEL_TYP varchar2(10) Activity main area shipment
DISC_DEC decimal Number of decimals discount percentage
DJ_CASH varchar2(3) System journal counter invoices
DJ_CORR varchar2(3) System journal corrections
DJ_DJI varchar2(3) System journal journal messages
DJ_DJIUBLP varchar2(3) System journal UBL invoices (purchase)
DJ_DJIUBLS varchar2(3) System journal UBL invoices (sales)
DJ_EDIC_P varchar2(3) System journal EDI-Circle (purchase)
DJ_EDIC_S varchar2(3) System journal EDI-Circle (sales)
DJ_II varchar2(3) System journal stock movements
DJ_MFG varchar2(3) System journal production orders
DJ_OI varchar2(3) System journal settle open items
DJ_PI varchar2(3) System journal purchase invoices
DJ_PPS varchar2(3) System journal receipts
DJ_REVA varchar2(3) System journal stock revaluation
DJ_SI varchar2(3) System journal sales invoices
DOC_PATH varchar2(150) Documents folder name
DP_CHECK char Period/date check
DSP_THOU char Show thousands separator
EMP_CY decimal Number of employees current year
EMP_PY decimal Number of employees previous year
END_DATE datetime Financial year end date
EXP_CINV char Include copy documents when carrying over administration
EXP_DATE datetime Last export
EXPL_CALC decimal Price calculation
EXPL_INV char Suppress explosion on invoice
EXPL_PSLP char Suppress explosion on delivery note
EXPL_QT char Suppress explosion on quotation
EXPL_RESN float Reservation
EXPL_SOLB char Suppress explosion on shipping label
EXPL_SOOC char Suppress explosion on order confirmation
EXPL_SOSL char Suppress explosion on consignment note
EXT_COAPP char Available in AccountView Contact
FSL_COST varchar2(10) Cost centre code reports
FSL_CUR varchar2(3) Currency code reports
FSL_FUPD char Update reports quickly
FSL_PER1 decimal Period figures first column
FSL_PER2 decimal Period figures second column
FSL_RND decimal Round reports
GEN_POO char Create final purchase orders
HOME_CNT varchar2(2) ISO country code automatic foreign payment
HOME_ICUR varchar2(3) ISO currency automatic foreign payment
ICNT_CODE varchar2(2) IS country code
ID_ALL char Import as fully approved
ID_APP char Add to page
ID_DIF char Write off differences
ID_DJC varchar2(3) Journal code transaction import
ID_FILE varchar2(40) File name transaction import
ID_TYPE float File type transaction import
IMP_DATE datetime Last import
IMP_DJP decimal Handling of existing journal pages during import
IMP_SET decimal Overwrite existing master data during import
INP_DATE datetime Entry date
INPL_BLK char Select from free lists only
INV_VAL decimal Stock valuation method
INVDED_CY decimal Investment deduction current year
INVDED_PY decimal Investment deduction previous year
IS_DCCNT varchar2(2) IS country code customer/supplier
IS_DOMPO char IS customs clearance permit purchase
IS_DOMSO char IS customs clearance permit sales
IS_POMIN decimal IS declaration threshold purchase
IS_SOMIN decimal IS declaration threshold sales
ISHP_CODE varchar2(1) IS mode of transport
ISXF_PO varchar2(3) IS statistical factor code purchase
ISXF_SO varchar2(3) IS statistical factor code sales
ISYS_CODE varchar2(2) IS regime
ITYP_CODE varchar2(1) IS transaction code
LAST_CPER varchar2(3) Last blocked period
LAST_DEP decimal Last depreciated period
LAST_FPER varchar2(3) Period completed up to and including
LAST_PER decimal Last closed period
LDCOST_CY decimal Partially deductible costs current year
LDCOST_PY decimal Partially deductible costs previous year
LNG_CODE varchar2(5) Language code
LOC_CODE varchar2(5) Default warehouse location
MRK_CRED char Mark credit notes
NCBEX_LIM decimal Exemption limit
NCBREG_NR varchar2(8) DNB registration number
NCBSEC_NR varchar2(4) Industry
NCBTRD_NR varchar2(4) Dealer number
NO_DJACHK char No access control per journal
ORD_ACT char Create activity when sales order is accepted
ORD_MAIL char Send email when sales order is accepted
ORD_SUB varchar2(10) Activity sub-area order confirmation
ORD_TYP varchar2(10) Activity main area order confirmation
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PAY_COST varchar2(25) Payment method bank charges
PAY_PROC varchar2(25) Payment method interest
PD_GROSS char Calculate payment discount on gross
PD_PFX varchar2(15) Payment reference
PD_VCAP varchar2(2) VAT code credit limit supplier
PD_VCAR varchar2(2) VAT code credit limit customer
PER_YEAR decimal Number of periods per year
PJ1_QTACC decimal Status after quotation accepted
PJ1_QTDEF decimal Status after final quotation
PJ1_QTREJ decimal Status after quotation rejected
PO_CNFAPR char Order confirmation approval required
PO_CNFCHK char Order confirmation check required
PO_CNFREC char Receipt of order confirmation required
PO_COMM1 varchar2(40) Default purchase order description
PO_GROSS char Purchase orders gross by default
PO_INVAPR char Purchase invoice approval required
PO_INVCHK char Purchase invoice check required
PO_INVREC char Receipt of purchase invoice required
PO_ORDAPR char Purchase order approval required
POL_SOL char Update backorders automatically
POST_PUW char Post automatic payment to creditors control account
POST_RUW char Post direct debit to debtors control account
PST_RECD char Post invoices to be received
QD_CHK char Check scale pricing
REC_ID varchar2(10) Unique code
REM_METH decimal Dunning method
REM_RNG1 decimal Dunning term 1 due period
REM_RNG2 decimal Dunning term 2 due period
REM_RNG3 decimal Dunning term 3 due period
RPT_DATE datetime Report date
RT_DJP char Direct processing journals
RT_PODS char Direct processing purchase payment discount
RT_POP char Direct processing purchase invoices
RT_SODS char Direct processing sales payment discount
RT_SOP char Direct processing sales invoices
SET_POB char Confirm creation of draft purchase orders
SHOW_DDESC char Show dimension description
SHOW_OI60 char Do not update open items display immediately during journal entry
SO_CNFREC char Order confirmation return
SO_CNFSND char Order confirmation printing required
SO_COMM1 varchar2(40) Default sales order description
SO_GROSS char Sales orders/invoices gross by default
SO_NULREC char Reset periodic orders to zero
SO_ORDAPR char Sales order approval required
SO_PACAPR char Delivery approval required
SO_PACCHK char Delivery note completion required
SO_PACPRN char Delivery note printing required
SO_SUPNUL char Suppress zero lines on delivery note
SOC_AMT int64 Max difference amount
SOC_DIF varchar2(10) Differences account
SOC_OPEN char Sales on account
SOC_SUB varchar2(10) Counter invoice customer
SUP_COST char Skip cost centre code
SUP_CUR char Skip foreign currency
SUP_SUB char Skip customer/supplier
SUP_VAT char Skip VAT code
SX_STGY varchar2(25) Intrastat declaration
TPL_PATH varchar2(150) Templates folder name
TRF_ACCT varchar2(10) Transfer clearing account
VAT_DEC decimal Number of decimals VAT return
VAT_IC_NR varchar2(14) VAT number EC sales list
VAT_NR varchar2(14) Fiscal VAT number
VAT_TERM decimal VAT number verification period
VERSION varchar2(4) Administration version number
VERSIONV varchar2(5) Administration version number (function)
WHS_CODE varchar2(5) Default warehouse code