Project Tracking Interface

images\btn_see_also_programs64.gif

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.

Project Tracking Post Types and Parameter Items

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