Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- evergreen=# \d+ reporter.acq_fund_debit_view
- View "reporter.acq_fund_debit_view"
- Column | Type | Modifiers | Storage | Description
- --------------------------------+--------------------------+-----------+----------+-------------
- fund_id | integer | | plain |
- fund_code | text | | extended |
- fund_debit_id | integer | | plain |
- invoice_item_id | integer | | plain |
- inv_item_inv_id | integer | | plain |
- invoice_item_invoice_ident | text | | extended |
- invoice_item_provider_id | integer | | plain |
- invoice_item_inv_provider_code | text | | extended |
- inv_entry_inv_id | integer | | plain |
- inv_entry_invoice_ident | text | | extended |
- inv_entry_provider_id | integer | | plain |
- inv_entry_provider_code | text | | extended |
- po_item_id | integer | | plain |
- po_item_po_id | integer | | plain |
- lineitem_detail_id | bigint | | plain |
- lineitem_id | bigint | | plain |
- po_id | integer | | plain |
- po_provider_id | integer | | plain |
- po_provider_code | text | | extended |
- fund_debit_origin_amount | numeric | | main |
- fund_debit_amount | numeric | | main |
- encumbrance | boolean | | plain |
- fund_debit_type | text | | extended |
- create_time | timestamp with time zone | | plain |
- View definition:
- SELECT fund.id AS fund_id,
- fund.code AS fund_code,
- fd.id AS fund_debit_id,
- acqii.id AS invoice_item_id,
- invoice_item_invoice.id AS inv_item_inv_id,
- invoice_item_invoice.inv_ident AS invoice_item_invoice_ident,
- inv_item_provider.id AS invoice_item_provider_id,
- inv_item_provider.code AS invoice_item_inv_provider_code,
- inv_entry_invoice.id AS inv_entry_inv_id,
- inv_entry_invoice.inv_ident AS inv_entry_invoice_ident,
- inv_entry_provider.id AS inv_entry_provider_id,
- inv_entry_provider.code AS inv_entry_provider_code,
- acqpoi.id AS po_item_id,
- po_item_po.id AS po_item_po_id,
- lid.id AS lineitem_detail_id,
- jub.id AS lineitem_id,
- po.id AS po_id,
- po_provider.id AS po_provider_id,
- po_provider.code AS po_provider_code,
- fd.origin_amount AS fund_debit_origin_amount,
- fd.amount AS fund_debit_amount,
- fd.encumbrance,
- fd.debit_type AS fund_debit_type,
- fd.create_time
- FROM acq.fund fund
- LEFT JOIN acq.fund_debit fd ON fd.fund = fund.id
- LEFT JOIN acq.invoice_item acqii ON acqii.fund_debit = fd.id
- LEFT JOIN acq.invoice invoice_item_invoice ON acqii.invoice = invoice_item_invoice.id
- LEFT JOIN acq.po_item acqpoi ON acqpoi.fund_debit = fd.id
- LEFT JOIN acq.purchase_order po_item_po ON acqpoi.purchase_order = po_item_po.id
- LEFT JOIN acq.lineitem_detail lid ON lid.fund_debit = fd.id
- LEFT JOIN acq.lineitem jub ON lid.lineitem = jub.id
- LEFT JOIN acq.purchase_order po ON jub.purchase_order = po.id
- LEFT JOIN acq.provider po_provider ON po.provider = po_provider.id
- LEFT JOIN acq.provider inv_item_provider ON invoice_item_invoice.provider = inv_item_provider.id
- LEFT JOIN acq.invoice_entry inv_entry ON inv_entry.lineitem = jub.id
- LEFT JOIN acq.invoice inv_entry_invoice ON inv_entry.invoice = inv_entry_invoice.id
- LEFT JOIN acq.provider inv_entry_provider ON inv_entry_invoice.provider = inv_entry_provider.id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement