| 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 | * | MANDT | Allow NULL? |
| 2 | REG_ID | Registration Number for incoming document handler | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | | /OPT/CIDH_REGID_DE | Allow NULL? |
| 3 | ARCHIV_ID | Content Repository Identification | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SAEARCHIVI | Allow NULL? |
| 4 | ARC_DOC_ID | SAP ArchiveLink: Document ID | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /OPT/SAEARDOID | Allow NULL? |
| 5 | AR_OBJECT | Archive Document Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /OPT/SAEOBJART_DE | Allow NULL? |
| 6 | ARCHIVE_DATE | Document Archive Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /OPT/ARDATE | Allow NULL? |
| 7 | ARCHIVE_TIME | Document Archive Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /OPT/ARTIME | Allow NULL? |
| 8 | ARCHIVE_USER | Document Archive User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /OPT/ARUSER | Allow NULL? |
| 9 | STATUS | Document Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | /OPT/DOCSTATUS | Allow NULL? |
| 10 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 11 | RMWWR | Gross invoice amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | RMWWR | |
| 12 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 13 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 14 | VEND_NAME | Name 1 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME1_GP | Allow NULL? |
| 15 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 16 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR | Allow NULL? |
| 17 | DOCTYPE | Document Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /OPT/DOCTYPE | Allow NULL? |
| 18 | REF_DOC_ID | Document Ledger Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | /OPT/DOCID | Allow NULL? |
| 19 | CHANNEL_ID | Channel ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /OPT/CHANNEL_ID | Allow NULL? |
| 20 | CHANGE_DATE | Document Change Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /OPT/DOCCHDATE | Allow NULL? |
| 21 | CHANGE_TIME | Document Change Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /OPT/DOCCHTIME | Allow NULL? |
| 22 | CHANGE_USER | Document Data Change User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /OPT/DOCCHUSER | Allow NULL? |
| 23 | PROCESSING_FLAG | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 24 | ERROR_FLAG | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 25 | PROCESS_ID | Process ID of incoming document processing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /OPT/CIDH_PROCESSID_DE | Allow NULL? |
| 26 | EXT_PROFILE | External profile that triggers incoming channel | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | /OPT/CIDH_EXTPROFILE_DE | Allow NULL? |
| 27 | IMP_PROFILE | External profile that triggers incoming channel | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | /OPT/CIDH_EXTPROFILE_DE | Allow NULL? |
| 28 | INDEX_DATE | Document Create Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /OPT/DOCCRDATE | Allow NULL? |
| 29 | INDEX_TIME | Document Create Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /OPT/DOCCRTIME | Allow NULL? |
| 30 | INDEX_USER | User Responsible for Document Creation | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /OPT/DOCCRUSER | Allow NULL? |
| 31 | END_FLAG | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 32 | TIMEOUT | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 33 | BARCODE | Bar code | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | BARCODE | Allow NULL? |
| 34 | WINDOWS_ID | Windows Id | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | /OPT/WINID | Allow NULL? |
| 35 | SAP_OBJECT | SAP ArchiveLink: Object type of business object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAEANWDID | Allow NULL? |
| 36 | ATTACHMENT_FLAG | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 37 | ERRORS_FOUND | Error flag | char | 1 | 0 | CHAR | (N' ') | Yes | | ERRORS_FOUND | Allow NULL? |
| 38 | SCAN_DATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 39 | SCAN_TIME | System Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SYUZEIT | Allow NULL? |
| 40 | SCAN_LOC | Scan Location | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | * | /OPT/VIM_BL_SLOC | Allow NULL? |
| 41 | BATCHNUMBER | Batch Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /OPT/VIM_BL_BN | Allow NULL? |
| 42 | VAT_AMOUNT | Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | /OPT/RMWWR | |
| 43 | TAX_CODE | Tax Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | /OPT/VIM_TAX_CODE | Allow NULL? |
