| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ACTIVE | Table entry is active (A) or in suspense (S) | char | 1 | 0 | | | | Allow NULL? |
| 3 | CLAIM | Number of Claim | nvarchar | 17 | 0 | | | | Allow NULL? |
| 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | ITEM | Claim Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | EVALUATION | Claim Item Evaluation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | | | | |
| 8 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | | | | Allow NULL? |
| 10 | EVALCAT | Evaluation Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | EVAMOUNT | Evaluated Amount | decimal | 15 | 2 | | | | |
| 12 | EVCURR | Currency of Evaluated Amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | GROSNET | Flag: Amount Is Net Amount | char | 1 | 0 | | | | Allow NULL? |
| 14 | TXCOD | Tax Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | EVDATE | Valuation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | LIABRATE | Liability Rate in Percent | decimal | 5 | 2 | | | | |
| 17 | EVALBASE | Type of Evaluator | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | CLMDAMOUNT | Amount Requested | decimal | 15 | 2 | | | | |
| 19 | EVAMTPERUNIT | Amount per Unit | decimal | 15 | 2 | | | | |
| 20 | EVQUANTITY | Claim Item: Number (Days, Visits, Area) for Evaluation | decimal | 10 | 3 | | | | |
| 21 | EVQUANUNIT | Claim Item: Unit of Measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | XARCHDOC | Archived Document Assigned? | char | 1 | 0 | | | | Allow NULL? |
| 23 | FACTOR | Factor | decimal | 7 | 4 | | | | |
| 24 | DNUMBER | Number of Days | decimal | 5 | 0 | | | | |
| 25 | STARTDATE | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | ENDDATE | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | PERDAY | Amount per Day | decimal | 15 | 2 | | | | |
| 28 | OC | Original Value | decimal | 15 | 2 | | | | |
| 29 | RC | Original Cash Value | decimal | 15 | 2 | | | | |
| 30 | ACV | Actual Cash Value | decimal | 15 | 2 | | | | |
| 31 | INUMBER | Number | decimal | 5 | 0 | | | | |
| 32 | AGE | Age of Item in Years | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | ACVPERCENT | Proportion of Actual Cash Value to Original Cash Value in % | decimal | 5 | 2 | | | | |
| 34 | RCORACV | Flag: Use Actual Cash Value or Original Cash Value | char | 1 | 0 | | | | Allow NULL? |
| 35 | CATALOGID | Catalog ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 36 | CATALOGITEM | Catalog Item Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 37 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 38 | MATGROUP | EBP: Material Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | PRICE_UNIT | Price Unit | decimal | 5 | 0 | | | | |
| 40 | VENDOR_CATALOG | Supplier | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | VENDORMAT | Product Number of Vendor | nvarchar | 22 | 0 | | | | Allow NULL? |
| 42 | MANUFACTCODE | EBP: Manufacturer Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | MANUFACTMAT | EBP: Part Number of Manufacturer | nvarchar | 40 | 0 | | | | Allow NULL? |
| 44 | SERVICE | EBP: Service Flag | char | 1 | 0 | | | | Allow NULL? |
| 45 | CUST_FIELD1 | BBP: Catalog - Customer Field 1 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 46 | CUST_FIELD2 | BBP: Catalog - Customer Field 2 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 47 | CUST_FIELD3 | BBP: Catalog - Customer Field 3 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 48 | CUST_FIELD4 | BBP: Catalog - Customer Field 4 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 49 | CUST_FIELD5 | BBP: Catalog - Customer Field 5 | nvarchar | 50 | 0 | | | | Allow NULL? |
| 50 | PROCUREMENT | ID of Claim Item Grouping | nvarchar | 4 | 0 | | | | Allow NULL? |
