u_posterminal

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 NULL::numeric
ad_org_id numeric 10 NULL::numeric
autolock bpchar 1 'N'::bpchar
card_bankaccount_id numeric 10 √ null
c_bankaccount.c_bankaccount_id cardbankaccount_uposterminal R
cardtransferbankaccount_id numeric 10 √ null
c_bankaccount.c_bankaccount_id cardtransferbankaccount_uposte R
cardtransfercashbook_id numeric 10 √ null
c_cashbook.c_cashbook_id cardtransfercashbook_upostermi R
cardtransfertype bpchar 1 √ null
cashbooktransfertype bpchar 1 null
cashtransferbankaccount_id numeric 10 √ null
c_bankaccount.c_bankaccount_id cashtransferbankaccount_uposte R
cashtransfercashbook_id numeric 10 √ null
c_cashbook.c_cashbook_id cashtransfercashbook_upostermi R
c_cashbook_id numeric 10 null
c_cashbook.c_cashbook_id ccashbook_uposterminal R
c_cashbpartner_id numeric 10 null
c_bpartner.c_bpartner_id ccashbpartner_uposterminal R
check_bankaccount_id numeric 10 √ null
c_bankaccount.c_bankaccount_id checkbankaccount_uposterminal R
checktransferbankaccount_id numeric 10 √ null
c_bankaccount.c_bankaccount_id checktransferbankaccount_upost R
checktransfercashbook_id numeric 10 √ null
c_cashbook.c_cashbook_id checktransfercashbook_uposterm R
checktransfertype bpchar 1 √ null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
c_templatebpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id ctemplatebpartner_uposterminal R
description varchar 255 √ null
help varchar 2000 √ null
isactive bpchar 1 √ 'Y'::bpchar
lastlocktime timestamp 29,6 √ null
locked bpchar 1 √ 'N'::bpchar
locktime numeric 10 √ null
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id mwarehouse_uposterminal R
name varchar 60 √ null
po_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id popricelist_uposterminal R
printername varchar 60 √ null
salesrep_id numeric 10 √ null
ad_user.ad_user_id salesrep_uposterminal R
so_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id sopricelist_uposterminal R
unlockingtime timestamp 29,6 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 √ null
u_posterminal_id numeric 10 null
value varchar 40 √ null
u_posterminal_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
u_posterminal_key Primary key Asc u_posterminal_id
u_posterminal_uu_idx Must be unique Asc u_posterminal_uu
u_posterminal_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

Constraint Name Constraint
u_posterminal_autolock_check ((autolock = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
u_posterminal_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
u_posterminal_locked_check ((locked = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation