| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | FKK_JLRK_SHORT | Header Data for IS-M/SD Service Settlement - Extracts | 11 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
2 | A448 | IS-M/SD: Promotion Rebate for WBZ Company | 7 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
3 | A458 | IS-M/SD: Employee Renewal Commission | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
4 | A459 | IS-M/SD: Employee Up-Front Commission | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
5 | A461 | IS-M/SD: Employee Bonus for Sales Promotion | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
6 | A462 | IS-M/SD: SC Commission Settlement - Renewal Commission | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
7 | A463 | IS-M/SD: SC Commission Settlement - Bonus for Up-Front Comm. | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
8 | A464 | IS-M/SD: SC Commission Settlement for Up-Front Commission | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
9 | A470 | IS-M/SD: Deliverer Settlement - Normal Items | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
10 | A471 | IS-M/SD: Lump Sum Deliverer Sett.for Normal Items: District | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
11 | A472 | IS-M/SD: Lump Sum Deliv.Sett.for Normal Items: Delivery Type | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
12 | A473 | IS-M/SD: Gen.Settlement for Purchasing Org./Service Company | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
13 | A474 | IS-M/SD: Deliverer Settlement - Sunday Bonus | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
14 | A475 | IS-M/SD: Deliverer Settlement - Path Compensation | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
15 | A476 | IS-M/SD: Deliverer Settlement - Public Holiday Bonus | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
16 | A477 | IS-M/SD: Deliverer Settlement - Night Work Bonus | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
17 | A478 | IS-M/SD: Deliverer Settlement - Run Compensation | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
18 | A479 | IS-M/SD: Deliverer Settlement - Key Bonus | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
19 | A480 | IS-M/SD: Deliverer Settlement - District Flat Rate | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
20 | A482 | IS-M/SD: SC Commission Settlement - Bonus for Up-Front Comm. | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
21 | A483 | IS-M/SD: Payment Method for Employee Bonus for Up-Front Com. | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
22 | A484 | IS-M/SD: Employee Commission Deposit | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
23 | A485 | IS-M/SD: SC Hand Delivery Settlement - Normal Item | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
24 | A486 | IS-M/SD: Lump Sum Del.Type f.SC Hand Del.Sett. - Normal Item | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
25 | A487 | IS-M/SD: Deliverer Settlement - Bonuses (Inserts/Weight) | 4 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
26 | A488 | IS-M/SD: SC Delivery Settlement - Sunday Bonus | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
27 | A489 | IS-M/SD: SC Delivery Settlement - Path Compensation | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
28 | A490 | IS-M/SD: SC Delivery Settlement - Public Holiday Bonus | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
29 | A491 | IS-M/SD: SC Delivery Settlement - Night Work Bonus | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
30 | A492 | IS-M/SD: SC Delivery Settlement - Run Compensation | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
31 | A493 | IS-M/SD: SC Delivery Settlement - Key Bonus | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
32 | A494 | IS-M/SD: SC Delivery Settlement - District Lump Sum | 5 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |
33 | JLRK | IS-M/SD: Settlement Header Data | 41 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | | |