| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LAND1 | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | STGRP | Customer group for Substituiçao Tributária calculation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | VALIDFROM | Date from which the tax rule is valid | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | VALIDTO | Date to which the tax rule is valid | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SUR_TYPE | Sub.Trib. calculation rule | char | 1 | 0 | | | | Allow NULL? |
| 9 | RATE | Sub.Trib. surcharge percentage rate | decimal | 6 | 2 | | | | |
| 10 | PRICE | Sub.Trib. fixed price per unit | decimal | 15 | 2 | | | | |
| 11 | FACTOR | Number of units for Sub.Trib. calc. (price per n units) | decimal | 6 | 2 | | | | |
| 12 | UNIT | Unit for Sub.Trib. calculation (price per n units) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | BASERED1 | Sub.Trib. Base Reduction 1 (Federal) (in %) | decimal | 6 | 2 | | | | |
| 14 | BASERED2 | Sub.Trib. Base Reduction 2 (State) (in %) | decimal | 6 | 2 | | | | |
| 15 | ICMSBASER | ICMS Reduction for Sub.Trib. (in %) | decimal | 6 | 2 | | | | |
| 16 | MINPRICE | Minimum Price Per Item Is Basis for Substituição Tributária | decimal | 15 | 2 | | | | |
| 17 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |