| 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 | * | MANDT | Allow NULL? |
| 2 | RPNUM | Installment plan number in Contract A/R & A/P | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | RPBEL_KK | Allow NULL? |
| 3 | RPRCI | Index: Use installment plan when printing payment form | char | 1 | 0 | CHAR | (N' ') | Yes | | RPRCI_KK | Allow NULL? |
| 4 | RPRDA | Print Type for Letters and Payment Forms | char | 1 | 0 | NUMC | (N'0') | Yes | | RPRDA_KK | Allow NULL? |
| 5 | RPCAT | Installment plan category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK062A | RPCAT_KK | Allow NULL? |
| 6 | DEADT | Deactivation Date Of Installment Plan | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DEADT_KK | Allow NULL? |
| 7 | DEMAN | Instalment plan was manually deactivated | char | 1 | 0 | CHAR | (N' ') | Yes | | DEMAN_KK | Allow NULL? |
| 8 | DEOFF | Open amount at time of deactivation | decimal | 13 | 2 | CURR | ((0)) | Yes | | DEOFF_KK | |
| 9 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS_KK | Allow NULL? |
| 10 | DEAGD | Reason for deactivation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK061A | DEAGD_KK | Allow NULL? |
| 11 | STTDT | Start date of installment plan | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STARDAT_KK | Allow NULL? |
| 12 | ENDDT | Installment plan end date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDEDAT_KK | Allow NULL? |
| 13 | NINST | Number of Installments | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NINST_KK | Allow NULL? |
| 14 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONT_KK | Allow NULL? |
| 15 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 16 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 17 | DRCDT | Print Date of the Last Run for Payment Form | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DRCDT_KK | Allow NULL? |
| 18 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 19 | DZINS | Calculate Interest from Original Items | char | 1 | 0 | CHAR | (N' ') | Yes | | DZINS_KK | Allow NULL? |
| 20 | GZVER | Distribute Interest/Charges to all Installments | char | 1 | 0 | CHAR | (N' ') | Yes | | GZVER_KK | Allow NULL? |
| 21 | FAEIN | Interest Document Due Date | char | 1 | 0 | CHAR | (N' ') | Yes | | FAEIN_KK | Allow NULL? |
| 22 | DPUDT | Entry Day Of Installment Plan Deactivation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DPUDT_KK | Allow NULL? |
| 23 | DPUTM | Entry Time Of Installment Plan Deactivation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | DPUTM_KK | Allow NULL? |
| 24 | C4EYE | Check Reason for Workflows Acc. to Dual Control Principle | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | C4EYE_KK | Allow NULL? |
| 25 | C4EYP | Editing Process To Be Confirmed | char | 1 | 0 | CHAR | (N' ') | Yes | | C4EYP_KK | Allow NULL? |
| 26 | SUBAP | Subapplication in Contract Accounts Receivable and Payable | char | 1 | 0 | CHAR | (N' ') | Yes | | SUBAP_KK | Allow NULL? |
| 27 | ANZINTRT | Number of Additional Interest Installments | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ANZINTRT | Allow NULL? |
| 28 | STTIN | Start date of interest calc. on installment plan (and loans) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STDTINT_KK | Allow NULL? |
| 29 | INVIP | Installment Plan Status: Installment Plan from Invoicing | char | 1 | 0 | CHAR | (N' ') | Yes | | INVIP_KK | Allow NULL? |
