Journal Header Fields Type

JournalKey Text
AccountingJournalID Text

AccountingJournalReferenceIDType Text

AccountingJournalReferenceID Text
Submit Boolean

DisableOptionalWorktagBalancing Boolean

LockedinWorkday Boolean
AddOnlyJournal Boolean

CreateJournalwithErrors Boolean
RoundLedgerAmounts Boolean
JournalNumber Text
CompanyReferenceIDType Text

CompanyReferenceID Text
Currency Text
LedgerType Text

BookCode Text

AccountingDate Date
JournalSource Text
BalancingWorktagReferenceIDType Text

BalancingWorktagReferenceID Text
BalancingWorktag_ExternalCodeMapName Text
BalancingWorktag_ExternalCodeMapValue Text
OptionalBalancingWorktags_WorktagType1 Text

OptionalBalancingWorktagsExternalCode_Exter Text

RecordQuantity Boolean
JournalEntryMemo Text
JournalExternalReferenceID Text
DocumentLink Text
AdjustmentJournal Boolean
IncludeTaxLines Boolean
CreateReversal Boolean
ReversalDate Date
ControlTotalAmount Decimal
CurrencyRateType Text

DisplayAccountSetID Text
DisplayAccountSetID Text
Description
Aggregates journal lines belonging to the same journal. Workday loads all journal lines with the same JournalKey
For this field, you can:

Create an accounting journal with the value provided in this field. If you leave the field empty, Workday generates a u
Update an accounting journal by providing a reference to an existing accounting journal ID.
Change the accounting journal ID for an existing journal by entering a new value in this field. Enter the reference for t

Required if you provide a value on AccountingJournalReferenceID. Enter either:

Account_Set_ID
WID

Optional field. Identifies an existing accounting journal. Enter a reference to an existing journal in Workday or leave t
Optional field. Determines if you save the journal in draft mode or submit it. Enter:

0 to save the journal in draft mode with a status of Created.

1 to submit the journal with a status of Posted.

If the field is empty, Workday automatically enters 0.

Optional field. Disables worktag balancing for the given journal. Enter:

0 to enable worktag balancing.

1 to disable worktag balancing.

If the field is empty, Workday automatically enters 1.

Optional field. Determines if you can edit the journal in Workday. Enter a value of 1 to lock the journal. You can't edit,
Optional field. Determines if Workday updates an existing journal or creates a new journal. Enter:

0 to update an existing journal.

1 to create a new journal.

If you update an existing journal, you must enter the reference on the AccountingJournalReferenceID field.
Optional field. Determines if Workday creates a journal in Created status for a ledger company with alternate accoun
Optional field. Determines how Workday balances the rounding differences for the ledger amounts on a multicurrenc
Optional field. Workday automatically generates a value using the sequencing number configuration when you creat
Provide a value for this field based on the CompanyReferenceID field. Enter:

Company_Reference_ID
Organization_Reference_ID
WID

Provide a reference ID to an existing company in Workday for the accounting journal.

Provide references to the company currency. The currencies you reference must match company currencies.
Provide the value for an existing ledger type in Workday.

If you configured the ledger type map in your integration system, you can enter an external value from the map. Work
Optional field. Provide the value for an existing book code ID in Workday.

If you configured the book code map in your integration system, you can enter an external value from the map. Work
Provide the accounting date of the journal.
Provide the value for an existing accounting journal source in Workday.
Required field if you provide a value on BalancingWorktagReferenceID. You can enter:

Business_Unit_ID
Cost_Center_Reference_ID
Custom_Organization_Reference_ID
Fund_ID
Organization_Reference_ID
Region_Reference_ID
WID

Optional field. Provide the reference ID for the anchor balancing worktag for the journal. If you enter a reference ID, y
Optional field. Provide the name of the balancing worktag external code map. After configuring an external code ma
Optional field. Provide the value that Workday needs to look up from the balancing worktag external code map.
Optional field. You can add 1 or more optional balancing worktags to the journal header. You must prefix the workta

Example: A cost center worktag should display as OptionalBalancingWorktags_Cost_Center.

If you enter a value for this field, you must enable optional balancing worktag for the company.
Optional field. You can provide 1 or more optional balancing worktag external codes to the journal header. When you

Example: An external code map called RegionMap should display as OptionalBalancingWorktagsExternalCode_Regio

