id |
integer |
Yes |
Yes |
nextval('udf_fields_id_seq'::regclass) |
Unique identifier |
page_id |
integer |
Yes |
No |
|
Link to udf_pages.id |
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 items |
field_name |
character varying(32) |
No |
No |
''::character varying |
Name of field |
widget_type |
character varying(32) |
No |
No |
'BCTextBox'::character varying |
Field type |
field_label |
character varying(60) |
No |
No |
''::character varying |
Field label |
align |
smallint |
No |
No |
0 |
Alignment setting; 0 = Left 1 = Centre 2 = Right |
field_type |
smallint |
No |
No |
0 |
Field type; 0 = Numeric 1 = Currency 2 = Percent 3 = Date 4 = Text 5 = Masked Text |
decimals |
smallint |
No |
No |
2 |
Number of decimals |
thousands_sep |
boolean |
No |
No |
false |
Use thousands separator; FALSE = No TRE = Yes |
negative_format |
smallint |
No |
No |
0 |
Display negative format; 0 = -SYM1,234.00 1 = -1,234.00SYM 2 = SYM1,234.00- 3 = 1,234.00SYM- 4 = (SYM1,234.00) 5 = (1,234.00SYM) 6 = SYM1,234.00 (red) 7 = 1,234.00SYM (red) |
text_mask |
character varying(64) |
No |
No |
''::character varying |
Text mask set by user |
mask_text_case |
smallint |
No |
No |
0 |
Text case mask; 0 = Any Case 1 = UPPERCASE 2 = lowercase |
validate_period |
boolean |
No |
No |
false |
Validate period flag; FALSE = No TRUE = Yes |
validate_period_mode |
smallint |
No |
No |
0 |
Fiscal period validatation mode; 0 = Current month 1 = Current year 2 = Within fiscal periods |
postdate_warning |
boolean |
No |
No |
false |
Post-dated message enabled; FALSE = No TRUE = Yes |
backdate_warning |
boolean |
No |
No |
false |
Back-dated message enabled; FALSE = No TRUE = Yes |
require_numeric |
boolean |
No |
No |
false |
Require numeric data flag; FALSE = No TRUE = Yes |
min_numeric |
bigint |
No |
No |
0 |
Minimum number permitted |
max_numeric |
bigint |
No |
No |
0 |
Maximum number permitted |
list_items |
character varying[] |
No |
No |
'{}'::character varying[] |
Items list as set by user |
allow_null_date |
boolean |
No |
No |
false |
Allow empty date enabled; FALSE = No TRUE = Yes |
default_null_date |
boolean |
No |
No |
false |
Default empty date enabled; FALSE = No TRUE = Yes |