Download platform/model/topics/customer_open_documents.yml from fsanyoto/loopable: direct link, hf CLI and curl.
- Browser
- Download file 1.12 kB
-
https://huggingface.co/spaces/fsanyoto/loopable/resolve/main/platform/model/topics/customer_open_documents.yml
- Command line
-
hf download hf://spaces/fsanyoto/loopable/platform/model/topics/customer_open_documents.yml
-
curl -L -o customer_open_documents.yml https://huggingface.co/spaces/fsanyoto/loopable/resolve/main/platform/model/topics/customer_open_documents.yml
1.12 kB
| key: customer_open_documents | |
| label: Open customer documents (all channels) | |
| entity: account.move | |
| semantic: | |
| approved: [] | |
| date_field: "" | |
| date_col_note: m.invoice_date | |
| scope: Posted customer documents across all channels, including an empty group for customers without documents. | |
| measure: {key: customer_open_documents, validate: customer_open_documents} | |
| grain: one row per posted customer document, including an empty group for customers without documents | |
| store: | |
| table: account_move | |
| alias: m | |
| date_col: m.invoice_date | |
| join: >- | |
| FULL OUTER JOIN res_partner rp ON rp.id = m.partner_id AND m.state = 'posted' | |
| AND m.move_type IN ('out_invoice', 'out_refund') AND m.partner_id IS NOT NULL | |
| scope_sql: >- | |
| (m.state = 'posted' AND m.move_type IN ('out_invoice', 'out_refund') AND m.partner_id IS NOT NULL) | |
| OR (m.id IS NULL AND (rp.customer_rank > 0 OR rp.id IN ( | |
| SELECT partner_id FROM sale_order WHERE state IN ('sale', 'done') | |
| AND partner_id IS NOT NULL))) | |
| dims: | |
| partner: {col: "COALESCE(m.partner_id, rp.id)", name_col: "COALESCE(m.partner_name, rp.name)", label: Customer} | |