Fisier Incarcare Coduri clasificare =================================== +------+-------------+---------+---------+-----------+---------+---------+ | Nr. | Camp | Tip | Dimens | Valori | Observa | Obligat | | crt | | | | implicite | tii | oriu | +------+-------------+---------+---------+-----------+---------+---------+ | 1 | Firma | N | 3 | | | DA | +------+-------------+---------+---------+-----------+---------+---------+ | 2 | Cod | C | 20 | | | DA | | | Clasificare | | | | | | | | care | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 3 | Cod | C | 20 | | | DA | | | sortare | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 4 | Cod | C | 20 | | | NU | | | tata | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 5 | Durata | N | 3 | | | NU | | | normala | | | | | | | | utilizare | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 6 | Indicator | C | 10 | A/B | | DA | | | mijloc | | | | | | | | fix | | | | | | | | Baza / | | | | | | | | Auxiliar | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 7 | Denumire | C | 180 | | | DA | | | Cod | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 8 | Data | D | | | | DA | | | inceput | | | | | | | | activitate | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 9 | Data | D | | | | DA | | | Sfarsit | | | | | | | | activitate | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 10 | Data | D | | | | DA | | | ultimei | | | | | | | | actualizari | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 11 | Nume | C | 30 | | | DA | | | utilizator | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 12 | Stare | C | 10 | ACTIV / | | DA | | | | | | BLOCAT | | | +------+-------------+---------+---------+-----------+---------+---------+ | 13 | Ultimul | C | 2 | DA / NU | | DA | +------+-------------+---------+---------+-----------+---------+---------+ | 14 | Tip | C | 20 | MIJLOACE | | DA | | | imobilizare | | | FIXE | | | +------+-------------+---------+---------+-----------+---------+---------+ | 15 | Cont | C | 32 | | Ex. 212 | NU | | | imobilizare | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 16 | Cont | C | 32 | | Ex. 281 | NU | | | amortizare | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 17 | Activitate | C | 2 | DA/NU | | NU | | | mentenanta | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 18 | Cod | C | 20 | | | NU | | | clasificare | | | | | | | | vechi | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 19 | Camp | C | | | | | | | liber | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 20 | Camp | C | | | | | | | liber | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 21 | Camp | C | | | | | | | liber | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 22 | DN | N | 3 | | | NU | | | Inferioara | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 23 | DN | N | 3 | | | NU | | | Superioara | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 24 | DN in | N | 7 | | | NU | | | Km | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 25 | DN in | N | 7 | | | NU | | | Ore | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 26 | DN | N | 3 | | | NU | | | veche | | | | | | | | (HG964) | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 27 | Camp | C | | | | | | | liber | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ | 28 | Camp | C | | | | | | | liber | | | | | | +------+-------------+---------+---------+-----------+---------+---------+ Tip camp: C caracter N numeric D data Coloanele de tip caracter sau data se pun intre ghilimele duble("). Coloanele de tip numeric care nu sunt obligatorii se completeaza cu 0 (zero). Coloanele de tip caracter care nu sunt obligatorii se completeaza cu " " (spatiu). Coloanele de tip data calendaristica care nu sunt obligatorii se completeaza cu . Coloanele se despart printr-un singur spatiu. Coloanele de tip data trebuie sa aiba formatul: zz/ll/aaaa . Dupa completarea informatiilor intr-un fisier .xls acesta se va salva in format .csv sau .txt, cu alegerea delimitarii prin spatiu.