| 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 | CALCGUID | GUID (RAW16) for Calculations | varbinary | 16 | 0 | RAW | | No | VICDCOND | RECDCALCGUID | |
| 3 | CONDGUID | GUID (RAW16) for Conditions | varbinary | 16 | 0 | RAW | | Yes | VICDCOND | RECDCONDGUID | |
| 4 | INTRENO | Internal Key of Real Estate Object | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | RECAINTRENO | Allow NULL? |
| 5 | OBJNR | Object Number for Calculation | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RECDOBJNRCALC | Allow NULL? |
| 6 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVCDCONDTYPE | RECDCONDTYPE | Allow NULL? |
| 7 | CONDVALIDFROM | Date from when condition is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECDVALIDFROM | Allow NULL? |
| 8 | VALUEVALIDFROM | Date from when condition is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECDVALIDFROM | Allow NULL? |
| 9 | VALUEVALIDTO | Date up to when condition is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECDVALIDTO | Allow NULL? |
| 10 | CALCVALUE | Currency-Dependent Calculation Factor | decimal | 15 | 6 | DEC | ((0)) | Yes | | RECDCALCVALUE | |
| 11 | CONDVALUE | Condition item currency amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | RECDCONDVALUE | |
| 12 | TAXVALUE | Tax on Sales/Purchase of Condition Item | decimal | 15 | 2 | CURR | ((0)) | Yes | | RECDTAXVALUE | |
| 13 | CONDVALUENET | Currency Amount (Net) of Condition Item | decimal | 15 | 2 | CURR | ((0)) | Yes | | RECDCONDVALUENET | |
| 14 | CONDVALUEGROSS | Currency Amount (Gross) of Condition Item | decimal | 15 | 2 | CURR | ((0)) | Yes | | RECDCONDVALUEGROSS | |
| 15 | CONDCURR | Currency of condition item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RECDCONDCURR | Allow NULL? |
| 16 | CALCNUMBER | Sequence Number of Calculation | smallint | 5 | 0 | INT2 | ((0)) | Yes | | RECDCALCNUMBER | |
| 17 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 18 | PARTNEROBJNR | Object Number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RECAOBJNR | Allow NULL? |
| 19 | DUEDATE | Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECDDUEDATE | Allow NULL? |
