Listed below for the Project Tracking Interface are the posting type, the posting type description, what transactions are used for the postings, and the value for the posting.
For example, the posting type JBGR is used to post when a change is made to the gross revenue of the project, and is calculated as the new gross revenue amount.
When entering Project Tracking posting templates in program GPTM, Posting Template Maintenance, if the credit and debit accounts are the same, postings will not be created for transactions meeting that template's criteria.
The REV posting types, such as APREV, RDREV, MDREV, JLREV, and LDREV post earned amounts as calculated when transactions are entered. They do not reflect any budget constraints imposed at the project line level.
The Project Tracking Interface uses Two-sided entries
APCA AP Amount Vouchered Change in amount vouchered in APVM, Voucher Entry/Maintenance. The amount vouchered is posted
APREV AP Amount Earned Change in amount earned in APVM, Voucher Entry/Maintenance. The amount earned is posted
CURR Currency Gain/Loss
JBCB Billing Cost Booked Change in cost booked from program PMBM, Project Billing. The amount booked is posted
JBGR Billing Cost Gross Amount Change in gross revenue from program PMBM, Project Billing. The gross revenue amount is posted
JLCA Project Line Labor Cost, Actual Change in actual cost, from transactions entered in the following programs. The change in actual cost is posted.
PMLE, Project Labor Entry
PMRE, Project Resource Entry
PMME, Project Material Entry
PMXE, Project Expense Entry
Purchase order receipts
Work order receipts
JLCS Project Line Change in standard cost, from transactions entered in the following programs. The change in standard cost is posted.
PMLE, Project Labor Entry
PMRE, Project Resource Entry
PMME, Project Material Entry
Purchase order receipts
Work order receipts
JLREV Project Line Revenue Earned Change in the budgeted revenue entered in program PMMM, Project Tracking Maintenance. The change in budgeted revenue is posted.
JLEAR Project Line Amount Earned Change in the amount earned, from transactions entered in the following programs. The change in the amount earned is posted.
PMMM, Project Tracking Maintenance
PMLE, Project Labor Entry
PMRE, Project Resource Entry
PMME, Project Material Entry
PMXE, Project Expense Entry
Purchase order receipts
Work order receipts
JLBUD Project Lone Cost Budget Change in the budgeted cost in program PMMM, Project Tracking Maintenance. The change in the cost budget is posted.
JLGRP Project Line Gross Profit Change in the gross profit, from transactions entered in the following programs. The change in the gross profit is posted.
PMMM, Project Tracking Maintenance
PMLE, Project Labor Entry
PMRE, Project Resource Entry
PMME, Project Material Entry
PMXE, Project Expense Entry
Purchase order receipts
Work order receipts
LDCA Labor Detail Actual Cost Change in labor actual cost from program PMLE, Project Labor Entry, or program PMRE, Project Resource Entry. The actual labor cost is posted.
LDCS Labor Detail Standard Cost Change in the labor standard cost from program PMLE, Project Labor Entry, or program PMRE, Project Resource Entry. The standard labor cost is posted.
LDREV Labor Detail Revenue Earned Change in labor detail amount earned from program PMLE, Project Labor Entry, or PMRE, Project Resource Entry. The labor detail amount earned is posted.
MDCA Material Detail 2nd Mfg Cost Change in material actual cost from program PMME, Project Material Entry, or work order receipts. The material actual cost is posted.
MDCAF Element Fix Ovhd 2nd Mfg Cost Change in actual fixed overhead cost component from program PMME, Project Material Entry, or work order receipts. The actual fixed overhead cost component is posted.
MDCAL Element Labor 2nd Mfg Cost Change in actual labor cost component from program PMME, Project Material Entry, or work order receipts. The actual labor cost component is posted.
MDCAM Element Material 2nd Mfg Cost Change in actual material cost component from program PMME, Project Material Entry, or work order receipts. The actual material cost component is posted.
MDCAS Element Service 2nd Mfg Cost Change in actual service cost component from program PMME, Project Material Entry, or work order receipts. The actual service cost component is posted.
MDCAV Element Var Ovhd 2nd Mfg Cost Change in actual variable overhead cost component from program PMME, Project Material Entry, or work order receipts. The actual variable overhead cost component is posted.
MDCS Material Detail System Cost Change in material standard cost from program PMME, Project Material Entry, or work order receipts. The material standard cost is posted.
MDCSF Element Fix Ovhd System Cost Change in standard fixed overhead cost component from program PMME, Project Material Entry, or work order receipts. The standard fixed overhead cost component is posted.
MDCSL Element Labor System Cost Change in standard labor cost component from program PMME, Project Material Entry, or work order receipts. The standard labor cost component is posted.
MDCSM Element Material System Cost Change in standard material cost component from program PMME, Project Material Entry, or work order receipts. The standard material cost component is posted.
MDCSS Element Service System Cost Change in standard service cost component from program PMME, Project Material Entry, or work order receipts. The standard service cost component is posted.
MDCSV Element Var Ovhd System Cost Change in standard variable overhead cost component from program PMME, Project Material Entry, or work order receipts. The standard variable cost component is posted.
MDREV Material Detail Revenue Earned Change in detail amount earned from program PMME, Project Material Entry, or work order receipts. The detail amount earned is posted.
RDCA Receiving Actual Cost Change in the actual cost from program REOM, One Step Receiver Entry/Maintenance, or program REMD, Move to Destination. The actual cost.
RDREV Receiving Detail Revenue Earned Change in detail amount earned from program REOM, One Step Receiver Entry/Maintenance, or program REMD, Move to Destination. The detail amount earned.
XDBC Billable Cost Change in the expense billable cost from program PMXE, Project Expense Entry. The billable cost.
XDCA Expense Detail Actual Cost Change in expense actual cost from program PMXE, Project Expense Entry. The actual cost.
XDREV Expense Detail Revenue Earned Change in the expense detail amount earned from program PMXE, Project Expense Entry. The detail amount earned.
When entering Project Tracking posting templates in program GPTM, Posting Template Maintenance, if the credit and debit accounts are the same, postings will not be created for transactions meeting that template's criteria.
|
Project Tracking |
APCA |
APREV |
CURR |
JBCB |
JBGR |
JLBIL |
JLBUD |
JLCA |
JLCS |
JLEAR |
JLGRP |
JLREV |
LDCA |
LDCS |
LDREV |
MDCA |
MDCAF |
MDCAL |
|
ACI |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALT_CURRENCY_CD |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
BILLING_ID |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
X |
X |
|
BILLING_TYPE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CLASS_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
COST_ELEMENT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CUST_NO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DEPARTMENT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EFF_RATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EMPNO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE6S |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ITEM_NO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
X |
X |
|
JOB_GROUP_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JOB_LINE_NO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
X |
X |
|
JOB_LINE_TYPE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JOB_NO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
X |
X |
|
LABOR_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
LABOR_RESOURCE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
LINE_STATUS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PLANT_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
X |
X |
|
PO_LINE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PO_NO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PRODUCT_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PRODUCT_GROUP |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PROJECT_ID |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RATE_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RATE_TYPE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RESOURCE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TRANS_DATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
UNIT_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
X |
X |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Project Tracking |
MDCAM |
MDCAS |
MDCAV |
MDCS |
MDCSF |
MDCSL |
MDCSM |
MDCSS |
MDCSV |
MDREV |
RDCA |
RDREV |
XDBC |
XDCA |
XDREV |
|
ACI |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALT_CURRENCY_CD |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
BILLING_ID |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
|
|
|
|
BILLING_TYPE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CLASS_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
COST_ELEMENT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CUST_NO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DEPARTMENT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EFF_RATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EMPNO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1S |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ICODE1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ITEM_NO |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
|
|
|
|
JOB_GROUP_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JOB_LINE_NO |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
|
|
|
|
JOB_LINE_TYPE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JOB_NO |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
|
|
|
|
LABOR_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
LABOR_RESOURCE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
LINE_STATUS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PLANT_CODE |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
|
|
|
|
PO_LINE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PO_NO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PRODUCT_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PRODUCT_GROUP |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PROJECT_ID |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RATE_CODE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RATE_TYPE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RESOURCE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TRANS_DATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
UNIT_CODE |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|