Input File Layout
Use this information as a guide in creating an input file that you can upload to Costpoint using the Import Multi-Job Allocation Percentage Basis screen.
Note: The input file layout may contain fields that are available only in Costpoint Advanced. If you are using Costpoint Essentials, these fields are excluded from the import process and may be left blank or null when you create the input file.
Multi-Job Allocation Percentage Basis Input File (PROJ_ALLOC_PCTBASE)
| Column No | Column Name | Costpoint Field Name | Data Type | Data Length | "R" (Required) / "O" (Optional) / "D" (Derived) | Contents |
|---|---|---|---|---|---|---|
| 1 | ALLOC_CD | Allocation Code | Character | 6 | R | |
| 2 | PROJ_ID | Project | Character | 30 | O | |
| 3 | ACCT_ID | Account ID | Character | 15 | R | |
| 4 | ORG_ID | Organization | Character | 20 | R | |
| 5 | APPLY_RES_FL | Apply Residual Flag (Y/N) | Character | 1 | R | Y, N |
| 6 | UNITS_AMT | Units | Decimal | 14,4 | R | |
| 7 | DOL_LIMIT_AMT | Dollar Limit Amount | Decimal | 14,2 | R |