ADM_PRF3: AccountView Administration settings table 3
read only per partition
- Catalogo:
AccountView - Label: Administration settings table 3
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella ADM_PRF3. 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 |
|---|---|---|---|---|---|
ACCR_ |
char |
Allow accruals and deferrals on balance sheet accounts | |||
ACCT_ |
varchar2 |
Private settlements clearing account | |||
ACCT_ |
varchar2 |
Orders to be received account | |||
ACCT_ |
varchar2 |
Costs to be authorised | |||
AD_ |
int32 |
Advisor import batch number | |||
AI_ |
char |
Invoices via print service AutoInvoice possible | |||
AI_API |
varchar2 |
API key (admin) AutoInvoice | |||
AI_DJP |
varchar2 |
System journal purchase invoices AutoInvoice | |||
AI_ |
varchar2 |
System journal purchase invoices AutoInvoice, no workflow | |||
APUB_ |
varchar2 |
First name contact person annual accounts publication | |||
APUB_ |
varchar2 |
Last name contact person annual accounts publication | |||
APUB_ |
varchar2 |
Email contact person annual accounts publication | |||
AUTO_ |
char |
Schedule automatically | |||
AUTO_ |
char |
Report back automatically when printing delivery note | |||
AUTO_ |
char |
Receive automatically when processing purchase invoices | |||
BLK_ |
char |
General ledger accounts add/modify/delete not allowed | |||
CHK_ |
varchar2 |
Taxonomy code | |||
CLINK_ |
varchar2 |
Default account new suppliers | |||
CRED_ |
varchar2 |
Creditor ID | |||
DAILY_ |
char |
Descriptions based on journal settings | |||
DCALC_ |
datetime |
Last sales calculation per week | |||
DEPR_ |
int32 |
Depreciation regime | |||
DESC_ |
char |
Modifying general ledger account description allowed | |||
DIS_ |
char |
Disable Severa Plus link | |||
DIS_ |
char |
Disable Severa Complete link | |||
DISC_ |
varchar2 |
Payment term new suppliers | |||
DISC_ |
varchar2 |
Payment term new customers | |||
DJ_ |
varchar2 |
Sales invoices Invoicing | |||
DJ_ |
varchar2 |
Write-offs of open items | |||
DJ_ |
varchar2 |
Purchase invoices | |||
DJ_ |
varchar2 |
Sales invoices Basic | |||
DJ_ |
varchar2 |
Payments in transit | |||
DJ_ |
varchar2 |
Payroll journal | |||
DJ_WF |
varchar2 |
Journal (purchase) | |||
DJIM_ |
char |
Skip VAT when importing journal messages | |||
DJIM_ |
varchar2 |
VAT code for journal import | |||
DJIMAP_ |
char |
Take journal message headers from reference administration | |||
DLINK_ |
varchar2 |
Default account new customers | |||
DPH_ |
char |
Period/date check for projects and hours | |||
EBNK_ |
char |
Use SEPA guidelines for direct bank link | |||
EIA |
varchar2 |
Electronic Invoice Address | |||
EV_DJP |
varchar2 |
Purchase invoices journal (eVerbinding) | |||
EV_DJS |
varchar2 |
Sales invoices journal (eVerbinding) | |||
EXT_ |
varchar2 |
Additional status 'Partially paid' (Severa) | |||
EXT_ |
varchar2 |
Additional payment statuses (Severa) | |||
EXT_ |
varchar2 |
Additional retrieval statuses (Severa) | |||
FAH_ |
char |
Number fixed assets automatically | |||
GLSTPY_ |
int32 |
Change number for comparative annual figures | |||
HRS_ |
varchar2 |
Last modified time hours registration | |||
IN2_ |
char |
Extended stock management | |||
INCL_ |
char |
Costs and revenues including commitments | |||
ISAH_ |
varchar2 |
Isah administration | |||
ISAH_ |
varchar2 |
Isah password | |||
ISAH_ |
varchar2 |
Isah user name | |||
KPI_ |
varchar2 |
Taxonomy project scorecard controller | |||
LEAD_ |
varchar2 |
Heading code payroll total | |||
LNG_ |
varchar2 |
Language code new suppliers | |||
LNG_ |
varchar2 |
Language code new customers | |||
MAIL_ |
char |
Also create UBL format for electronic invoicing | |||
NMBRS_ |
int32 |
Nmbrs import level | |||
OBLI_ |
int32 |
Commitment from status | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PAY_ |
int32 |
Fixed day | |||
PAY_ |
int32 |
Payment day | |||
PRN_ |
char |
Print packing list when generating issue order | |||
PROF_ |
varchar2 |
Email profile | |||
PST_ |
char |
Post orders to be received | |||
REC_ID |
varchar2 |
Primary key | |||
REGCH_ |
varchar2 |
Account number system change | |||
RELV_ |
varchar2 |
Relevance changed | |||
RISK_ |
int32 |
Organisation risk | |||
SCAN_ |
varchar2 |
Credit card payments account | |||
SCAN_ |
varchar2 |
Debit card payments account | |||
SCAN_ |
varchar2 |
System journal cash purchases/sales | |||
SCAN_ |
varchar2 |
System journal credit card payments | |||
SCAN_ |
varchar2 |
System journal purchase invoices | |||
SCAN_ |
varchar2 |
System journal debit card payments | |||
SCAN_ |
varchar2 |
System journal sales invoices | |||
SDEL_ |
char |
Synchronise deleted relations | |||
SETUP_ |
varchar2 |
Last modified time master data | |||
SHIP_ |
char |
Deliver composite items complete | |||
STAT_ |
varchar2 |
Status tangible | |||
STAT_ |
varchar2 |
Status n/a | |||
STAT_ |
varchar2 |
Status intangible | |||
SV_API |
varchar2 |
API key (Severa) | |||
SV_ |
varchar2 |
Department (Severa) | |||
SV_ |
varchar2 |
Employee code (Severa) | |||
SV_ |
varchar2 |
Hour type code own work (Severa) | |||
SV_ |
varchar2 |
Hour type code (Severa) | |||
SV_ |
varchar2 |
Hour type code hours (Severa) | |||
SV_ |
varchar2 |
Hour type code travel expenses (Severa) | |||
SV_ |
varchar2 |
Invoice status Paid (Severa) | |||
SV_ |
varchar2 |
Invoice status 'Partially paid' (Severa) | |||
SV_REV |
varchar2 |
Invoice status Retrieve (Severa) | |||
SV_ |
char |
Split hours by employee (Severa) | |||
SV_ |
char |
Split hours by hour type (Severa) | |||
SV_ |
char |
Split travel expenses by hour type (Severa) | |||
UBL_ |
int32 |
UBL variant for electronic invoicing | |||
WF_ |
char |
Post directly to cost accounts | |||
WF_EMP |
varchar2 |
Invoice distributor | |||
WF_ |
varchar2 |
Workflow for organisation | |||
WKR_ |
decimal |
Work-related costs scheme percentage | |||
WKST_ |
int32 |
Weeks sales history | |||
YEAR_ |
int64 |
Estimated payroll total |