| 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 | 22 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
TOPPeriodical Sales and Distribution |
2 | A450 | IS-PSD: Versandkosten pauschal Ländergruppierung | 10 | BZPERF | IS-M: Facturatierelevante abonnementsperiodiciteit | nvarchar | 5 | 0 | | |
3 | A451 | Purchase Price | 8 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
4 | A452 | IS-M/SD: Lump Sum Shipping Costs f.Current Delivery Country | 10 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
5 | A457 | Subscription Prices for Edition Condition Grouping | 8 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
6 | A458 | IS-M/SD: Employee Renewal Commission | 8 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
7 | A459 | IS-M/SD: Employee Up-Front Commission | 9 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
8 | A460 | Daily Subscription Prices for Edition Condition Grouping | 7 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
9 | A461 | IS-M/SD: Employee Bonus for Sales Promotion | 10 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
10 | A462 | IS-M/SD: SC Commission Settlement - Renewal Commission | 8 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
11 | A463 | IS-M/SD: SC Commission Settlement - Bonus for Up-Front Comm. | 10 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
12 | A464 | IS-M/SD: SC Commission Settlement for Up-Front Commission | 9 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
13 | A468 | IS-M/SD: Daily Shipping Costs for Current Delivery Country | 9 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
14 | A469 | IS-M/SD: Daily Shipping Costs for Country Grouping | 9 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
15 | A481 | IS-M/SD: Daily Purchase Prices | 7 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
16 | A482 | IS-M/SD: SC Commission Settlement - Bonus for Up-Front Comm. | 10 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
17 | A483 | IS-M/SD: Payment Method for Employee Bonus for Up-Front Com. | 10 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
18 | JKEP | Sales Order: Schedule Line Data | 35 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
19 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 64 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |
20 | JLRP | IS-M/SD: Item Data for Settlement | 129 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | | |