| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | DATE_POST | Posting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BCA_DTE_DIM_RECON_POSTING_DATE | Allow NULL? |
| 3 | BUSINESS_AREA | Business area for reconciliation | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BCA_DTE_DIM_RECONC_BUSNES_AREA | Allow NULL? |
| 4 | SYST_TO | Target System ID | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BCA_DTE_DIM_RECON_SYSTEM_TO | Allow NULL? |
| 5 | APPL_TO | Target Application ID | nvarchar | 5 | 0 | CHAR | (N' ') | No | | BCA_DTE_DIM_RECONC_APPL_TO | Allow NULL? |
| 6 | RECONC_SYSTEM | Source System ID | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BCA_DTE_DIM_RECONC_SYSTEM_FROM | Allow NULL? |
| 7 | RECONC_APPL | Source Application ID | nvarchar | 5 | 0 | CHAR | (N' ') | No | | BCA_DTE_DIM_RECONC_APPL_FROM | Allow NULL? |
| 8 | RECONC_NO | Additional Key in the Reconciliation Unit | nvarchar | 15 | 0 | CHAR | (N' ') | No | | BCA_DTE_DIM_RECONC_NO | Allow NULL? |
| 9 | ADDKEY | Additional Key (Parallel Processing) | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | BCA_DTE_DIM_RECONC_ADDTNL_KEY | Allow NULL? |
| 10 | CURRENCY | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | No | * | BCA_DTE_DIM_RECONC_TCUR | Allow NULL? |
| 11 | FLG_CREDIT | Item is a Credit Memo | char | 1 | 0 | CHAR | (N' ') | No | | BCA_DTE_DIM_RECONC_FLG_CREDIT | Allow NULL? |
| 12 | STATUS | Interface Reconciliation Status | nvarchar | 2 | 0 | CHAR | (N' ') | No | | BCA_DTE_DIM_RCN_STATUS | Allow NULL? |
| 13 | OBJECT_TYPE | Reconciliation Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | BCA_DTE_DIM_RECONC_OBJECT_TYPE | Allow NULL? |
| 14 | ITEM_SUM | Reconciliation Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | BCA_DTE_DIM_RECONC_ITEMS_SUM | |
| 15 | ITEM_CNT | Number of Reconciliation Objects | int | 10 | 0 | INT4 | ((0)) | Yes | | BCA_DTE_DIM_RECONC_ITEMS_COUNT | Allow NULL? |
| 16 | CHANGE_TSTMP | Time Stamp of Last Change | decimal | 15 | 0 | DEC | ((0)) | Yes | | BCA_DTE_DIM_RECON_TMSTMP_CHNGE | |
