| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /1CN/SBPSAP001 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 2 | /1CN/SBPSAP016 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 3 | /1CN/SBPSAP019 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 4 | /1CN/SBPSAP068 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 5 | /1CN/SBPSAP118 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 6 | /1CN/SPTSAP00001 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 7 | /1CN/SPTSAP00004 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 8 | /1CN/SPTSAP00005 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 9 | /1CN/SPTSAP00006 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 10 | /1CN/STXSAPD0001 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 11 | /1CN/STXSAPD0002 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 12 | /1CN/STXSAPD0003 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 13 | /1CN/STXSAPD0004 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 14 | /1CN/STXSAPD0201 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 15 | /1CN/STXSAPR0100 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 16 | /1CN/STXSAPR0103 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 17 | /1CN/STXSAPR0104 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 18 | /1CN/STXSAPR0105 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 19 | /1CN/STXSAPR0106 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 20 | /1CN/STXSAPR0107 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 21 | /1CN/STXSAPR0108 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 22 | /1CN/STXSAPR0110 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 23 | /1CN/STXSAPR0111 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 24 | /1CN/STXSAPR0112 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 25 | /1CN/STXSAPR0113 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 26 | /1CN/STXSAPR0120 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 27 | /1CN/STXSAPR0130 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 28 | /1CN/STXSAPR0131 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 29 | /1CN/STXSAPR0140 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 30 | /1CN/STXSAPR0201 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 31 | /1CN/STXSAPRBR01 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 32 | /1CN/STXSAPRBR02 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 33 | /1CN/STXSAPRBR03 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 34 | /1CN/STXSAPRBR10 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 35 | /1CN/STXSAPRBR11 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 36 | /1CN/STXSAPRBR12 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 37 | /1CN/STXSAPRBR20 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 38 | /1CN/STXSAPRBR21 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 39 | /1CN/STXSAPRIN03 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 40 | /1CN/STXSAPRIN04 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 41 | /1CN/STXSAPRIN06 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 42 | /1CN/STXSAPRIN07 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 43 | /1CN/STXSAPS0100 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 44 | /1CN/STXSAPS0101 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 45 | /1CN/STXSAPS0102 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 46 | /1CN/STXSAPW0201 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 47 | /1CN/STXSAPW0202 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 48 | /1CN/STXSAPX0100 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 49 | /1CN/STXSAPX0101 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 50 | /1CN/STXSAPX0102 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 51 | /1CN/STXSAPX0103 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 52 | /1CN/STXSAPX0104 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 53 | /1CN/STXSAPX0105 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 54 | /1CN/STXSAPX0106 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 55 | /1CN/STXSAPX0140 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 56 | /1CN/STXSAPX0141 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 57 | /1CN/STXSAPX0146 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 58 | /1CN/STXSAPX0147 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 59 | /1CN/STXSAPX0148 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 60 | /1CN/STXSAPXBR01 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 61 | /1CN/STXSAPXBR02 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 62 | /1CN/STXSAPXBR03 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 63 | /1CN/STXSAPXBR11 | Supplementary Table for a Condition Table | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 64 | P2RK_GRDBT | Payroll results Canada: Garnishment debt | 49 | EXPNT | Garnishment payroll: Pointer to entry in ext. table for debt | varbinary | 2 | 0 | | |
| TOPPricing |
| 65 | PRCD_COND | Price Condition - Item - Condition (KONV) | 54 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
| 66 | PRCM_SUPP_000 | Reference Table for Additional Information (KONP000) | 7 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | |
