Page tree
Skip to end of metadata
Go to start of metadata

metadb (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'
  • No labels