Attachment C.xlsx

XLSX spreadsheet 45 KB Posted

Attached to
CORE MANAGEMENT SOFTWARE
Solicitation number
5400030147
Issued by
Charleston County, South Carolina

About this file

This file is a technical specification document for accounting journal data submission requirements related to a Core Management Software contract opportunity in South Carolina. The document outlines the detailed data structure and field requirements for submitting accounting journal entries through a web service interface, likely to a Workday financial management system. The specification covers journal header information, journal line details, tax information, and attachment capabilities. Key required fields include company reference, currency, ledger type, book code, accounting date, journal source, and fund information. The document provides guidance on data types, field restrictions (required versus optional), and formatting standards for multiple data categories including journal entry lines, tax detail data, taxable event lines, reference data, and intercompany attachment fields.

The technical requirements specify precise data formatting standards including text fields, boolean values, date formats (YYYY-MM-DD), and numeric precision specifications. The document establishes protocols for controlling transaction submission status, enabling or disabling worktag balancing, locking transactions in Workday, and managing multi-currency journal entries. Two example records are provided demonstrating journal submissions with company reference C001, USD currency, actuals ledger type, and an accounting date of 4/30/26, with various spend categories, funds, cost centers, and functions designated. The specification includes provisions for automatic journal number generation, sequence numbering within accounting periods, support for reversal journals, and attachment management with file compression capabilities.

View the file

Other files

File Type Posted
Amendment 1.pdf PDF
Attachment A.docx DOCX document
Attachment B.xlsx XLSX spreadsheet
RFP.docx DOCX document

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Submit Accounting Journal

Submit Accounting Journal
AreaAllComment DataAccounting Journal DataJournal Entry Line Replacement Data+Tax Detail Data+Taxable Event Line Reference+Journal Entry Line Replacement Data+Attachment Data+
RestrictionsRequiredOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalRequiredRequiredRequiredOptionalRequiredRequiredOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalRequired
: Journal Entry Line DataOptionalOptionalRequiredOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptional. May have multiplesOptionalRequiredRequiredRequiredOptionalRequiredRequiredOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalRequiredRequiredOptionalOptionalRequired
: Attachment with Intercompany Attachment Field DataOptionalOptionalOptionalOptionalOptionalOptional. May have multiplesOptionalOptionalOptionalOptionalOptionalOptionalRequiredRequiredOptionalOptionalOptionalOptional
FormatText
: Required for all transactions. Used to uniquely identify a transaction header. All rows with the same value will be submitted to Workday as one transaction set.Y/N
: Boolean itemAccounting_Journal_ID
: Type: Accounting_Journal_IDText
: Text itemContingent_Worker_ID
: Type: Contingent_Worker_IDText
: Text itemY/N
: Boolean itemY/N
: Boolean itemY/N
: Boolean itemY/N
: Boolean itemText
: Text itemText
: Text itemCompany_Reference_ID
: Type: Company_Reference_IDCurrency_ID
: Type: Currency_IDLedger_Type_ID
: Type: Ledger_Type_IDBook_Code_ID
: Type: Book_Code_IDYYYY-MM-DD
: Date itemJournal_Source_ID
: Type: Journal_Source_IDFund_ID
: Type: Fund_IDY/N
: Boolean itemText
: Text itemText
: Text itemText
: Text itemAccount_Set_ID
: Type: Account_Set_IDY/N
: Boolean itemY/N
: Boolean itemY/N
: Boolean itemYYYY-MM-DD
: Date itemNumber (26,6)Currency_Rate_Type_ID
: Type: Currency_Rate_Type_IDText
: Journal Entry Line DataText
: Text itemCompany_Reference_ID
: Type: Company_Reference_IDLedger_Account_ID
: Type: Ledger_Account_IDAccount_Set_IDNumber (26,6)Number (26,6)Number (18,3)Number (18,3)Text
: Text itemText
: Text itemYYYY-MM-DD
: Date itemSpend_Category_ID
: Type: Academic_Level_IDRevenue_Category_ID
: Type: Academic_Level_IDFund_ID
: Type: Academic_Level_IDCost_Center_Reference_ID
: Type: Academic_Level_IDCustom_Organization_Reference_ID
: Type: Academic_Level_IDGrant_ID
: Type: Academic_Level_IDGift_Reference_ID
: Type: Academic_Level_IDProject_ID
: Type: Academic_Level_IDProgram_ID
: Type: Academic_Level_IDCustom_Worktag_06_ID
: Type: Academic_Level_IDOrganization_Reference_ID
: Type: Academic_Level_IDCustom_Organization_Reference_ID
: Type: Academic_Level_IDLocation_ID
: Type: Academic_Level_IDBusiness_Unit_ID
: Type: Business_Unit_IDTextYYYY-MM-DD
: Date itemTax_Type_ID
: Type: Tax_Type_IDNumber (18,3)Tax_Code_ID
: Type: Tax_Code_IDTax_Rate_ID
: Type: Tax_Rate_IDTax_Applicability_ID
: Type: Tax_Applicability_IDTax_Recoverability_Object_ID
: Type: Tax_Recoverability_Object_IDTax_Recoverability_Type_ID
: Type: Tax_Recoverability_Type_IDTax_Point_Date_Type_ID
: Type: Tax_Point_Date_Type_IDSupplier_ID
: Type: Supplier_IDCustomer_ID
: Type: Customer_IDText
: Text itemText
: Text itemText
: Text itemTextText
: Text itemText
: Text itemNumberText
: Attachment with Intercompany Attachment Field DataText
: Text itemText
: Text itemText
: Text itemY/N
: Boolean itemText
: Text itemCompany_Reference_ID
: Type: Company_Reference_IDText
: Text itemY/N
: Boolean itemY/N
: Boolean itemY/N
: Boolean itemText
: Text itemContingent_Worker_ID
: Type: Contingent_Worker_IDTextText
: Text itemText
: Text itemDocument_Category__Workday_Owned__ID
: Type: Document_Category__Workday_Owned__IDText
: Text itemText

