|
|
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 - unique| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_admdat1ix - unique| 1 | 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 |
|
|