--- ANALIZA STRUKTURE: FAKTURE I OTPREMNICE --- ========================================================== TABELA/VIEW: Invoice_Doc_Ref ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- ID varchar 50 ID_autoinc int - Attacment varbinary 50 ========================================================== TABELA/VIEW: Invoice_Event ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- id int - EventId int - Date datetime - NewInvoiceStatus varchar 50 SalesInvoiceId int - Comment varchar 250 CirInvoiceId int - SubscriptionKey varchar 250 ========================================================== TABELA/VIEW: Invoice_Header ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- ID varchar 50 IssueDate datetime - DueDate datetime - InvoiceTypeCode char 3 Note text 2147483647 DocumentCurrencyCode char 3 InvoicePeriod char 3 ActualDeliveryDate datetime - ContractDocumentReference varchar 50 BuyerReference nvarchar 50 ProjectReference nvarchar 50 OrderReference nvarchar 50 OriginatorDocumentReference nvarchar 50 DespatchDocumentReference nvarchar 50 AccountingCost nvarchar 50 SupplierAssignedAccountID nvarchar 50 CustomerAssignedAccountID nvarchar 50 CustomerJBKJS nvarchar 5 CustomerName nvarchar 120 CustomerPostalAddress nvarchar 50 CustomerCityName nvarchar 50 CountryCode char 3 CountryName nvarchar 50 PartyLegalEntity nvarchar 50 PaymentTerms nvarchar 50 PaymentMeansCode char 3 PaymentInstructionNote nvarchar 50 PaymentMeansID nvarchar 50 PayeeFinancialAccount nvarchar 50 TaxAmount money - LineExtensionAmount money - TaxExclusiveAmount money - TaxInclusiveAmoun money - AllowanceTotalAmount money - PrepaidAmount money - PayableAmount money - TaxCategory char 6 TaxExemptionReasonCode nvarchar 50 TaxPointDate datetime - InvoiceID nchar 50 SalesInvoiceID nchar 50 eStatus nchar 10 SendDate datetime - EComment varchar 250 InvoiceDocumentReference nvarchar 50 LogError varchar 250 DMSLink varchar 250 SuplierPartyLegalEntity nvarchar 50 sendToCir nchar 10 CustomerPostalZone nchar 10 ========================================================== TABELA/VIEW: Invoice_Line ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- ID varchar 50 InvoiceLineID char 10 InvoicedQuantity money - PriceAmount money - AllowanceChargeIndicator int - AllowanceMultiplierFactor money - AllowanceAmount money - LineExtensionAmount money - TaxableAmount money - TaxAmount money - TaxCategory char 6 Percent money - Description nvarchar 150 Name nvarchar 200 SellersItemIdentification nvarchar 50 UnitCode nchar 3 ========================================================== TABELA/VIEW: Invoice_Prepayment ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- ID varchar 50 ID_preayment varchar 50 TaxAmount money - TaxableAmount money - TaxCategory char 6 TaxPercent money - IssueDate_prepayment datetime - ========================================================== TABELA/VIEW: Invoice_Reduced ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- ID varchar 50 TaxAmount money - TaxableAmount money - TaxExclusiveAmount money - TaxInclusiveAmount money - PayableAmount money - TaxCategory char 6 TaxPercent money - ========================================================== TABELA/VIEW: Invoice_Setup ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- PartyLegalEntity nvarchar 50 SupplierAssignedAccountID nvarchar 50 ApiKey nvarchar 50 BaseURL nvarchar 50 Name nvarchar 50 CityName nvarchar 50 DMS_link varchar 250 DMS_API_link varchar 250 DMS_S_Invoice varchar 250 DMS_user nchar 50 DMS_password nchar 50 BasePURL nchar 100 BaseSURL nchar 100 Local_API_host nchar 50 Local_API_port smallint - Local_API_base_url nchar 100 SupplierPostalAddress nchar 50 SupplierPostalZone nchar 10 BaseOURL nchar 100 ========================================================== TABELA/VIEW: Invoice_Tax_Total ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- ID varchar 50 TaxPercent money - TaxableAmount money - TaxAmount money - TaxCategory char 6 TaxExamptionReasonCode nvarchar 20 ========================================================== TABELA/VIEW: PInvoice_Event ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- id int - EventId int - Date datetime - NewInvoiceStatus varchar 50 PurchaseInvoiceId int - Comment varchar 250 CirInvoiceId int - SubscriptionKey varchar 250 StornoNumber varchar 50 LimesStatus int - ========================================================== TABELA/VIEW: PInvoice_Header ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- PurchaseInvoiceID nchar 50 ID nvarchar 120 IssueDate datetime - DueDate datetime - InvoiceTypeCode nvarchar 200 Note text 2147483647 DocumentCurrencyCode char 3 InvoicePeriod char 3 ActualDeliveryDate datetime - ContractDocumentReference nvarchar 200 BuyerReference nvarchar 200 ProjectReference nvarchar 200 OrderReference nvarchar 200 OriginatorDocumentReference nvarchar 200 DespatchDocumentReference nvarchar 200 AccountingCost nvarchar 200 SupplierAssignedAccountID nvarchar 50 SupplierJBKJS nvarchar 20 SupplierName nvarchar 500 SupplierPostalAddress nvarchar 500 SupplierCityName nvarchar 200 SupplierCountryCode char 3 SupplierCountryName nvarchar 50 CustomerAssignedAccountID nvarchar 50 CustomerJBKJS nvarchar 20 CustomerName nvarchar 500 CustomerPostalAddress nvarchar 500 CustomerCityName nvarchar 200 CountryCode char 3 CountryName nvarchar 50 PartyLegalEntity nvarchar 50 PaymentTerms nvarchar 200 PaymentMeansCode nvarchar 200 PaymentInstructionNote nvarchar 50 PaymentMeansID nvarchar 50 TaxAmount money - LineExtensionAmount money - TaxExclusiveAmount money - TaxInclusiveAmoun money - AllowanceTotalAmount money - PrepaidAmount money - PayableAmount money - TaxCategory char 6 TaxExemptionReasonCode nvarchar 50 TaxPointDate datetime - InvoiceID nchar 50 eStatus nchar 10 SendDate datetime - EComment varchar 250 InvoiceDocumentReference nvarchar 50 LogError varchar 250 DMSLink varchar 250 SuplierPartyLegalEntity nvarchar 50 PayeeFinancialAccount nchar 250 SifKomint char 6 RbrNarudzbenice int - RbrKalk int - RbrTrkalk int - RbrKnjLista int - RbrPovracajaDob int - RbrAvansRn int - SifPlacanja char 2 KontoTroska char 10 KontoTroska2 char 10 SifraMestaTroska char 3 TipRefDok char 6 BrUgovora int - BrUgovora2 int - RbrPrijemnice int - RbrNaloga int - Knjizen int - StatusOdobrenja nvarchar 10 Napomena char 50 TipDokumenta varchar 6 IzNaLokaciju varchar 10 StatusZaSEF nvarchar 10 KomentarZaSef nchar 100 PoslaoNaSef nchar 10 DatumSlanja datetime - AvansniPDV money - Procenat money - MT2 nchar 3 Procenat2 money - MT3 nchar 3 Procenat3 money - MT4 nchar 3 Procenat4 money - MT5 nchar 3 Procenat5 money - MT6 nchar 3 Procenat6 money - Napomena2 nchar 50 KomentarOdobravanja nchar 100 NepotpunaDokumentacija int - PoslednjiStatus nchar 10 KnjizenjePoDPO int - CreationDate datetime - ========================================================== TABELA/VIEW: PInvoice_Line ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- PurchaseInvoiceID nchar 50 ID nvarchar 120 InvoiceLineID char 10 InvoicedQuantity money - PriceAmount money - AllowanceChargeIndicator int - AllowanceMultiplierFactor money - AllowanceAmount money - LineExtensionAmount money - TaxableAmount money - TaxAmount money - TaxCategory char 6 Percent money - Description nvarchar 1800 Name nvarchar 1800 SellersItemIdentification nvarchar 1800 UnitCode nchar 3 ========================================================== TABELA/VIEW: PInvoice_Prepayment ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- PurchaseInvoiceID nchar 50 ID nvarchar 120 ID_preayment nvarchar 120 TaxAmount money - TaxableAmount money - TaxCategory char 6 TaxPercent money - IssueDate_prepayment datetime - ========================================================== TABELA/VIEW: PInvoice_Reduced ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- PurchaseInvoiceID nchar 50 ID nvarchar 120 TaxAmount money - TaxableAmount money - TaxExclusiveAmount money - TaxInclusiveAmount money - PayableAmount money - TaxCategory char 6 TaxPercent money - ========================================================== TABELA/VIEW: PInvoice_Tax_Total ---------------------------------------------------------- KOLONA TIP DUŽINA ---------------------------------------------------------- PurchaseInvoiceID nchar 50 ID nvarchar 120 TaxPercent money - TaxableAmount money - TaxAmount money - TaxCategory char 6 TaxExamptionReasonCode nvarchar 20