| 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 | DOCNUM | SMI document number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | /PTGWFI/F_DOCNUM | Allow NULL? |
| 3 | ARCHIV_ID | Content Repository Identification | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TOAAR | SAEARCHIVI | Allow NULL? |
| 4 | IMAGE_ID | SAP ArchiveLink: Document ID | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SAEARDOID | Allow NULL? |
| 5 | IMAGE_DOC_TYPE | Document type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TOADV | SAEOBJART | Allow NULL? |
| 6 | OBJTYPE | SAP ArchiveLink: Object type of business object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAEANWDID | Allow NULL? |
| 7 | OBJECTID | SAP ArchiveLink: Object ID (object identifier) | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SAEOBJID | Allow NULL? |
| 8 | SREASON | Suspend Reason | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | /PTGWFI/F_SMIRSN | /PTGWFI/F_SMRSN | Allow NULL? |
| 9 | LST_AGENT | Responsible Party | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | /PTGWFI/RSP | Allow NULL? |
| 10 | LST_USER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 11 | TO_AGENT | Responsible Party | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | /PTGWFI/RSP | Allow NULL? |
| 12 | L_OPTYP | Option Type | char | 1 | 0 | CHAR | (N' ') | Yes | /PTGWFI/F_POT | /PTGWFI/OPTYP | Allow NULL? |
| 13 | L_OPNUM | Option ID | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | /PTGWFI/F_POT | /PTGWFI/OPNUM | Allow NULL? |
| 14 | L_OPST | Option Status | char | 1 | 0 | CHAR | (N' ') | Yes | | /PTGWFI/OPST | Allow NULL? |
| 15 | UPDDT | Creation Date of Work Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SWW_CD | Allow NULL? |
| 16 | UPDTM | Creation Time of Work Item | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SWW_CT | Allow NULL? |
| 17 | ZSMIST | SMI Status | char | 1 | 0 | CHAR | (N' ') | Yes | | /PTGWFI/SMIST | Allow NULL? |
| 18 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 19 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 20 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 21 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EKORG | Allow NULL? |
| 22 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 23 | AMOUNT | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 24 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 25 | INVOICENO | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR | Allow NULL? |
| 26 | INVOICEDATE | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 27 | PONUMBER | Purchase Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EKKO | BSTNR | Allow NULL? |
| 28 | DOCUMENTTYPE | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BLART | Allow NULL? |
| 29 | VENDOR_NAME | Name 1 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME1_GP | Allow NULL? |
