Table assettable {
  assetid string
  bookid string
  dataareaid string
  assetgroup string
  name string
  majortype string
  usedfromdate date
  servicelife int
}

Table assetgroup {
  assetgroup string
  groupid string
  dataareaid string
  name string
}

Table assetbook {
  dataareaid string
  assetid string 
  depreciationprofile string
  defaultdimension string
  acquisitiondate date
  acquisitionprice currency
}

Table assetdepreciationprofile {
  dataareaid string
  profile string
  name string
}

Table dimensionattributevalueset {
  recid string
  d01_businessunitvalue string
}

Table assettrans {
  dataareaid string
  assetid string
  transdate date
  voucher string
  amountcur currency
  txt string
  transtype int
  ledgerdimension string
}

Table GlobalOptionsetMetadata {
  Option int
  LocalizedLabel string
  EntityName string
  OptionSetname string
}

Table dimensionattributevaluecombination {
  recid string
  mserp_recordid string
  displayvalue string
  mainaccountvalue string
  d01_businessunitvalue string
  d02_costcentrevalue string
  d03_analysisvalue string
  d04_incometypevalue string
}

Table budgettransactionheader {
  budgetmodeldataareaid string
  transactionnumber string
  createdby string
  date date
  budgetmodelid string
  budgettransactioncode string
  transactionstatus string
  recid string
}

Table budgettransactioncode {
  recid string
  name string
  budgettransactiontype int
}

Table budgettransactionline {
  linenumber string
  date date
  transactioncurrency string
  accountingcurrencyamount currency
  Comment string
  budgettransactionheader string
  ledgerdimension string
}

Table sysuserinfo {
  fnoid string
}

Table omoperatingunit {
  recid string
  OMOperatingUnitNumber string
}

Table DirPartyTable {
 recid string
 name string
}

Table custtable {
  dataareaid string
  accountnum string
  custgroup string
  currency string
  paymmode string
  vatnum string
  taxgroup string
  party string
  blocked string
}

Table ledgerconsolidatetemplatelegalentity {
  sourcecompany string
}

Table dimensionfinancialtag {
  value string
  description string
  financialtagcategory string
}

Table dimensionattribute {
  recid string
}

Table dimensionattributeDirCategory {
  dircategory string
  dimensionattribute string
}

Table vendtable {
  recid string
  dataareaid string
  vendgroup string
}

Table vendtrans {
  recid string
}

Table vendsettlement {
  recid string
  offsetrecid string
}

Table dirpartytable {
  party string
  name string
}


Ref: assetbook.(assetid, dataareaid) - assettable.(assetid, dataareaid)
Ref: assetbook.(depreciationprofile, dataareaid) > assetdepreciationprofile.(profile, dataareaid)
Ref: dimensionattributevalueset.recid - assetbook.defaultdimension
Ref: assettrans.transtype > GlobalOptionsetMetadata.Option
Ref: assettrans.ledgerdimension - dimensionattributevaluecombination.recid

Ref: assettable.(assetgroup, dataareaid) - assetgroup.(groupid, dataareaid)

Ref: budgettransactionheader.budgettransactioncode - budgettransactioncode.recid
Ref: budgettransactioncode.budgettransactiontype > GlobalOptionsetMetadata.Option
Ref: budgettransactionheader.transactionstatus > GlobalOptionsetMetadata.Option
Ref: budgettransactionheader.recid - budgettransactionline.budgettransactionheader
Ref: budgettransactionline.ledgerdimension - dimensionattributevaluecombination.recid
Ref: budgettransactionline.ledgerdimension - dimensionattributevaluecombination.mserp_recordid
Ref: budgettransactionheader.createdby > sysuserinfo.fnoid
Ref: omoperatingunit.recid - DirPartyTable.recid
Ref: assettable.dataareaid - ledgerconsolidatetemplatelegalentity.sourcecompany

Ref: dimensionfinancialtag.value < assetbook.dataareaid
Ref: dimensionattributeDirCategory.dircategory < dimensionfinancialtag.financialtagcategory
Ref: dimensionattribute.recid > dimensionattributeDirCategory.dimensionattribute

Ref: vendtable.recid - dirpartytable.party

Ref: vendtrans.recid > vendsettlement.offsetrecid