| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_DOCFI_H | Data Transfer: FI Documents (Header Data) | 5 | SETTLE_DATE | Receipt Date | nvarchar | 8 | 0 | | |
2 | CACS00_DOCSE | Commission Document, Settlement | 24 | SETTLE_DATE | Settlement Date | nvarchar | 8 | 0 | | |
3 | YCRM01_DOCFI_H | Data Transfer: FI Documents Header Data | 7 | SETTLE_DATE | Receipt Date | nvarchar | 8 | 0 | | |
4 | YCRM01_DOCSE | Commission Document: Due Dates | 24 | SETTLE_DATE | Settlement Date | nvarchar | 8 | 0 | | |
5 | YHITEC_DOCFI_H | Data Transfer: FI Documents Header Data | 5 | SETTLE_DATE | Receipt Date | nvarchar | 8 | 0 | | |
6 | YHITEC_DOCSE | Commission Document: Due Dates | 24 | SETTLE_DATE | Settlement Date | nvarchar | 8 | 0 | | |
7 | YSVMA_DOCFI_H | Data Transfer: FI Documents (Header Data) | 5 | SETTLE_DATE | Receipt Date | nvarchar | 8 | 0 | | |
8 | YSVMA_DOCSE | Commission Document: Due Dates | 24 | SETTLE_DATE | Settlement Date | nvarchar | 8 | 0 | | |
9 | YTEL01_DOCFI_H | Data Transfer: FI Documents Header Data | 5 | SETTLE_DATE | Receipt Date | nvarchar | 8 | 0 | | |
10 | YTEL01_DOCSE | Commission Document: Due Dates | 41 | SETTLE_DATE | Settlement Date | nvarchar | 8 | 0 | | |
11 | YTEL05_DOCFI_H | Data Transfer: FI Documents (Header Data) | 5 | SETTLE_DATE | Receipt Date | nvarchar | 8 | 0 | | |
12 | YTEL05_DOCSE | Commission Document: Due Dates | 30 | SETTLE_DATE | Settlement Date | nvarchar | 8 | 0 | | |
13 | ZICMAG_DOCFI_H | Data Transfer: FI Documents (Header Data) | 5 | SETTLE_DATE | Receipt Date | nvarchar | 8 | 0 | | |
14 | ZICMAG_DOCSE | Commission Document: Due Dates | 24 | SETTLE_DATE | Settlement Date | nvarchar | 8 | 0 | | |