| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DOCNUM | SMI document number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | ARCHIV_ID | Content Repository Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | IMAGE_ID | SAP ArchiveLink: Document ID | nvarchar | 40 | 0 | | | | Allow NULL? |
| 5 | IMAGE_DOC_TYPE | Document type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | OBJTYPE | SAP ArchiveLink: Object type of business object | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | OBJECTID | SAP ArchiveLink: Object ID (object identifier) | nvarchar | 50 | 0 | | | | Allow NULL? |
| 8 | SREASON | Suspend Reason | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | LST_AGENT | Responsible Party | nvarchar | 15 | 0 | | | | Allow NULL? |
| 10 | LST_USER | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | TO_AGENT | Responsible Party | nvarchar | 15 | 0 | | | | Allow NULL? |
| 12 | L_OPTYP | Option Type | char | 1 | 0 | | | | Allow NULL? |
| 13 | L_OPNUM | Option ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | L_OPST | Option Status | char | 1 | 0 | | | | Allow NULL? |
| 15 | UPDDT | Creation Date of Work Item | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | UPDTM | Creation Time of Work Item | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | ZSMIST | SMI Status | char | 1 | 0 | | | | Allow NULL? |
| 18 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | AMOUNT | Amount in document currency | decimal | 13 | 2 | | | | |
| 24 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | INVOICENO | Reference Document Number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 26 | INVOICEDATE | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | PONUMBER | Purchase Order Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | DOCUMENTTYPE | Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | VENDOR_NAME | Name 1 | nvarchar | 35 | 0 | | | | Allow NULL? |
