| id |
integer |
Yes |
Yes |
nextval('notes_id_seq'::regclass) |
|
| link_table |
character varying(4) |
No |
No |
|
Field to use for module linking; AP = Accounts Payable AR = Accounts Receivable BORD = Production Orders CUST = Customer EMP = Employee IADJ = Inventory Adjustment INV = Inventory JC = Job Cost NOTE = Communiction PORD = Purchase Order SORD = Sales Order TRAN = General Ledger Transaction VEND = Vendor |
| link_no |
character varying(60) |
No |
No |
|
Field to store join value for link to; vendor_no, cust_no, employee_no, job_no, purchase_no, order_no, trans_no, part_no |
| subject |
character varying(60) |
No |
No |
|
Subject of the communication |
| attachment_flag |
boolean |
No |
No |
|
Has an attachment; FALSE = No TRUE = Yes |
| attachment_type |
character varying(50) |
No |
No |
|
Type of attachment |
| attachment_path |
character varying(280) |
No |
No |
|
Network path to the attachment |
| detail |
text |
No |
No |
|
Note text |
| due_date |
date |
No |
No |
|
Due date set by user |
| completed_date |
timestamp without time zone |
No |
No |
|
Completed date set by user |
| alert_flag |
integer |
No |
No |
|
Not used |
| display_flag |
character(1) |
No |
No |
|
Display setting; A = Alert popup B = Both P = Print on form |
| type |
character(1) |
No |
No |
|
Document to print this note on; A = Packing Slip B = Booking Order C = Picking Slip I = Invoice O = Order Confirmation P = Purchase Order Q = Quote S = Sales Order W = Work Order |
| group_type |
character varying(10) |
No |
No |
|
Note type - links to note_types.type |
| qty |
numeric(21,5) |
No |
No |
|
Numeric reference value |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
| due_time |
time without time zone |
No |
No |
|
Due time set by user |
| assigned_user_id |
integer |
No |
No |
|
User note is assigned to |