| 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 | RECORDMODE | BW Delta Procedure: Update Mode | char | 1 | 0 | CHAR | (N' ') | Yes | | BWUPDMOD_KK | Allow NULL? |
| 4 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 5 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONT_KK | Allow NULL? |
| 6 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_KK | Allow NULL? |
| 7 | STTDT | Start date of installment plan | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STARDAT_KK | Allow NULL? |
| 8 | ENDDT | Installment plan end date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDEDAT_KK | Allow NULL? |
| 9 | RPCAT | Installment plan category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RPCAT_KK | Allow NULL? |
| 10 | DEADT | Deactivation Date Of Installment Plan | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DEADT_KK | Allow NULL? |
| 11 | DEOFF | Open amount at time of deactivation | decimal | 13 | 2 | CURR | ((0)) | Yes | | DEOFF_KK | |
| 12 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS_KK | Allow NULL? |
| 13 | COMPA | Total of individual installments for installment plan | decimal | 13 | 2 | CURR | ((0)) | Yes | | COMPA_KK | |
| 14 | INTBETG | Total Interest Amt of Instmnt Plan (PlanInst+LatePymtCharge | decimal | 13 | 2 | CURR | ((0)) | Yes | | IBTGG_KK | |
