Charge Code Download

This integration downloads task/expense code custom fields for time sheets, expense sheets, and/or credit debit memos for the purposes of external validation of custom field values. Once validated, the Charge Code Upload may be used to either approve or reject these documents.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

1.0

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration – Charge Code Download.

User role permission must be turned on for Upload Data and Download Data.

Company configuration plug-in: Require External Validation of Worker's Time/Expense Sheet must be enabled.

Predecessors

Expense Sheets

Time Sheets

Credit Debit Memos

Related Connectors

Charge Code Validation Upload

Triggering Events

The type of document downloaded is either TS, ES, CD for Timesheet (TS), Expense Sheet (ES), Credit Debit Memo (CD).

The TS/ES/CD status should be in 'Pending Validation'.

The TS/ES/CD Buyer Code is required and is either:
  • The company code for which the connector is to be downloaded

    or

  • The buyer code for the MSP buyer supplier contract

Parameters

  • TS for time sheets

  • ES for expense sheets

  • CD for credit debit memos

  • ALL for all 3 types of records

File Formatting

Detail

Column Header Name

Data Type

Length

Enabled by Default?

Value(s)/Format

Description/Use/Field Rules

DOCID

Text

16

Yes

SAP Fieldglass ID format.

Valid Time Sheet ID, Expense Sheet ID, or Credit Debit Memo ID.  Dependent on document type downloaded.

RT

Text

2

Yes

Valid values:

  • TS

  • ES

  • CD

Record Type (RT) of document downloaded.

TS = Time Sheet

ES = Expense Sheet

CD = Credit Debit Memo

Both SOW & contingent-related documents will be downloaded.

COSTCENTERCODE

Text

200

Yes

See Cost Center List

SAP Fieldglass Cost Center Code for which charges were booked against on the document.

GLACCOUNTCODE

Text

100

Yes

See SAP Fieldglass GL Account List

SAP Fieldglass GL Account Code for which charges were booked against on the document.

CHARGECODE

Text

100

Yes

See SAP Fieldglass Task Code or Expense Code List

SAP Fieldglass Task Code or Expense Code for which charges were booked against on the document.

[c] Custom_Field1

Dependent on Custom Field Type

Dependent on Custom Field.

Task or Expense Code Custom Field to be validated by external system.

FG Internal Ref (CFs, Adjustment, and Reasons only):

CHARGE_CODE_VALI_CF1

[c] Custom_Field2

Dependent on Custom Field Type

Dependent on Custom Field.

Task or Expense Code Custom Field to be validated by external system.

FG Internal Ref (CFs, Adjustment, and Reasons only):

CHARGE_CODE_VALI_CF2

[c] Custom_Field3

Dependent on Custom Field Type

Dependent on Custom Field.

Task or Expense Code Custom Field to be validated by external system.

FG Internal Ref (CFs, Adjustment, and Reasons only):

CHARGE_CODE_VALI_CF3

[c] Custom_Field4

Dependent on Custom Field Type

Dependent on Custom Field.

Task or Expense Code Custom Field to be validated by external system.

FG Internal Ref (CFs, Adjustment, and Reasons only):

CHARGE_CODE_VALI_CF4

[c] Custom_Field5

Dependent on Custom Field Type

Dependent on Custom Field.

Task or Expense Code Custom Field to be validated by external system.

FG Internal Ref (CFs, Adjustment, and Reasons only):

CHARGE_CODE_VALI_CF5

[c] Custom_Field6

Dependent on Custom Field Type

Dependent on Custom Field.

Task or Expense Code Custom Field to be validated by external system.

FG Internal Ref (CFs, Adjustment, and Reasons only):

CHARGE_CODE_VALI_CF6

Unique Identifier

  • Combination of DOCID, COSTCENTERCODE, GLACCOUNTCODE, and CHARGECODE fields.

Custom Fields

  • The download file will include custom fields from the Task Code and Expense Code Modules of the application only.

  • Internal References CHARGE_CODE_VALI_CF1 … CHARGE_CODE_VALI_CF6 may be assigned to up to 6 Task and / or Expense Codes in order for them to be included in this download.

  • No more than 6 Custom Fields may be used in this download in its standard format.

  • All 6 Custom Field columns will be present in the download no matter the number Custom Fields actually assigned to Internal References. Unused Custom Field columns will be blank.