: Text item Fields Spreadsheet Key* : You must use the spreadsheet key to coordinate the header information throughout the tabs of the spreadsheet. Keep the same spreadsheet key for each row as you add information in the subsequent tabs. The spreadsheet key is also required to coordinate multiple child rows that roll up to the same parent row.

: Type: Accounting_Journal_ID Add Only : Add Only Flag. Indicates that the service is an add only, not an update.

: Text item Accounting Journal : Reference to an existing Accounting Journal : Type: Contingent_Worker_ID Comment : Free form comment regarding the business process.

: Text item Worker : Default the Person making the comment to the processing person if not submitted via the web service.

: Boolean item Accounting Journal ID : Accounting Journal Reference ID. This is the Accounting Journal unique identifier : Boolean item Submit : Submit for Approval is a boolean flag indicating if the transaction is to be submitted or saved in draft mode. If this flag is set, the transaction will be submitted, otherwise the transaction is saved in draft.

: Boolean item Disable Optional Worktag Balancing : Disables Optional Worktag balancing for the given journal.

: Boolean item Locked in Workday : Locked in Workday is a boolean flag controlling user ability to edit the transaction. If the flag is set the user can't edit, cancel or change the transaction inside the Workday application, however the user can submit a draft transaction. The transaction can only be updated from the web service.

: Text item Round Ledger Amounts : Automatically balances ledger amount rounding differences on multi-currency journals while: all line company references match the journal company reference, ledger debit and ledger credit amounts are blank or zero, all journal lines use the same currency rate, all journal lines use the same transaction currency, and you haven't provided a balancing worktag reference for the accounting journal.

: Text item Journal Number : Journal Number. The Journal Number will be automatically generated through the sequencing number configuration.

: Type: Company_Reference_ID Journal Sequence Number : The Sequence Number assigned to the current journal. It is unique among all journals within a period (or year, depending on the setup.)

