...
Name | Type | Mandatory | Default | Explanation | |
---|---|---|---|---|---|
ClaimItemID | int (PK) | YES | |||
ClaimID | int | YES | FK tblClaim | ||
ItemID | int | YES | FK tblItems | ||
ProdID | int | NO | FK tblProduct | ||
ClaimItemStatus | tinyint | YES | 1 | ||
Availability | bit | YES | 1 | FK tblFamilyTypes | |
QtyProvided | decimal(18, 2) | YES | |||
QtyApproved | decimal(18, 2) | NO | |||
PriceAsked | decimal(18, 2) | YES | |||
PriceAdjusted | decimal(18, 2) | NO | |||
PriceApproved | decimal(18, 2) | NO | |||
PriceValuated | decimal(18, 2) | NO | |||
Explanation | ntext | NO | |||
Justification | ntext | NO | |||
RejectionReason | smallint | NO | 0 | ||
ValidityFromReview | datetime | NO | |||
ValidityToReview | datetime | NO | |||
AuditUserIDReview | int | NO | |||
LimitationValue | decimal(18, 2) | NO | |||
Limitation | char(1) | NO | |||
PolicyID | int | NO | |||
RemuneratedAmount | decimal(18, 2) | NO | |||
DeductableAmount | decimal(18, 2) | NO | |||
ExceedCeilingAmount | decimal(18, 2) | NO | |||
PriceOrigin | char(1) | NO | |||
ExceedCeilingAmountCategory | decimal(18, 2) | NO | |||
ValidityFrom | datetime | YES | Current date | ||
ValidityTo | datetime | NO | |||
LegacyID | int | NO | |||
AuditUserID | int | YES |
...