| 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 | EXKEY | Official Document Number Key | nvarchar | 40 | 0 | CHAR | (N' ') | No | | EXKEY_KK | Allow NULL? |
| 3 | EXKID | Key Identification | nvarchar | 2 | 0 | CHAR | (N' ') | No | | EXKID_KK | Allow NULL? |
| 4 | EXBELX | Official Document Number for Digital Signatures | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | EXBELX_KK | Allow NULL? |
| 5 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 6 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 7 | OBJECT | Name of number range object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | NROBJ | Allow NULL? |
| 8 | SUBOBJECT | Number range object subobject value | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | NRSOBJ | Allow NULL? |
| 9 | NRRANGENR | Number range number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NRNR | Allow NULL? |
| 10 | TOYEAR | To fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | NRYEAR | Allow NULL? |
| 11 | ENC_STRING | Encrypted Character String | ntext | 1073741823 | 0 | | | Yes | | ENCCHAR_ST_KK | |
| 12 | ENC_XSTRING | Encrypted Byte Chain | image | 2147483647 | 0 | | | Yes | | ENCBYTE_ST_KK | |
| 13 | ENC_ATTR1 | Attribute for Digital Signature | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE40_KK | Allow NULL? |
| 14 | ENC_ATTR2 | Attribute for Digital Signature | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE40_KK | Allow NULL? |
| 15 | ENC_ATTR3 | Attribute for Digital Signature | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE40_KK | Allow NULL? |
| 16 | ENC_ATTR4 | Attribute for Digital Signature | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE40_KK | Allow NULL? |
| 17 | ENC_ATTR5 | Attribute for Digital Signature | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE40_KK | Allow NULL? |
| 18 | SDATAX | Additional Data for Digital Signature | ntext | 1073741823 | 0 | | | Yes | | SDATAX_KK | |
| 19 | ENCREQ | Encryption Required | char | 1 | 0 | CHAR | (N' ') | Yes | | ENCREQ_KK | Allow NULL? |
| 20 | ENCCRE | Encryption Performed | char | 1 | 0 | CHAR | (N' ') | Yes | | ENCCRE_KK | Allow NULL? |
| 21 | ENC_USER | Encryption by User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ENCUSNAM_KK | Allow NULL? |
| 22 | ENC_DATE | Encryption Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENCDATE_KK | Allow NULL? |
| 23 | ENC_TIME | Encryption Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ENCTIME_KK | Allow NULL? |
| 24 | ENCBATCH | Encryption Changed in Batch Process | char | 1 | 0 | CHAR | (N' ') | Yes | | ENCBATCH_KK | Allow NULL? |
| 25 | CHANGE_USER | Encryption by User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ENCUSNAM_KK | Allow NULL? |
| 26 | CHANGE_DATE | Encryption Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENCDATE_KK | Allow NULL? |
| 27 | CHANGE_TIME | Encryption Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ENCTIME_KK | Allow NULL? |
| 28 | PT_DS_PRTPAT_PRE | Digital Signature PT: Print Pattern of Previous Document | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | IDPT_DS_PREVPRINT_CHAR | Allow NULL? |
| 29 | PT_INV_DATE | Digital Signature PT: Invoice/Billing/Document Date | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | IDPT_DS_INV_DATE | Allow NULL? |
| 30 | PT_INV_NO | Digital Signature PT: Complete ODN of Document to be Signed | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | IDPT_DS_INVOICE_NUM | Allow NULL? |
| 31 | PT_INV_CRESYS | Digital Signature PT: System Entry Date and Time | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | IDPT_DS_SY_DATE | Allow NULL? |
| 32 | PT_INV_TOTAL | Digital Signature PT: Gross Amount | nvarchar | 23 | 0 | CHAR | (N' ') | Yes | | IDPT_DS_GROSS_TOTAL | Allow NULL? |
| 33 | PT_DS_PRTPAT | Digital Signature PT: Print Pattern of Current Document | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | IDPT_DS_PRINT_CHAR | Allow NULL? |
