Name | Data type | Not Null? | Primary key? | Default | Comment |
---|---|---|---|---|---|
id | integer | Yes | Yes | nextval('udf_pages_id_seq'::regclass) | Unique identifier |
link_table | character varying(32) | Yes | No | Table this UDF definition record is for; AR = Accounts Receivable AP = Accounts Payable BOLi = Production Order Items BORD = Production Order EMP = Employees CUST = Customer INV = Inventory PORD = Purchase Orders PROD = Product Codes SHIS = Sales Sistory SHLi = Sales History Items SORD = Sales Orders SOLi = Sales Order Items VEND = Vendors | |
sequence | integer | Yes | No | Sequential number to control order of pages | |
label | character varying(60) | No | No | ''::character varying | Page label |
Name | Type | Definition | Comment |
---|---|---|---|
udf_pages_pkey | Primary key | (id) | |
udf_pages_link_table_sequence_uniq | Unique | (link_table, sequence) DEFERRABLE INITIALLY DEFERRED |