| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | FKK_JLRPCM_SHORT | Item Data for IS-M/SD Commission Settlement - Extracts | 24 | MINBEZ | IS-M/SD: Minimum Length of Subscription | nvarchar | 3 | 0 | | |
TOPPeriodical Sales and Distribution |
2 | A459 | IS-M/SD: Employee Up-Front Commission | 7 | MINBEZ | IS-M: Min.length of subscription (NUMC field for pricing) | nvarchar | 2 | 0 | | |
3 | A461 | IS-M/SD: Employee Bonus for Sales Promotion | 8 | MINBEZ | IS-M: Min.length of subscription (NUMC field for pricing) | nvarchar | 2 | 0 | | |
4 | A463 | IS-M/SD: SC Commission Settlement - Bonus for Up-Front Comm. | 8 | MINBEZ | IS-M: Min.length of subscription (NUMC field for pricing) | nvarchar | 2 | 0 | | |
5 | A464 | IS-M/SD: SC Commission Settlement for Up-Front Commission | 7 | MINBEZ | IS-M: Min.length of subscription (NUMC field for pricing) | nvarchar | 2 | 0 | | |
6 | A482 | IS-M/SD: SC Commission Settlement - Bonus for Up-Front Comm. | 8 | MINBEZ | IS-M: Min.length of subscription (NUMC field for pricing) | nvarchar | 2 | 0 | | |
7 | A483 | IS-M/SD: Payment Method for Employee Bonus for Up-Front Com. | 8 | MINBEZ | IS-M: Min.length of subscription (NUMC field for pricing) | nvarchar | 2 | 0 | | |
8 | JLRP | IS-M/SD: Item Data for Settlement | 132 | MINBEZ | Minimum Length of Subscription | decimal | 2 | 0 | | |