| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | /GSINS/UPR_RETRN | Relevance for Accounting | char | 1 | 0 | CHAR | (N' ') | No | | /GSINS/UPR_RETRN | Allow NULL? |
| 4 | PDATE | Transfer Posting Date for Delayed Revenues | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATE_KK | Allow NULL? |
| 5 | /GSINS/UPR_METH | ID of Calculation Method | char | 1 | 0 | CHAR | (N' ') | No | /GSINS/UPR_FCALC | /GSINS/UPR_METH | Allow NULL? |
| 6 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | OPBEL_KK | Allow NULL? |
| 7 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OPUPK_KK | Allow NULL? |
| 8 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPZ_KK | Allow NULL? |
| 9 | HKONT | General ledger account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT_KK | Allow NULL? |
| 10 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 11 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HVORG_KK | Allow NULL? |
| 12 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TVORG_KK | Allow NULL? |
| 13 | KONTT | Account Assignment Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KONTT_KK | Allow NULL? |
| 14 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | KONTL_KK | Allow NULL? |
| 15 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 16 | DATUM | Date of Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /GSINS/UPR_DDATE | Allow NULL? |
| 17 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_KK | Allow NULL? |
| 18 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OPUPW_KK | Allow NULL? |
