CONTACT: AccountView Companies (basic data)
read only per partition
- Catalogo:
AccountView - Label: Companies (basic data)
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella CONTACT. 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_ |
int64 |
Balance | |||
ACCT_ |
int64 |
Balance payable | |||
ACCT_ |
int32 |
Control account type | |||
ACCT_ |
varchar2 |
Nome della ditta | |||
ACCT_ |
varchar2 |
Control account | |||
ACCT_ |
varchar2 |
Phonetic company name | |||
ADDR_ |
varchar2 |
Address line 1 | |||
ADDR_ |
varchar2 |
Address line 2 | |||
ADDRESS1 |
varchar2 |
Address | |||
ADM_ |
varchar2 |
Administration contact person salutation | |||
ADMIN_ |
varchar2 |
Administration contact person | |||
ADMIN_ |
varchar2 |
Administration contact person | |||
ADMIN_ |
varchar2 |
Contact person code | |||
AI_ |
char |
Post purchase invoices in journal 'Purchase invoices, no workflow' | |||
AIEI_ |
char |
Always system-to-system | |||
AIEM_ |
char |
Always via email AutoInvoice | |||
AIPR_ |
char |
Always print service AutoInvoice | |||
AMT_DD |
int64 |
Selected amount to be received | |||
AMT_ |
int64 |
Maximum direct debit amount | |||
AMT_ |
int64 |
Selected amount to be paid | |||
AMT_ |
int64 |
To be received | |||
AMT_ |
int64 |
Remaining amount | |||
AMT_ |
int64 |
Remaining amount payable | |||
APX_ |
varchar2 |
Price list item prices | |||
AUTH_ |
varchar2 |
Approving employee | |||
AUTO_ |
char |
Invoicing via AutoInvoice | |||
BANK_ |
varchar2 |
Relation bank account 1 | |||
BANK_ |
varchar2 |
Relation bank account 2 | |||
BANK_ |
varchar2 |
Bank account 2 | |||
BANK_ |
varchar2 |
Bank account 1 | |||
BLK_ |
varchar2 |
G-account number | |||
BLK_ |
varchar2 |
G-account bank code | |||
BLK_ |
datetime |
Date of subcontractor payment behaviour proof | |||
BLK_ |
char |
Allow G-account information in electronic invoices | |||
BLK_ |
varchar2 |
G-account IBAN | |||
BLK_ |
decimal |
G-account percentage | |||
BLK_SP |
char |
Blocked for orders | |||
BNK_ |
char |
Postbank account pure | |||
BNK_ |
varchar2 |
Bank code, bank account 1 | |||
BNK_ |
varchar2 |
Bank code, bank account 2 | |||
BOS_ |
varchar2 |
AccountView Server code | |||
BOX_ |
varchar2 |
City or postal address city | |||
BV_NR |
varchar2 |
UWV connection number | |||
BV_PCT |
decimal |
UWV percentage | |||
BV_SUB |
varchar2 |
UWV supplier | |||
C_ |
varchar2 |
Company list field 1 | |||
C_ |
varchar2 |
Company list field 2 | |||
C_ |
varchar2 |
Company list field 3 | |||
C_ |
varchar2 |
Company list field 4 | |||
C_ |
varchar2 |
Company list field 5 | |||
C_ |
varchar2 |
Company list field 6 | |||
C_ |
varchar2 |
Company list field 7 | |||
C_ |
varchar2 |
Company list field 8 | |||
C_ |
varchar2 |
Company list field 9 | |||
C_ |
varchar2 |
Company list field 10 | |||
C_ |
char |
Company checkbox field 1 | |||
C_ |
char |
Company checkbox field 2 | |||
C_ |
char |
Company checkbox field 3 | |||
C_ |
char |
Company checkbox field 4 | |||
C_ |
char |
Company checkbox field 5 | |||
C_ |
char |
Company checkbox field 6 | |||
C_ |
char |
Company checkbox field 7 | |||
C_ |
char |
Company checkbox field 8 | |||
C_ |
char |
Company checkbox field 9 | |||
C_ |
char |
Company checkbox field 10 | |||
CHN_ |
varchar2 |
Dealer postal address | |||
CHN_ |
varchar2 |
Dealer city | |||
CHN_ |
varchar2 |
Dealer main contact person email | |||
CHN_ |
varchar2 |
Dealer main contact person | |||
CHN_ |
varchar2 |
Dealer fax | |||
CHN_ |
varchar2 |
Dealer email | |||
CHN_ |
char |
Relation is dealer | |||
CHN_ |
varchar2 |
Dealer company name | |||
CHN_ |
varchar2 |
Dealer telephone | |||
CHN_ |
varchar2 |
Dealer channel | |||
CITY |
varchar2 |
City | |||
CNG_ |
datetime |
Date last modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Modificato da | |||
CNT_ |
varchar2 |
ISO country code | |||
COC_ |
varchar2 |
Numero di registrazione presso la Camera di Commercio | |||
COMMENT1 |
varchar2 |
Customer/supplier note | |||
COUNTRY |
varchar2 |
Country | |||
CPA_ |
varchar2 |
Accountant | |||
CR_AMT |
int64 |
Credit amount | |||
CRED_ |
int64 |
Credit availability | |||
CRED_ |
int32 |
Credit limit | |||
CRED_ |
char |
Also show as supplier | |||
CUR_ |
varchar2 |
Currency code | |||
CUR_ |
varchar2 |
Currency symbol | |||
DD_ACT |
char |
Direct debit allowed | |||
DEB_NR |
varchar2 |
External customer number | |||
DEB_ |
varchar2 |
External customer/supplier number | |||
DEB_ |
char |
Also show as customer | |||
DISC_ |
varchar2 |
Payment term code | |||
DISC_ |
decimal |
Invoice discount | |||
DJIP_ |
char |
Process posting proposals as purchase invoices | |||
DR_AMT |
int64 |
Debit amount | |||
EIA |
varchar2 |
Electronic Invoice Address | |||
EL_CI |
char |
Send counter invoices by email | |||
EL_DP |
char |
Send prepayments by email | |||
EL_PO |
char |
Send purchase orders by email | |||
EL_PS |
char |
Send delivery notes by email | |||
EL_RE |
char |
Send reminders by email | |||
EL_SBS |
char |
Send subscriptions by email | |||
EL_SI |
char |
Send invoices by email | |||
EL_SO |
char |
Send order confirmations by email | |||
EMP_ |
varchar2 |
Employee class | |||
EMP_NR |
varchar2 |
Salesperson/buyer | |||
FAX_ |
varchar2 |
Business fax | |||
FIRST_ |
varchar2 |
First approver in the workflow | |||
GIRO |
varchar2 |
Postbank account | |||
GRAY_ |
datetime |
Graydon import date | |||
GRAY_ |
varchar2 |
Graydon credit information | |||
GRAY_ |
int32 |
Graydon credit limit | |||
GRAY_ |
decimal |
Graydon score | |||
HDQ_ |
varchar2 |
Head office | |||
HDQ_ |
char |
Branch office | |||
IBAN_ |
varchar2 |
IBAN 1 | |||
IBAN_ |
varchar2 |
IBAN 2 | |||
ICAT_ |
varchar2 |
IS goods flow category | |||
ICNT_ |
varchar2 |
IS country code | |||
IMM_WF |
char |
Send invoices directly to workflow | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
INV_ |
varchar2 |
Address in country-dependent format (memo) | |||
IS_ |
char |
Relation is my competitor | |||
ISHP_ |
varchar2 |
IS mode of transport | |||
ISXF_ |
varchar2 |
IS statistical factor code | |||
ISYS_ |
varchar2 |
IS regime | |||
ITYP_ |
varchar2 |
IS transaction code | |||
K_ |
datetime |
Chamber of Commerce number verification date | |||
LB_NR |
varchar2 |
Payroll tax number | |||
LB_PCT |
decimal |
Payroll tax percentage | |||
LB_SUB |
varchar2 |
Payroll tax supplier | |||
LNG_ |
varchar2 |
Language code | |||
LNK_ |
varchar2 |
Default account | |||
MAIL_ |
varchar2 |
Business email | |||
MAIL_ |
int32 |
Mailing | |||
MAIN_ |
varchar2 |
Persona di contatto | |||
MAIN_ |
varchar2 |
Main contact person | |||
MAND_ |
char |
Direct debit type: business | |||
MAND_ |
datetime |
Signature date | |||
MAND_ |
varchar2 |
Direct debit mandate reference | |||
MC_ |
varchar2 |
Main contact person salutation | |||
MC_ |
varchar2 |
Main contact person email | |||
MRN_ |
varchar2 |
Partner discount price list | |||
NO_ |
char |
Exclude from workflow | |||
OPP_ |
varchar2 |
Package choice | |||
OPP_ |
varchar2 |
Source | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PAY_ |
varchar2 |
Short company name | |||
PCT_ |
varchar2 |
Discount percentages price list | |||
PD_PFX |
varchar2 |
Payment reference | |||
PG_BLK |
char |
Blocked for automatic payment | |||
PO_BOX |
varchar2 |
Postal address | |||
PO_ |
varchar2 |
Postal address city | |||
PO_ |
varchar2 |
Postal address postcode | |||
POL_ |
decimal |
Delivery priority | |||
POST_ |
varchar2 |
Postcode | |||
PROJ_ |
char |
Project supplier | |||
QD_ |
varchar2 |
Price list code | |||
REC_ |
char |
Blocked | |||
REM_ |
varchar2 |
Suppliers administration address in country-dependent format | |||
REM_ |
char |
Blocked for reminders | |||
REV_ |
varchar2 |
Revenue category | |||
RPL_ |
varchar2 |
Dealer of relation | |||
RPL_ |
varchar2 |
Relation group | |||
RPL_ |
varchar2 |
Invoice customer/supplier | |||
RPL_ |
varchar2 |
Relation type | |||
RPL_ |
char |
Relation is customer | |||
SALE_ |
int64 |
Revenue current year | |||
SALE_ |
int64 |
Revenue previous year | |||
SCAN_ |
varchar2 |
Scanbooks relation no. | |||
SG_ |
varchar2 |
Version | |||
SHIP_ |
char |
No partial deliveries allowed | |||
SHIP_ |
varchar2 |
Transport method | |||
SHOW_ |
char |
Show note when adding purchase order | |||
SHOW_ |
char |
Show note when adding sales order | |||
SIC_ |
varchar2 |
Industry code | |||
SP_ |
int32 |
Address for delivery | |||
SRC_ |
varchar2 |
Company search code | |||
SRC_PC |
varchar2 |
Postcode (quick search) | |||
ST_ |
varchar2 |
Address addition | |||
ST_NR |
varchar2 |
House number | |||
ST_ |
varchar2 |
Building | |||
ST_ |
varchar2 |
Address region | |||
ST_ |
varchar2 |
Nome della via | |||
SUB_NR |
varchar2 |
Customer/supplier number | |||
SYNC_ |
int32 |
Synchronisation status | |||
TEL_ |
varchar2 |
Business telephone | |||
TEL_ |
varchar2 |
Mobile telephone | |||
TRANS_ |
int32 |
Number of transactions | |||
VAT_ |
varchar2 |
Codice IVA | |||
VAT_ |
datetime |
Verification date | |||
VAT_NR |
varchar2 |
Numero di partita IVA | |||
VIS_ |
varchar2 |
Visiting address in country-dependent format (memo) | |||
WF_ |
varchar2 |
IFA employee | |||
WF_ |
char |
Direct posting to cost accounts (IFA) | |||
WWW_ |
varchar2 |
Website |