| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /IAM/D_ACT_PARTY | Party | 9 | POSITION_ID | Position in Issue and Activity Engine | nvarchar | 20 | 0 | | |
| 2 | /IAM/D_I_PARTY | Party node DB table | 9 | POSITION_ID | Position in Issue and Activity Engine | nvarchar | 20 | 0 | | |
| 3 | BCKTRLIT_AD_TRAN | Accrual/Deferral Business Transactions Backup | 5 | POSITION_ID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
| 4 | CMCBC_PS | Cash budgeting position | 4 | POSITION_ID | Position | nvarchar | 8 | 0 | | |
| 5 | CMCBD_COMMENT_PL | Cash Budgeting Workflow History | 5 | POSITION_ID | Position | nvarchar | 8 | 0 | | |
| 6 | CMCBD_ORG_POS | Organizational Hierarchy Position | 6 | POSITION_ID | Position | nvarchar | 8 | 0 | | |
| 7 | CMCBD_WF_USERS | Cash Budgeting Workflow Users | 5 | POSITION_ID | Position | nvarchar | 8 | 0 | | |
| 8 | CMCBD_WKLIST_TK | Work List: Tasks Table | 8 | POSITION_ID | Position | nvarchar | 8 | 0 | | |
| 9 | SFIOM_RPRQ_ORGAS | Replication Request Organizational Assignment | 16 | POSITION_ID | Organizational Structure Item ID | nvarchar | 100 | 0 | | |
| TOPNon Profit Organizations |
| 10 | HRP1081 | DB Table for Infotype 1081 | 22 | POSITION_ID | NPO Position Type ID | nvarchar | 2 | 0 | | |
| 11 | T7UNOM_FUND_POS | Map Funding Type to Position Type | 3 | POSITION_ID | NPO Position Type ID | nvarchar | 2 | 0 | | |
| TOPOLAP Technology |
| 12 | RSDRDLOGHEADER | Log Delete Actions (Header Table) | 7 | POSITION_ID | | int | 10 | 0 | | |
| 13 | RSDRDLOGPOSITION | Log Delete Actions (Positions) | 1 | POSITION_ID | | int | 10 | 0 | | |
| TOPPosition Budgeting and Control |
| 14 | HRFPM_BPREP_DATA | Preprocesses Data for BPREP Data Extraction | 32 | POSITION_ID | Object ID | nvarchar | 8 | 0 | | |
| TOPTransaction Manager |
| 15 | TEXT_ARCH_LOG | Archive trace log info | 5 | POSITION_ID | Exposure Position ID | nvarchar | 20 | 0 | | |
| 16 | TEXT_POSITIONS | Exposure Positions | 3 | POSITION_ID | Exposure Position ID | nvarchar | 20 | 0 | | |
| 17 | TEXT_TRANSACTION | Unmatched Exposure Business Transactions | 56 | POSITION_ID | Exposure Position ID | nvarchar | 20 | 0 | | |
| 18 | TRADT_LOCK | TR: Accrual/Deferral: TRL Position Lock | 5 | POSITION_ID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
| 19 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 4 | POSITION_ID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
| TOPWaste Management |
| 20 | EWA_CCOC_ASS_RS | Assign CO Data to Resources | 6 | POSITION_ID | Position | nvarchar | 8 | 0 | | |
| 21 | EWA_ORDER_RESOBJ | Resource Table for Waste Disposal Order | 8 | POSITION_ID | Position | nvarchar | 8 | 0 | | |
