vflowsclient

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

int4

√

null

debitvalidated

float8

17,17

√

null

creditinprogress

float8

17,17

√

null

creditvalidated

float8

17,17

√

null

remaining

float8

17,17

√

null

suspense

float8

17,17

√

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,
    0 AS debitinprogress,
    0 AS debitvalidated,
        CASE p.paystatus
            WHEN 'VALID'::text THEN (0)::double precision
            ELSE p.payamount
        END AS creditinprogress,
        CASE p.paystatus
            WHEN 'VALID'::text THEN p.payamount
            ELSE (0)::double precision
        END AS creditvalidated,
    0 AS remaining,
        CASE p.paystatus
            WHEN 'VALID'::text THEN p.payremainingamount
            ELSE (0)::double precision
        END AS suspense,
    p.paystatus,
    p.currcode
   FROM payment p
  WHERE (((p.paytype)::text = 'PAY'::text) AND ((p.paydirection)::text = 'IN'::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,
    p.payamount 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 = 'REJ'::text) AND ((p.paydirection)::text = 'IN'::text) AND ((p.paystatus)::text <> 'CANCEL'::text))
UNION
 SELECT ci.tpidclient AS tpid,
    'INVOICE'::text AS flowtype,
    ci.ciid AS objectid,
    ci.cireference AS objectreference,
    ci.cidocdate AS docdate,
    0 AS debitinprogress,
    ci.cigrosstotal AS debitvalidated,
    0 AS creditinprogress,
    0 AS creditvalidated,
    ci.cidueamount AS remaining,
    0 AS suspense,
    ci.cistatus AS paystatus,
    ci.currcode
   FROM clientinvoice ci
  WHERE ((ci.ciinvoicetype)::text <> 'CN'::text)
UNION
 SELECT ci.tpidclient AS tpid,
    'CN'::text AS flowtype,
    ci.ciid AS objectid,
    ci.cireference AS objectreference,
    ci.cidocdate AS docdate,
    0 AS debitinprogress,
    0 AS debitvalidated,
    0 AS creditinprogress,
    ci.cigrosstotal AS creditvalidated,
    0 AS remaining,
    0 AS suspense,
    ci.cistatus AS paystatus,
    ci.currcode
   FROM clientinvoice ci
  WHERE ((ci.ciinvoicetype)::text = 'CN'::text);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views