TECHNICAL DETAILS

Tables Read

Account (ACCT) — Manage Accounts

Accounting Period (ACCTING_PD) — Manage Accounting Periods

Allocation Basis Journal History (ALLOC_BASIS_JNL_HS)

Billable Labor Category (BILL_LAB_CAT) — Manage Project Labor Categories (PLC)

Employee (EMPL) - Manage Employee Information

Employee Account Group Default (EMPL_ACCT_GRP_DFLT) — Manage Employee Proj-Acct-Group Timesheet Defaults

Fiscal Year (FY) — Manage Fiscal Years

General Labor Category (GENL_LAB_CAT) — Manage General Labor Categories

Cash Receipts Header History (CASH_RECPT_HDR_HS)

Cash Receipts Transaction History (CASH_RECPT_TRN_HS)

Costpoint to Microframe Organization Breakdown Structure Mapping (X_MIC_OBSMAP)

Costpoint to Microframe Work Breakdown Structure Mapping (X_MIC_WBSMAP)

Journal Entry Header History (JE_HDR_HS)

Journal Entry Labor Employee History (JE_TRN_LAB_EMPL_HS)

Journal Entry Labor Vendor History (JE_TRN_LAB_VEND_HS)

Journal Entry Transaction History (JE_TRN_HS)

Microframe EOC Mapping (X_MIC_EOCMAP) — Manage Microframe EOC Mappings

Microframe Mapping Codes (X_MIC_MAP)]

Microframe Resource Mappings (X_MIC_RESMAP) — Manage Microframe Resource Mappings

Organization (ORG)

Other Pool Info (POOL_INFO)

Project (PROJ) — Manage Project User Flow

Project Burden Summary (PROJ_BURD_SUM) — Compute Revenue

Project Employee Labor Category (PROJ_EMPL_LAB_CAT)

Project Modifications (PROJ_MOD) — Manage Modifications

Reference Structure (REF_STRUC) — Manage Reference Structures

Salary Information and History (EMPL_LAB_INFO) — Manage Employee Salary Information

Timesheet Header History (TS_HDR_HS)

Timesheet Line History (TS_LN_HS)]

Vendor (VEND) — Manage Vendors

Vendor Expense Accounts (VEND_EXP_ACCT) — Manage Vendors

Voucher Header History (VCHR_HDR_HS)

Voucher Labor Vendor History (VCHR_LAB_VEND_HS)

Voucher Line History (VCHR_LN_HS)

Tables Read and Written

Function Parameter Catalog (FUNC_PARM_CATLG)

Microframe Transfer Parameters (X_PARMS_AOPMICDN) - Create Microframe Transfer File

Microframe Data (X_MIC_DATA)]

Microframe Errors (X_MIC_ERROR)

Other Output

Microframe Transfer File (user named)

Microframe Error Report

Microframe Edit Report

Output File Layout

Microframe WBS ID                Character (20)

The Microframe Work Breakdown Structure field (entered in the Manage Microframe WBS Mappings screen), account, reference 1, or reference 2 depending on WBS ID Source selected on the Create Microframe Transfer File screen.

EOC Code                             Character (10)

When you transfer by EOC, this value is "*" plus the EOC code. When you transfer by resource, this value is the resource code.

Resource Department             Character (10)

When you transfer by EOC, this value is blank. When you transfer by resource, this value is the Microframe department taken from the Manage Microframe OBS Mappings screen (Organization Breakdown Structure field).

Overtime Factor                     Character (1)

This value is blank.

Microframe Month                   Number (6)

Calendar year and month in the format "YYYYMM," taken from the Create Microframe Transfer File screen.

Hours                                    Character (12)

Labor hours from the timesheet history, vendor history, and journal history tables.

Prime Dollars                         Character (12)

Transaction amount from the timesheet history, vendor history, allocation basis journal history, and journal history tables.

Overhead Dollars                   Character (12)

Amount of the burden markup for pool types one through four from the Project Burden Summary table, multiplied by the transaction amount.

G&A Dollars                           Character (12)

Amount of the burden markup for pool types five and six from the Project Burden Summary table, multiplied by the transaction amount.

COM Dollars                          Character (12)

Amount of the burden markup COM from the Project Burden Summary table, multiplied by the transaction amount.

Fee Dollars                            Character (12)

Amount of the fee value divided by the cost value from the Project Modification table, multiplied by the transaction amount.