| id |
integer |
Yes |
Yes |
nextval('job_items_id_seq'::regclass) |
Unique identifier |
| job_no |
character varying(10) |
No |
No |
|
Job number - links to jobs.job_no |
| account |
character varying(10) |
No |
No |
|
Job account number - links to jobs.account |
| date |
date |
No |
No |
|
|
| folio |
character varying(10) |
No |
No |
|
Job Transaction number for this record |
| recno |
integer |
No |
No |
|
Sequential record number |
| where_from |
character varying(4) |
No |
No |
|
The module that the transaction originated from; AP = Accounts Payable AR = Accounts Receivable GL = General Ledger INVC = Inventory Count INVR = Inventory Receipts LWAY = Sales Deposit MFG = Manufacturing PAYR = Payroll PORD = Purchase Orders SORD = Sales Orders |
| jcd_user |
character varying(3) |
No |
No |
|
User initials that posted the transaction |
| mf_who |
character varying(10) |
No |
No |
|
Transaction type |
| mf_key |
character varying(20) |
No |
No |
|
The code of the associated record involved in the transaction; Vendor code Customer code Employee code Inventory code |
| mf_tran |
character varying(25) |
No |
No |
|
Document reference or document number for transaction, Invoice or Purchase Order number. |
| post_date |
date |
No |
No |
|
The date the transaction was posted as per user's log on date. |
| tran_date |
date |
No |
No |
|
Transaction date used to set fiscal period for transaction |
| expense |
numeric(15,2) |
Yes |
No |
|
Expense amount for this transaction |
| income |
numeric(15,2) |
Yes |
No |
|
Income or Revenue amount for this transaction |
| hours |
numeric(9,2) |
Yes |
No |
|
Hours for transaction |
| _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 |
| gl_memo |
character varying(60) |
No |
No |
|
Memo created automatically by some subledger transactions or entered manually by the user |
| foreign_expense |
numeric(15,2) |
Yes |
No |
0 |
Expense in foreign currency if applicable |
| foreign_income |
numeric(15,2) |
Yes |
No |
0 |
Income or Revenue in foreign currency if applicable |
| currency |
character varying(3) |
No |
No |
|
Currency for transaction; blank = base currency - links to currencies.code |
| currency_rate |
numeric(13,7) |
No |
No |
|
Currency conversion rate used |
| currency_rate_method |
character varying(1) |
No |
No |
|
Currency rate conversion method used; / = direct * = indirect |