Optional field. Enter 1 if you enter values for both Quantity and Unit of Measure on a journal line. If you don't provide
Optional field. Free text comment regarding the journal entry.
Optional field. Enables you to maintain references to your external endpoints at the journal header level. You can use
Optional field. Enables you to provide a link to additional information regarding your journal.
Optional field. Determines if the journal entry is an adjustment. Enter a value of 1 to treat this journal entry as an adju
Optional field. Determines if the journal includes tax detail data. Enter a value of 1 to indicate if you enter tax detail d
Optional field. Determines if Workday should create a reversal journal for the original journal. Enter a value of 
Optional field. If you create a reversal journal, you can enter an accounting date for that reversal. If you leave this fiel
Optional field. Provide a value that equals the sum of all journal lines. Workday validates the total value of all journal
Optional field. Provide the value for an existing currency rate type in Workday.

If you configured a currency rate type map in your integration system, you can enter the external value from the map
Optional field. Provide the value for an existing account set in Workday. If you leave this field empty, Workday derive
If you configured a display account set map in your integration system, you can enter the external value from the ma
 the same JournalKey as a single journal entry.

y, Workday generates a unique accounting journal ID.

. Enter the reference for the old accounting journal ID in the  AccountingJournalReferenceID field.

nal in Workday or leave the field empty. If this field is empty, Workday generates a unique ID.

he journal. You can't edit, cancel, or change a locked journal. If the field is empty, Workday automatically enters 

ferenceID field.
ny with alternate account sets, even if the alternate ledger account isn’t mapped.
mounts on a multicurrency journal entry. Enter a value of  1 to enable rounding of ledger amounts. Don’t set this value if your jou
guration when you create a new journal. If you reference an existing journal entry, leave this field empty.
mpany currencies.

value from the map. Workday then links the value to a Workday ledger type.

alue from the map. Workday then links the value to a Workday book code.

ou enter a reference ID, you must enable worktag balancing. You can’t enter a reference ID if you specify a value for 
ing an external code map using the Create Integration Worktag Mapping task, enter the external value for the map.
external code map.
u must prefix the worktag type with OptionalBalancingWorktags_.

ournal header. When you configure an optional balancing worktag external code map using the  Create Integration Worktag Ma

tagsExternalCode_RegionMap.
line. If you don't provide a value, Workday automatically enters 0.

header level. You can use this free text field in reports.

s journal entry as an adjustment. If you don't provide a value, Workday automatically enters 0.
e if you enter tax detail data in the journal lines. If you don't provide a value, Workday automatically enters  0.
l. Enter a value of 1 if you wish to create a reversal. If you don't provide a value, Workday automatically enters 0
ersal. If you leave this field empty, Workday uses the first day of the next open period to post the reversal journal. If there’s no op
e total value of all journal lines is equal to the amount you specify for the control amount. You can enter up to 26 total digits, inc

ernal value from the map. Workday then links the value to a Workday currency rate type.
d empty, Workday derives this field from the ledger account for the journal.
ternal value from the map. Workday then links the value to a Workday account set.
cally enters 0.

on’t set this value if your journal is intercompany.

ecify a value for  RoundLedgerAmounts.
lue for the map.

ate Integration Worktag Mapping task, prefix the External Value of Map Name with OptionalBalancingWorktagsExternalCode_

ally enters 0.
ersal journal. If there’s no open period, then Workday generates the journal in  Created status.
nter up to 26 total digits, including up to 6 fractional digits.
gWorktagsExternalCode_.
Journal Line Fields Type
JournalLineOrder Text

LineCompanyReferenceIDType Text

LineCompanyReferenceID Text

LedgerAccountReferenceID_ParentIDType Text

LedgerAccountReferenceID_ParentID Text

LedgerAccountReferenceIDType Text
LedgerAccountReferenceID Text

AlternateLedgerAccountReferenceID_ParentIDType Text

AlternateLedgerAccountReferenceID_Parent ID Text

AlternateLedgerAccountReferenceIDType Text

AlternateLedgerAccountReferenceID Text
DebitAmount Decimal

CreditAmount Decimal

LineCurrency Text

LineCurrencyRate Decimal

LedgerDebitAmount Decimal

LedgerCreditAmount Decimal

Quantity Decimal
UnitOfMeasure Text
Quantity2 Decimal

UnitOfMeasure2 Text

LineMemo Text

JournalLineExternalReferenceID Text

BudgetDate Date
BalancingWorktagAffiliateIDType Text

