| 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 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | OPBEL_KK | Allow NULL? |
| 3 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPW_KK | Allow NULL? |
| 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OPUPK_KK | Allow NULL? |
| 5 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPZ_KK | Allow NULL? |
| 6 | CREATETIME | Created: UTC Date+Time | decimal | 15 | 0 | DEC | ((0)) | No | | CREATETIME_KK | |
| 7 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 8 | AUGST | Clearing status | char | 1 | 0 | CHAR | (N' ') | Yes | | AUGST_KK | Allow NULL? |
| 9 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 10 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 11 | REFCLAIM | Reference to Payment in Claims Management System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | REFCLAIM_VK | Allow NULL? |
| 12 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONT_KK | Allow NULL? |
| 13 | APPLK | Application area | char | 1 | 0 | CHAR | (N' ') | Yes | | APPLK_KK | Allow NULL? |
| 14 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HVORG_KK | Allow NULL? |
| 15 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TVORG_KK | Allow NULL? |
| 16 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART_KK | Allow NULL? |
| 17 | XANZA | Item is a Down Payment/Down Payment Request | char | 1 | 0 | CHAR | (N' ') | Yes | | XANZA_KK | Allow NULL? |
| 18 | OPTXT | Item text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | OPTXT_KK | Allow NULL? |
| 19 | WAERS | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BLWAE_KK | Allow NULL? |
| 20 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 21 | KURSF | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSF_KK | |
| 22 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRW_KK | |
| 23 | AUGDT | Clearing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGDT_KK | Allow NULL? |
| 24 | AUGBL | Clearing Document or Printed Document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AUGBL_KK | Allow NULL? |
| 25 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | AUGRD_KK | Allow NULL? |
| 26 | AUGWA | Clearing currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | AUGWA_KK | Allow NULL? |
| 27 | AUGBT | Clearing amount in clearing currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGBT_KK | |
| 28 | XTAUS | Item Split | char | 1 | 0 | CHAR | (N' ') | Yes | | XTAUS_KK | Allow NULL? |
| 29 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BLART_KK | Allow NULL? |
| 30 | AUGBW | Clearing Amount in Transaction Currency (With +/- Sign) | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGBW_KK | |
| 31 | AUGBH | Clearing amount in local currency with +/- sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGBH_KK | |
| 32 | AUGBO | Clearing Amount in Open Item Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGBO_KK | |
| 33 | ORIWA | Document currency of open item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | ORIWA_KK | Allow NULL? |
| 34 | AUG_VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 35 | AUG_REFCLAIM | Reference to Payment in Claims Management System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | REFCLAIM_VK | Allow NULL? |
