| 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 | VBELN | Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | VBELN_VF | Allow NULL? |
| 3 | POSNR | Billing item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | VBUP | POSNR_VF | Allow NULL? |
| 4 | ZAEHK | Condition counter | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DZAEHK | Allow NULL? |
| 5 | KSCHL | Condition type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T685A | KSCHA | Allow NULL? |
| 6 | LFDKONV | IS-H: Sequential number of a partial payment | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | LFDKONV | Allow NULL? |
| 7 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TN01 | EINRI | Allow NULL? |
| 8 | KOTYP | IS-H: Usage of Condition Type in Billing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | AB_KOTYP | Allow NULL? |
| 9 | KWERT | Condition value | decimal | 13 | 2 | CURR | ((0)) | Yes | | KWERT | |
| 10 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 11 | KAPPL | Application | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T681A | KAPPL | Allow NULL? |
| 12 | ORGID | ID of Billing Organizational Unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ABROEF | Allow NULL? |
| 13 | GESBTR | IS-H: Total amount of an invoice | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_GESBTR | |
| 14 | TBTRAG | IS-H: Partial Payment Amount of an Invoice | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_TBTRAG | |
| 15 | TZDAT | IS-H: Date of Partial Payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_TZDAT | Allow NULL? |
| 16 | TZBEL | IS-H: Document for partial payment for an invoice | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_TZBEL | Allow NULL? |
| 17 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 18 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 19 | SFAKN | Cancelled billing document number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | SFAKN | Allow NULL? |
