| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | TOGRU | Tolerance group for the business partner/G/L account | nvarchar | 4 | 0 | CHAR | (N' ') | No | | TOGRU | Allow NULL? |
| 4 | BETRS | Maximum Payment Difference for Revenue | decimal | 7 | 2 | CURR | ((0)) | Yes | | BETRS_043T | |
| 5 | BETRH | Maximum Payment Difference for Expense | decimal | 7 | 2 | CURR | ((0)) | Yes | | BETRH_043T | |
| 6 | PROZS | Maximum Allowable Revenues from Payment Differences | decimal | 3 | 1 | DEC | ((0)) | Yes | | PROZS_043T | |
| 7 | PROZH | Maximum Expense Permitted from Payment Differences | decimal | 3 | 1 | DEC | ((0)) | Yes | | PROZH_043T | |
| 8 | SKNTS | Maximum Discount Adjust. for Gain from Payment Differences | decimal | 7 | 2 | CURR | ((0)) | Yes | | SKNTS_043T | |
| 9 | SKNTH | Maximum Discount Adjust. for Loss from Payment Differences | decimal | 7 | 2 | CURR | ((0)) | Yes | | SKNTH_043T | |
| 10 | TOLER | Grace Days | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TOLER_043G | Allow NULL? |
| 11 | SKTRE | Cash Discount Terms Used for Displaying Items when Clearing | char | 1 | 0 | CHAR | (N' ') | Yes | | SKTRE_043G | Allow NULL? |
| 12 | XKONR | Indicator: Transfer payment conditions from the invoice ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XKONR_043G | Allow NULL? |
| 13 | ZTERM | Standard Payment Term for Carryforward Postings | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM_043 | Allow NULL? |
| 14 | XSKAN | Indicator: Only grant partial cash discount ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSKAN_043G | Allow NULL? |
| 15 | MSLRP | Dunning Key for Residual Items | char | 1 | 0 | CHAR | (N' ') | Yes | T040 | MSLRP_043G | Allow NULL? |
| 16 | PRAVS | Tolerance Limit for Difference Compared with Pmnt Advce Item | decimal | 3 | 1 | DEC | ((0)) | Yes | | PRAVS_043G | |
| 17 | PRAVH | Tolerance Limit for Difference Compared with Pmnt Advce Item | decimal | 3 | 1 | DEC | ((0)) | Yes | | PRAVH_043G | |
| 18 | BEAVS | Tolerance Limit for Difference Compared with Pmnt Advce Item | decimal | 7 | 2 | CURR | ((0)) | Yes | | BEAVS_043G | |
| 19 | BEAVH | Tolerance Limit for Difference Compared with Pmnt Advce Item | decimal | 7 | 2 | CURR | ((0)) | Yes | | BEAVH_043G | |
| 20 | VRZDE | Base Date for Determining Arrears Days for OI Processing | char | 1 | 0 | CHAR | (N' ') | Yes | | VRZDE | Allow NULL? |
| 21 | BEADS | Maximum Payment Diff. for Revenue with Function Code AD | decimal | 7 | 2 | CURR | ((0)) | Yes | | BETRADS_043T | |
| 22 | BEADH | Maximum Payment Diff. for Expense with Function Code AD | decimal | 7 | 2 | CURR | ((0)) | Yes | | BETRADH_043T | |
| 23 | PRADS | Max. Permitted Rev. from Payment Diff. with Function Code AD | decimal | 3 | 1 | DEC | ((0)) | Yes | | PROZADS_043T | |
| 24 | PRADH | Max. Permitted Exp. from Payment Diff. with Function Code AD | decimal | 3 | 1 | DEC | ((0)) | Yes | | PROZADH_043T | |
