| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BOE_OP_HISTORY | Operation history data table | 9 | BATCH_ID | Global Unique ID for table | varbinary | 16 | 0 | | |
2 | RSMONREQDELREDU | Monitoring of Reduce/Delete Runs for critical DTAs | 11 | BATCH_ID | Batch ID | nvarchar | 30 | 0 | | |
TOPContract Accounts Receivable and Payable |
3 | DFKKDOC | FI-CA DMS: Administrative Data of Documents | 23 | BATCH_ID | Identification Number of Lot | nvarchar | 12 | 0 | | |
TOPData Staging |
4 | RSBATCHCTRL | BW Batch Management - Control Table | 1 | BATCH_ID | Batch ID | nvarchar | 30 | 0 | | |
5 | RSBATCHCTRL_PAR | BW Batch Management - Control Table | 1 | BATCH_ID | Batch ID | nvarchar | 30 | 0 | | |
6 | RSBATCHDATA | Copy of INDX for Batch and Enqueue Runtime Data | 2 | BATCH_ID | 30 Characters | nvarchar | 30 | 0 | | |
7 | RSBATCHDEBUGWAIT | Waiting Processes for Batch Manager to Be Caught | 4 | BATCH_ID | 30 Characters | nvarchar | 30 | 0 | | |
8 | RSBATCHENQ | Pure Enqueue Table for the Batch Manager | 3 | BATCH_ID | 30 Characters | nvarchar | 30 | 0 | | |
9 | RSBATCHHEADER | BW Batch Management - Header Table for the Start Process | 1 | BATCH_ID | Batch ID | nvarchar | 30 | 0 | | |
10 | RSBATCHPROT | BW Batch Management - Log Table | 1 | BATCH_ID | 30 Characters | nvarchar | 30 | 0 | | |
11 | RSBATCHSTACK | BW Batch Management - Caller Stack of Start Process | 1 | BATCH_ID | 30 Characters | nvarchar | 30 | 0 | | |
12 | RSBKDATAPAKID | DTP: Status Table for Data Packages | 8 | BATCH_ID | Batch ID | nvarchar | 30 | 0 | | |
13 | RSBKREQUESTRUN | DTP Requests | 4 | BATCH_ID | Batch ID | nvarchar | 30 | 0 | | |
14 | RSCRT_RDA_IBC | Information Broadcasting Triggered by RDA | 4 | BATCH_ID | Batch ID | nvarchar | 30 | 0 | | |
15 | RSMIGRATEPREX | Migration: Execute | 7 | BATCH_ID | Batch ID | nvarchar | 30 | 0 | | |
TOPNorway |
16 | T5VBP | Altinn Integration Status Table | 2 | BATCH_ID | Batch ID | nvarchar | 18 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
17 | DFMCA_FORMS | Data Table for Tax Forms | 16 | BATCH_ID | Identification Number of Lot | nvarchar | 12 | 0 | | |
18 | DFMCA_RETURN | Data Table for Tax Returns | 49 | BATCH_ID | Identification Number of Lot | nvarchar | 12 | 0 | | |
19 | DFMCA_RETURN_O | Data Table for Tax Returns | 52 | BATCH_ID | Identification Number of Lot | nvarchar | 12 | 0 | | |
TOPWorkforce Management Application |
20 | WFAFC_CALC_BATCH | Calculation Batch | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
21 | WFAFC_CALC_BCH_T | Calculation Batch | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
22 | WFAFC_CALC_BTLOC | Calculation Batch Information | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
23 | WFAFC_CALC_BT_IN | Calculation Batch Information | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
24 | WFAFC_CALC_BT_ST | Batch calculation status | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
25 | WFAFC_CALC_MP | Mapping table to assign Org Ids to Calc Batches OBSOLETE | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
TOPWorkforce Management Core |
26 | WFMFC_CALC_BATCH | Calculation Batch | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
27 | WFMFC_CALC_BCH_T | Calculation Batch | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
28 | WFMFC_CALC_BTLOC | Calculation Batch Information | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
29 | WFMFC_CALC_BT_IN | Calculation Batch Information | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
30 | WFMFC_CALC_BT_ST | Batch calculation status | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |
31 | WFMFC_CALC_MP | Mapping table to assign Org Ids to Calc Batches OBSOLETE | 2 | BATCH_ID | Forecasting Batch ID | nvarchar | 20 | 0 | | |