CONTACT: AccountView Companies (basic data)
read only per partition
- Katalog:
AccountView - Label: Companies (basic data)
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle CONTACT sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
int64 |
Balance | |||
ACCT_ |
int64 |
Balance payable | |||
ACCT_ |
int32 |
Control account type | |||
ACCT_ |
varchar2 |
Firmennamen | |||
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 |
Geändert von | |||
CNT_ |
varchar2 |
ISO country code | |||
COC_ |
varchar2 |
Handelsregisternummer | |||
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 |
Kontaktperson | |||
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 |
Straßenname | |||
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 |
Umsatzsteuer-IDNr. | |||
VAT_ |
datetime |
Verification date | |||
VAT_NR |
varchar2 |
Umsatzsteuer-Identifikationsnummer | |||
VIS_ |
varchar2 |
Visiting address in country-dependent format (memo) | |||
WF_ |
varchar2 |
IFA employee | |||
WF_ |
char |
Direct posting to cost accounts (IFA) | |||
WWW_ |
varchar2 |
Website |