Feiten

Package RDBMS Dataentiteiten
Auteur Bert Dingemans
Alias
Stereotypes table

Attributes

Name Type Cardinality Description
%LocatieId #mincard# - #maxcard#
%Kostenplaats #mincard# - #maxcard#
%DimItemID #mincard# - #maxcard#
%Datum #mincard# - #maxcard#
MP.L12MKEY #mincard# - #maxcard#
MP.ITEMID #mincard# - #maxcard#
%KeyDekkingsPrijs_ServiceObject_HoofdObjectId #mincard# - #maxcard#
%KeyDekkingsPrijs_ServiceObject_ObjectId #mincard# - #maxcard#
%KeyDekkingsPrijs_ServiceObject #mincard# - #maxcard#
DueDate #mincard# - #maxcard#
ServiceObject_ArtikelNummer #mincard# - #maxcard#
ServiceObject_Betaler #mincard# - #maxcard#
ServiceObjectText #mincard# - #maxcard#
_RecordType #mincard# - #maxcard#
Invoiced #mincard# - #maxcard#
Factuurdatum #mincard# - #maxcard#
FactuurJaarMaand #mincard# - #maxcard#
FactuurJaar #mincard# - #maxcard#
FactuurDatumPast12MonthsFlag #mincard# - #maxcard#
ActualsOrBudget #mincard# - #maxcard#
FactuurNummer #mincard# - #maxcard#
MeldingStatus #mincard# - #maxcard#
Grootboeknummer #mincard# - #maxcard#
IsSana #mincard# - #maxcard#
IsProject #mincard# - #maxcard#
MeldingTypeId #mincard# - #maxcard#
MeldingType #mincard# - #maxcard#
ArtikelTeller #mincard# - #maxcard#
OmzetGroep #mincard# - #maxcard#
OmzetStroom #mincard# - #maxcard#
OmzetType #mincard# - #maxcard#
Bedrag #mincard# - #maxcard#
BedragZonderToeslag #mincard# - #maxcard#
CustomerBK #mincard# - #maxcard#
ToBeInvoiced #mincard# - #maxcard#
Kostprijs #mincard# - #maxcard#
Grootboeknummer_kosten #mincard# - #maxcard#
Artikelnummer #mincard# - #maxcard#
Artikelomschrijving #mincard# - #maxcard#
MinMax #mincard# - #maxcard#
MachineTypeDescription #mincard# - #maxcard#
ContractTypeId #mincard# - #maxcard#
InvoiceGroupId #mincard# - #maxcard#
LineType #mincard# - #maxcard#
Bedrag_Korting #mincard# - #maxcard#
Bedrag_Bruto #mincard# - #maxcard#
Ordertype #mincard# - #maxcard#
Ordertype_desc #mincard# - #maxcard#
Pool #mincard# - #maxcard#
Bedrag_Eindkorting #mincard# - #maxcard#
Verkoopordernummer #mincard# - #maxcard#
Artikelgroepcode #mincard# - #maxcard#
ServiceObjectStatus #mincard# - #maxcard#
ServiceObjectActief #mincard# - #maxcard#
Contractnummer_melding #mincard# - #maxcard#
MeldingContractNummerFlag #mincard# - #maxcard#
Duedate_reference_year #mincard# - #maxcard#
RentalOrderBK #mincard# - #maxcard#
BrutoBedrag #mincard# - #maxcard#
LijnKorting #mincard# - #maxcard#
PROJTRANSIDREF #mincard# - #maxcard#
ServiceCallBK #mincard# - #maxcard#
FDKostenplaatsBK #mincard# - #maxcard#
DimCustomerID #mincard# - #maxcard#
DimCompanyID #mincard# - #maxcard#
DimServiceCallID #mincard# - #maxcard#
DimItemID #mincard# - #maxcard#
DimServiceObjectID #mincard# - #maxcard#
HB-Artikelnummer #mincard# - #maxcard#
Hoofdobject_melding #mincard# - #maxcard#
%Key_DekkingsPrijs #mincard# - #maxcard#
IsInvoicedFlag #mincard# - #maxcard#
Projectfase #mincard# - #maxcard#
ProjectfaseNaam #mincard# - #maxcard#
ProjKlantrekening #mincard# - #maxcard#
MeldingCreatedDate #mincard# - #maxcard#
Afgesloten #mincard# - #maxcard#
Besteld wacht op factuur #mincard# - #maxcard#
Bestellen onderdelen #mincard# - #maxcard#
Geannuleerd #mincard# - #maxcard#
Gepland bevestigd #mincard# - #maxcard#
Gepland niet bevestigd #mincard# - #maxcard#
Monteur afgehandeld #mincard# - #maxcard#
Monteur onderhanden #mincard# - #maxcard#
Monteur teruggemeld #mincard# - #maxcard#
Nieuw #mincard# - #maxcard#
Offerte opstellen #mincard# - #maxcard#
Offerte verzonden #mincard# - #maxcard#
Te plannen #mincard# - #maxcard#
Wacht op factuur #mincard# - #maxcard#
Wacht op leverancier #mincard# - #maxcard#
Wacht op onderdelen #mincard# - #maxcard#
Wacht op reactie #mincard# - #maxcard#
Afwijking_TotaalMeldingbedrag #mincard# - #maxcard#
MeldingIsInvoiced #mincard# - #maxcard#
Uitvoerdatum #mincard# - #maxcard#
SanaProjectRegulier #mincard# - #maxcard#
IsHuurFlag #mincard# - #maxcard#
Factureerbaar? #mincard# - #maxcard#
NTFO_YES_FLAG #mincard# - #maxcard#
ServiceObject_HoofdObjectId #mincard# - #maxcard#
ServiceObject_HoofdObject #mincard# - #maxcard#
ServiceObject_ObjectTypeId #mincard# - #maxcard#
ServiceObject_StandaardPrijs #mincard# - #maxcard#
ServiceObject_ObjectType #mincard# - #maxcard#
ServiceObject_ProjectIntegratieId #mincard# - #maxcard#
ServiceObject_ActieCode #mincard# - #maxcard#
ServiceObject_EPL2021 #mincard# - #maxcard#
ServiceObject_EPL2020 #mincard# - #maxcard#
ServiceObject_EPL2019 #mincard# - #maxcard#
ServiceObject_EPL2018 #mincard# - #maxcard#
ServiceObject_InvoiceGroup #mincard# - #maxcard#
ServiceObject_ContractNummer #mincard# - #maxcard#
ServiceObject_EPL_CurrentYear #mincard# - #maxcard#
ServiceObject_StandaardUren #mincard# - #maxcard#
ServiceObject_ContractKlantNaam #mincard# - #maxcard#
HandelsPrijs_Financieel #mincard# - #maxcard#
ContractWaarde #mincard# - #maxcard#
ServiceObject_StandaardPrijs_In_Planjaar #mincard# - #maxcard#
DekkingsPrijs_ServiceObject #mincard# - #maxcard#
DekkingsPrijs_ServiceObject_ObjectId #mincard# - #maxcard#
DekkingsPrijs_ServiceObject_HoofdObjectId #mincard# - #maxcard#
HeeftAfwijkendBedrag #mincard# - #maxcard#
AfwijkingsPercentage #mincard# - #maxcard#
ServiceObject_DekkingsPrijs #mincard# - #maxcard#
Crosscheck #mincard# - #maxcard#
ServiceObject_HartingBankIsContactnaamFlag #mincard# - #maxcard#
ServiceObject_Eigenaar #mincard# - #maxcard#
ServiceObject_QV_ContractType #mincard# - #maxcard#
MP.SLA_prestatie #mincard# - #maxcard#
MP.Last12MonthsFlag #mincard# - #maxcard#
MP.JaarMaand #mincard# - #maxcard#
OverdueFlag #mincard# - #maxcard#
MP.TAAK_dagen_openstaand #mincard# - #maxcard#
MP.MELDING_dagen_openstaand #mincard# - #maxcard#
MP.Voorraad_flag #mincard# - #maxcard#
MP.MeldingIsInvoiced #mincard# - #maxcard#
MP.Taakregel #mincard# - #maxcard#
MP.QV.ExecutionStatusTaak #mincard# - #maxcard#
MP.DagenOpenMateriaal #mincard# - #maxcard#
MP.Surrogate_Key_RESERVED #mincard# - #maxcard#
RepCorTelefonischArtikelToegevoegd #mincard# - #maxcard#
MP.Sim_responsdag #mincard# - #maxcard#
MP.MAX_ATP_SIM_Werkdagen #mincard# - #maxcard#
MP.Taaknummer #mincard# - #maxcard#
MP.Meldingsnummer #mincard# - #maxcard#
MP.Responsafspraak #mincard# - #maxcard#
MP.Bestelvertraging #mincard# - #maxcard#
MP.Leverprestatie #mincard# - #maxcard#
MP.Responstijd #mincard# - #maxcard#
MP.Leverbetrouwbaarheid #mincard# - #maxcard#
MP.Procesfout #mincard# - #maxcard#
MP.Responstijd_in_dagen #mincard# - #maxcard#
MP.Verbruiksprofiel #mincard# - #maxcard#
MP.JaarMeldingCreatie #mincard# - #maxcard#
MP.Gecreƫerd #mincard# - #maxcard#
MP.Bevestigde verzenddatum #mincard# - #maxcard#
MP.Ritdatum #mincard# - #maxcard#
MP.PakbonVerzenddatum #mincard# - #maxcard#
MP.Berekend(werkelijk) #mincard# - #maxcard#
MP.Jaar #mincard# - #maxcard#
MP.ATP_SIM_Werkdagen #mincard# - #maxcard#
MP.Maand #mincard# - #maxcard#
MP.ResponsTime_WorkingDays #mincard# - #maxcard#
MP.SERVICEOBJECTID #mincard# - #maxcard#
MP.MeldingContractNummerFlag #mincard# - #maxcard#
MP.DateBK #mincard# - #maxcard#
MP.CustomerBK #mincard# - #maxcard#
MP.EmployeeBK #mincard# - #maxcard#
MP.CompanyBK #mincard# - #maxcard#
MP.ServiceObjectBK #mincard# - #maxcard#
MP.CallTypeBK #mincard# - #maxcard#
MP.ServiceRegionBK #mincard# - #maxcard#
MP.ServiceCallBK #mincard# - #maxcard#
MP.VWCustObjectBK #mincard# - #maxcard#
MP.FDKostenplaatsBK #mincard# - #maxcard#
MP.ResponseTime #mincard# - #maxcard#
MP.ProcessTime #mincard# - #maxcard#
MP.CProcessTime #mincard# - #maxcard#
MP.Tasks #mincard# - #maxcard#
MP.CallNum #mincard# - #maxcard#
MP.CreatedDate_melding #mincard# - #maxcard#
MP.ResponseDate #mincard# - #maxcard#
MP.CallClosedDate #mincard# - #maxcard#
MP.PurchaseOrder #mincard# - #maxcard#
MP.Klantrekening #mincard# - #maxcard#
MP.DimDateID #mincard# - #maxcard#
MP.DimCustomerID #mincard# - #maxcard#
MP.DimEmployeeID #mincard# - #maxcard#
MP.DimCompanyID #mincard# - #maxcard#
MP.DimServiceObjectID #mincard# - #maxcard#
MP.DimCallTypeID #mincard# - #maxcard#
MP.DimServiceRegionID #mincard# - #maxcard#
MP.DimServiceCallID #mincard# - #maxcard#
MP.VWDimCustomerObjectID #mincard# - #maxcard#
MP.DimFDKostenplaatsID #mincard# - #maxcard#
MP.TASKID #mincard# - #maxcard#
MP.ACTIONCODEID #mincard# - #maxcard#
MP.CreatedDate_trans #mincard# - #maxcard#
MP.CALLSTATUSID #mincard# - #maxcard#
MP.SALESID #mincard# - #maxcard#
MP.INVENTDIMID #mincard# - #maxcard#
MP.INVENTLOCATIONID #mincard# - #maxcard#
MP.DELIVERYDATE #mincard# - #maxcard#
MP.DELIVEREDQTY #mincard# - #maxcard#
MP.AMOUNTMST #mincard# - #maxcard#
MP.SALESPRICE #mincard# - #maxcard#
MP.ResponsType #mincard# - #maxcard#
MP.ProjectIntegrationId #mincard# - #maxcard#
MP.Bus_MinMax #mincard# - #maxcard#
MP.Mag_MinMAx #mincard# - #maxcard#
MP.NAME #mincard# - #maxcard#
MP.Herkomst_DWH #mincard# - #maxcard#
MP.inventtransid #mincard# - #maxcard#
MP.OLD_FIRSTSTARTTIME #mincard# - #maxcard#
MP.ShippingDateConfirmed #mincard# - #maxcard#
MP.SALESQTY #mincard# - #maxcard#
MP.LASTENDTIME #mincard# - #maxcard#
MP.RIDEDATE #mincard# - #maxcard#
MP.Pakbon_verzenddatum #mincard# - #maxcard#
MP.Berekend #mincard# - #maxcard#
MP.ATPTIMEFENCE #mincard# - #maxcard#
MP.CREATEDDATETIME #mincard# - #maxcard#
MP.LOADID #mincard# - #maxcard#
MP.Voorraad_actueel #mincard# - #maxcard#
MP.Fabrikant #mincard# - #maxcard#
MP.Artikelgroep #mincard# - #maxcard#
MP.message #mincard# - #maxcard#
MP.solution #mincard# - #maxcard#
MP.Pakbon #mincard# - #maxcard#
MP.REALHOURS #mincard# - #maxcard#
MP.BPPSERVICETASKSUBSTATUS #mincard# - #maxcard#
MP.FIRSTSTARTTIME #mincard# - #maxcard#
MP.Objecttype #mincard# - #maxcard#
MP.Steltijd #mincard# - #maxcard#
MP.Medewerker #mincard# - #maxcard#
MP.ResourceIsMonteurJaNee #mincard# - #maxcard#
MP.Som_betalingsregel #mincard# - #maxcard#
MP.HBvanTTR #mincard# - #maxcard#
MP.F_NF_vanTTR #mincard# - #maxcard#
MP.PLANNEDMAINTENANCERELATED #mincard# - #maxcard#
MP.laatste_factuur_melding #mincard# - #maxcard#
MP.contractid #mincard# - #maxcard#
MP.CALLDUEDATE #mincard# - #maxcard#
MP.DueDateYear #mincard# - #maxcard#
MP.MACHINETYPEID #mincard# - #maxcard#
MP.QV_MeldingStatus #mincard# - #maxcard#
MP.QV_TaakStatus #mincard# - #maxcard#
MP.HB_Voorraad #mincard# - #maxcard#
MP.Offerte gehad? #mincard# - #maxcard#
MP.Plandatum #mincard# - #maxcard#
MP.voorraad_Available_Pick #mincard# - #maxcard#
MP.voorraad_Available_NIET_Pick #mincard# - #maxcard#
MP.HB_voorraad_Available_Pick #mincard# - #maxcard#
MP.HB_voorraad_Available_NIET_Pick #mincard# - #maxcard#
MP.Fysiek_Beschikbaar #mincard# - #maxcard#
MP.HB_Fysiek_Beschikbaar #mincard# - #maxcard#
MP.HSOExecuteTaskOwnRisk #mincard# - #maxcard#
MP.HSOQUOTATIONACCEPTEDBY #mincard# - #maxcard#
MP.WMSLOCATIONID #mincard# - #maxcard#
MP.InkoopLeverDatum #mincard# - #maxcard#
MP.OpenInkoopHB #mincard# - #maxcard#
MP.OpenInkoopDemand #mincard# - #maxcard#
MP.OpenInkoopVoorraadLocatie #mincard# - #maxcard#
MP.InkoopPakbonDatum #mincard# - #maxcard#
MP.InkoopAantalBevestigingen #mincard# - #maxcard#
MP.InkoopOrder #mincard# - #maxcard#
MP.Melding_Klantrekening #mincard# - #maxcard#
MP.InterneNotitie #mincard# - #maxcard#
MP.LastNoteDate #mincard# - #maxcard#
MP.LastNoteBy #mincard# - #maxcard#
MP.SALESLINESTATUS #mincard# - #maxcard#
MP._Meldingsnummer #mincard# - #maxcard#
MP.aantal_taken #mincard# - #maxcard#
MP.Meldingsprofiel #mincard# - #maxcard#
MP.MAXLEADTIME #mincard# - #maxcard#
MP._Taaknummer #mincard# - #maxcard#
MP.aantal_artikelen #mincard# - #maxcard#
MP.Taakprofiel #mincard# - #maxcard#
MP.Afgesloten #mincard# - #maxcard#
MP.Afgehandeld #mincard# - #maxcard#
MP.Teruggemeld #mincard# - #maxcard#
MP.MeldingAfsluitdatum #mincard# - #maxcard#
MP.ServiceObject_HartingBankIsContactnaamFlag #mincard# - #maxcard#
MP.ServiceObject_Eigenaar #mincard# - #maxcard#
MP.ServiceObject_QV_ContractType #mincard# - #maxcard#
MP.Bedrag #mincard# - #maxcard#
MP.HulpmiddelStatusCode #mincard# - #maxcard#
MP.HulpmiddelStatus #mincard# - #maxcard#
MP.HulpmiddelStatusCodeNoSpaces #mincard# - #maxcard#
MP.DatumKEY #mincard# - #maxcard#
MP.UsersPerTaak #mincard# - #maxcard#
MP.MonteursPerTaak #mincard# - #maxcard#
MP.CreatedBy #mincard# - #maxcard#
MP.IsMonteurJaNee #mincard# - #maxcard#
MP.Productiviteit_Jaar #mincard# - #maxcard#
MP.Productiviteit_Maand #mincard# - #maxcard#
MP.Productiviteit_Week #mincard# - #maxcard#
MP.Productiviteit_Kwartaal #mincard# - #maxcard#
MP.Productiviteitsdatum #mincard# - #maxcard#
MP.Dagtype #mincard# - #maxcard#
MP.Uitvoerdatum #mincard# - #maxcard#
MP.DoorlooptijdMelding #mincard# - #maxcard#
MP.AfsluitdatumJaarMaand #mincard# - #maxcard#
MP.AfsluitdatumJaar #mincard# - #maxcard#
MP.AfsluitdatumMaand #mincard# - #maxcard#
MP.AfsluitdatumWeek #mincard# - #maxcard#
MP.AfsluitdatumKwartaal #mincard# - #maxcard#
MP.MagazijnLocatiesMinMax #mincard# - #maxcard#
MP.VestigingUniek #mincard# - #maxcard#
MP.AantalMinMaxBussen #mincard# - #maxcard#
MP.AantalMinMaxVestigingen #mincard# - #maxcard#
MP.Voorraadlocaties #mincard# - #maxcard#
MP.VoorraadMagazijnen #mincard# - #maxcard#
MP.AV_VesBusQua #mincard# - #maxcard#
MP.StarttijdStatus #mincard# - #maxcard#
MP.DagenOpStatus #mincard# - #maxcard#
MP.StatusDagenOpStatus #mincard# - #maxcard#
MP.DoorlooptijdOfferteTraject #mincard# - #maxcard#
MP.OfferteGoedkeuringsDatum #mincard# - #maxcard#
_MP.ArtikelGereserveerd #mincard# - #maxcard#
MP.Created_Jaar #mincard# - #maxcard#
MP.Created_Maand #mincard# - #maxcard#
MP.Created_Week #mincard# - #maxcard#
MP.Created_Kwartaal #mincard# - #maxcard#
MP.ArtikelGereserveerd #mincard# - #maxcard#
Meldingsprofiel #mincard# - #maxcard#
MP.QV.ExecutionStatusMelding #mincard# - #maxcard#
VerhuurNTFO.OrderNr #mincard# - #maxcard#
VerhuurNTFO.OrderRegelNr #mincard# - #maxcard#
VerhuurNTFO.EindPeriode #mincard# - #maxcard#
VerhuurNTFO.Periodebedrag #mincard# - #maxcard#
VerhuurNTFO.KlantNr #mincard# - #maxcard#
VerhuurNTFO.Locatie #mincard# - #maxcard#
VerhuurNTFO.Koepel #mincard# - #maxcard#
VerhuurNTFO.PROJID #mincard# - #maxcard#
VerhuurNTFO.POOL #mincard# - #maxcard#
VerhuurNTFO.FactuurNr #mincard# - #maxcard#
VerhuurNTFO.FactuurDatum #mincard# - #maxcard#
VerhuurNTFO.Grootboeknummer #mincard# - #maxcard#
VerhuurNTFO.Bedrag #mincard# - #maxcard#
GL_LocatieCode #mincard# - #maxcard#
GL_SalesOrderNum #mincard# - #maxcard#
GL_FactuurNum #mincard# - #maxcard#
GL_Accountingdate2 #mincard# - #maxcard#
GL_ledgeraccount #mincard# - #maxcard#
GL_Amount #mincard# - #maxcard#
Omzetdatum #mincard# - #maxcard#
Omzetdatum2 #mincard# - #maxcard#
Omzetstroom_new #mincard# - #maxcard#
Jaar_omzetdatum #mincard# - #maxcard#
Maand_omzetdatum #mincard# - #maxcard#
Week_omzetdatum #mincard# - #maxcard#
Jaar_omzetdatum2 #mincard# - #maxcard#
Maand_omzetdatum2 #mincard# - #maxcard#
Week_omzetdatum2 #mincard# - #maxcard#
StockArtikelnummer #mincard# - #maxcard#

Links 2 Tags