Skip to end of banner
Go to start of banner

ERM-Agreements Costs - Cross-module connections

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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

metadb

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

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