rv_cof_taxes

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

10

√

null

ad_org_id

numeric

10

√

null

created

timestamp

29,6

√

null

createdby

numeric

10

√

null

updated

timestamp

29,6

√

null

updatedby

numeric

10

√

null

record_id

numeric

10

√

null

table_name

text

2147483647

√

null

lbr_tax_id

numeric

0

√

null

tax_type

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT lbr_taxdefinition.ad_client_id,
    lbr_taxdefinition.ad_org_id,
    lbr_taxdefinition.created,
    lbr_taxdefinition.createdby,
    lbr_taxdefinition.updated,
    lbr_taxdefinition.updatedby,
    lbr_taxdefinition.lbr_taxdefinition_id AS record_id,
    'LBR_TaxDefinition'::text AS table_name,
    lbr_taxdefinition.lbr_tax_id,
    'C'::text AS tax_type
   FROM lbr_taxdefinition
UNION
 SELECT lbr_issmatrix.ad_client_id,
    lbr_issmatrix.ad_org_id,
    lbr_issmatrix.created,
    lbr_issmatrix.createdby,
    lbr_issmatrix.updated,
    lbr_issmatrix.updatedby,
    lbr_issmatrix.lbr_issmatrix_id AS record_id,
    'LBR_ISSMatrix'::text AS table_name,
    lbr_issmatrix.lbr_tax_id,
    'C'::text AS tax_type
   FROM lbr_issmatrix
UNION
 SELECT lbr_ncm.ad_client_id,
    lbr_ncm.ad_org_id,
    lbr_ncm.created,
    lbr_ncm.createdby,
    lbr_ncm.updated,
    lbr_ncm.updatedby,
    lbr_ncm.lbr_ncm_id AS record_id,
    'LBR_NCM'::text AS table_name,
    lbr_ncm.lbr_tax_id,
    'C'::text AS tax_type
   FROM lbr_ncm
UNION
 SELECT m_movementline.ad_client_id,
    m_movementline.ad_org_id,
    m_movementline.created,
    m_movementline.createdby,
    m_movementline.updated,
    m_movementline.updatedby,
    m_movementline.m_movementline_id AS record_id,
    'M_MovementLine'::text AS table_name,
    m_movementline.lbr_tax_id,
    'T'::text AS tax_type
   FROM m_movementline
UNION
 SELECT lbr_cfopline.ad_client_id,
    lbr_cfopline.ad_org_id,
    lbr_cfopline.created,
    lbr_cfopline.createdby,
    lbr_cfopline.updated,
    lbr_cfopline.updatedby,
    lbr_cfopline.lbr_cfopline_id AS record_id,
    'LBR_CFOPLine'::text AS table_name,
    lbr_cfopline.lbr_tax_id,
    'C'::text AS tax_type
   FROM lbr_cfopline
UNION
 SELECT test.ad_client_id,
    test.ad_org_id,
    test.created,
    test.createdby,
    test.updated,
    test.updatedby,
    test.test_id AS record_id,
    'Test'::text AS table_name,
    test.lbr_tax_id,
    'C'::text AS tax_type
   FROM test
UNION
 SELECT c_orderline.ad_client_id,
    c_orderline.ad_org_id,
    c_orderline.created,
    c_orderline.createdby,
    c_orderline.updated,
    c_orderline.updatedby,
    c_orderline.c_orderline_id AS record_id,
    'C_OrderLine'::text AS table_name,
    c_orderline.lbr_tax_id,
    'T'::text AS tax_type
   FROM c_orderline
UNION
 SELECT lbr_icmsmatrix.ad_client_id,
    lbr_icmsmatrix.ad_org_id,
    lbr_icmsmatrix.created,
    lbr_icmsmatrix.createdby,
    lbr_icmsmatrix.updated,
    lbr_icmsmatrix.updatedby,
    lbr_icmsmatrix.lbr_icmsmatrix_id AS record_id,
    'LBR_ICMSMatrix'::text AS table_name,
    lbr_icmsmatrix.lbr_tax_id,
    'C'::text AS tax_type
   FROM lbr_icmsmatrix
UNION
 SELECT ad_orginfo.ad_client_id,
    ad_orginfo.ad_org_id,
    ad_orginfo.created,
    ad_orginfo.createdby,
    ad_orginfo.updated,
    ad_orginfo.updatedby,
    ad_orginfo.ad_org_id AS record_id,
    'AD_OrgInfo'::text AS table_name,
    ad_orginfo.lbr_tax_id,
    'C'::text AS tax_type
   FROM ad_orginfo
UNION
 SELECT c_invoiceline.ad_client_id,
    c_invoiceline.ad_org_id,
    c_invoiceline.created,
    c_invoiceline.createdby,
    c_invoiceline.updated,
    c_invoiceline.updatedby,
    c_invoiceline.c_invoiceline_id AS record_id,
    'C_InvoiceLine'::text AS table_name,
    c_invoiceline.lbr_tax_id,
    'T'::text AS tax_type
   FROM c_invoiceline
UNION
 SELECT m_rmaline.ad_client_id,
    m_rmaline.ad_org_id,
    m_rmaline.created,
    m_rmaline.createdby,
    m_rmaline.updated,
    m_rmaline.updatedby,
    m_rmaline.m_rmaline_id AS record_id,
    'M_RMALine'::text AS table_name,
    m_rmaline.lbr_tax_id,
    'T'::text AS tax_type
   FROM m_rmaline;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views