| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T500L | MOLGA | Allow NULL? |
| 3 | NXMOD | Code for the non-exempt amount model | nvarchar | 6 | 0 | CHAR | (N' ') | No | T53GE | P_NXMODG | Allow NULL? |
| 4 | NXIDE | Is result of exemption calculation the exempt amount? | char | 1 | 0 | CHAR | (N' ') | Yes | | P_NXIDE | Allow NULL? |
| 5 | NXIDN | Is result of exemption calculation the non-exempt amount? | char | 1 | 0 | CHAR | (N' ') | Yes | | P_NXIDN | Allow NULL? |
| 6 | NXLTP | Percentage limit of non-exempt amount calculation | decimal | 5 | 2 | DEC | ((0)) | Yes | | P_NXLTP | |
| 7 | NXUNP | Unit of percentage value in non-exempt calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | P_NXUNP | Allow NULL? |
| 8 | NXLTF | Flat amount value in non-exempt calculation | decimal | 9 | 2 | CURR | ((0)) | Yes | | P_NXLTF | |
| 9 | NXLTD | Amount per dependant value in non-exempt calculation | decimal | 9 | 2 | CURR | ((0)) | Yes | | P_NXLTD | |
| 10 | NXEXD | Number of excluded dependants in non-exempt calculation | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P_NXEXD | Allow NULL? |
| 11 | NXUNA | Unit of the non-exempt amount | char | 1 | 0 | CHAR | (N' ') | Yes | | P_NXUNA | Allow NULL? |
| 12 | NXREL | Relation by which percentage and amount values are connected | char | 1 | 0 | CHAR | (N' ') | Yes | | P_NXREL | Allow NULL? |
| 13 | SRCOD | Code for special rule | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T53GH | P_SRCOD | Allow NULL? |
| 14 | LSCOD | Code for level systems | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T53GK | P_LSCOD | Allow NULL? |
| 15 | ROMOD | Rounding model | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T53GX | P_ROMOD | Allow NULL? |
