purchase_bill_union

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

int4

10

√

null

name

varchar

2147483647

√

null

reference

varchar

2147483647

√

null

partner_id

int4

10

√

null

date

13

√

null

amount

numeric

0

√

null

currency_id

int4

10

√

null

company_id

int4

10

√

null

vendor_bill_id

int4

10

√

null

purchase_order_id

int4

10

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT account_move.id,
    account_move.name,
    account_move.ref AS reference,
    account_move.partner_id,
    account_move.date,
    account_move.amount_untaxed AS amount,
    account_move.currency_id,
    account_move.company_id,
    account_move.id AS vendor_bill_id,
    NULL::integer AS purchase_order_id
   FROM account_move
  WHERE (((account_move.move_type)::text = 'in_invoice'::text) AND ((account_move.state)::text = 'posted'::text))
UNION
 SELECT (- purchase_order.id) AS id,
    purchase_order.name,
    purchase_order.partner_ref AS reference,
    purchase_order.partner_id,
    (purchase_order.date_order)::date AS date,
    purchase_order.amount_untaxed AS amount,
    purchase_order.currency_id,
    purchase_order.company_id,
    NULL::integer AS vendor_bill_id,
    purchase_order.id AS purchase_order_id
   FROM purchase_order
  WHERE (((purchase_order.state)::text = ANY ((ARRAY['purchase'::character varying, 'done'::character varying])::text[])) AND ((purchase_order.invoice_status)::text = ANY ((ARRAY['to invoice'::character varying, 'no'::character varying])::text[])));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views