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 |