ADM_PRF2: AccountView Administration settings table 2
read only per partition
- Catalogo:
AccountView - Label: Administration settings table 2
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella ADM_PRF2. 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 |
Suppliers control account | |||
ACCT_ |
varchar2 |
Customers control account | |||
ADDRESS1 |
varchar2 |
Address | |||
ADM_ |
varchar2 |
Reference administration | |||
ADM_ |
varchar2 |
Company email address | |||
ADM_ |
varchar2 |
Company fax number | |||
ADM_ |
varchar2 |
Company telephone number | |||
ADM_ |
varchar2 |
Company website | |||
ADV_ |
char |
Advice: repost administration | |||
AG_ |
int32 |
Length of customer number in giro payment reference | |||
AG_ |
int32 |
Length of invoice number in giro payment reference | |||
AG_ |
char |
Use customer number in payment reference | |||
AP1_ |
varchar2 |
Supplier number prefix | |||
AR1_ |
varchar2 |
Customer number prefix | |||
ATP_ |
datetime |
Date stock over time | |||
AUDIT_ |
char |
Activate audit trail | |||
AUTH_ |
varchar2 |
Approving employee | |||
AUTO_ |
char |
Number customers/suppliers automatically | |||
BIV_ |
varchar2 |
Capital goods adjustment declaration profile | |||
BLK_ |
char |
Adding journals not allowed | |||
BLK_ |
char |
Show blocked hours | |||
BLK_ |
char |
Adding VAT codes not allowed | |||
BUD_ |
int32 |
Budget per week/month | |||
CC_ |
decimal |
Default year-end transition value cost centres | |||
CC_ |
decimal |
Default status value cost centres | |||
CCNG_ |
datetime |
Ultima modifica | |||
CENDR_ |
varchar2 |
Item code 500 units for Cendris | |||
CENDR_ |
varchar2 |
Item code 1000 units for Cendris | |||
CENDR_ |
varchar2 |
Item code 2500 units for Cendris | |||
CENDR_ |
int32 |
Number of units to assign to Cendris users | |||
CHK_ |
int32 |
Record client changes | |||
CIMP_ |
decimal |
Client import/export exchange format | |||
CITY |
varchar2 |
City | |||
CLT_ |
varchar2 |
Relation type client representative | |||
CLT_ |
varchar2 |
Notification text for message | |||
CLTA_ |
varchar2 |
Activity main area client request | |||
CLTA_ |
varchar2 |
Activity sub-area client request | |||
CLTO_ |
varchar2 |
Activity main area client | |||
CLTO_ |
varchar2 |
Activity sub-area client | |||
CNT_ |
varchar2 |
ISO country code | |||
COLL_ |
char |
Collect advance note settlements | |||
COMP_ |
varchar2 |
Business unit ID | |||
COUNTRY |
varchar2 |
Country | |||
CPA_ |
varchar2 |
Office name | |||
CPA_ |
varchar2 |
Office address | |||
CPA_ |
char |
Client must approve return | |||
CPA_ |
varchar2 |
Office city | |||
CPA_ |
varchar2 |
Office ISO country code | |||
CPA_ |
varchar2 |
Office country | |||
CPA_ |
varchar2 |
Office telephone number | |||
CPA_ |
varchar2 |
Office postal address | |||
CPA_ |
varchar2 |
Office postal address city | |||
CPA_ |
varchar2 |
Office postal address postcode | |||
CPA_ |
varchar2 |
Office postcode | |||
CPA_ |
varchar2 |
Office address addition | |||
CPA_ |
varchar2 |
Office house number | |||
CPA_ |
varchar2 |
Office address region | |||
CPA_ |
varchar2 |
Office street name | |||
DEL_ |
char |
Deliver on working days only | |||
DETAX_ |
varchar2 |
Tax office | |||
DETAX_ |
varchar2 |
State | |||
DFLT_ |
varchar2 |
Default partner | |||
DIM_ |
varchar2 |
Dimension definition | |||
DISP_ |
char |
Block automatic payments | |||
DJ_ |
varchar2 |
System journal purchase/sales invoices | |||
DOC_ |
varchar2 |
Document font | |||
DOS_ |
decimal |
Last depreciated period | |||
DSP_ |
int32 |
Print column total | |||
DSP_ |
int32 |
Print column table header | |||
DYN_ |
char |
Update item history multiple years dynamically | |||
DYN_ |
char |
Update hours history multiple years dynamically | |||
EDIC_ |
varchar2 |
Client relation code | |||
EDIC_ |
varchar2 |
VAT differences account (EDI-Circle) | |||
EXP_ |
char |
Approve claim proposals | |||
EXP_ |
int32 |
Cancel/postpone remaining amount to be invoiced after change | |||
EXP_ |
int32 |
Make change | |||
EXP_ |
int32 |
Distribution of line amount | |||
EXP_ |
datetime |
Export date last import | |||
EXP_ |
char |
Print final invoice when generating invoice | |||
FDIM_ |
varchar2 |
Financial (Dimensions) | |||
FNT_ |
int32 |
Align text | |||
FNT_ |
int32 |
Align amounts | |||
FNT_ |
char |
Total text bold | |||
FNT_ |
char |
Total amounts bold | |||
FNT_ |
int32 |
Underline total | |||
GRAY_ |
varchar2 |
Graydon activity main area | |||
GRAY_ |
varchar2 |
Graydon activity sub-area | |||
GRAY_ |
char |
Adopt credit limit automatically at customer | |||
GRAY_ |
char |
Create Graydon activity | |||
GRAY_ |
int32 |
Graydon retrieval interval | |||
GRP_ |
char |
Condensed posting | |||
HD1_ |
varchar2 |
Heading 1 font | |||
HD2_ |
varchar2 |
Heading 2 font | |||
HD3_ |
varchar2 |
Heading 3 font | |||
HOUR_ |
decimal |
Post hourly rate | |||
ICL_ |
int32 |
EC sales list reporting period | |||
ID_ |
int32 |
Administration background colour | |||
IN_ |
char |
Stock page approval required | |||
INCL_ |
char |
Add mandatory items automatically | |||
INO_ |
decimal |
Entry method stocktaking order | |||
INO_ |
varchar2 |
Transaction code | |||
INT_ |
varchar2 |
Name of umbrella organisation of tax service providers | |||
INT_ |
varchar2 |
BECON number | |||
INT_ |
varchar2 |
Intermediary contact person | |||
INT_ |
varchar2 |
Name of electronic filing office | |||
INT_ |
char |
Returns are handled by intermediary | |||
KVK_NR |
varchar2 |
Numero di registrazione presso la Camera di Commercio | |||
MSG_ |
char |
Report bonus items | |||
MSG_ |
char |
Report cross-selling items | |||
MSG_ |
char |
Report exclusion items | |||
MSG_ |
char |
Report mandatory items | |||
MSG_ |
char |
Report alternative items | |||
MSG_UP |
char |
Report up-selling items | |||
NUM_ |
int32 |
Customer/supplier number length | |||
OWN_ |
varchar2 |
Hours display | |||
OWN_ |
varchar2 |
Claim proposal display | |||
OWN_OI |
varchar2 |
Invoice display | |||
OWN_ |
varchar2 |
Project display | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PICK_ |
varchar2 |
Warehouse picking strategy | |||
PJ_ALL |
char |
Also show cost centres in projects overview | |||
PJ_ |
varchar2 |
Draft invoices description | |||
PJ_ |
varchar2 |
Project hierarchy 1 | |||
PJ_ |
varchar2 |
Project hierarchy 2 | |||
PJ_ |
varchar2 |
Project hierarchy 3 | |||
PJ_ |
varchar2 |
Invoice item advances | |||
PJ_ |
varchar2 |
Invoice description | |||
PJ_ |
varchar2 |
Invoice item fixed amounts | |||
PJ_MIN |
int64 |
Minimum invoice amount projects | |||
PJ1_ |
decimal |
Default year-end transition value projects | |||
PJ1_ |
decimal |
Default budgeting method value projects | |||
PJ1_ |
decimal |
Default status value projects | |||
PJB_ |
decimal |
Number of decimals project monitoring | |||
PMT_ |
varchar2 |
Item number for transit | |||
PMT_ |
char |
Payment by cheque | |||
PMT_ |
char |
All bank charges for account of beneficiary | |||
PMT_ |
char |
Charges of other banks for account of principal | |||
PMT_ |
varchar2 |
Description for DNB | |||
PMT_ |
char |
Urgent foreign payment | |||
PMT_ |
varchar2 |
Goods code | |||
PMT_ |
varchar2 |
Payment instruction code 1 | |||
PMT_ |
varchar2 |
Payment instruction code 2 | |||
PMT_ |
varchar2 |
Payment instruction code 3 | |||
PMT_ |
varchar2 |
Payment instruction code 4 | |||
PMT_ |
varchar2 |
Foreign exchange reporting | |||
PO_BOX |
varchar2 |
Postal address | |||
PO_ |
varchar2 |
Postal address city | |||
PO_ |
varchar2 |
Postal address postcode | |||
PO_ |
varchar2 |
Default receipt description | |||
PO_ |
varchar2 |
Default purchase invoice description | |||
POST_ |
varchar2 |
Postcode | |||
PRJ_ |
int32 |
Project period | |||
QD_ |
decimal |
Price agreement calculation method | |||
QD_SPL |
char |
Merge lines per item code | |||
QD_ |
decimal |
Scale pricing display | |||
QT_ACT |
char |
Create quotation activities | |||
QT_ |
varchar2 |
Quotation activity main area | |||
QT_ |
varchar2 |
Quotation activity priority | |||
QT_ |
varchar2 |
Quotation activity sub-area accept quotation | |||
QT_ |
varchar2 |
Quotation activity sub-area change quotation | |||
QT_ |
varchar2 |
Quotation activity sub-area final quotation | |||
QT_ |
varchar2 |
Quotation activity sub-area create sales order | |||
QT_ |
varchar2 |
Quotation activity sub-area reject quotation | |||
QT_ |
varchar2 |
Quotation file name | |||
QT_ |
char |
Link quotation document to company | |||
QT_ |
char |
Quotation approval required | |||
QTAUTH_ |
varchar2 |
Quotation approval checks | |||
REC_ID |
varchar2 |
Unique code | |||
RELT_ |
varchar2 |
Head office at company | |||
RELT_ |
varchar2 |
Dealer at company | |||
RELT_ |
varchar2 |
Accountant at company | |||
RELT_ |
varchar2 |
Company at opportunity | |||
RELT_ |
varchar2 |
Competitor at opportunity | |||
RELT_ |
varchar2 |
Employee at opportunity | |||
RELT_ |
varchar2 |
Principal at project | |||
RELT_ |
varchar2 |
Project manager at projects | |||
REM_ |
char |
Create dunning activity | |||
REM_ |
varchar2 |
Dunning activity main area | |||
REM_ |
varchar2 |
Dunning activity priority | |||
REM_ |
varchar2 |
Dunning activity sub-area 1 | |||
REM_ |
varchar2 |
Dunning activity sub-area 2 | |||
REM_ |
varchar2 |
Dunning activity sub-area 3 | |||
RTF_ |
varchar2 |
Free text font | |||
SBS_ |
char |
Delete one-off items from subscription after invoicing | |||
SBS_ |
char |
Explode composite item in subscription | |||
SBS_ |
char |
Print final invoice when generating invoice | |||
SBS_ |
int32 |
Generate subscription as | |||
SG_ |
varchar2 |
Default version | |||
SI_ |
char |
Sales invoice approval required | |||
SI1_ |
int32 |
Assign invoice number | |||
SIAUTH_ |
varchar2 |
Sales invoice approval checks | |||
SIGN_ |
int32 |
Signing method | |||
SO_ |
varchar2 |
Default issue order description | |||
SO_ |
varchar2 |
Default sales invoice description | |||
SO1_ |
char |
Print final invoice when generating invoice | |||
SOAUTH_ |
varchar2 |
Sales order approval checks | |||
SP_ |
char |
Issue order approval required | |||
SP_ |
char |
Packing list completion required | |||
SP_ |
char |
Use postal address as delivery address | |||
SPAUTH_ |
varchar2 |
Issue order approval checks | |||
ST_ |
varchar2 |
Address addition | |||
ST_NR |
varchar2 |
House number | |||
ST_ |
varchar2 |
Address region | |||
ST_ |
varchar2 |
Nome della via | |||
SW_ |
char |
Show quantity | |||
SW_ |
char |
Show weight | |||
SW_ |
char |
Show partner | |||
TAX_ID |
varchar2 |
Citizen service number | |||
TAX_ |
varchar2 |
Company contact person | |||
TAX_ |
varchar2 |
Return profile | |||
TBL_ |
varchar2 |
Table header font | |||
TBL_ |
varchar2 |
Table text font | |||
TIM_ |
char |
Project manager must approve hours lines | |||
TIM_ |
decimal |
Complete automatically | |||
TIM_ |
char |
Approve hours page automatically | |||
TIM_ |
decimal |
Check overrun | |||
TIM_ |
decimal |
Check underrun | |||
TIM_ |
char |
Overtime always external | |||
TIM_ |
char |
Use hours entry description when posting | |||
TIM_ |
char |
Project code mandatory on entry | |||
TIM_ |
varchar2 |
Sequence external rate | |||
TIM_ |
varchar2 |
Sequence internal rate | |||
TIME_ |
decimal |
Hours entry administration | |||
TX2_ |
varchar2 |
Taxonomy profile | |||
UPDT_ |
int32 |
Update item history multiple years per type | |||
VAT_ |
int32 |
VAT return period | |||
VAT_ |
varchar2 |
VAT number VAT return | |||
WM_ |
char |
Footer as watermark on all reports | |||
WM_ |
varchar2 |
Footer watermark | |||
WM_ |
char |
Header as watermark on all reports | |||
WM_ |
varchar2 |
Header watermark | |||
WM_ |
varchar2 |
Watermark image | |||
WM_ |
char |
Image as watermark on all reports | |||
WM_ |
int32 |
Watermark text colour | |||
WM_ |
varchar2 |
Watermark text font |