| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GSFNR | Business Transaction Number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 3 | BELNR | Transfer Document Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | LFDNB | Seq. Number - Single Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 6 | BUGRD | Posting Reason | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | OPHVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | OPTVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | FAEDS | Due Date for Cash Discount | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | FOKNZ | Subledger Item Indicator | char | 1 | 0 | | | | Allow NULL? |
| 14 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | LNDSL | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | PRGRP | Product Group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | VKONT | Contract Account | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | GPART | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | EMGPA | Alternative Business Partner for Payments | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | EMADE | Address number in external system | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | EMADR | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | SPZAH | Lock Reason for Automatic Payment | char | 1 | 0 | | | | Allow NULL? |
| 25 | SPZFD | Payment Lock Valid from | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | SPZTD | Payment lock valid to | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | PYMET | Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 28 | PYGRP | Grouping field for automatic payments | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | INDYN | Key for Index/Dynamic Basis of an Insurance Contract | nvarchar | 5 | 0 | | | | Allow NULL? |
| 30 | INFAK | Index Value or Dynamic Factor-Insurance Contracts to Adjust | decimal | 8 | 3 | | | | |
| 31 | RBART | Legal Relationship Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | RBZNR | Number of Legal Relationship | nvarchar | 17 | 0 | | | | Allow NULL? |
| 33 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | | | | Allow NULL? |
| 34 | ABWRA | Alt. Legal Relationship Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | ABWRN | Alternative Classification Key | nvarchar | 17 | 0 | | | | Allow NULL? |
| 36 | VTRE2 | Additional Reference Information | nvarchar | 20 | 0 | | | | Allow NULL? |
| 37 | VGPART2 | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 38 | ERGRA | Supplementary Legal Relationship Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | ERGRN | Supplementary Classification Key | nvarchar | 17 | 0 | | | | Allow NULL? |
| 40 | VTRE3 | Supplementary contract number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 41 | VGPART3 | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | STAKZ | Type of statistical item | char | 1 | 0 | | | | Allow NULL? |
| 43 | SKTPZ | Cash discount rate | decimal | 5 | 3 | | | | |
| 44 | STPRZ | Insurance tax percentage | decimal | 5 | 2 | | | | |
| 45 | GRKEY | Grouping Key for Displaying Open Items | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | VERKZ | Item Can Only Be Cleared | char | 1 | 0 | | | | Allow NULL? |
| 47 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 48 | VSARL_VX | Insurance Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 49 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 50 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 51 | ERKRS | Operating concern | nvarchar | 4 | 0 | | | | Allow NULL? |
| 52 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 53 | HKONT | General ledger account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | GHKONT | G/L Account (for Business Partner Item) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 55 | ADKNZ | Additional Acct Assignments in BP Items as Well | char | 1 | 0 | | | | Allow NULL? |
| 56 | OPTXT | Item text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 57 | LNDSL_VX | Country Where Risk Is Situated | nvarchar | 3 | 0 | | | | Allow NULL? |
| 58 | GSART_VX | Business Transaction Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 59 | BSART_VX | In-Force Business Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 60 | GZART_VX | Underwriting Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 61 | SDART_VX | Type of Loss | nvarchar | 2 | 0 | | | | Allow NULL? |
| 62 | SJAHR_VX | Year of loss | nvarchar | 4 | 0 | | | | Allow NULL? |
| 63 | MJAHR_VX | Reporting Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 64 | RSART_VX | Risk type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 65 | FUBER_VX | Insurance Functional Area | nvarchar | 3 | 0 | | | | Allow NULL? |
| 66 | BEBER_VX | Organizational area - insurance | nvarchar | 3 | 0 | | | | Allow NULL? |
| 67 | BSGRP_VX | In-Force Business Group for Pension Funds and Life Insurance | nvarchar | 3 | 0 | | | | Allow NULL? |
| 68 | KONTT | Account Assignment Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 69 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | | | Allow NULL? |
| 70 | FDGRP | Planning Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 71 | FDZTG | Additional Days for Cash Management | nvarchar | 2 | 0 | | | | Allow NULL? |
