Structura Fisierului de Incarcare Obiecte, Contracte , Furnizori - fara Cereri de Cumparare =========================================================================================== Scop ---- Completarea obiectelor, contractelor pe furnizori pe obiectivele cu stare Deschis sau Aproate in cazul in care fluxul investional este setat sa functioneze fara cereri de cumparare. Prerechizite ------------ - Plan de investitii, cu versiune de tip: In Lucru sau Aprobata - Obiective definite - Proiecte definite - Nomenclator de servicii si de articole - Obiecte de Cost - Comenzi de lucru in contabilitatea de gestiune - Cereri / Comenzi de cumparare in Logistica +-----------+-----------+-----------+-----------+-----------+-----------+ | Nume Camp | Tip | Dimensiun | Obligator | Unde se | Mod | | | | e | iu | valideaza | Completar | | | | | de | | e | | | | | completat | | | | | | | in fisier | | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Caracter | Caracter | 60 | DA | Obiective | | | | | | | - Profil | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Obiect | Caracter | 60 | DA | Obiectve | | | | | | | - Obiecte | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Ermarire | Caracter | 10 | DA | Obiective | Valori | | Executie | | | | - Obiecte | posibile: | | | | | | | Cumparari | | | | | | | , | | | | | | | PJ/WBS, | | | | | | | Comanda, | | | | | | | Ob\_ | | | | | | | Cost, | | | | | | | Declarat | +-----------+-----------+-----------+-----------+-----------+-----------+ | Articol/S | Caracter | 10 | DA/NU | | Numai | | erviciu | | | | | daca | | | | | | | Urmarie | | | | | | | Executie | | | | | | | = | | | | | | | Cumparari | | | | | | | | | | | | | | Valori | | | | | | | posibile: | | | | | | | Servicu, | | | | | | | Articol | +-----------+-----------+-----------+-----------+-----------+-----------+ | Proiect | Caracter | 12 | DA/NU | Proiecte | Numai | | | | | | | daca | | | | | | | Urmarie | | | | | | | Executie | | | | | | | = PJ/WBS | +-----------+-----------+-----------+-----------+-----------+-----------+ | Task | Caracter | | DA/NU | Proiecte- | Numai | | Proiect | | | | WBS | daca | | | | | | | Urmarie | | | | | | | Executie | | | | | | | = PJ/WBS | +-----------+-----------+-----------+-----------+-----------+-----------+ | Nr.Comand | Caracter | 14 | DA/NU | Contabili | Numai | | a | | | | tatea | daca | | Interna | | | | Costurilo | Urmarie | | | | | | r | Executie | | | | | | Comenzi | = Comanda | | | | | | de lucru | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Zona | Numeric | 10,2 | DA/NU | Obiecte | Numai | | | | | | de Cost- | daca | | | | | | Zone - | Urmarie | | | | | | cod Zona | Executie | | | | | | | = Ob_Cost | +-----------+-----------+-----------+-----------+-----------+-----------+ | Purtator | Caracter | 32 | DA/NU | Obiecte | Numai | | | | | | de Cost- | daca | | | | | | Purtatori | Urmarie | | | | | | - | Executie | | | | | | Cod | = Ob_Cost | | | | | | Purtator | | +-----------+-----------+-----------+-----------+-----------+-----------+ | CPV | Caracter | 10 | NU | Nomenclat | | | | | | | or | | | | | | | CPV | | +-----------+-----------+-----------+-----------+-----------+-----------+ | UM | Caracter | 10 | NU | Obiective | | | | | | | - Obiecte | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Cantitate | Numeric | 12,3 | NU | Obiective | | | | | | | - Obiecte | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Pret | Numeric | 10.2 | NU | Obiective | | | | | | | - Obiecte | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Valoare | Numeric | 16.2 | DA | Obiective | | | Obiect | | | | - Obiecte | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Valoare | Numeric | 16.2 | DA | Obiective | | | Baza | | | | - Obiecte | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Cod | Caracter | 20 | DA | Parteneri | | | Furnizor | | | | \_Cod | | | | | | | furnizor | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Categorie | Caracter | 15 | DA | Setari - | | | Furnizor | | | | Nomenclat | | | | | | | oare | | | | | | | - Tip | | | | | | | Furnizor | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Nr | Caracter | 14 | DA | Comenzi | | | Comanda | | | | Clienti | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Linie | Caracter | 3 | DA | | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Numar | Caracter | 20 | DA | | | | Contract | | | | | | +-----------+-----------+-----------+-----------+-----------+-----------+ | Anul | Caracter | 6 | DA | | | +-----------+-----------+-----------+-----------+-----------+-----------+