| 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 | GUID | GUID in 'RAW' format | varbinary | 16 | 0 | RAW | | No | | GUID_16 | |
| 3 | DVALID_FROM | Start of Term for Insurance Premium | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | TB_INS_ITEM_VALID_FROM | Allow NULL? |
| 4 | DVALID_TO | End of Term for Insurance Premium | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_INS_ITEM_VALID_TO | Allow NULL? |
| 5 | PAYER | Payer of Insurance Premium | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | TB_INS_PAYER | Allow NULL? |
| 6 | PAYMENT_METHOD | Payment Method for Insurance | char | 1 | 0 | CHAR | (N' ') | Yes | * | TB_INS_PAYMENT_METHOD | Allow NULL? |
| 7 | BANKID | Bank Details ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TB_BVTYP | Allow NULL? |
| 8 | XACCRUAL_METHOD | Calculation Method for Insurance | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_INS_ACCRUAL_METHOD | Allow NULL? |
| 9 | PACCRUAL_FACTOR | Percentage Rate for Insurance Calculation | decimal | 10 | 7 | DEC | ((0)) | Yes | | TB_INS_ACCRUAL_FACTOR | |
| 10 | APAY_FREQUENCY | Frequency in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AMMRHY | Allow NULL? |
| 11 | DNEXT_PAY_DATE | Next Payment Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_INS_PAYMENT_DATE | Allow NULL? |
| 12 | BNEXT_PAY_AMOUNT | Next Insurance Premium | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_INS_PAYMENT_AMOUNT | |
| 13 | WCURR_AMOUNT | Insurance Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TB_INS_CURR_PAYMENT_AMOUNT | Allow NULL? |
| 14 | DSTATEMENT_DATE | Date of Next Bill | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_INS_STATEMENT_DATE | Allow NULL? |
| 15 | DLAST_STATEMENT | Date of Last Bill | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_INS_LAST_STATEMENT_DATE | Allow NULL? |
| 16 | RERF | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RERF | Allow NULL? |
| 17 | TZERF | | decimal | 15 | 0 | | ((0)) | Yes | | | |
| 18 | REHER | Source of initial entry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REHER | Allow NULL? |
| 19 | RBEAR | Employee ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RBEAR | Allow NULL? |
| 20 | TZBEAR | | decimal | 15 | 0 | | ((0)) | Yes | | | |
| 21 | RBHER | Editing Source | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RBHER | Allow NULL? |
| 22 | IFLG_CHANGED | Data Changed in Customer APPEND | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_INS_FLG_CUSTOM_CHANGED | Allow NULL? |
