| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | REFXCN_CD_ADJ | Condition Adjustment | 2 | STORE_ID | Store Number | nvarchar | 4 | 0 | | |
2 | REFXCN_CMAP | Mapping Table For Store, Counter And Contract | 3 | STORE_ID | Store Number | nvarchar | 4 | 0 | | |
3 | REFXCN_CNT | Counter | 3 | STORE_ID | Store Number | nvarchar | 4 | 0 | | |
4 | REFXCN_DIVIDE | Rule of Sharing Expenses | 4 | STORE_ID | Store Number | nvarchar | 4 | 0 | | |
5 | REFXCN_PMAP | Mapping Table For Payment Detail to RR | 3 | STORE_ID | Store Number | nvarchar | 4 | 0 | | |
6 | REFXCN_RMAP | Mapping of Material, Category & Promotion to Reporting Rule | 3 | STORE_ID | Store Number | nvarchar | 4 | 0 | | |
7 | REFXCN_SMAP | Mapping of Store and Contract | 3 | STORE_ID | Store Number | nvarchar | 4 | 0 | | |
8 | REFXCN_VIP | VIP Actual Discount Percentage | 3 | STORE_ID | Store Number | nvarchar | 4 | 0 | | |
9 | RTST_OP_STATUS | Status information for a store product | 2 | STORE_ID | Plant | nvarchar | 4 | 0 | | |
TOPStorage and Retention Service |
10 | DAS_COLLECTIONS | ILM SRS: Collections | 8 | STORE_ID | Storage System ID | nvarchar | 19 | 0 | | |
11 | DAS_COL_STORE | ILM SRS: Relationship Between Collection and Store | 3 | STORE_ID | Storage System ID | nvarchar | 19 | 0 | | |
12 | DAS_STORES | ILM SRS: Store Administration | 2 | STORE_ID | Storage System ID | nvarchar | 19 | 0 | | |