| 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 | EXBEL | Official Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | EXBEL_KK | Allow NULL? |
| 5 | CANCEL | Status of Official Document Number | char | 1 | 0 | CHAR | (N' ') | Yes | | EXSTA_KK | Allow NULL? |
| 6 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 7 | BRANCH | Branch | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BRANCH_KK | Allow NULL? |
| 8 | ATTRIBUTE1 | Attribute For Official Document Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE_KK | Allow NULL? |
| 9 | ATTRIBUTE2 | Attribute For Official Document Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE_KK | Allow NULL? |
| 10 | ATTRIBUTE3 | Attribute For Official Document Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE_KK | Allow NULL? |
| 11 | ATTRIBUTE4 | Attribute For Official Document Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE20_KK | Allow NULL? |
| 12 | ATTRIBUTE5 | Attribute For Official Document Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE20_KK | Allow NULL? |
| 13 | OBJECT | Name of number range object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | NROBJ | Allow NULL? |
| 14 | SUBOBJECT | Number range object subobject value | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | NRSOBJ | Allow NULL? |
| 15 | NRRANGENR | Number range number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NRNR | Allow NULL? |
| 16 | TOYEAR | To fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | NRYEAR | Allow NULL? |
| 17 | DOCCLS | Document Class for Official Document Numbers | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DOCCLS_KK | Allow NULL? |
| 18 | PT_DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 19 | PT_SYS_DATE | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CPUDT | Allow NULL? |
| 20 | PT_SYS_TIME | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
| 21 | PT_TOTAL_AMOUNT | Digital Signature PT: Total Amount in Local Currency | decimal | 13 | 2 | DEC | ((0)) | Yes | | IDPT_DS_AMOUNT_LC | |
