| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | EINRI | Institution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | LFDNR | Sequence Number of Fee-Based Service | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | ARZT | IS-H: Person Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | HONART | Fee Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | HONUGR | Fee Subgroup | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | ROLLE | IS-H: Function of Business Partner in Rel. to Service | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | BETRAG | Amount | decimal | 15 | 2 | | | | |
| 11 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | STATUS | Status of Fee-Based Service | char | 1 | 0 | | | | Allow NULL? |
| 13 | AUFTCDE | Fee Breakdown Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | FGUSR | Name of User Who Released Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | UEBDAT | Transfer Date for Fee-Based Service | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | BEMERK | Comments (Abridged) | nvarchar | 50 | 0 | | | | Allow NULL? |
| 21 | RECHNR | Billing Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | KOSTL | IS-H: Cost Center Assigned to Organizational Unit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | ERBDAT | IS-H: Date when Service Performance Ends (Actual) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | SPERRE | Block Indicator for Fee-Based Service | char | 1 | 0 | | | | Allow NULL? |
| 25 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | VERRKTO | General Ledger Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | FALAI | IS-H: Case Type - User-Specific | char | 1 | 0 | | | | Allow NULL? |
| 28 | CLASS | Class for Fee | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | LIMIT | Limit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | ABSCHR | Indicator for Depreciation | char | 1 | 0 | | | | Allow NULL? |
| 31 | ABDAT | Depreciation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | ABUSR | User Who Performed Depreciation | nvarchar | 12 | 0 | | | | Allow NULL? |
| 33 | UBLDAT | Date Fee-Based Service Transferred to FI | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | UBLUSR | User Who Performed Transfer to FI | nvarchar | 12 | 0 | | | | Allow NULL? |
