http://in.compucrete.com/index.php?action=history&feed=atom&title=Dev%3A_Job_Cost_System_Design
Dev: Job Cost System Design - Revision history
2026-05-15T16:57:34Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=Dev:_Job_Cost_System_Design&diff=124&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T12:58:48Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-123:rev-124 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=Dev:_Job_Cost_System_Design&diff=123&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:01:32Z
<p>1 revision imported</p>
<p><b>New page</b></p><div>=Job Cost Spec=<br />
<br />
==Tables==<br />
<br />
===JCTJOB===<br />
<br />
{| <br />
| style="background:#ffffff"|FIELD<br />
| style="background:#ffffff"|DATA TYPE<br />
|-<br />
| |JOB_ID<br />
| |VARCHAR(20)<br />
|-<br />
| |NAME <br />
| |VARCHAR(30) <br />
|-<br />
| |DESCRIPTION_1<br />
| |VARCHAR(35) <br />
|-<br />
| |DESCRIPTION_2<br />
| |VARCHAR(35) <br />
|-<br />
| |DESCRIPTION_3<br />
| |VARCHAR(35) <br />
|-<br />
| |DESCRIPTION_4<br />
| |VARCHAR(35) <br />
|-<br />
| |ADDRESS_1<br />
| |VARCHAR(30) <br />
|-<br />
| |ADDRESS_2<br />
| |VARCHAR(30) <br />
|-<br />
| |ADDRESS_3<br />
| |VARCHAR(30) <br />
|-<br />
| |ADDRESS_4<br />
| |VARCHAR(30) <br />
|-<br />
| |AR_JOB_SESSION_NO<br />
| |INTEGER<br />
|-<br />
| |AR_JOB_TRANS_NO<br />
| |INTEGER<br />
|-<br />
| |JOB_GROUP<br />
| |VARCHAR(2)<br />
|-<br />
| |START_DATE<br />
| |DATE<br />
|-<br />
| |STOP_DATE<br />
| |DATE<br />
|-<br />
| |CONTRACT_AMT<br />
| |NUMERICE(15,2)<br />
|-<br />
| |PCT_COMPLETE<br />
| |NUMERICE(15,4)<br />
|-<br />
| |LAST_CHANGE_DATETIME<br />
| |TIMESTAMP<br />
|-<br />
| |LAST_CHANGE_USER<br />
| |VARCHAR(10)<br />
|-<br />
| |ACTIVE_FLAG<br />
| |CHAR(1)<br />
| |DEFAULT 'Y' NOT NULL<br />
|}<br />
<br />
<br />
===JCTBUDCAT===<br />
<br />
{| <br />
| |BUDCAT_ID<br />
| |CHAR(10)<br />
|-<br />
| |DESCRIPTION<br />
| |VARCHAR(35)<br />
|-<br />
| |LAST_CHANGE_DATETIME<br />
| |TIMESTAMP<br />
|-<br />
| |LAST_CHANGE_USER<br />
| |VARCHAR(10)<br />
|-<br />
| |ACTIVE_FLAG<br />
| |CHAR(1)<br />
| |DEFAULT 'Y' NOT NULL<br />
|}<br />
<br />
===JCTTRXTYPE===<br />
<br />
{| <br />
| |TRX_TYPE<br />
| |VARCHAR(2)<br />
|-<br />
| |DESCRIPTION<br />
| |VARCHAR(35)<br />
|-<br />
| |AMT_TYPE<br />
| |CHAR(1)<br />
| |CURRENCY,HOURS,QTY<br />
|-<br />
| |UNIT_OF_MEASURE<br />
| |VARCHAR(2)<br />
|-<br />
| |LAST_CHANGE_DATETIME<br />
| |TIMESTAMP<br />
|-<br />
| |LAST_CHANGE_USER<br />
| |VARCHAR(10)<br />
|-<br />
| |ACTIVE_FLAG<br />
| |CHAR(1)<br />
| |DEFAULT 'Y' NOT NULL<br />
|}<br />
<br />
CLASSIC JC TYPES:<br />
<br />
<PRE><br />
1 LABOR HOURS<br />
2 ACTUAL LABOR DOLLARS<br />
3 EXPENSES (IE TRAVEL)<br />
4 FRINGE BENEFITS<br />
5 MATERIALS<br />
6 SUBCONTRACT AND CONSULTANTS<br />
7 EQUIPMENT<br />
8 MISCELLANEOUS CHARGES<br />
9 BILLABLE LABOR<br />
</PRE><br />
<br />
===JCTJOBGROUP===<br />
<br />
{| <br />
| |JOB_GROUP<br />
| |VARCHAR(2)<br />
|-<br />
| |DESCRIPTION<br />
| |VARCHAR(35)<br />
|-<br />
| |LAST_CHANGE_DATETIME<br />
| |TIMESTAMP<br />
|-<br />
| |LAST_CHANGE_USER<br />
| |VARCHAR(10)<br />
|-<br />
| |ACTIVE_FLAG<br />
| |CHAR(1)<br />
| |DEFAULT 'Y' NOT NULL<br />
|}<br />
<br />
===JCTJOBBUD===<br />
<br />
{| <br />
| |JOB_ID<br />
| |VARCHAR(20)<br />
|-<br />
| |BUDCAT_ID<br />
| |VARCHAR(10)<br />
|-<br />
| |TRX_TYPE<br />
| |VARCHAR(2)<br />
|-<br />
| |BUDGET_AMT<br />
| |NUMERIC(15,2)<br />
|-<br />
| |PCT_COMPLETE<br />
| |NUMERIC(15,4)<br />
|-<br />
| |LAST_CHANGE_DATETIME<br />
| |TIMESTAMP<br />
|-<br />
| |LAST_CHANGE_USER<br />
| |VARCHAR(10)<br />
|-<br />
| |ACTIVE_FLAG<br />
| |CHAR(1)<br />
| |DEFAULT 'Y' NOT NULL<br />
|}<br />
<br />
===JCTJOBTRX===<br />
<br />
{| <br />
| |SESSION_NO<br />
| |INTEGER<br />
|-<br />
| |TRANS_NO<br />
| |INTEGER<br />
|-<br />
| |JOB_ID<br />
| |VARCHAR(20)<br />
|-<br />
| |BUDCAT_ID<br />
| |VARCHAR(10)<br />
|-<br />
| |TRX_TYPE<br />
| |VARCHAR(2)<br />
|-<br />
| |TRX_DATE<br />
| |DATE<br />
|-<br />
| |TRX_AMOUNT<br />
| |NUMERIC(15,2)<br />
|-<br />
| |UNIT_OF_MEASURE<br />
| |VARCHAR(2)<br />
|-<br />
| |DESCRIPTION<br />
| |VARCHAR(35)<br />
|-<br />
| |SOURCE_APP<br />
| |CHAR(1)<br />
|-<br />
| |SOURCE_SESSION_NO<br />
| |INTEGER<br />
|-<br />
| |SOURCE_TRANS_NO<br />
| |INTEGER<br />
|-<br />
| |SOURCE_LINE_NO<br />
| |INTEGER<br />
|}<br />
<br />
===APTINVDT/APTBINDT===<br />
<br />
Existing:<br />
{| <br />
| |JOB_ID<br />
| |VARCHAR(20)<br />
|-<br />
| |JC_BUD_CAT<br />
| |VARCHAR(10)<br />
|-<br />
| |JC_TYPE_CODE<br />
| |VARCHAR(2)<br />
|}<br />
<br />
===PRTTIMCRDHD/PRTCRDHSTHD===<br />
Existing:<br />
{| <br />
| |JOB_LOC<br />
| |VARCHAR(18)<br />
|-<br />
| |BUDGET_CATEGORY<br />
| |VARCHAR(10)<br />
|}<br />
<br />
===PRTCOMPDEF===<br />
New:<br />
{| <br />
| |JOB_TRX_TYPE<br />
| |VARCHAR(2)<br />
|}<br />
<br />
==New Programs==<br />
<br />
===Transactions===<br />
Job Cost Transaction Entry<br />
<br />
===Reports===<br />
:Job Cost Summary<br />
::By Job<br />
::By Budget Category<br />
::By Budget Category/Type<br />
:Job Cost Detail<br />
<br />
===File Maintenance===<br />
:Job<br />
::Budget Maintenance<br />
::Percent C0mpete Maintenance<br />
:Budget Category<br />
:Job Transaction Type<br />
:Job Group<br />
<br />
===File Lists===<br />
:Job Cost<br />
::Job List<br />
::Budget Summary<br />
:Budget Category<br />
:Job Transaction Type<br />
:Job Group<br />
<br />
==PROGRAMS AFFECTED==<br />
<br />
===Accounts Payable===<br />
*Invoice Vouchering<br />
::Distribution<br />
::Posting<br />
<br />
===Payroll===<br />
*Time Card Entry <br />
*Commit Payroll<br />
*Void<br />
*Company Maintenance</div>
Intra>User