Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Page is under draft. The data in the first table still needs to be adjusted.

metadbmetadb (Draft: The schema can change in the Metadb database.)

FromTo
ModuleTableAttributeModuleTableAttribute
Agreementsremote_license_linkrole_remote_idLicenseslicenselic_id
Agreementsorgorg_orgs_uuidOrganizationsorganizationsid
Agreements??eUsage??
Agreementsorder_linepol_orders_fkOrderspo_lineid
Orderspurchase_orderjsonb->>'billTo'
jsonb->>'shipTo'
jsonb->>'vendor'
Organizationsorganizationsid
Orderspo_lineidInvoicesinvoice_linesjsonb->>'poLineId'
Orderspo_linejsonb->'fundDistribution'->> 'fundId'Financefundid
Orderspo_lineidFinancetransactionjsonb->>'sourcePoLineId'
purchase_orderidFinancetransactionjsonb->>'sourcePurchaseOrderId'
Invoicesinvoicesjsonb->>'billTo'
jsonb->>'vendorId'
Organizationsorganizationsid
Invoicesinvoice_linesjsonb->'fundDistributions'->> 'fundId'Financefundid
Invoicesinvoice_linesidFinancetransactionjsonb->>'sourceInvoiceLineId'
invoicesidFinancetransactionjsonb->>'sourceInvoiceId'

folio-database (Iris)

FromTo
ModuleTableAttributeModuleTableAttribute
Agreementsremote_license_linkrole_remote_idLicenseslicenselic_id
Agreementsorgorg_orgs_uuidOrganizationsorganizationsid
Agreements??eUsage??
Agreementsorder_linepol_orders_fkOrderspo_lineid
Orderspurchase_orderjsonb->>'billTo'
jsonb->>'shipTo'
jsonb->>'vendor'
Organizationsorganizationsid
Orderspo_lineidInvoicesinvoice_linesjsonb->>'poLineId'
Orderspo_linejsonb->'fundDistribution'->> 'fundId'Financefundid
Orderspo_lineidFinancetransactionjsonb->>'sourcePoLineId'
purchase_orderidFinancetransactionjsonb->>'sourcePurchaseOrderId'
Invoicesinvoicesjsonb->>'billTo'
jsonb->>'vendorId'
Organizationsorganizationsid
Invoicesinvoice_linesjsonb->'fundDistributions'->> 'fundId'Financefundid
Invoicesinvoice_linesidFinancetransactionjsonb->>'sourceInvoiceLineId'
invoicesidFinancetransactionjsonb->>'sourceInvoiceId'

...