BalancingWorktagAffiliateID Text

ExcludeFromSpendReport Boolean
Description
Optional field. Provide an ordered set of values
that Workday can use to sort and display journal
lines in the application. Workday also uses these
values to sort your journal lines when you print
invoices. Example: 1a, 1b, 1c.

Required if you provide a value

on LineCompanyReferenceID. You can enter:

Company_Reference_ID
Organization_Reference_ID
WID

Optional field. Uniquely identifies the company on

the line for intercompany journals. If this field is
empty in your input file, Workday uses
the CompanyReferenceID value you provided. For
journals that aren't intercompany, leave this field
blank or use your CompanyReferenceID value.

Required if you provide a value

on LedgerAccountReferenceID_ParentID. You can
enter:

Ledger_Account_ID
WID

Optional field. Uniquely identifies an existing

parent ledger account. You can provide the ID to
the parent ledger account of the ledger account
you enter for LedgerAccountReferenceID.

Required if you provide a value

on LedgerAccountReferenceID. You can enter:

Ledger_Account_ID
WID
Optional field. Uniquely identifies an existing ledger
account. You can provide a reference to an
existing ledger account in Workday. You can leave
this field empty and enter a reference to the ledger
account on
the ExternalCode_ExternalCodeMapName field.
Workday then matches the external code you enter
to the ledger account you mapped in the Create
Integration Worktag Mapping task.

Required if you provide a value

for AlternateLedgerAccountReferenceID_ParentID
. You can enter:

Ledger_Account_ID
WID

Workday only uses this field if you’ve selected an

alternate account set on the Edit Company
Accounting Details task.
Optional field. Uniquely identifies an existing
alternate parent ledger account. You can provide
the ID to the alternate parent ledger account of the
ledger account you enter in
the AlternateLedgerAccountReferenceID field.

Required if you provide a value

for AlternateLedgerAccountReferenceID. You can
enter:

Ledger_Account_ID
WID

Optional field. Uniquely identifies an existing

alternate ledger account (ALA). You can provide a
reference to an existing ALA in Workday. You can
create ALA mapping using the Create Alternate
Account Set Mapping task.
Workday only uses this field if you configured an
alternate account set for the company you
specified on CompanyReferenceID. You can
configure an alternate account set for a company
using the Edit Company Accounting Details task.

Enter either a debit amount or a credit amount, but

not both. You can enter up to 26 digits before the
decimal point and 2 digits after.

Enter either a debit amount or a credit amount, but

not both. You can enter up to 26 digits before the
decimal point and 2 digits after.

Optional field. Provide the 3-digit ISO code for the

currency you use on the journal line.
Optional field. Provide the currency exchange rate
for the line currency you specify.
Enter either a ledger debit amount or a ledger
credit amount, but not both. You can enter up to 26
digits before the decimal point and 2 digits after.

Enter either a ledger debit amount or a ledger

credit amount, but not both. You can enter up to 26
digits before the decimal point and 2 digits after.

Optional field. Use with Unit of Measure.

Optional field. Use with Quantity.
Optional field. Use with Unit of Measure 2. Only
use if you entered Quantity and Unit of Measure.

Optional field. Use with Quantity 2. Only use if you

entered Quantity and Unit of Measure.
Optional field. Use this as a freeform text field on
the journal line.
Optional field. Enables you to maintain references
to your external endpoints at the journal line level.
You can use this free text field in reports.

Optional field. Provide the budget date for the

journal line. Required if you selected the View
Budget Date check box when you created the
ledger.
Required if you provide a value
on BalancingWorktagAffiliateID. You can enter:

Business_Unit_ID
Cost _Center_Reference_ID
Custom_Organization_Reference_ID
Fund_ID
Organization_Reference_ID
Region_Reference_ID
WID

Optional field. Provide a reference to a balancing

worktag affiliate. Enable worktag balancing to
define a balancing worktag affiliate.

Optional field. For expense reports and supplier

invoice transactions tied to a capital project
worktag, Workday creates special accounting to
debit the Work in Progress account. Workday also
records the amount as a debit into the spend
account. This action is necessary to reflect correct
amounts for the purposes of budget checking and
reporting, and any other custom spend reports.
Attachment Information Fields Type
Attachment_FileName Text

Attachment_FileType Text
Attachment_FileEncoding Text
Attachment_Compressed Boolean

Attachment_CompaniesWithoutAccess Text
ReferenceIDType