: Type: Currency_ID Company* : Reference to an existing Company which holds the asset : Type: Ledger_Type_ID Currency* : Reference to the currency of the header company. Workday only accepts the company currency on this field for inbound Workday Web Services requests. When you leave this field blank, Workday automatically populates the field with the currency of the header company.To submit journal lines with foreign transaction currencies, enter the foreign currency on the currency_reference field of the journal line.

: Type: Book_Code_ID Ledger Type* : Reference to an existing Ledger Type : Date item Book Code : Reference to the Book Code the Journal is booked to : Type: Journal_Source_ID Accounting Date* : Accounting Date : Type: Fund_ID Journal Source* : Reference to an existing Journal Source : Boolean item Balancing Worktag : Anchor balancing worktag for journal.

: Text item Record Quantity : Record Quantity - set to True (1) if setting Quantity and Unit of Measure on a journal line.

: Text item Journal Entry Memo : This transaction header memo will print on the delivered transaction. It is optional freeform text : Text item External Reference ID : This is a freeform text reference that is used to associate this Journal with a record in a third party system : Type: Account_Set_ID Document Link : Link to supporting documents : Boolean item Display Account Set : Display Account Set Reference is used to display the Display Account Set connected to the Accounting Journal : Boolean item Adjustment Journal : Boolean flag indicating if the journal entry is an adjustment.

: Boolean item Include Tax Lines : Boolean to enable Journal Line Tax Detail Data.

: Date itemCreate Reversal
: Boolean attribute indicating if the journal entry should create a reversalReversal Date

: Date for which the reversal journal is to be posted.

: Journal Entry Line Data : Type: Currency_Rate_Type_ID Control Total Amount : Control Total Amount : Journal Entry Line Data Currency Rate Type : Reference to an existing instance of Currency Rate Type : Text item Row ID* : You must use the row ID to coordinate the data that spreads across multiple rows in the spreadsheet. A change in the value of the ID indicates that a new child object will be created under the same parent object.

: Type: Company_Reference_ID Line Order : Optional line order. If specified, lines will be sorted by this value when displayed and when invoice is printed.

: Type: Ledger_Account_IDLine Company
: The company for the line for intercompany journals.If field is left blank, it will default to the same company as the header company. For non-intercompany journals this field should be left blank or have the same value as the header company. For beginning balance journal loads, this field should always be blank or the same as the header company. For journals that are intercompany beginning balances, the other company should only be referenced as an intercompany affiliate worktag.Ledger Account*
: Reference to an existing Ledger Account. The Ledger Account reference is a 2 part reference ID, composed of the Ledger Account ID and the Reference ID for the Ledger Account Set it is organized into.Account Set
: For types that require a parent reference, contains a unique identifier for an instance of a parent object.Debit Amount
: Debit AmountCredit Amount
: Credit AmountLedger Debit Amount

: Ledger Debit Amount : Text item Ledger Credit Amount : Ledger Credit Amount : Text item Memo : Memo for the line : Date item External Reference ID : This is a freeform text reference that is used to associate this Journal with a record in a third party system : Type: Academic_Level_ID Budget Date : Budget Date for the Journal Line. It is required if the View Budget Date flag is set to true for the Ledger.

: Type: Academic_Level_ID Spend Category : Spend Category : Type: Academic_Level_ID Revenue Category : Revenue Category : Type: Academic_Level_ID Fund : Fund : Type: Academic_Level_ID Cost Center : Cost Center : Type: Academic_Level_ID Function : Function : Type: Academic_Level_ID Grant : Grant : Type: Academic_Level_ID Gift : Gift : Type: Academic_Level_ID Project : Project : Type: Academic_Level_ID Program : Program : Type: Academic_Level_ID Activity : Activity : Type: Academic_Level_ID Appropriation : Appropriation : Type: Academic_Level_ID Trust : Trust

: Type: Business_Unit_IDLocation
: LocationBalancing Worktag Affiliate

: Interworktag affiliate for journal line.

: Date item Row ID* : You must use the row ID to coordinate the data that spreads across multiple rows in the spreadsheet. A change in the value of the ID indicates that a new child object will be created under the same parent object.

