|
|
Data dictionary admdat - Company data
| 1 | adm-nr | integer | >>>>>9 | | | ? | Company | | 2 | adm-nr-refxxx | integer | >>9 | | | 0 | Company | | 3 | adm-name | character | X(60) | | | | Description | | 4 | adm-mother | integer | >>>>>9 | | | 0 | Master company | | 5 | surname | character | X(60) | | | | Name | | 6 | address | character | X(60) | | | | Address line 1 | | 7 | address-2 | character | X(60) | | | | Address line 2 | | 8 | address-3 | character | X(60) | | | | Address line 3 | | 9 | postal-code | character | x(8) | | | | Postcode | | 10 | city | character | X(60) | | | | City | | 11 | country | character | x(3) | | | | Country | | 12 | contact | character | X(60) | | | | Contact | | 13 | telephone | character | x(15) | | | | Telephone | | 14 | fax-nr | character | x(15) | | | | Telefax | | 15 | interface | character | x(6) | | | | Interface | | 16 | e-mail | character | X(60) | | | | E-mail | | 17 | telex-nr | character | x(10) | | | | Telex number | | 18 | acc-nr-bank | character | x(34) | | | | Bank account | | 19 | postbank-acc-nr | character | x(34) | | | | Postbank | | 20 | kvk-nummer | character | X(10) | | | | Chamber of Commerce number | | 21 | coc-city | character | X(60) | | | | Chamber of Commerce city | | 22 | vat-nr | character | x(20) | | | | VAT number | | 23 | lb-nummer | character | x(20) | | | | Income tax number | | 24 | fiscal-nr | character | x(9) | | | | Fiscal ID | | 25 | corr-address | character | X(60) | | | | Address line 1 | | 26 | corr-address-2 | character | X(60) | | | | Address line 2 | | 27 | corr-address-3 | character | X(60) | | | | Address line 3 | | 28 | corr-postal-code | character | x(8) | | | | Postcode | | 29 | corr-city | character | X(60) | | | | City | | 30 | corr-country | character | x(3) | | | | Country | | 31 | corr-contact | character | X(60) | | | | Contact | | 32 | curr-code | character | x(3) | | | | Currency | | 33 | bgc-adm-nr | integer | >>>>>>9 | | | 0 | BGC company | | 34 | batchlevel | integer | >>>>>9 | | | 0 | Batch level | | 35 | source-lc | character | x(8) | | | | | | 36 | time-lc | integer | ->,>>>,>>9 | | | 0 | | | 37 | date-lc | date | 99/99/9999 | | | | | | 38 | euserid-lc | character | X(12) | | | | | | 39 | type-lc | character | x(8) | | | | | | 40 | xxxLicNumber | decimal | >>>>>>>>>>9 | 0 | | 0 | License number | | 41 | xxxLicSeq | integer | >>9 | | | 0 | Sequence | | 42 | bnk-curr-code | character | x(3) | | | | Currency code of bank account number | | 43 | siret_number | character | x(20) | | | | Siret number | | 44 | func_desc | character | x(30) | | | | Position | | 45 | website | character | X(160) | | | | Website | | 46 | information | character | X(2000) | | | | Company information | | 47 | ext_file | character | X(80) | | | | External file | | 48 | deleted | logical | yes/no | | | no | Deleted | | 49 | type_company | integer | >>>>>9 | | | 0 | Company type | | 50 | house_nr | integer | >>>>>9 | | | 0 | House number | | 51 | house_nr_addition | character | X(8) | | | | House number addition | | 52 | lang_code | character | x(3) | | | | Language | | 53 | corr_house_nr | integer | >>>>>9 | | | 0 | House number | | 54 | corr_house_nr_addition | character | X(8) | | | | House number addition | | 55 | corr_lang_code | character | x(3) | | | | Language | | 56 | wc_stylesheet | integer | >>>>>9 | | | 0 | WebClient: Stylesheet | | 57 | vat_nr_fiscal_unit | character | X(20) | | | | Fiscal unit: VAT number | | 58 | xml_definition_vat | character | X(8) | | | | XML definition code | | 59 | stylesheet_vat | integer | >>>>>9 | | | 0 | Stylesheet | | 60 | contact_type | integer | >>>>>9 | | | 0 | Contact type | | 61 | contact_id | character | X(15) | | | | Contact ID | | 62 | contact_name | character | X(30) | | | | Name | | 63 | contact_telephone | character | X(30) | | | | Contact: Telephone |
Indexesadmdatix - primary - unique| 1 | adm-nr | integer | >>>>>9 | Company |
admdat02ix| 1 | adm-mother | integer | >>>>>9 | Master company | | 2 | adm-nr | integer | >>>>>9 | Company |
Contents > admdat
| Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
25.809.102 |
| Assortment: |
Exact Financials
|
Date: |
30-04-2014 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|