Import CSSR Budgets Input File Layout
Below is the input file layout for the Import CSSR Budgets screen.
Numbers should be right-justified, alphas (like PROJ_ID and FY_CD) should be left-justified, and any remaining unfilled positions must contain spaces.
CSSR Budgets Input File (PROJ_CSSR_BUD)
Column No | Column Name | Costpoint Field Name | Data Type | Data Length | "R" (Required) / "O" (Optional) / "D" (Derived) | Position |
---|---|---|---|---|---|---|
1 | PROJ_ID | Project | Character | 30 | R | 1-30 |
2 | FY_CD | Fiscal Year | Character | 6 | R | 31-36 |
3 | PD_NO | Period Number | Number | 2 | R | 37-38 |
4 | SUB_PD_NO | Subperiod Number | Number | 2 | R | 39-40 |
5 | SCHEDULED_AMT | Scheduled Amount | Decimal | 14 | R | 41-54 |
6 | PERFORMED_AMT | Performed Amount | Decimal | 14 | R | 55-68 |
7 | SCHEDULED_COM_AMT | Scheduled Cost Of Money Amount | Decimal | 14 | O | 69-82 |
8 | PERFORMED_COM_AMT | Performed Cost Of Money Amount | Decimal | 14 | O | 83-96 |
9 | SCHEDULED_GA_AMT | Scheduled G&A Amount | Decimal | 14 | O | 97-110 |
10 | PERFORMED_GA_AMT | Performed G&A Amount | Decimal | 14 | O | 111-124 |
Parent Topic: Import CSSR Budgets