|
Data dictionary y_admdat - Company data - 7.20
1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | 2 | adm_nr | integer | >>>>>9 | | | ? | Company | 3 | adm_nr_refxxx | integer | >>9 | | | 0 | Company | 4 | adm_name | character | X(60) | | | | Description | 5 | adm_mother | integer | >>>>>9 | | | 0 | Base company | 6 | surname | character | X(60) | | | | Name | 7 | address | character | X(60) | | | | Address line 1 | 8 | address_2 | character | X(60) | | | | Address line 2 | 9 | address_3 | character | X(60) | | | | Address line 3 | 10 | postal_code | character | x(8) | | | | Postcode | 11 | city | character | X(60) | | | | City | 12 | country | character | x(3) | | | | Country | 13 | contact | character | X(60) | | | | Contact | 14 | telephone | character | x(15) | | | | Telephone | 15 | fax_nr | character | x(15) | | | | Telefax | 16 | interface | character | x(6) | | | | Interface | 17 | e_mail | character | X(60) | | | | E-mail | 18 | telex_nr | character | x(10) | | | | Telex number | 19 | acc_nr_bank | character | x(34) | | | | Bank account | 20 | postbank_acc_nr | character | x(34) | | | | Postbank | 21 | kvk_nummer | character | X(10) | | | | Chamber of Commerce number | 22 | coc_city | character | X(60) | | | | Chamber of Commerce city | 23 | vat_nr | character | x(20) | | | | VAT number | 24 | lb_nummer | character | x(20) | | | | Income tax number | 25 | fiscal_nr | character | x(12) | | | | Fiscal ID | 26 | corr_address | character | X(60) | | | | Address line 1 | 27 | corr_address_2 | character | X(60) | | | | Address line 2 | 28 | corr_address_3 | character | X(60) | | | | Address line 3 | 29 | corr_postal_code | character | x(8) | | | | Postcode | 30 | corr_city | character | X(60) | | | | City | 31 | corr_country | character | x(3) | | | | Country | 32 | corr_contact | character | X(60) | | | | Contact | 33 | curr_code | character | x(3) | | | | Currency | 34 | bgc_adm_nr | integer | >>>>>>9 | | | 0 | BGC company | 35 | batchlevel | integer | >>>>>9 | | | 0 | Batch level | 36 | source_lc | character | x(12) | | | | | 37 | time_lc | integer | ->,>>>,>>9 | | | ? | | 38 | date_lc | date | 99/99/9999 | | | | | 39 | euserid_lc | character | X(12) | | | | | 40 | type_lc | character | x(8) | | | | | 41 | xxxLicNumber | decimal | >>>>>>>>>>9 | 0 | | 0 | License number | 42 | xxxLicSeq | integer | >>9 | | | 0 | Sequence | 43 | bnk_curr_code | character | x(3) | | | | Currency code of bank account number | 44 | siret_number | character | x(20) | | | | Siret number | 45 | func_desc | character | x(30) | | | | Position | 46 | website | character | X(160) | | | | Website | 47 | information | character | X(2000) | | | | Company information | 48 | ext_file | character | X(80) | | | | External file | 49 | deleted | logical | yes/no | | | no | Deleted | 50 | type_company | integer | >>>>>9 | | | 0 | Company type | 51 | house_nr | integer | >>>>>9 | | | 0 | House number | 52 | house_nr_addition | character | X(8) | | | | House number addition | 53 | lang_code | character | x(3) | | | | Language | 54 | corr_house_nr | integer | >>>>>9 | | | 0 | House number | 55 | corr_house_nr_addition | character | X(8) | | | | House number addition | 56 | corr_lang_code | character | x(3) | | | | Language | 57 | wc_stylesheet | integer | >>>>>9 | | | 0 | WebClient: Stylesheet | 58 | vat_nr_fiscal_unit | character | X(20) | | | | Fiscal unit: VAT number | 59 | xml_definition_vat | character | x(12) | | | | XML definition code | 60 | stylesheet_vat | integer | >>>>>9 | | | 0 | Stylesheet | 61 | contact_type | integer | >>>>>9 | | | 0 | Contact type | 62 | contact_id | character | X(15) | | | | Contact ID | 63 | contact_name | character | X(30) | | | | Name | 64 | contact_telephone | character | X(30) | | | | Contact: Telephone |
Indexesy_admdatix - primary - unique1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_admdat1ix - unique1 | adm_nr | integer | >>>>>9 | Company | 2 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_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.701 |
Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
Release: |
|
Attachment: |
|
Disclaimer |
|
|