| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPData Collection |
1 | S120 | Sales as per receipts | 28 | PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | decimal | 19 | 2 | | |
2 | S120BIW1 | S120BIW1 * Sales as Per Receipts | 28 | PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | decimal | 19 | 2 | | |
3 | S120BIW2 | S120BIW2 * Sales as Per Receipts | 28 | PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | decimal | 19 | 2 | | |
4 | S121 | Material aggregation - POS | 22 | PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | decimal | 19 | 2 | | |
5 | S122 | Cashier | 20 | PDIFF | Cashier: price difference between R/3 -> and POS rtl price | decimal | 19 | 2 | | |
6 | S122BIW1 | S122BIW1 * Cashier | 20 | PDIFF | Cashier: price difference between R/3 -> and POS rtl price | decimal | 19 | 2 | | |
7 | S122BIW2 | S122BIW2 * Cashier | 20 | PDIFF | Cashier: price difference between R/3 -> and POS rtl price | decimal | 19 | 2 | | |
TOPPayroll |
8 | T5HS1 | HR-H: Havi bevallás - bevallási adatok | 9 | PDIFF | HR-H: Havi bevallás - mezoérték pozitív diff.-val érintett | nvarchar | 1 | 0 | | |
9 | T5HSJ | Havi bevallás - bevallási adatok - munkavállalónként | 9 | PDIFF | HR-H: Havi bevallás - mezoérték pozitív diff.-val érintett | nvarchar | 1 | 0 | | |
10 | T5HSM | Havi bevallás - külso bevallási adatok magánszemély (I.né) | 9 | PDIFF | HR-H: Havi bevallás - mezoérték pozitív diff.-val érintett | nvarchar | 1 | 0 | | |
11 | T5HST | Havi bevallás- külso-belso adatok összesítve - személy | 9 | PDIFF | HR-H: Havi bevallás - mezoérték pozitív diff.-val érintett | nvarchar | 1 | 0 | | |
12 | T5HSV | HR-H: Havi bevallás - bevallási adatok (negyedéves) | 9 | PDIFF | HR-H: Havi bevallás - mezoérték pozitív diff.-val érintett | nvarchar | 1 | 0 | | |
13 | T5HSY | Havi bevallás- külso-belso adatok összesítve személy I.né | 9 | PDIFF | HR-H: Havi bevallás - mezoérték pozitív diff.-val érintett | nvarchar | 1 | 0 | | |