> Endringer i datamodell

Modellendringer versjon 8.00.0

Dette emnet inneholder en liste over alle modellendringer i Visma Business versjon 8.00.0.

Catalog database

Tabell 1. Nye kolonner i eksisterende tabeller
  Navn SQL navn Datatype Property
T Active catalog process ActPrc    
C Session ID SesId Limited string, 40 characters Future extension
Tabell 2. Slettede kolonner
  Navn SQL navn Datatype Property
T Active catalog process ActPrc    
C   SesGuid    

System database

Tabell 3. Nye tabeller
  Navn SQL navn Datatype Property
T Dashbord-rapport DshRep    
C Dashboard report no. DshRepNo Int32 Primary key
C Distinguished name DtgNm Limited string, 1024 characters  
C Dashboard report processing DshRepPrc Int32 Future extension
C Changed date ChDt Int32  
C Changed time ChTm Int16  
C Changed by user ChUsr Limited string, 24 characters  
C Edit status LckSt Int8  
C Process no. ChPrc Int32  
Tabell 4. Nye kolonner i eksisterende tabeller
  Navn SQL navn Datatype Property
T Arbeidsområdevindu WGrWin    
C Window layout no. WinLayNo Int32 Future extension
T Arbeidsområdeelement WGrPrt    
C Dashboard report no. DshRepNo Int32  
T Vinduselement WinPrt    
C Dashboard report no. DshRepNo Int32  
T Aktiv sesjon ActSes    
C Session ID SesId Limited string, 40 characters Future extension
T Tidligere sesjon TrmSes    
C Session ID SesId Limited string, 40 characters Future extension
T Aktiv systemprosess ActPrc    
C Session ID SesId Limited string, 40 characters Future extension
Tabell 5. Slettede kolonner
  Navn SQL navn Datatype Property
T Aktiv sesjon ActSes    
C   SesGuid    
T Tidligere sesjon TrmSes    
C   SesGuid    
T Aktiv systemprosess ActPrc    
C   SesGuid    

Company database

Tabell 6. Nye tabeller
  Navn SQL navn Datatype Property
T Avg. og bokf.gr. TaxAcGr    
C VAT and accounting group ProdGrNo Int32 Primary key
C Description Descr Limited string, 80 characters  
C Other VAT and accounting group OtPrGrNo Int32  
C VAT and accounting group processing PrGrProc Int32  
C Changed date ChDt Int32  
C Changed time ChTm Int16  
C Changed by user ChUsr Limited string, 24 characters  
C Edit status LckSt Int8  
C Process no. ChPrc Int32  
T Aggregert vareparti AgShp    
C Product no. ProdNo Limited string, 40 characters Primary key
C Warehouse no. StcNo Int32 Primary key
C Physical stock PhStc Decimal  
C Realised stock RestBal Decimal  
C Unrealised stock inc. StcInc Decimal  
C Inflow InInc Decimal  
C Reserved Rsv Decimal  
C Reserved from stock NoRsv Decimal  
C Reserved from inflow NoRsvInc Decimal  
C Available stock Av Decimal  
C Available in stock AvStc Decimal  
C Purchased/prod. not received AvInc Decimal  
C Physical stock value PhStcVal Decimal  
C Realised stock value StcVal Decimal  
C Sold NoDel Decimal  
C Hired NoHire Decimal  
C Loaned NoLoan Decimal  
C Lost Loss Decimal  
C Further processed NoFrProd Decimal  
C Received NoRec Decimal  
C Produced NoProd Decimal  
C Transferred NoTrf Decimal  
C Accounting value AcVal Decimal  
C Purchase value PurcVal Decimal  
T Ordrevedlegg OrdAtt    
C Order no. OrdNo Int32 Primary key
C Attachment no AttNo Int32 Primary key
C Sort seq. no. Srt Int32  
C Description Descr Limited string, 250 characters  
C Order attachment processing OrdAttProc Int32  
C Order attachment type FileTp Int32  
C Source file name SrcFNm Limited string, 260 characters  
C Changed date ChDt Int32  
C Changed time ChTm Int16  
C Changed by user ChUsr Limited string, 24 characters  
C Edit status LckSt Int8  
C Process no. ChPrc Int32  
C File data FileData Blob  
T Ordredokumentvedlegg OrdDocAtt    
C Order doc. no OrdDocNo Int32 Primary key
C Order no. OrdNo Int32 Primary key
C Attachment no AttNo Int32 Primary key
C Changed date ChDt Int32  
C Changed time ChTm Int16  
C Changed by user ChUsr Limited string, 24 characters  
C Edit status LckSt Int8  
C Process no. ChPrc Int32  
Tabell 7. Nye kolonner i eksisterende tabeller
  Navn SQL navn Datatype Property
