DW_Id | bigint | #mincard# - #maxcard# | |
_Alladin_Order_Key | bigint | #mincard# - #maxcard# | |
Uniek | bigint | #mincard# - #maxcard# | |
Ordernummer | int | #mincard# - #maxcard# | |
Contractvorm | nvarchar | #mincard# - #maxcard# | |
Voorzieningnummer | int | #mincard# - #maxcard# | |
Relatienummer | int | #mincard# - #maxcard# | |
Order Code | tinyint | #mincard# - #maxcard# | |
Actie | nvarchar | #mincard# - #maxcard# | |
Label | int | #mincard# - #maxcard# | |
Zuil | int | #mincard# - #maxcard# | |
Factuur Datum | datetime2 | #mincard# - #maxcard# | |
Factuurnummer | nvarchar | #mincard# - #maxcard# | |
Prijs | decimal | #mincard# - #maxcard# | |
Contract Datum | datetime2 | #mincard# - #maxcard# | |
Locatie | varchar | #mincard# - #maxcard# | |
Locatie Soort | varchar | #mincard# - #maxcard# | |
Type Invoer | varchar | #mincard# - #maxcard# | |
Kostenplaats | varchar | #mincard# - #maxcard# | |
IncrementalTimeStamp | datetime | #mincard# - #maxcard# | |
DW_Batch | bigint | #mincard# - #maxcard# | |
DW_SourceCode | varchar | #mincard# - #maxcard# | |
DW_TimeStamp | datetime | #mincard# - #maxcard# | |
Aflever Datum | datetime2 | #mincard# - #maxcard# | |
Kanaal AFAS | varchar | #mincard# - #maxcard# | |
Kanaal Verkoop | varchar | #mincard# - #maxcard# | |
Leeftijd Categorie op Aflevermoment | varchar | #mincard# - #maxcard# | |
LocatieSoortLocatieInvoer Sleutel | varchar | #mincard# - #maxcard# | |
Order Centrum | int | #mincard# - #maxcard# | |
Order Ledenverening | nvarchar | #mincard# - #maxcard# | |
Order Preventief Onderhoud | varchar | #mincard# - #maxcard# | |
Order Provincie | varchar | #mincard# - #maxcard# | |
Order Regio | varchar | #mincard# - #maxcard# | |
Postcode4 | nvarchar | #mincard# - #maxcard# | |
Aantal Netto Sleutel | varchar | #mincard# - #maxcard# | |
Order Klant Locatie | nvarchar | #mincard# - #maxcard# | |
Order Klant Locatiesoort | varchar | #mincard# - #maxcard# | |
Order Koepel | nvarchar | #mincard# - #maxcard# | |