| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | FKK_JLRPHD_SHORT | Item Data for IS-M/SD Home Delivery Settlement - Extracts | 31 | LFATAT | Actual delivery type (usually DT for dist.viability set) | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
2 | A470 | IS-M/SD: Deliverer Settlement - Normal Items | 7 | LFATAT | Actual delivery type (usually DT for dist.viability set) | nvarchar | 2 | 0 | | |
3 | A471 | IS-M/SD: Lump Sum Deliverer Sett.for Normal Items: District | 6 | LFATAT | Actual delivery type (usually DT for dist.viability set) | nvarchar | 2 | 0 | | |
4 | A472 | IS-M/SD: Lump Sum Deliv.Sett.for Normal Items: Delivery Type | 5 | LFATAT | Actual delivery type (usually DT for dist.viability set) | nvarchar | 2 | 0 | | |
5 | A485 | IS-M/SD: SC Hand Delivery Settlement - Normal Item | 7 | LFATAT | Actual delivery type (usually DT for dist.viability set) | nvarchar | 2 | 0 | | |
6 | A486 | IS-M/SD: Lump Sum Del.Type f.SC Hand Del.Sett. - Normal Item | 6 | LFATAT | Actual delivery type (usually DT for dist.viability set) | nvarchar | 2 | 0 | | |
7 | JLRP | IS-M/SD: Item Data for Settlement | 80 | LFATAT | Actual delivery type (usually DT for dist.viability set) | nvarchar | 2 | 0 | | |