Input File Layout
The input file is named by the user.
The error file has the same name with an ".ERR" extension.
The input file can be either a fixed-format file or a comma-separated file. If the file is a fixed-format file, you must fill every position with either an appropriate character or a space. It is not necessary to zero-fill numbers; you can use spaces to maintain the proper format. If the file is comma-separated, it is not necessary to fill every position, but the file must have the correct number of commas. Each record must be on a separate line and end with a carriage return and line feed.
In fixed-format files, you must populate the required input file fields with valid data. If you do not populate an optional column in a fixed-length input file, you must enter the maximum number of spaces for that column before entering data for the next column. After you have entered the last character of meaningful data for the input file, you do not need to fill the remaining column lines with spaces. For example, if the Sequence Number field in position 229 is the last required value (out of the total possible field position spaces), you do not need to add the remaining spaces. However, if you enter the Sequence Number in position 229 and wish to enter data in the Project-Account Abbrev field (positions 240-245) but not the Effective Billing Date field (positions 230-239), you must enter 10 spaces in place of the Effective Billing Date field before entering Project-Account Abbrev data in position 240-245. This also applies when you enter data in a required field, skip the following optional field, and then enter data in another required field.
Note: You cannot use commas in the
Notes field. Neither format requires that the
Notes field be filled with spaces, but both require that every record end with a carriage return and line feed.
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.
Pay Type field Expanded to 15 Characters
Starting in Costpoint 2026.2, Costpoint expanded the allowed length of Pay Type values from 3 characters to 15 characters. To support this enhancement, the fixed length file layout used by the Import Timesheets application was updated to accommodate the longer Pay Type field.
If your organization currently imports fixed length timesheet files with a Pay Type field limited to 3 characters, you may encounter import errors when using Costpoint 2026.2. This can occur if your timesheet product has not yet been updated to align with the revised file layout. To help minimize disruption, we are providing a transition period.
Beginning with Costpoint 2026.2.1, the Import Timesheets application will support the following file formats:
- Comma Separated
- Fixed Length (3-character Pay Type) - transitional support
- Fixed Length (15-character Pay Type)
Support for the Fixed Length (3-character Pay Type) format will continue through Costpoint version 2026.4.
Important: The Fixed Length (3-character Pay Type) format will be removed in Costpoint 2027.1. If you use a fixed length timesheet file format, please begin coordinating with your timesheet product vendor now to:
- Transition to a comma separated file format, or
- Update your fixed length file layout to support a 15-character Pay Type. Cloud clients can find the updated file layouts in the application’s Help. On-Premise customers can find the file layouts in KB article 125962.
Taking action ahead of the 2027.1 release will help ensure uninterrupted timesheet imports.
Input File Excel Template
For Costpoint 2025.x and later releases, you can download the Excel template file specifically designed for this preprocessor from the Costpoint Preprocessor Guides page on the Deltek Learning Hub.
For Costpoint 8.1, the input file is available on the Developer Resources page in the Costpoint Information Center.
Excel templates for the other Costpoint preprocessors can be found in these same locations.
Non-MO/SO Timesheets (15-character Pay Type)
| # | Field Name | Costpoint Table/Column | Data Type and Size | Column | Required/Optional | Defaulting Information | Format/Contents |
|---|---|---|---|---|---|---|---|
| 1 | Timesheet Date | TS_HDR and TS_LN.TS_DT | Char 10 | 1–10 | Required | If a value is not supplied in the input file, the To date specified on the screen defaults. | YYYY-MM-DD |
| 2 | Employee ID | TS_HDR and TS_LN.EMPL_ ID | Char 12 | 11-22 | Required | ||
| 3 | Timesheet Type Code | TS_HDR and TS_LN.S_TS_ TYPE_CD | Char 2 | 23-24 | Required | If a value is not supplied in the input file, type R defaults. | R, B, L, D, N, or C |
| 4 | Working State | TS_HDR. WORK_STATE_CD | Char 2 | 25-26 | Required | If a value is not supplied in the input file, the Default Overtime State from the Manage Employee Salary Information screen defaults. | |
| 5 | Fiscal Year | TS_HDR.FY_ CD | Char 6 | 27-32 | Required | If not supplied in the input file, the Fiscal Year specified on the Import Timesheets screen defaults. | |
| 6 | Period | TS_HDR.PD_ NO | Numeric 2 | 33-34 | Required | If not supplied in the input file, the Period specified on the Import Timesheets screen defaults. | (99) |
| 7 | Subperiod | TS_HDR.SUB_PD_NO | Numeric 2 | 35-36 | Required | If not supplied in the input file, the Subperiod specified on the Import Timesheets screen defaults. | (99)
Note: Not available with a Costpoint Starter license.
|
| 8 | Correcting Ref Date | TS_HDR.CORRECTING_REF_DT | Char 10 | 37-46 | Optional | YYYY-MM-DD | |
| 9 | Pay Type | TS_LN.PAY_TYPE | Char 15 | 47-61 | Required | For default information, please see "Pay Type" in the Tables section of Processing Details. | |
| 10 | General Labor Category | TS_LN.GENL_LAB_CAT_CD | Char 6 | 62-67 | Required | For default information, please see "General Labor Category" in the Tables section of Processing Details. | |
| 11 | Timesheet Line Type Code | TS_LN.S_TS_ LN_TYPE_CD | Char 1 | 68-68 | Required | If a value is not supplied in the input file, type A defaults. | A, B, L, M, S |
| 12 | Labor Cost Amount | TS_LN.LAB_CST_AMT | Numeric 15 | 69-83 | Required | For default information, please the "Labor Cost Amount" in the Tables section of Processing Details. | (-99999999999.99) |
| 13 | Hours | TS_LN.ENTERED_HRS and CHG_HRS | Numeric 10 | 84-93 | Required | (-999999.99) | |
| 14 | Workers' Comp Code | TS_LN.WORK_COMP_CD | Char 6 | 94-99 | Required | For default information, please see "Workers' Comp Code" in the Tables section of Processing Details. | |
| 15 | Labor Location Code | TS_LN.LAB_LOC_CD | Char 6 | 100-105 | Required if Require Labor Location is selected on the Configure Labor Settings screen. | For default information, please see "Labor Location Code" in the Tables section of Processing Details. | |
| 16 | Organization ID | TS_LN.ORG_ID | Char 20 | 106-125 | Required | For default information, please see "Organization" in the Tables section of Processing Details. | |
| 17 | Account ID | TS_LN.ACCT_ ID | Char 15 | 126-140 | Required | For default information, please see "Account" in the Tables section of Processing Details. | |
| 18 | Project ID | TS_LN.PROJ_ ID | Char 30 | 141-170 | Required if Project Required is selected on the Manage Accounts screen for the specified account. | For default information, please see "Project" in the Tables section of Processing Details. | |
| 19 | Project Labor Category | TS_LN.BILL_LAB_CAT_CD | Char 6 | 171-176 | Required/ Optional status dependent upon project setup. | For default information, please see "Project Labor Category" in the Tables section of Processing Details. | |
| 20 | Reference Number 1 | TS_LN.REF_STRUC_1_ID | Char 20 | 177-196 | Optional | For default information, please see "Reference Number 1" in the Tables section of Processing Details. |
Note: This should be blank if you have a Costpoint Starter Edition license. Any value will cause an error.
|
| 21 | Reference Number 2 | TS_LN.REF_STRUC_2_ID | Char 20 | 197-216 | Optional | For default information, please see "Reference Number 2" in the Tables section of Processing Details. |
Note: This should be blank if you have a Costpoint Starter Edition license. Any value will cause an error.
|
| 22 | Organization Abbreviation | TS_LN.ORG_ABBRV_CD | Char 6 | 217-222 | Optional | If not supplied in input file, the organization abbreviation defaults from the Manage Organization Elements screen. | |
| 23 | Project Abbreviation | TS_LN.PROJ_ABBRV_CD | Char 6 | 223-228 | Optional | If not supplied in input file, the project abbreviation defaults from the Basic Info tab of the Manage Project User Flow. | |
| 24 | Sequence Number | TS_HDR and TS_LN.TS_HDR_SEQ_NO | Numeric 1 | 229-229 | Required | If a value is not supplied in the input file, 1 defaults. | 1 - 9 |
| 25 | Effective Billing Date | TS_LN.EFFECT_BILL_D | Char 10 | 230-239 | Optional | If a value is not supplied in the input file, the Default Method selected in the Effective Bill Date Options group box on the Configure Labor Settings screen is used to determine the default value. | YYYY-MM-DD |
| 26 | Project-Account Abbrev. | TS_LN.PROJ_ACCT_ABBRV_CD | Char 6 | 240-245 | Optional | If a value is not specified in the input file, the Proj-Acct Abbrev defaults from the Manage Project Account Groups screen. | |
| 27 | Multi-State Code | TS_LN.WH_ST_CD | Char 2 | 246-247 | Optional | Required if the Multi State Withholding Taxes check box is selected on the Manage Pay Periods screen. | |
| 28 | Reference Sequence Num | TS_HDR.REFERENCE_
SEQ_NO |
Char 1 | 248-248 | Optional | If not supplied and timesheet type is Labor Only, default 1. | |
| 29 | Timesheet Line Date | TS_LN.TS_LN_DT | Char 10 | 249-258 | Optional | Required only when prorating with a Calculation Method of Days per Cycle. | YYYY-MM-DD |
| 30 | Notes | TS_LN.NOTES | Char 254 | 259-512 | Optional |
Manufacturing Order Timesheets (15-character Pay Type)
Note: This input file layout section is used only by companies with a Costpoint Manufacturing license.
If the timesheet line type is M (Manufacturing Order), replace fields 22 through 30 with the following fields:
| # | Field Name | Costpoint Table/Column | Data Type and Size | Column | Required/ Optional | Defaulting Information | Format/Contents |
|---|---|---|---|---|---|---|---|
| 22 | Manufacturing Order ID | TS_LN_MO.MO_ID | Char 10 | 217-226 | Required if the Timesheet Line Type Code is M. | ||
| 23 | Operation Sequence No | TS_LN_MO.MO_ OPER_SEQ_NO | Numeric 4 | 227-230 | Required if the Operation Step No is specified. | ||
| 24 | Operation Step No | TS_LN_MO.MO_OPER_STEP_NO | Numeric 3 | 231-233 | Required if the Operation Sequence No is specified. | ||
| 25 | Activity Type | TS_LN_MO.S_ ACTIVITY_ TYPE | Char 1 | 234-234 | Required if the Timesheet Line Type Code is M. | R or S | |
| 26 | Work Center ID | TS_LN_MO.WC_ID | Char 12 | 235-246 | Optional | ||
| 27 | Organization Abbreviation | TS_LN.ORG_ ABBRV_CD | Char 6 | 247-252 | Optional | If not supplied in input file, the organization abbreviation defaults from the Manage Organization Elements screen. | |
| 28 | Project Abbreviation | TS_LN.PROJ_ ABBRV_CD | Char 6 | 253-258 | Optional | If not supplied in the input file, the project abbreviation defaults from the Basic Info tab of the Manage Project User Flow. | |
| 29 | Sequence Number | TS_HDR and TS_LN.TS_HDR_SEQ_NO | Numeric 1 | 259-259 | Required | If a value is not supplied in the input file, 1 defaults. | 1 - 9 |
| 30 | Effective Billing Date | TS_LN.EFFECT_BILL_DT | Char 10 | 260-269 | Optional | If a value is not supplied in the input file, the Default Method selected in the Effective Bill Date Options group box on the Configure Labor Settings screen is used to determine the default value. | YYYY-MM-DD |
| 31 | Project-Account Abbrev | TS_LN.PROJ_ACCT_ABBRV_CD | Char 6 | 270-275 | Optional | If not specified in the input file, the project account abbreviation defaults from the Manage Project Account Groups screen. | |
| 32 | Multi-State Code | TS_LN.WH_ST_CD | Char 2 | 276-277 | Optional | Required if the Multi State Withholding Taxes check box is selected on the Manage Pay Periods screen. | |
| 33 | Reference Seq Num | TS_HDR.REFERENCE_SEQ_NO | Char 1 | 278-278 | Optional | If not supplied and timesheet type is Labor Only, default 1. | |
| 34 | Timesheet Line Date | TS_LN.TS_LN_DT | Char 10 | 279-288 | Optional | Required only when prorating with a Calculation Method of Days per Cycle. | YYYY-MM-DD |
| 35 | Notes | TS_LN.NOTES | Char 254 | 289-542 | Optional |
Sales Order Timesheets (15-character Pay Type)
If the Timesheet Line Type is S (Sales Order), replace fields 22 through 30 with the following fields:
| # | Field Name | Costpoint Table/Column | Data Type and Size | Column | Required/ Optional | Defaulting Information | Format/Contents |
|---|---|---|---|---|---|---|---|
| 22 | Sales Order ID | TS_LN_SO.SO_ ID | Char 10 | 217-226 | Required if the Timesheet Line Type Code is S. | ||
| 23 | SO Release No | TS_LN_SO.SO_RLSE_NO | Numeric 2 | 227-228 | Required if the Timesheet Line Type Code is S. | ||
| 24 | SO Line No | TS_LN_SO.SO_LN_KEY | Numeric 2 | 229-230 | Optional | ||
| 25 | Organization Abbreviation | TS_LN.ORG_ABBRV_CD | Char 6 | 231-236 | Optional | If not supplied in input file, the organization abbreviation defaults from the Manage Organization Elements screen. | |
| 26 | Project Abbreviation | TS_LN.PROJ_ ABBRV_CD | Char 6 | 237-242 | Optional | If not supplied in input file, the project abbreviation defaults from the Basic Info tab of the Manage Project User Flow. | |
| 27 | Sequence Number | TS_HDR and TS_LN.TS_HDR_SEQ_NO | Numeric 1 | 243 | Required | If not supplied in the input file, 1 defaults. | 1 - 9 |
| 28 | Effective Billing Date | TS_LN.EFFECT_BILL_DT | Char 10 | 244-253 | Optional | If a value is not supplied in the input file, the Default Method selected in the Effective Bill Date Options group box on the Configure Labor Settings screen is used to determine the default value. | YYYY-MM-DD |
| 29 | Project-Account Abbrev. | TS_LN.PROJ_ ACCT_ABBRV_CD | Char 6 | 254-259 | Optional | If not specified in the input file, the project account abbreviation defaults from Manage Project Account Groups screen. | |
| 30 | Multi-State Code | TS_LN.WH_ST_CD | Char 2 | 260-261 | Optional | Required if the Multi State Withholding Taxes check box is selected on the Manage Pay Periods screen. | |
| 31 | Reference Sequence Num | TS_HDR.REFERENCE_SEQ_NO | Char 1 | 262 | Optional | If not supplied and timesheet type is Labor Only, default 1. | |
| 32 | Timesheet Line Date | TS_LN.TS_LN_DT | Char 10 | 263-272 | Optional | Required only when prorating with a Calculation Method of Days per Cycle. | YYYY-MM-DD |
| 33 | Notes | TS_LN.NOTES | Char 254 | 273-526 | Optional |
Non-MO/SO Timesheets (3-character Pay Type)
| # | Field Name | Costpoint Table/Column | Data Type and Size | Column | Required/Optional | Defaulting Information | Format/Contents |
|---|---|---|---|---|---|---|---|
| 1 | Timesheet Date | TS_HDR and TS_LN.TS_DT | Char 10 | 1–10 | Required | If a value is not supplied in the input file, the To date specified on the screen defaults. | YYYY-MM-DD |
| 2 | Employee ID | TS_HDR and TS_LN.EMPL_ ID | Char 12 | 11-22 | Required | ||
| 3 | Timesheet Type Code | TS_HDR and TS_LN.S_TS_ TYPE_CD | Char 2 | 23-24 | Required | If a value is not supplied in the input file, type R defaults. | R, B, L, D, N, or C |
| 4 | Working State | TS_HDR. WORK_STATE_CD | Char 2 | 25-26 | Required | If a value is not supplied in the input file, the Default Overtime State from the Manage Employee Salary Information screen defaults. | |
| 5 | Fiscal Year | TS_HDR.FY_ CD | Char 6 | 27-32 | Required | If not supplied in the input file, the Fiscal Year specified on the Import Timesheets screen defaults. | |
| 6 | Period | TS_HDR.PD_ NO | Numeric 2 | 33-34 | Required | If not supplied in the input file, the Period specified on the Import Timesheets screen defaults. | (99) |
| 7 | Subperiod | TS_HDR.SUB_PD_NO | Numeric 2 | 35-36 | Required | If not supplied in the input file, the Subperiod specified on the Import Timesheets screen defaults. | (99)
Note: Not available with a Costpoint Starter license.
|
| 8 | Correcting Ref Date | TS_HDR.CORRECTING_REF_DT | Char 10 | 37-46 | Optional | YYYY-MM-DD | |
| 9 | Pay Type | TS_LN.PAY_TYPE | Char 3 | 47-49 | Required | For default information, please see "Pay Type" in the Tables section of Processing Details. | |
| 10 | General Labor Category | TS_LN.GENL_LAB_CAT_CD | Char 6 | 50-55 | Required | For default information, please see "General Labor Category" in the Tables section of Processing Details. | |
| 11 | Timesheet Line Type Code | TS_LN.S_TS_ LN_TYPE_CD | Char 1 | 56-56 | Required | If a value is not supplied in the input file, type A defaults. | A, B, L, M, S |
| 12 | Labor Cost Amount | TS_LN.LAB_CST_AMT | Numeric 15 | 57-71 | Required | For default information, please the "Labor Cost Amount" in the Tables section of Processing Details. | (-99999999999.99) |
| 13 | Hours | TS_LN.ENTERED_HRS and CHG_HRS | Numeric 10 | 72-81 | Required | (-999999.99) | |
| 14 | Workers' Comp Code | TS_LN.WORK_COMP_CD | Char 6 | 82-87 | Required | For default information, please see "Workers' Comp Code" in the Tables section of Processing Details. | |
| 15 | Labor Location Code | TS_LN.LAB_LOC_CD | Char 6 | 88-93 | Required if Require Labor Location is selected on the Configure Labor Settings screen. | For default information, please see "Labor Location Code" in the Tables section of Processing Details. | |
| 16 | Organization ID | TS_LN.ORG_ID | Char 20 | 94-113 | Required | For default information, please see "Organization" in the Tables section of Processing Details. | |
| 17 | Account ID | TS_LN.ACCT_ ID | Char 15 | 114-128 | Required | For default information, please see "Account" in the Tables section of Processing Details. | |
| 18 | Project ID | TS_LN.PROJ_ ID | Char 30 | 129-158 | Required if Project Required is selected on the Manage Accounts screen for the specified account. | For default information, please see "Project" in the Tables section of Processing Details. | |
| 19 | Project Labor Category | TS_LN.BILL_LAB_CAT_CD | Char 6 | 159-164 | Required/ Optional status dependent upon project setup. | For default information, please see "Project Labor Category" in the Tables section of Processing Details. | |
| 20 | Reference Number 1 | TS_LN.REF_STRUC_1_ID | Char 20 | 165-184 | Optional | For default information, please see "Reference Number 1" in the Tables section of Processing Details. |
Note: This should be blank if you have a Costpoint Starter Edition license. Any value will cause an error.
|
| 21 | Reference Number 2 | TS_LN.REF_STRUC_2_ID | Char 20 | 185-204 | Optional | For default information, please see "Reference Number 2" in the Tables section of Processing Details. |
Note: This should be blank if you have a Costpoint Starter Edition license. Any value will cause an error.
|
| 22 | Organization Abbreviation | TS_LN.ORG_ABBRV_CD | Char 6 | 205-210 | Optional | If not supplied in input file, the organization abbreviation defaults from the Manage Organization Elements screen. | |
| 23 | Project Abbreviation | TS_LN.PROJ_ABBRV_CD | Char 6 | 211-216 | Optional | If not supplied in input file, the project abbreviation defaults from the Basic Info tab of the Manage Project User Flow. | |
| 24 | Sequence Number | TS_HDR and TS_LN.TS_HDR_SEQ_NO | Numeric 1 | 217-217 | Required | If a value is not supplied in the input file, 1 defaults. | 1 - 9 |
| 25 | Effective Billing Date | TS_LN.EFFECT_BILL_D | Char 10 | 218-227 | Optional | If a value is not supplied in the input file, the Default Method selected in the Effective Bill Date Options group box on the Configure Labor Settings screen is used to determine the default value. | YYYY-MM-DD |
| 26 | Project-Account Abbrev. | TS_LN.PROJ_ACCT_ABBRV_CD | Char 6 | 228-233 | Optional | If a value is not specified in the input file, the Proj-Acct Abbrev defaults from the Manage Project Account Groups screen. | |
| 27 | Multi-State Code | TS_LN.WH_ST_CD | Char 2 | 234-235 | Optional | Required if the Multi State Withholding Taxes check box is selected on the Manage Pay Periods screen. | |
| 28 | Reference Sequence Num | TS_HDR.REFERENCE_
SEQ_NO |
Char 1 | 236-236 | Optional | If not supplied and timesheet type is Labor Only, default 1. | |
| 29 | Timesheet Line Date | TS_LN.TS_LN_DT | Char 10 | 237-246 | Optional | Required only when prorating with a Calculation Method of Days per Cycle. | YYYY-MM-DD |
| 30 | Notes | TS_LN.NOTES | Char 254 | 247-500 | Optional |
Manufacturing Order Timesheets (3-character Pay Type)
Note: This input file layout section is used only by companies with a Costpoint Manufacturing license.
If the timesheet line type is M (Manufacturing Order), replace fields 22 through 30 with the following fields:
| # | Field Name | Costpoint Table/Column | Data Type and Size | Column | Required/ Optional | Defaulting Information | Format/Contents |
|---|---|---|---|---|---|---|---|
| 22 | Manufacturing Order ID | TS_LN_MO.MO_ID | Char 10 | 205-214 | Required if the Timesheet Line Type Code is M. | ||
| 23 | Operation Sequence No | TS_LN_MO.MO_ OPER_SEQ_NO | Numeric 4 | 215-218 | Required if the Operation Step No is specified. | ||
| 24 | Operation Step No | TS_LN_MO.MO_OPER_STEP_NO | Numeric 3 | 219-221 | Required if the Operation Sequence No is specified. | ||
| 25 | Activity Type | TS_LN_MO.S_ ACTIVITY_ TYPE | Char 1 | 222-222 | Required if the Timesheet Line Type Code is M. | R or S | |
| 26 | Work Center ID | TS_LN_MO.WC_ID | Char 12 | 223-234 | Optional | ||
| 27 | Organization Abbreviation | TS_LN.ORG_ ABBRV_CD | Char 6 | 235-240 | Optional | If not supplied in input file, the organization abbreviation defaults from the Manage Organization Elements screen. | |
| 28 | Project Abbreviation | TS_LN.PROJ_ ABBRV_CD | Char 6 | 241-246 | Optional | If not supplied in the input file, the project abbreviation defaults from the Basic Info tab of the Manage Project User Flow. | |
| 29 | Sequence Number | TS_HDR and TS_LN.TS_HDR_SEQ_NO | Numeric 1 | 247-247 | Required | If a value is not supplied in the input file, 1 defaults. | 1 - 9 |
| 30 | Effective Billing Date | TS_LN.EFFECT_BILL_DT | Char 10 | 248-257 | Optional | If a value is not supplied in the input file, the Default Method selected in the Effective Bill Date Options group box on the Configure Labor Settings screen is used to determine the default value. | YYYY-MM-DD |
| 31 | Project-Account Abbrev | TS_LN.PROJ_ACCT_ABBRV_CD | Char 6 | 258-263 | Optional | If not specified in the input file, the project account abbreviation defaults from the Manage Project Account Groups screen. | |
| 32 | Multi-State Code | TS_LN.WH_ST_CD | Char 2 | 264-265 | Optional | Required if the Multi State Withholding Taxes check box is selected on the Manage Pay Periods screen. | |
| 33 | Reference Seq Num | TS_HDR.REFERENCE_SEQ_NO | Char 1 | 266-266 | Optional | If not supplied and timesheet type is Labor Only, default 1. | |
| 34 | Timesheet Line Date | TS_LN.TS_LN_DT | Char 10 | 267-276 | Optional | Required only when prorating with a Calculation Method of Days per Cycle. | YYYY-MM-DD |
| 35 | Notes | TS_LN.NOTES | Char 254 | 277-530 | Optional |
Sales Order Timesheets (3-character Pay Type)
If the Timesheet Line Type is S (Sales Order), replace fields 22 through 30 with the following fields:
| # | Field Name | Costpoint Table/Column | Data Type and Size | Column | Required/ Optional | Defaulting Information | Format/Contents |
|---|---|---|---|---|---|---|---|
| 22 | Sales Order ID | TS_LN_SO.SO_ ID | Char 10 | 205-214 | Required if the Timesheet Line Type Code is S. | ||
| 23 | SO Release No | TS_LN_SO.SO_RLSE_NO | Numeric 2 | 215-216 | Required if the Timesheet Line Type Code is S. | ||
| 24 | SO Line No | TS_LN_SO.SO_LN_KEY | Numeric 2 | 217-218 | Optional | ||
| 25 | Organization Abbreviation | TS_LN.ORG_ABBRV_CD | Char 6 | 219-224 | Optional | If not supplied in input file, the organization abbreviation defaults from the Manage Organization Elements screen. | |
| 26 | Project Abbreviation | TS_LN.PROJ_ ABBRV_CD | Char 6 | 225-230 | Optional | If not supplied in input file, the project abbreviation defaults from the Basic Info tab of the Manage Project User Flow. | |
| 27 | Sequence Number | TS_HDR and TS_LN.TS_HDR_SEQ_NO | Numeric 1 | 231-231 | Required | If not supplied in the input file, 1 defaults. | 1 - 9 |
| 28 | Effective Billing Date | TS_LN.EFFECT_BILL_DT | Char 10 | 232-241 | Optional | If a value is not supplied in the input file, the Default Method selected in the Effective Bill Date Options group box on the Configure Labor Settings screen is used to determine the default value. | YYYY-MM-DD |
| 29 | Project-Account Abbrev. | TS_LN.PROJ_ ACCT_ABBRV_CD | Char 6 | 242-247 | Optional | If not specified in the input file, the project account abbreviation defaults from Manage Project Account Groups screen. | |
| 30 | Multi-State Code | TS_LN.WH_ST_CD | Char 2 | 248-249 | Optional | Required if the Multi State Withholding Taxes check box is selected on the Manage Pay Periods screen. | |
| 31 | Reference Sequence Num | TS_HDR.REFERENCE_SEQ_NO | Char 1 | 250-250 | Optional | If not supplied and timesheet type is Labor Only, default 1. | |
| 32 | Timesheet Line Date | TS_LN.TS_LN_DT | Char 10 | 251-260 | Optional | Required only when prorating with a Calculation Method of Days per Cycle. | YYYY-MM-DD |
| 33 | Notes | TS_LN.NOTES | Char 254 | 261-514 | Optional |