3305 Main Street Ste 019 Vancouver, WA 98663

OCI MW – File Format

Column Notes

1 - Record Type

Alpha, 5 Characters
Required.
Must be "JCTMW"

2 - Job

Alpha, 12 Characters
Required.
Must identify an existing Job.
See details.

3 - Extra

Alpha, 10 Characters
Optional.
If provided, must identify an existing Extra for the Job.
See details.

4 - Cost Code

Alpha, 13 Characters
Optional.
If provided, must identify an existing Cost Code for the Job or for the Job & Extra.
See details.

5 - Category

Alpha, 3 Characters
Optional.
If provided, must identify an existing Category under the Job & Cost Code or under the Job, Extra & Cost Code.
See details.

6 - Transaction Type

Alpha
Required.
May be either the text or numeric value for one of the transaction types shown below:
  1. EstimatedProdUnits
  2. ActualProdUnits
  3. PercentComplete
  4. MiscAmount1
  5. MiscAmount2
  6. MiscAmount3
  7. MiscAmount4
  8. MiscAmount5
  9. MiscAmount6
  10. ScheduledValue
See details.

7 - Transaction Date

Date
Required.
Date of transaction. Date must be formatted in a manner consistent with the Short Date format in the Windows Regional and Language Options (found in Windows Control Panel).

8 - Description

Alpha, 30 Characters
Optional.
Description of transaction.

9 - Units

Numeric, 8.4
Only required for Estimated or Actual Production Unit transactions. Not valid for all other types.

10 - Amount

Numeric 9.2
Required for all transaction types except Estimated and Actual Production Unit transactions.

11 - Action

Alpha
Optional.
Determines whether the Units or Amount value should be added to the current master file amount or if the value should replace the current master file amount. Possible values may be a number, letter, or text:
  • 1 | R | Replace
  • 2 | A | Add
If not specified, the action will be Add for all transaction types except for Percent Complete which will always use an action of Replace.
See details.

12 - Reference 1

Alpha
Optional.
Value for the Reference 1 field.

13 - Reference 2

Alpha
Optional.
Value for the Reference 2 field.

See Also