|
Data dictionary admdat - Company data - 7.20
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(12) | | | | 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(12) | | | | | 36 | time_lc | integer | ->,>>>,>>9 | | | ? | | 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(12) | | | | 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 - unique1 | adm_nr | integer | >>>>>9 | Company |
admdat02ix1 | 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: |
26.936.147 |
Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
Release: |
|
Attachment: |
|
Disclaimer |
|
|