: Type: Tax_Type_IDTransaction Date*
: The date the transaction occurred for the manual journal with direct tax.Tax Type*

: The reference id value for the tax type.

: Type: Tax_Code_ID Taxable Amount : The transaction taxable amount basis for the tax amount entered in the debit/credit amount of the journal line with tax.

: Type: Tax_Rate_ID Tax Code* : The reference id value for the tax code.

: Type: Tax_Applicability_ID Tax Rate* : The reference id value for the tax rate.

: Type: Tax_Recoverability_Object_ID Tax Applicability : The reference id value of the tax applicability.

: Type: Tax_Recoverability_Type_ID Tax Recoverability : The reference id value for the tax recoverability.

: Type: Tax_Point_Date_Type_ID Tax Recoverability Type : The reference id value for the tax recoverability.

: Type: Supplier_ID Tax Point Date Type : Tax Point Date Type : Type: Customer_ID Supplier : The reference id value for the supplier.

: Text item Customer : The reference id value for the customer.

: Text item External Business Entity Name : The name of the customer or supplier if not defined within Workday.

: Text itemExternal Business Entity Address
: The address for the customer or supplier if not defined within Workday.External Business Entity Tax ID

: The tax id for the customer or supplier if not defined within Workday.

: Text item Row ID* : You must use the row ID to coordinate the data that spreads across multiple rows in the spreadsheet. A change in the value of the ID indicates that a new child object will be created under the same parent object.

: Text item Line Order* : Enter the line order of the journal line to which this tax line is related. Workday uses the line order to relate the tax line to the taxable event journal line : Attachment with Intercompany Attachment Field Data Do Not Use : Do not use : Attachment with Intercompany Attachment Field Data Journal Line Number : The number Workday automatically assigned to the journal line.

: Text item Row ID* : You must use the row ID to coordinate the data that spreads across multiple rows in the spreadsheet. A change in the value of the ID indicates that a new child object will be created under the same parent object.

: Text item Content Type : Text attribute identifying Content Type of the Attachment.

: Text item Filename : Text attribute identifying Filename of the Attachment.

: Boolean item Encoding : Text attribute identifying Encoding of the Attachment.

: Text item Compressed : Boolean attribute identifying whether the Attachment is compressed.

: Type: Company_Reference_ID File Content : File content in binary format.

: Text item Companies Without Access+ : Reference to companies with access to attachment.

: Boolean item Comment : Comment : Boolean item Auto Complete : When set to "true" or "1", the business process is automatically processed. This means that all approvals will be automatically approved in the system, all reviews and to-do's will be automatically by-passed, and all notifications will be automatically suppressed.

: Boolean item Skip : When set to "true" or "1", the business process is automatically skipped (if it is defined as "skippable" within the business process definition).

: Text item Discard On Exit Validation Error : Enforces all validation conditions defined on the initiation step. If any condition is true, the validation error blocks the step from exiting and a business process event isn't created. The attribute is currently not available for use. It will be generally available for all web services in a future release.

: Type: Contingent_Worker_IDComment
: Free form comment regarding the business process.Worker

: Default the Person making the comment to the processing person if not submitted via the web service.

: Text item Row ID* : You must use the row ID to coordinate the data that spreads across multiple rows in the spreadsheet. A change in the value of the ID indicates that a new child object will be created under the same parent object.

: Text item File Name* : Filename for the attachment.

: Type: Document_Category__Workday_Owned__ID Event Attachment Description : Free form text comment about the attachment.

: Text item Event Attachment Category : Category of attachment.

: Text itemFile
: Binary file contents.Content Type

: Text attribute identifying Content Type of the Attachment.

1YYC001USDActuals4/30/26Manual_Journal_Advanced_RoutingFD001Test - Example11C00142010Standard_Account_Set1CMI ExampleRC0112FD001CC000977FN03PG000558
1YYC001USDActuals4/30/26Manual_Journal_Advanced_RoutingFD001Test - Example22C00142010Standard_Account_Set1CMI Example 2SC0037FD001CC000988FN20

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .