| 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 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | BUT000 | GPART_KK | Allow NULL? |
| 3 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | OPBEL_KK | Allow NULL? |
| 4 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPW_KK | Allow NULL? |
| 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OPUPK_KK | Allow NULL? |
| 6 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPZ_KK | Allow NULL? |
| 7 | CREATETIME | Created: UTC Date+Time | decimal | 15 | 0 | DEC | ((0)) | No | | CREATETIME_KK | |
| 8 | QSSEW | Withholding Tax Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | QSSEW_KK | Allow NULL? |
| 9 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 10 | AUGBL | Clearing Document or Printed Document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AUGBL_KK | Allow NULL? |
| 11 | AUGBD | Clearing document posting date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGBD_KK | Allow NULL? |
| 12 | NAUGH | Net clearing amount in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | NAUGH_KK | |
| 13 | AQSBH | Proportional Withholding Tax Amount In Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | AQSBH_KK | |
| 14 | QSSKZ | Withholding Tax Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T059Q | QSSKZ | Allow NULL? |
| 15 | STPRZ | Tax rate | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | STPRZ_KK | Allow NULL? |
| 16 | XNGPZ | Percentage Rate Is Negative | char | 1 | 0 | CHAR | (N' ') | Yes | | XNGPZ_KK | Allow NULL? |
| 17 | SBASH | Amount Subject to Tax in Local Currency (Tax Base Amount) | decimal | 13 | 2 | CURR | ((0)) | Yes | | SBASH_KK | |
| 18 | EMADR | Address number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AD_ADDRNUM | Allow NULL? |
| 19 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFKHVO | HVORG_KK | Allow NULL? |
| 20 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFKTVO | TVORG_KK | Allow NULL? |
| 21 | REPDT | Reporting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REPDT_KK | Allow NULL? |
