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

ADM_PRF2: AccountView Administration settings table 2

read only per partition

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

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla ADM_PRF2. 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_CRED varchar2(10) Suppliers control account
ACCT_DEB varchar2(10) Customers control account
ADDRESS1 varchar2(80) Address
ADM_COMPL varchar2(10) Reference administration
ADM_EMAIL varchar2(50) Company email address
ADM_FAX varchar2(25) Company fax number
ADM_PHONE varchar2(25) Company telephone number
ADM_URL varchar2(60) Company website
ADV_REBOOK char Advice: repost administration
AG_DEBLEN int32 Length of customer number in giro payment reference
AG_INVLEN int32 Length of invoice number in giro payment reference
AG_USEDEB char Use customer number in payment reference
AP1_PREFIX varchar2(2) Supplier number prefix
AR1_PREFIX varchar2(2) Customer number prefix
ATP_DEMO datetime Date stock over time
AUDIT_ON char Activate audit trail
AUTH_EMP varchar2(10) Approving employee
AUTO_NUM char Number customers/suppliers automatically
BIV_PROF varchar2(10) Capital goods adjustment declaration profile
BLK_DAILY char Adding journals not allowed
BLK_HOURS char Show blocked hours
BLK_VAT char Adding VAT codes not allowed
BUD_PERSRT int32 Budget per week/month
CC_BBTP decimal Default year-end transition value cost centres
CC_STAT decimal Default status value cost centres
CCNG_DATE datetime Última modificación
CENDR_ART1 varchar2(15) Item code 500 units for Cendris
CENDR_ART2 varchar2(15) Item code 1000 units for Cendris
CENDR_ART3 varchar2(15) Item code 2500 units for Cendris
CENDR_CRED int32 Number of units to assign to Cendris users
CHK_CLTCNG int32 Record client changes
CIMP_FMT decimal Client import/export exchange format
CITY varchar2(35) City
CLT_LEMP varchar2(10) Relation type client representative
CLT_MSG varchar2(4) Notification text for message
CLTA_MAIN varchar2(10) Activity main area client request
CLTA_SUB varchar2(10) Activity sub-area client request
CLTO_MAIN varchar2(10) Activity main area client
CLTO_SUB varchar2(10) Activity sub-area client
CNT_CODE varchar2(2) ISO country code
COLL_ADV char Collect advance note settlements
COMP_ID varchar2(10) Business unit ID
COUNTRY varchar2(30) Country
CPA_ACCT varchar2(80) Office name
CPA_ADDR1 varchar2(80) Office address
CPA_CAPPR char Client must approve return
CPA_CITY varchar2(35) Office city
CPA_CNT varchar2(2) Office ISO country code
CPA_CTRY varchar2(30) Office country
CPA_PHONE varchar2(25) Office telephone number
CPA_POBOX varchar2(80) Office postal address
CPA_POCITY varchar2(35) Office postal address city
CPA_POCODE varchar2(10) Office postal address postcode
CPA_POST varchar2(10) Office postcode
CPA_STEXT varchar2(10) Office address addition
CPA_STNR varchar2(10) Office house number
CPA_STREG varchar2(40) Office address region
CPA_STRT varchar2(60) Office street name
DEL_WDAY char Deliver on working days only
DETAX_OFF varchar2(4) Tax office
DETAX_STAT varchar2(4) State
DFLT_PAR varchar2(10) Default partner
DIM_DEF varchar2(4) Dimension definition
DISP_INV char Block automatic payments
DJ_EXT_SP varchar2(3) System journal purchase/sales invoices
DOC_FONT varchar2(40) Document font
DOS_LDP decimal Last depreciated period
DSP_COL int32 Print column total
DSP_COL_H int32 Print column table header
DYN_HSTAL char Update item history multiple years dynamically
DYN_HSTTL char Update hours history multiple years dynamically
EDIC_CLT varchar2(25) Client relation code
EDIC_VADIF varchar2(10) VAT differences account (EDI-Circle)
EXP_AUTH char Approve claim proposals
EXP_CHGACT int32 Cancel/postpone remaining amount to be invoiced after change
EXP_CHGLN int32 Make change
EXP_DIFDIV int32 Distribution of line amount
EXP_IMP datetime Export date last import
EXP_PRNSO char Print final invoice when generating invoice
FDIM_DEF varchar2(4) Financial (Dimensions)
FNT_ALGN_C int32 Align text
FNT_ALGN_Y int32 Align amounts
FNT_BOLD_C char Total text bold
FNT_BOLD_Y char Total amounts bold
FNT_UNDR_Y int32 Underline total
GRAY_ACTM varchar2(10) Graydon activity main area
GRAY_ACTS varchar2(10) Graydon activity sub-area
GRAY_CPLIM char Adopt credit limit automatically at customer
GRAY_CRACT char Create Graydon activity
GRAY_DAYS int32 Graydon retrieval interval
GRP_EMP char Condensed posting
HD1_FONT varchar2(40) Heading 1 font
HD2_FONT varchar2(40) Heading 2 font
HD3_FONT varchar2(40) Heading 3 font
HOUR_PX decimal Post hourly rate
ICL_RANGE int32 EC sales list reporting period
ID_COLOR int32 Administration background colour
IN_PAGEAPR char Stock page approval required
INCL_ADD char Add mandatory items automatically
INO_STGY decimal Entry method stocktaking order
INO_TR_COD varchar2(10) Transaction code
INT_ASS varchar2(20) Name of umbrella organisation of tax service providers
INT_BECON varchar2(17) BECON number
INT_CNAME varchar2(35) Intermediary contact person
INT_NAME varchar2(35) Name of electronic filing office
INT_USE char Returns are handled by intermediary
KVK_NR varchar2(10) Número de la Cámara de Comercio
MSG_BONUS char Report bonus items
MSG_CROSS char Report cross-selling items
MSG_EXCL char Report exclusion items
MSG_INCL char Report mandatory items
MSG_REPLA char Report alternative items
MSG_UP char Report up-selling items
NUM_LEN int32 Customer/supplier number length
OWN_HOURS varchar2(1) Hours display
OWN_INV varchar2(1) Claim proposal display
OWN_OI varchar2(1) Invoice display
OWN_PROJ varchar2(1) Project display
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PICK_STGY varchar2(25) Warehouse picking strategy
PJ_ALL char Also show cost centres in projects overview
PJ_COMM1 varchar2(40) Draft invoices description
PJ_HIER1 varchar2(10) Project hierarchy 1
PJ_HIER2 varchar2(10) Project hierarchy 2
PJ_HIER3 varchar2(10) Project hierarchy 3
PJ_INVAD varchar2(15) Invoice item advances
PJ_INVDESC varchar2(40) Invoice description
PJ_INVFA varchar2(15) Invoice item fixed amounts
PJ_MIN int64 Minimum invoice amount projects
PJ1_BBTP decimal Default year-end transition value projects
PJ1_BUDTP decimal Default budgeting method value projects
PJ1_STAT decimal Default status value projects
PJB_DEC decimal Number of decimals project monitoring
PMT_ARTS varchar2(2) Item number for transit
PMT_CHQ char Payment by cheque
PMT_CRECV char All bank charges for account of beneficiary
PMT_CSEND char Charges of other banks for account of principal
PMT_DESC varchar2(80) Description for DNB
PMT_FAST char Urgent foreign payment
PMT_GOODS varchar2(2) Goods code
PMT_ORD1 varchar2(2) Payment instruction code 1
PMT_ORD2 varchar2(2) Payment instruction code 2
PMT_ORD3 varchar2(2) Payment instruction code 3
PMT_ORD4 varchar2(2) Payment instruction code 4
PMT_TYPE varchar2(2) Foreign exchange reporting
PO_BOX varchar2(80) Postal address
PO_CITY varchar2(35) Postal address city
PO_CODE varchar2(10) Postal address postcode
PO_COMM2 varchar2(40) Default receipt description
PO_COMM3 varchar2(40) Default purchase invoice description
POST_CODE varchar2(10) Postcode
PRJ_PERIOD int32 Project period
QD_CALC decimal Price agreement calculation method
QD_SPL char Merge lines per item code
QD_VIEW decimal Scale pricing display
QT_ACT char Create quotation activities
QT_ACTM varchar2(10) Quotation activity main area
QT_ACTP varchar2(10) Quotation activity priority
QT_ACTSACC varchar2(10) Quotation activity sub-area accept quotation
QT_ACTSCHG varchar2(10) Quotation activity sub-area change quotation
QT_ACTSDEF varchar2(10) Quotation activity sub-area final quotation
QT_ACTSORD varchar2(10) Quotation activity sub-area create sales order
QT_ACTSREJ varchar2(10) Quotation activity sub-area reject quotation
QT_FILE varchar2(100) Quotation file name
QT_LNKDEB char Link quotation document to company
QT_QTAPR char Quotation approval required
QTAUTH_CHK varchar2(4) Quotation approval checks
REC_ID varchar2(10) Unique code
RELT_CMCM1 varchar2(10) Head office at company
RELT_CMCM2 varchar2(10) Dealer at company
RELT_CMCM3 varchar2(10) Accountant at company
RELT_OPCM1 varchar2(10) Company at opportunity
RELT_OPCM2 varchar2(10) Competitor at opportunity
RELT_OPEMP varchar2(10) Employee at opportunity
RELT_PJCM1 varchar2(10) Principal at project
RELT_PJEMP varchar2(10) Project manager at projects
REM_ACT char Create dunning activity
REM_ACTM varchar2(10) Dunning activity main area
REM_ACTP varchar2(10) Dunning activity priority
REM_ACTS1 varchar2(10) Dunning activity sub-area 1
REM_ACTS2 varchar2(10) Dunning activity sub-area 2
REM_ACTS3 varchar2(10) Dunning activity sub-area 3
RTF_FNT varchar2(40) Free text font
SBS_DEL_AO char Delete one-off items from subscription after invoicing
SBS_EXPL char Explode composite item in subscription
SBS_PRNSO char Print final invoice when generating invoice
SBS_TGT int32 Generate subscription as
SG_CODE varchar2(10) Default version
SI_INVAPR char Sales invoice approval required
SI1_INV int32 Assign invoice number
SIAUTH_CHK varchar2(4) Sales invoice approval checks
SIGN_METH int32 Signing method
SO_COMM2 varchar2(40) Default issue order description
SO_COMM3 varchar2(40) Default sales invoice description
SO1_PRNSO char Print final invoice when generating invoice
SOAUTH_CHK varchar2(4) Sales order approval checks
SP_PICAPR char Issue order approval required
SP_PICRET char Packing list completion required
SP_POSTADR char Use postal address as delivery address
SPAUTH_CHK varchar2(4) Issue order approval checks
ST_EXTRA varchar2(10) Address addition
ST_NR varchar2(10) House number
ST_REGION varchar2(40) Address region
ST_STREET varchar2(60) Nombre de la Calle
SW_AANTAL char Show quantity
SW_GEWICHT char Show weight
SW_VENNOOT char Show partner
TAX_ID varchar2(10) Citizen service number
TAX_NAME varchar2(35) Company contact person
TAX_PROF varchar2(10) Return profile
TBL_HD_FNT varchar2(40) Table header font
TBL_LN_FNT varchar2(40) Table text font
TIM_APPR char Project manager must approve hours lines
TIM_AUCO decimal Complete automatically
TIM_AUTOF char Approve hours page automatically
TIM_CHKCOO decimal Check overrun
TIM_CHKCOU decimal Check underrun
TIM_EXTHR char Overtime always external
TIM_LNDS char Use hours entry description when posting
TIM_OBLCST char Project code mandatory on entry
TIM_RATESE varchar2(4) Sequence external rate
TIM_RATESI varchar2(4) Sequence internal rate
TIME_SHEET decimal Hours entry administration
TX2_PROF varchar2(10) Taxonomy profile
UPDT_HSTAL int32 Update item history multiple years per type
VAT_RANGE int32 VAT return period
VAT_RET_NR varchar2(14) VAT number VAT return
WM_FOOTSHW char Footer as watermark on all reports
WM_FOOTTXT varchar2(40) Footer watermark
WM_HEADSHW char Header as watermark on all reports
WM_HEADTXT varchar2(40) Header watermark
WM_IMGFILE varchar2(80) Watermark image
WM_IMGSHOW char Image as watermark on all reports
WM_TXTCOL int32 Watermark text colour
WM_TXTFONT varchar2(40) Watermark text font