vflowssupplier

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

tpid

int8

√

null

flowtype

text

2147483647

√

null

objectid

int8

√

null

objectreference

varchar

√

null

docdate

date

√

null

debitinprogress

float8

17,17

√

null

debitvalidated

float8

17,17

√

null

creditinprogress

float8

17,17

√

null

creditvalidated

float8

17,17

√

null

remaining

float8

17,17

√

null

suspense

int4

√

null

paystatus

varchar

√

null

currcode

varchar

√

null

parcurrency.currcode

Implied Constraint

Relationships

Close relationships within degrees of separation

View Definition

SELECT p.tpid,
    'PAYMENT'::text AS flowtype,
    p.payid AS objectid,
    p.payreference AS objectreference,
    p.paydocdate AS docdate,
        CASE p.paystatus
            WHEN 'VALID'::text THEN (0)::double precision
            ELSE p.payamount
        END AS debitinprogress,
        CASE p.paystatus
            WHEN 'VALID'::text THEN p.payamount
            ELSE (0)::double precision
        END AS debitvalidated,
    0 AS creditinprogress,
    0 AS creditvalidated,
    0 AS remaining,
    0 AS suspense,
    p.paystatus,
    p.currcode
   FROM payment p
  WHERE (((p.paytype)::text = 'PAY'::text) AND ((p.paydirection)::text = 'OUT'::text) AND ((p.paystatus)::text <> 'CANCEL'::text))
UNION
 SELECT p.tpid,
    'REJECT'::text AS flowtype,
    p.payid AS objectid,
    p.payreference AS objectreference,
    p.paydocdate AS docdate,
    0 AS debitinprogress,
    0 AS debitvalidated,
    0 AS creditinprogress,
    p.payamount AS creditvalidated,
    0 AS remaining,
    0 AS suspense,
    p.paystatus,
    p.currcode
   FROM payment p
  WHERE (((p.paytype)::text = 'REJ'::text) AND ((p.paystatus)::text <> 'CANCEL'::text))
UNION
 SELECT si.tpidsupplier AS tpid,
    'INVOICE'::text AS flowtype,
    si.siid AS objectid,
    si.sireference AS objectreference,
    si.sidocdate AS docdate,
    0 AS debitinprogress,
    0 AS debitvalidated,
        CASE si.sistatus
            WHEN 'INIT'::text THEN si.sigrosstotal
            ELSE (0)::double precision
        END AS creditinprogress,
        CASE si.sistatus
            WHEN 'INIT'::text THEN (0)::double precision
            ELSE si.sigrosstotal
        END AS creditvalidated,
    si.sidueamount AS remaining,
    0 AS suspense,
    si.sistatus AS paystatus,
    si.currcode
   FROM supplierinvoice si
  WHERE (si.siidcreditnote IS NULL)
UNION
 SELECT si.tpidsupplier AS tpid,
    'CN'::text AS flowtype,
    si.siid AS objectid,
    si.sireference AS objectreference,
    si.sidocdate AS docdate,
        CASE si.sistatus
            WHEN 'VALID'::text THEN (0)::double precision
            ELSE si.sigrosstotal
        END AS debitinprogress,
        CASE si.sistatus
            WHEN 'VALID'::text THEN si.sigrosstotal
            ELSE (0)::double precision
        END AS debitvalidated,
    0 AS creditinprogress,
    0 AS creditvalidated,
    si.sidueamount AS remaining,
    0 AS suspense,
    si.sistatus AS paystatus,
    si.currcode
   FROM supplierinvoice si
  WHERE (si.siidcreditnote IS NOT NULL);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views