Reference: Accounting Source Datasets and Tables
When you create an accounting source, Workday creates these datasets and tables:
Workday uses System datasets for
internal Accounting Center processing. Don't edit or import these System
datasets into another derived dataset. Only edit System datasets under these 2
conditions:
- If fields change after you process an accounting center batch. You might need to edit the system datasets manually in order to sync schema. This ensures that Workday selects the fields on join or filter stages. Don't do any other transformations within system datasets.
- The only system dataset that you should read from is the XX_ENR_#_SYS_UnprocessedForBatch dataset within the Enrichment stage. Workday recommends importing the dataset into a derived dataset from where you can perform transformations.
Stage | Dataset/Table | Comments |
|---|---|---|
Batch Initiation | Input Dataset | The first dataset for the stage and displayed in your Accounting Center header. This
dataset is the Ingestion table for Batch initiation and will be the
output of the Data Change Task if you’ve have one. |
System Datasets
| The datasets are necessary for processing the batch. DON'T EDIT ANY
SYSTEM DATASETS. | |
Output Dataset XX_INIT_TBL_BatchMapping | This dataset contains results of the Initiation stage. Identifies records picked up
by the Accounting Center for processing in a batch. Is part of
the Input dataset for the Enrichment stage. | |
Enrichment | Input Dataset XX_SYS_MappedIngestionData | The first dataset for the enrichment stage. Is a join of Output dataset from the
Initiation stage and your Ingestion table. For multiple
enrichment stages, the input is the output of the previous
enrichment stage. |
System Datasets
** Are available only in existing Accounting Sources. For new
Accounting Sources that you create, Workday won't create these error
datasets. | These datasets contain data that Workday is processing for the
batch. DON'T EDIT ANY SYSTEM DATASETS. | |
User Dataset XX_ENR_ # _USR_UserConfiguration | This dataset is unique to the Enrichment stage. These datasets only process
transactions for the batch and don't store records. Instead of
adding transformations directly in this dataset, Workday recommends
that you make transformations in derived datasets that you’ve
imported from the XX_ENR_ # _SYS_UnprocessedForBatch dataset
and then connect to this User Dataset. Workday also
recommends that you create your transformation datasets between the
UnprocessedForBatch dataset and UserConfiguration
dataset. | |
Output Dataset XX_ENR_ # _TBL_EnrichedData | This dataset contains results of the Enrichment stage. The Input table for the
Detailed Accounting stage or the next enrichment stage if there are
multiple enrichment stages. | |
Error Dataset XX_ENR_ # _TBL_EnrichedError | This dataset contains processing errors for the Enrichment
stage. | |
Detailed Accounting | Input Dataset XX_ENR_ # _TBL_EnrichedData | This dataset is the first table for the Detailed Accounting stage. The Output dataset
from the last Enrichment stage. |
System Datasets
** Is available only in existing Accounting Sources. For new
Accounting Sources that you create, Workday won't create this error
dataset. | These datasets are necessary for processing the batch. DON'T EDIT
ANY SYSTEM DATASETS. | |
Output Tables XX_DTL_TBL_DetailedAccounting | These tables contain results of the Detailed Accounting stage. The Input table for
the Summarization stage. | |
Error Tables
| These tables contain processing errors for the Detailed Accounting
stage. | |
Summarization | Input Table XX_DTL_TBL_DetailedAccounting | This table is the Input table for the Summarization stage. The Output table from the
Detailed Accounting stage. |
System Datasets
| These datasets are necessary for processing the batch. DON'T EDIT
ANY SYSTEM DATASETS. | |
Output Datasets
| These datasets contain results of the Summarization stage. | |
Error Tables XX_SUM_TBL_JournalToKeyLinkageError | These tables contain processing errors for the Summarization
stage. | |
Reporting
Dataset XX_SummaryandDetailedAccountingReference | This dataset is unique to the Summarization stage. Links
DetailAccounting records and the Summarized Accounting
records. |
In addition, Workday also creates these systems and user-configured dismiss
datasets:
Dataset Type | Dataset/Table |
|---|---|
Dismiss System Datasets | XX_SYS_DismissedTransactionsConsolidated XX_SYS_DismissedTransactionsPopulatedForReprocessing XX_SYS_UserDirectedForDismissal XX_TBL_DismissedTransactionsConsolidated XX_TBL_UserDirectedForDismissal |
User Configured Dismiss System Dataset | XX_USR_UserDirectedForDismissal Use this dataset to configure your custom
dismissals. |