T Kundedokumentlinje CsDocLn    
C Cust. doc. line type CsDocLnTp Int32  
T Hovedbokstransaksjon AcTr    
C Realisation journal no. RealJNo Int32 Future extension
C Realisation journal line no. RealLnNo Int32 Future extension
T Regnskapstransaksjon AllAcTr    
C Realisation journal no. RealJNo Int32 Future extension
C Realisation journal line no. RealLnNo Int32 Future extension
T Produkt Prod    
C Change time in ms ChTmms Int32  
T Strekkode ScanCd    
C Change time in ms ChTmms Int32  
T Pris- og rabattmatrise PrDcMat    
C Change time in ms ChTmms Int32  
T Avgifts- og bokføringsopplysninger TaxAcInf    
C Debit stock cost production DbStcPr Int32 Future extension
C Credit stock cost production CrStcPr Int32 Future extension
T Aggregert vareparti AgShp    
C Accounting value AcVal Decimal  
C Purchase value PurcVal Decimal  
T Ordrelinje OrdLn    
C No per structure NoPerStr Decimal  
T Realisasjonsjournallinje RealJLn    
C Stock change StcCh Decimal Future extension
C Stock costs StcCst Decimal Future extension
C Realised stock value RlStcVal Decimal Future extension
C Journal date JDt Int32 Future extension
C Origin RlOr Int32 Future extension
T Produkttransaksjon ProdTr    
C Realised stock change; realisation journal no. StcChRealJNo Int32 Future extension
C Realised stock change; realisation journal line no. StcChRealLnNo Int32 Future extension
C Realised stock value; realisation journal no. StcValRealJNo Int32 Future extension
C Realised stock value; realisation journal line no. StcValRealLnNo Int32 Future extension
C Corrected stock value; realisation journal no. CorStcValRealJNo Int32 Future extension
C Corrected stock value; realisation journal line no. CorStcValRealLnNo Int32 Future extension
T Produkttransaksjon før komprimering ProdTr2    
C Realised stock change; realisation journal no. StcChRealJNo Int32 Future extension
C Realised stock change; realisation journal line no. StcChRealLnNo Int32 Future extension
C Realised stock value; realisation journal no. StcValRealJNo Int32 Future extension
C Realised stock value; realisation journal line no. StcValRealLnNo Int32 Future extension
C Corrected stock value; realisation journal no. CorStcValRealJNo Int32 Future extension
C Corrected stock value; realisation journal line no. CorStcValRealLnNo Int32 Future extension
T Ordredokumentlinje OrdDocLn    
C No per structure NoPerStr Decimal  
C Order doc. line type OrdDocLnTp Int32  
C VAT basis amount VatBas Decimal  
T Bilag WaVo    
C Realisation journal line no. RealLnNo Int32 Future extension
T Oppdatert bilag UpdVo    
C Realisation journal line no. RealLnNo Int32 Future extension
T Bedriftsopplysninger FrmData    
C Order attachment processing OrdAttProc Int32  
C Stock take account set StcCntAcSet Int32  
T Aktiv bedriftsprosess ActPrc    
C Session ID SesId Limited string, 40 characters Future extension
Tabell 8. Slettede kolonner
  Navn SQL navn Datatype Property
T Aktiv bedriftsprosess ActPrc    
C   SesGuid    


Vi setter pris på dine tilbakemeldinger. Send tilbakemelding til Visma på dette emnet.