| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | INV_EXTID | External ID of Document or Line Item | nvarchar | 22 | 0 | | | | Allow NULL? |
| 3 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 4 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | | | Allow NULL? |
| 5 | INT_INV_LINE_NO | Line Item Number of Bill/Payment Advice Note Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | nvarchar | 35 | 0 | | | | Allow NULL? |
| 7 | MC_NAME2 | Search Help Field 2 (Name 2/First Name) | nvarchar | 35 | 0 | | | | Allow NULL? |
| 8 | MC_STREET | Street name in upper case for search help | nvarchar | 25 | 0 | | | | Allow NULL? |
| 9 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | | | Allow NULL? |
| 10 | MC_POSTCODE | City postal code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | EXT_IDENT_TYPE | External Identification Type (for Example PoD) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | EXT_IDENT | External Identification of Document (e.g. Point of Delivery) | nvarchar | 50 | 0 | | | | Allow NULL? |
| 13 | MC_HOUSE_NUM1 | House Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | MC_HOUSE_NUM2 | House number supplement | nvarchar | 10 | 0 | | | | Allow NULL? |