Attachment_CompaniesWithoutAccess Text
ReferenceID

Attachment_FileComment Text
Description
Optional field. Provide the name of the attachment file. Maximum length is 255 characters.

Optional field. Provide the file format of the attachment.

Optional field. Provide the name of the encoding used for the attachment.
Optional field. Specifies if the attachment is compressed at the external endpoint. Enter a
value of 1 to indicate that the attachment is compressed.
Required if you provide a value on
the Attachment_CompaniesWithoutAccessReferenceID field. You can enter:

Company_Reference_ID
Organization_Reference_ID
WID

Optional field. Specifies companies that can't view files attached to the intercompany child
journal. You can provide reference IDs of existing companies or leave the field blank.

Provide the associated reference IDs

for Attachment_CompaniesWithoutAccessReferenceIDType and Attachment_CompaniesWith
outAccessReferenceID on a separate column for each company you wish to restrict.

Optional field. Free text comment regarding the attachment file.

InterCompanyBP_AutoComplete

InterCompanyBP_Skip

InterCompanyBP_Comment

InterCompanyBP_WorkerReferenceIDType

InterCompanyBP_WorkerReferenceID

IntercompanyBP_Attachment_FileName

IntercompanyBP_Attachment_EventDescription

IntercompanyBP_Attachment_EventCategoryReferenceIDType
IntercompanyBP_Attachment_EventCategoryReferenceID

IntercompanyBP_Attachment_File

IntercompanyBP_Attachment_ContentType
Boolean

Boolean

Text

Text

Text

Text

Text

Text
Text

Base64

Text
Optional field. Determines how Workday handles the intercompany business
process steps. When you enter a value of 1, Workday automatically completes
business processes. Completion includes:

Automatically completing approvals.

Bypassing reviews and to dos.
Suppressing notifications.

Enter a value of 0 to disable automatic completion of intercompany business

processes. If you leave this field empty, Workday automatically enters 0. You
can't enable InterCompanyBP_AutoComplete if you
enable InterCompanyBP_Skip.

Optional field. Determines if Workday skips the intercompany business

process. Workday can only skip the business process if the definition allows
skips. When you enter a value of 1, Workday automatically skips the business
process.

Enter a value of 0 to disable automatic skipping of intercompany business

processes. If you leave this field empty, Workday automatically enters 0. You
can't enable InterCompanyBP_Skip if you
enable InterCompanyBP_AutoComplete.
Optional field. Free text comment regarding the intercompany business
process.
Required if you provide a value for InterCompanyBP_WorkerReferenceID. You
can enter:

Contingent_Worker_ID
Employee_ID
WID

Optional field. Uniquely identifies an intercompany business process worker.

You can provide the reference ID of an existing intercompany business
process worker or leave this field blank.
Required if you provide a value on any fields that begin
with InterCompanyBP_Attachment_. Enter the filename for the intercompany
business process attachment.
Optional field. Free text comment regarding the intercompany business
process attachment.
Required if you provide a value on
the IntercompanyBP_Attachment_EventCategoryReferenceID field. You can
enter:

Document_Category_ID
Document_Category__Workday_Owned__ID
WID

Optional field. Provide the category of the attachment.

Optional field. Convert your intercompany business process file attachment to

Base64Binary format. After conversion, provide the attachment file contents.

Optional field. Provide the file format of the intercompany business process
attachment.
Business Process Fields
BP_AutoComplete

BP_Comment
BP_WorkerReferenceIDType

BP_WorkerReferenceID
Type
Boolean

Text
Text

Text
Description
Optional field. Determines how Workday handles business process steps.
When you enter a value of 1, Workday automatically completes business
processes. Completion includes:

Automatically completing approvals.

Bypassing reviews and To Dos.
Suppressing notifications.

Enter a value of 0 to disable automatic completion of business processes.

If you leave this field empty, Workday automatically enters 0.

Optional field. Free text comment regarding the business process.

Required if you provide a value on BP_WorkerReferenceID. You can enter:

Contingent_Worker_ID
Employee_ID
WID

Optional field. Provide the reference ID of the person adding the comment.
Tax Line Fields Type
TaxTransactionDate Date

TaxTypeReferenceIDType Text

TaxTypeReferenceID Text

TaxableAmount Decimal

TaxCodeReferenceIDType Text

TaxCodeReferenceID Text

TaxRateReferenceIDType Text

TaxRateReferenceID Text

