|
Data dictionary y_vattrs - VAT codes - 7.20
1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | 2 | adm_nr | integer | >>>>>9 | | | ? | Company | 3 | vat_code | character | x(3) | | | 0 | VAT code | 4 | descr | character | X(60) | | | | Description | 5 | code_ps | integer | >>>>>9 | | | 0 | Purchase/Sales | 6 | vat_transfer | logical | yes/no | | | no | VAT charged | 7 | vat_perc | decimal | ->>9.99 | 2 | | 0 | VAT percentage | 8 | vat_descr | character | x(16) | | | | Description VAT percentage | 9 | exclus | integer | >>>>>9 | | | 0 | Excluding/Including | 10 | country | character | x(3) | | | | Country EC sales list | 11 | vat_listing | integer | >>>>>9 | | | 0 | EC Sales List | 12 | acc_nr | character | x(12) | | | | Account VAT to claim | 13 | acc_nr_vat_sales | character | x(12) | | | | Account VAT to pay | 14 | acc_nr_contra | character | x(12) | | | | Offset account | 15 | credit_note | logical | yes/no | | | no | Credit note | 16 | cred_vat_code | character | x(3) | | | | VAT code credit notes | 17 | vat_appro | logical | yes/no | | | yes | VAT applicable | 18 | descr_ml | character | X(60) | | 5 | | ML description | 19 | source_lc | character | x(12) | | | | | 20 | time_lc | integer | ->,>>>,>>9 | | | ? | | 21 | date_lc | date | 99/99/9999 | | | | | 22 | euserid_lc | character | X(12) | | | | | 23 | type_lc | character | x(8) | | | | | 24 | vat_perc_comp | decimal | >>9.99 | 2 | | 0 | Compensation percentage | 25 | vat_perc_non_deduct | decimal | >>9.99 | 2 | | 0 | Non deductible | 26 | acc_nr_comp | character | x(12) | | | | Compensation g/l account | 27 | vat_perc_claim | decimal | >>9.99 | 2 | | 0 | Percentage VAT to claim | 28 | entity_state | integer | >>>>>9 | | | 0 | State | 29 | term_id | integer | >>>>>>>9 | | | 0 | Term ID |
Indexesy_vattrsix - primary - unique1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_vattrs1ix - unique1 | adm_nr | integer | >>>>>9 | Company | 2 | vat_code | character | x(3) | VAT code | 3 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_vattrs
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.894 |
Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
Release: |
|
Attachment: |
|
Disclaimer |
|
|