ADM_PRF: AccountView Administration settings
read only per partition
- Catalogo:
AccountView - Label: Administration settings
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella ADM_PRF. 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_ |
varchar2 |
Bank charges account | |||
ACCT_ |
varchar2 |
Exchange rate differences account | |||
ACCT_ |
varchar2 |
Prepayments account | |||
ACCT_ |
varchar2 |
Prepayments account | |||
ACCT_ |
varchar2 |
Other differences account | |||
ACCT_ |
varchar2 |
Supplier payment discount account | |||
ACCT_ |
varchar2 |
Customer payment discount account | |||
ACCT_ |
varchar2 |
Discounts account (sales) | |||
ACCT_ |
varchar2 |
Euro conversion differences account | |||
ACCT_ |
varchar2 |
Interest/costs account | |||
ACCT_ |
varchar2 |
Administration company name | |||
ACCT_ |
varchar2 |
Payment differences account | |||
ACCT_ |
varchar2 |
Invoices to be received account | |||
ACCT_ |
varchar2 |
Previous financial year result | |||
ACCT_ |
varchar2 |
Balance sheet rounding differences account | |||
ACCT_ |
varchar2 |
Profit and loss rounding differences account | |||
ACCT_ |
varchar2 |
Accruals and deferrals credit | |||
ACCT_ |
varchar2 |
Accruals and deferrals debit | |||
ACCT_ |
varchar2 |
Report rounding | |||
ACPY_ |
varchar2 |
Previous financial year items credit | |||
ACPY_ |
varchar2 |
Previous financial year items debit | |||
ADD_ |
char |
Add original heading | |||
ADM_ |
decimal |
Status | |||
ADM_ |
char |
External administration | |||
ADM_ |
varchar2 |
Central administration | |||
AGE_ |
decimal |
Ageing analysis term 1 | |||
AGE_ |
decimal |
Ageing analysis term 2 | |||
AGE_ |
decimal |
Ageing analysis term 3 | |||
APX_ |
decimal |
Number of decimals prices | |||
ART_ |
decimal |
Number of decimals quantities | |||
ART_ |
varchar2 |
Miscellaneous purchase item code | |||
ART_ |
varchar2 |
Purchase order costs item code | |||
ART_ |
varchar2 |
Purchase transport costs item code | |||
ART_ |
varchar2 |
Miscellaneous sales item code | |||
ART_ |
varchar2 |
Sales order costs item code | |||
ART_ |
varchar2 |
Sales transport costs item code | |||
AUTO_ |
char |
Use auto-coding | |||
AUTO_ |
char |
Post invoice and payment simultaneously | |||
BANK_ |
varchar2 |
Bank charges account | |||
BANK_ |
varchar2 |
Interest account | |||
BCK_ |
char |
Include copy documents in backup | |||
BEG_ |
datetime |
Financial year start date | |||
CAP_ |
decimal |
Nominal value of share | |||
CAP_ |
decimal |
Authorised capital | |||
CAP_ |
decimal |
Paid-up capital | |||
CHK_ |
int32 |
Stock check stock movements | |||
CHK_ |
int32 |
Stock check sales orders | |||
CINV_ |
varchar2 |
Copy documents folder name | |||
CLT_ |
varchar2 |
Blocked for client use up to period | |||
CN_ |
decimal |
Last consolidation performed | |||
CNG_ |
char |
Country cannot be changed | |||
CNG_ |
datetime |
Date last modified | |||
CNG_NR |
int32 |
Change number | |||
CNT_ |
varchar2 |
Country currency code | |||
COGS_ |
char |
Post cost price corrections | |||
COLL_ |
char |
Collect draft purchase orders | |||
COMP_ |
varchar2 |
Business activity | |||
COMP_ |
varchar2 |
Attention of | |||
COMP_ |
varchar2 |
Salutation | |||
COMP_ |
varchar2 |
Director | |||
CON_ |
char |
Show Bankleitzahl for relations | |||
COPY_ |
char |
Create copy documents | |||
CPA_ |
varchar2 |
Prepared by | |||
CPA_ |
varchar2 |
Signature | |||
CTAX_ |
decimal |
Corporate income tax current year | |||
CTAX_ |
decimal |
Corporate income tax previous year | |||
CUR_ |
varchar2 |
Administration currency code | |||
CUR_ |
decimal |
Number of decimals amounts | |||
CUR_ |
varchar2 |
Decimal separator | |||
CUR_ |
varchar2 |
Thousands separator | |||
DATE_ |
char |
Create activity when delivery date changes | |||
DATE_ |
varchar2 |
Delivery date email layout | |||
DATE_ |
char |
Send email to customer when delivery date changes | |||
DATE_ |
char |
Send email to salesperson when delivery date changes | |||
DATE_ |
varchar2 |
Activity sub-area delivery date change | |||
DATE_ |
varchar2 |
Activity main area delivery date change | |||
DATE_ |
decimal |
Date type | |||
DEL_ |
char |
Create activity when sales order is delivered | |||
DEL_ |
varchar2 |
Receipts email layout | |||
DEL_ |
char |
Send email when sales order is delivered | |||
DEL_ |
char |
Send email when sales order can be delivered | |||
DEL_ |
char |
Delete fully received order lines | |||
DEL_ |
char |
Delete delivered order lines | |||
DEL_ |
varchar2 |
Activity sub-area shipment | |||
DEL_ |
varchar2 |
Activity main area shipment | |||
DISC_ |
decimal |
Number of decimals discount percentage | |||
DJ_ |
varchar2 |
System journal counter invoices | |||
DJ_ |
varchar2 |
System journal corrections | |||
DJ_DJI |
varchar2 |
System journal journal messages | |||
DJ_ |
varchar2 |
System journal UBL invoices (purchase) | |||
DJ_ |
varchar2 |
System journal UBL invoices (sales) | |||
DJ_ |
varchar2 |
System journal EDI-Circle (purchase) | |||
DJ_ |
varchar2 |
System journal EDI-Circle (sales) | |||
DJ_II |
varchar2 |
System journal stock movements | |||
DJ_MFG |
varchar2 |
System journal production orders | |||
DJ_OI |
varchar2 |
System journal settle open items | |||
DJ_PI |
varchar2 |
System journal purchase invoices | |||
DJ_PPS |
varchar2 |
System journal receipts | |||
DJ_ |
varchar2 |
System journal stock revaluation | |||
DJ_SI |
varchar2 |
System journal sales invoices | |||
DOC_ |
varchar2 |
Documents folder name | |||
DP_ |
char |
Period/date check | |||
DSP_ |
char |
Show thousands separator | |||
EMP_CY |
decimal |
Number of employees current year | |||
EMP_PY |
decimal |
Number of employees previous year | |||
END_ |
datetime |
Financial year end date | |||
EXP_ |
char |
Include copy documents when carrying over administration | |||
EXP_ |
datetime |
Last export | |||
EXPL_ |
decimal |
Price calculation | |||
EXPL_ |
char |
Suppress explosion on invoice | |||
EXPL_ |
char |
Suppress explosion on delivery note | |||
EXPL_ |
char |
Suppress explosion on quotation | |||
EXPL_ |
float |
Reservation | |||
EXPL_ |
char |
Suppress explosion on shipping label | |||
EXPL_ |
char |
Suppress explosion on order confirmation | |||
EXPL_ |
char |
Suppress explosion on consignment note | |||
EXT_ |
char |
Available in AccountView Contact | |||
FSL_ |
varchar2 |
Cost centre code reports | |||
FSL_ |
varchar2 |
Currency code reports | |||
FSL_ |
char |
Update reports quickly | |||
FSL_ |
decimal |
Period figures first column | |||
FSL_ |
decimal |
Period figures second column | |||
FSL_ |
decimal |
Round reports | |||
GEN_ |
char |
Create final purchase orders | |||
HOME_ |
varchar2 |
ISO country code automatic foreign payment | |||
HOME_ |
varchar2 |
ISO currency automatic foreign payment | |||
ICNT_ |
varchar2 |
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 |
Journal code transaction import | |||
ID_ |
varchar2 |
File name transaction import | |||
ID_ |
float |
File type transaction import | |||
IMP_ |
datetime |
Last import | |||
IMP_ |
decimal |
Handling of existing journal pages during import | |||
IMP_ |
decimal |
Overwrite existing master data during import | |||
INP_ |
datetime |
Entry date | |||
INPL_ |
char |
Select from free lists only | |||
INV_ |
decimal |
Stock valuation method | |||
INVDED_ |
decimal |
Investment deduction current year | |||
INVDED_ |
decimal |
Investment deduction previous year | |||
IS_ |
varchar2 |
IS country code customer/supplier | |||
IS_ |
char |
IS customs clearance permit purchase | |||
IS_ |
char |
IS customs clearance permit sales | |||
IS_ |
decimal |
IS declaration threshold purchase | |||
IS_ |
decimal |
IS declaration threshold sales | |||
ISHP_ |
varchar2 |
IS mode of transport | |||
ISXF_ |
varchar2 |
IS statistical factor code purchase | |||
ISXF_ |
varchar2 |
IS statistical factor code sales | |||
ISYS_ |
varchar2 |
IS regime | |||
ITYP_ |
varchar2 |
IS transaction code | |||
LAST_ |
varchar2 |
Last blocked period | |||
LAST_ |
decimal |
Last depreciated period | |||
LAST_ |
varchar2 |
Period completed up to and including | |||
LAST_ |
decimal |
Last closed period | |||
LDCOST_ |
decimal |
Partially deductible costs current year | |||
LDCOST_ |
decimal |
Partially deductible costs previous year | |||
LNG_ |
varchar2 |
Language code | |||
LOC_ |
varchar2 |
Default warehouse location | |||
MRK_ |
char |
Mark credit notes | |||
NCBEX_ |
decimal |
Exemption limit | |||
NCBREG_ |
varchar2 |
DNB registration number | |||
NCBSEC_ |
varchar2 |
Industry | |||
NCBTRD_ |
varchar2 |
Dealer number | |||
NO_ |
char |
No access control per journal | |||
ORD_ |
char |
Create activity when sales order is accepted | |||
ORD_ |
char |
Send email when sales order is accepted | |||
ORD_ |
varchar2 |
Activity sub-area order confirmation | |||
ORD_ |
varchar2 |
Activity main area order confirmation | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PAY_ |
varchar2 |
Payment method bank charges | |||
PAY_ |
varchar2 |
Payment method interest | |||
PD_ |
char |
Calculate payment discount on gross | |||
PD_PFX |
varchar2 |
Payment reference | |||
PD_ |
varchar2 |
VAT code credit limit supplier | |||
PD_ |
varchar2 |
VAT code credit limit customer | |||
PER_ |
decimal |
Number of periods per year | |||
PJ1_ |
decimal |
Status after quotation accepted | |||
PJ1_ |
decimal |
Status after final quotation | |||
PJ1_ |
decimal |
Status after quotation rejected | |||
PO_ |
char |
Order confirmation approval required | |||
PO_ |
char |
Order confirmation check required | |||
PO_ |
char |
Receipt of order confirmation required | |||
PO_ |
varchar2 |
Default purchase order description | |||
PO_ |
char |
Purchase orders gross by default | |||
PO_ |
char |
Purchase invoice approval required | |||
PO_ |
char |
Purchase invoice check required | |||
PO_ |
char |
Receipt of purchase invoice required | |||
PO_ |
char |
Purchase order approval required | |||
POL_ |
char |
Update backorders automatically | |||
POST_ |
char |
Post automatic payment to creditors control account | |||
POST_ |
char |
Post direct debit to debtors control account | |||
PST_ |
char |
Post invoices to be received | |||
QD_CHK |
char |
Check scale pricing | |||
REC_ID |
varchar2 |
Unique code | |||
REM_ |
decimal |
Dunning method | |||
REM_ |
decimal |
Dunning term 1 due period | |||
REM_ |
decimal |
Dunning term 2 due period | |||
REM_ |
decimal |
Dunning term 3 due period | |||
RPT_ |
datetime |
Report date | |||
RT_DJP |
char |
Direct processing journals | |||
RT_ |
char |
Direct processing purchase payment discount | |||
RT_POP |
char |
Direct processing purchase invoices | |||
RT_ |
char |
Direct processing sales payment discount | |||
RT_SOP |
char |
Direct processing sales invoices | |||
SET_ |
char |
Confirm creation of draft purchase orders | |||
SHOW_ |
char |
Show dimension description | |||
SHOW_ |
char |
Do not update open items display immediately during journal entry | |||
SO_ |
char |
Order confirmation return | |||
SO_ |
char |
Order confirmation printing required | |||
SO_ |
varchar2 |
Default sales order description | |||
SO_ |
char |
Sales orders/invoices gross by default | |||
SO_ |
char |
Reset periodic orders to zero | |||
SO_ |
char |
Sales order approval required | |||
SO_ |
char |
Delivery approval required | |||
SO_ |
char |
Delivery note completion required | |||
SO_ |
char |
Delivery note printing required | |||
SO_ |
char |
Suppress zero lines on delivery note | |||
SOC_ |
int64 |
Max difference amount | |||
SOC_ |
varchar2 |
Differences account | |||
SOC_ |
char |
Sales on account | |||
SOC_ |
varchar2 |
Counter invoice customer | |||
SUP_ |
char |
Skip cost centre code | |||
SUP_ |
char |
Skip foreign currency | |||
SUP_ |
char |
Skip customer/supplier | |||
SUP_ |
char |
Skip VAT code | |||
SX_ |
varchar2 |
Intrastat declaration | |||
TPL_ |
varchar2 |
Templates folder name | |||
TRF_ |
varchar2 |
Transfer clearing account | |||
VAT_ |
decimal |
Number of decimals VAT return | |||
VAT_ |
varchar2 |
VAT number EC sales list | |||
VAT_NR |
varchar2 |
Fiscal VAT number | |||
VAT_ |
decimal |
VAT number verification period | |||
VERSION |
varchar2 |
Administration version number | |||
VERSIONV |
varchar2 |
Administration version number (function) | |||
WHS_ |
varchar2 |
Default warehouse code |