TaxApplicabilityReferenceIDType Text

TaxApplicabilityReferenceID Text
TaxRecoverabilityReferenceIDType Text

TaxRecoverabilityReferenceID Text

TaxRecoverabilityTypeReferenceIDType Text

TaxRecoverabilityTypeReferenceID Text

TaxPointDateTypeReferenceID Text

TaxSupplierReferenceIDType Text
TaxSupplierReferenceIDType Text

TaxSupplierReferenceID Text

TaxCustomerReferenceIDType Text

TaxCustomerReferenceID Text

TaxExternalBusinessEntityName Text

TaxExternalBusinessEntityAddress Text

TaxExternalBusinessEntityTaxID Text

Worktag_WorktagType1 Text

ExternalCode_ExternalCodeMapName1 Text

TaxableEventLineReferenceLineOrder Text
Description
Required if you add any values to Tax Details on a journal
line.
Required if you provide a value on TaxTypeReferenceID.
You can enter:

Tax_Type_ID
WID

Required if you add any values to Tax Details on a journal

line. Provide a reference ID to an existing tax type in
Workday.
Optional field. Provide the taxable amount of the
transaction line, based on the journal line debit and credit
amounts.
Required if you provide a value on TaxCodeReferenceID.
You can enter:

Tax_Code_ID
WID
Withholding_Tax_Code_ID

Required if you add any values to Tax Details on a journal

line. Provide a reference ID to an existing tax code in
Workday.
Required if you provide a value on TaxRateReferenceID.
You can enter:

Tax_Rate_ID
WID
Withholding_Tax_Rate_ID

Required if you add any values to Tax Details on a journal

line. Provide the reference ID to an existing tax rate in
Workday.
Required if you provide a value
on TaxApplicabilityReferenceID. You can enter:

Tax_Applicability_ID
WID

Required if you provide a value

for TaxCodeReferenceIDType. Provide a reference ID of
your tax applicability or leave the field empty.
Required if you provide a value
on TaxRecoverabilityReferenceID. You can enter:

Tax_Recoverability_Object_ID
WID

Optional field. If you have a transaction tax rate on a

journal line, provide a reference ID to your tax
recoverability.

To find the reference IDs to your tax recoverability,

access the Integration IDs report and select Tax
Recoverability on the Business Object prompt.
Required if you provide a value
on TaxRecoverabilityTypeReferenceID. You can enter:

Tax_Recoverability_Type_ID
WID

Required if you add any values to Tax Details on a journal

line. Provide a reference ID to a tax recoverability type in
Workday for your manual journals. You can enter
references to these tax recoverability types:

Fully Recoverable
Non Recoverable

Required if you add any values to Tax Details on a journal

line. Provide a reference ID to a tax point date type on
your manual journals. You can enter:

Accounting Date
Expense Report Date
Goods/Service Delivery Date
Invoice/Adjustment Date
Invoice/Adjustment Received Date
Payment Date
Transaction Date

Required if you provide a value

on TaxSupplierReferenceID. You can enter:

Supplier_ID
Supplier_Reference_ID
WID

Optional field. Uniquely identifies an existing supplier.

You can provide the reference ID of the supplier.

Required if you provide a value

on TaxCustomerReferenceID. You can enter:

Customer_ID
Customer_Reference_ID
WID

Optional field. Uniquely identifies an existing customer.

You can provide the reference ID of the customer.

Optional field. The name of the customer or supplier if

you don't define them within Workday.
Optional field. The address for the customer or supplier if
you don't define them within Workday.
Optional field. The tax ID for the customer or supplier if
you don't define them within Workday.
Optional field. Enter 1 or more worktags at the end of
each row. Each worktag column has a Worktag_ prefix.
The field name identifies the worktag type.

Example: If your worktag type is Cost_Center, then the

name of the field is Worktag_Cost_Center.
Optional field. If you map your external chart of accounts
information with the Create Integration Worktag
Map task, provide the external codes to the journal
connector for lookup. Enter 1 or more external codes at
the end of each row. Each external code column has an
ExternalCode_ prefix followed by the map name created
by Workday.

Example: If your integration worktag map is Region, then

the name of the field is ExternalCode_Region.

Optional field. Enter the line order of the journal line to

which the tax line relates. Workday uses the line order to
relate the tax line to the taxable event journal line.
Separate each taxable event journal line reference on
the TaxableEventLineReferenceLineOrder field with a
semicolon