| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | POLPROD | Policy Product | nvarchar | 6 | 0 | | | | Allow NULL? |
| 3 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | VERSION | Policy Product Version | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | ACTIVE | Status | char | 1 | 0 | | | | Allow NULL? |
| 6 | CHANGEDBY | Version Created By (= Object Changed By) | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | CHANGETIME | Version Created: Date + Time | decimal | 15 | 0 | | | | |
| 8 | INACTIVETIME | Version Deactivated: Date + Time | decimal | 15 | 0 | | | | |
| 9 | EFFFROMTIME | Version Valid From: Date + Time | decimal | 15 | 0 | | | | |
| 10 | EFFTOTIME | Version Valid To: Date + Time | decimal | 15 | 0 | | | | |
| 11 | TERMTIME | Valid-To Date Set: Date + Time | decimal | 15 | 0 | | | | |
| 12 | DELETED | Flag: Deletion Entry? | char | 1 | 0 | | | | Allow NULL? |
| 13 | OVERSION | Version in Original System | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | OSYSID | Original System of Version | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | OMANDT | Client in Original System | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | BVERSION | Basis Version | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | VERSION_REF | Reference Version | nvarchar | 32 | 0 | | | | Allow NULL? |
| 18 | PLINEOFBUS | Insurance Line of Business | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | COMPANYCODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | CURR | Currency for All reserves, Limits and Deductibles | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | CDSPEC | Specification for FS-CD Posting | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | XADDRDET | Additional Address Fields Displayed | char | 1 | 0 | | | | Allow NULL? |
| 23 | CDUSAGE | Integration with Collections/Disbursements | char | 1 | 0 | | | | Allow NULL? |
| 24 | BENTREE | Benefit Type Tree at Policy Product Level | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | PPOLPROD | Higher-Level Policy Product (Not Supported) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | MULT_INS_RISKS_FLAG | Use Multiple Insured Objects | char | 1 | 0 | | | | Allow NULL? |
