| id |
integer |
Yes |
Yes |
nextval('note_types_id_seq'::regclass) |
Unique identifier |
| type |
character varying(10) |
No |
No |
|
User set Code for the note type |
| link_table |
character varying(80) |
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 |
| description |
character varying(35) |
No |
No |
|
Description for the note type |