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 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. DON'T TRUNCATE OR EDIT AN OUTPUT DATASET. | |
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. DON'T EDIT AN INPUT DATASET. |
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. DON'T TRUNCATE OR EDIT AN OUTPUT DATASET. | |
Error Dataset
XX_ENR_ # _TBL_EnrichedError | This dataset contains processing errors for the Enrichment stage.
DON'T TRUNCATE OR EDIT AN ERROR DATASET. | |
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. DON'T TRUNCATE OR EDIT AN INPUT DATASET. |
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 Datasets
XX_DTL_TBL_DetailedAccounting | This table contains results of the Detailed Accounting stage. | |
Error Tables
| These tables contain processing errors for the Detailed Accounting stage.
DON'T TRUNCATE OR EDIT ANY ERROR DATASETS. | |
Summarization | Input Dataset
XX_DTL_TBL_DetailedAccounting | This table is the Input table for the Summarization stage.
The Output table from the Detailed Accounting stage. DON'T TRUNCATE OR EDIT ANY INPUT DATASET. |
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.
DON'T TRUNCATE OR EDIT ANY DATASETS. | |
Error Datasets
XX_SUM_TBL_JournalToKeyLinkageError | These tables contain processing errors for the Summarization stage.
DON'T TRUNCATE OR EDIT ANY ERROR DATASETS. | |
Reporting Dataset
XX_SummaryandDetailedAccountingReference | This dataset is unique to the Summarization stage.
Links Detail Accounting records and the Summarized Accounting records. DON'T EDIT THE REPORTING DATASET. |
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 DON'T EDIT ANY SYSTEM DATASETS. XX_TBL_DismissedTransactionsConsolidated XX_TBL_UserDirectedForDismissal DON'T TRUNCATE OR EDIT ANY SYSTEM DATASET. |
User Configured Dismiss System Dataset | XX_USR_UserDirectedForDismissal
Use this dataset to configure your custom dismissals. |