Table idempiere9.adempiere.u_posterminal
POS Terminal

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
ad_org_id numeric 10 NULL::numeric Organizational entity within client
autolock bpchar 1 'N'::bpchar Whether to automatically lock the terminal when till is closed
card_bankaccount_id numeric 10  √  null
c_bankaccount.c_bankaccount_id cardbankaccount_uposterminal R
Bank Account on which card transactions will be processed
cardtransferbankaccount_id numeric 10  √  null
c_bankaccount.c_bankaccount_id cardtransferbankaccount_uposte R
Bank account on which to transfer Card transactions
cardtransfercashbook_id numeric 10  √  null
c_cashbook.c_cashbook_id cardtransfercashbook_upostermi R
Cash Book on which to transfer all Card transactions
cardtransfertype bpchar 1  √  null Card Transfer Type
cashbooktransfertype bpchar 1 Where the money in the cash book should be transfered to. Either a Bank Account or another Cash Book
cashtransferbankaccount_id numeric 10  √  null
c_bankaccount.c_bankaccount_id cashtransferbankaccount_uposte R
Bank Account on which to transfer all Cash transactions
cashtransfercashbook_id numeric 10  √  null
c_cashbook.c_cashbook_id cashtransfercashbook_upostermi R
Cash Book on which to transfer all Cash transactions
c_cashbook_id numeric 10
c_cashbook.c_cashbook_id ccashbook_uposterminal R
Cash Book for recording petty cash transactions
c_cashbpartner_id numeric 10
c_bpartner.c_bpartner_id ccashbpartner_uposterminal R
BPartner to be used for Cash transactions
check_bankaccount_id numeric 10  √  null
c_bankaccount.c_bankaccount_id checkbankaccount_uposterminal R
Bank Account to be used for processing Check transactions
checktransferbankaccount_id numeric 10  √  null
c_bankaccount.c_bankaccount_id checktransferbankaccount_upost R
Bank account on which to transfer Check transactions
checktransfercashbook_id numeric 10  √  null
c_cashbook.c_cashbook_id checktransfercashbook_uposterm R
Cash Book on which to transfer all Check transactions
checktransfertype bpchar 1  √  null Check Transfer Type
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
c_templatebpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id ctemplatebpartner_uposterminal R
BPartner that is to be used as template when new customers are created
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
isactive bpchar 1  √  'Y'::bpchar The record is active in the system
lastlocktime timestamp 29,6  √  null Last time at which the terminal was locked
locked bpchar 1  √  'N'::bpchar Whether the terminal is locked
locktime numeric 10  √  null Time in minutes the terminal should be kept in a locked state.
m_warehouse_id numeric 10  √  null
m_warehouse.m_warehouse_id mwarehouse_uposterminal R
Storage Warehouse and Service Point
name varchar 60  √  null Alphanumeric identifier of the entity
po_pricelist_id numeric 10  √  null
m_pricelist.m_pricelist_id popricelist_uposterminal R
Price List used by this Business Partner
printername varchar 60  √  null Name of the Printer
salesrep_id numeric 10  √  null
ad_user.ad_user_id salesrep_uposterminal R
Sales Representative or Company Agent
so_pricelist_id numeric 10  √  null
m_pricelist.m_pricelist_id sopricelist_uposterminal R
Sales Pricelist
unlockingtime timestamp 29,6  √  null Time at which the terminal should be unlocked
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10  √  null User who updated this records
u_posterminal_id numeric 10 POS Terminal
value varchar 40  √  null Search key for the record in the format required - must be unique
u_posterminal_uu varchar 36  √  NULL::character varying U_POSTerminal_UU

Table contained 1 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.