ApprovedAmount | Approved Amount | Currency | | The value the supplier accepted for this row, entered by hand. It is not calculated from Approve Quantity and Unit Price. |
ApproveQuantity | Approve Quantity | Decimal | | The quantity the supplier approved, entered by hand. Left empty on a new row it is saved as 0, and a value of 0 or less is refused with Approved Quantity cannot be Negative, so a new row needs at least 1 even when nothing was approved. It is separate from the claim line's own Approve Quantity, and nothing keeps the two in step. |
ClaimAmount | Claim Amount | Calculated (calculated) | | Calculated on every save as Claim Quantity times Unit Price. It is not on the seeded forms. |
ClaimId | Claim | Lookup → Claim | | The claim the row refers to. For information only; nothing checks it against the claim line or the item. |
ClaimLineId | Claim Line | Lookup → ClaimLine | | The claim line the row accounts for. The picker lists every claim line, not just those of the chosen claim, and picking one fills in nothing else on the row. |
ClaimQuantity | Claim Quantity | Decimal | | The quantity claimed, entered by hand. Left empty on a new row it is saved as 0, and a value of 0 or less is refused with Claim Quantity Cannot be Negative, so enter at least 1. |
ClaimReconciliationId | Reconciliation | Lookup → ClaimReconciliation | | The reconciliation this row belongs to. Filled in automatically when the row is created with New on a reconciliation's Reconciliation Lines tab. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
ExternalId | External | Text | | A reference to the same row in another system, for imports. Nothing in xMatix reads it. |
Id | Id | Guid | Yes | |
ItemId | Item | Lookup → Item | | The item reconciled. Entered by hand; it is not taken from the claim line. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | Required, but no numbering setting is shipped for reconciliation lines and the shipped create form has no Name field, so a new line is refused with Name is required until an administrator adds a document name setting for the entity or adds Name to the form. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
RecordTypeId | Record Type | Guid, hidden | | |
RejectedAmount | Rejected Amount | Currency | | The value the supplier rejected, entered by hand. It is not calculated. |
RejectionReason | Rejection Reason | PickList | | Why the supplier rejected the quantity. No reasons are seeded, so the list is empty until an administrator adds values to this picklist. |
RejectQuantity | Reject Quantity | Decimal | | The quantity the supplier rejected, entered by hand. Left empty on a new row it is saved as 0, and a value of 0 or less is refused with Rejected Quantity cannot be Negative, so a new row needs at least 1 even when nothing was rejected. |
Remarks | Remarks | Text | | Free-text notes about the row. |
Status | Status | PickList | | Draft, Pending or Reclaim, where Reclaim means the quantity is to be claimed again. It is not on the create form and nothing sets it, so it stays empty unless an administrator adds it to the form. Reclaim does not raise a new claim. Values: Pending, Reclaim, Draft. |
UIProps | UI Props | Text | | |
UnitPrice | Unit Price | Currency | | The price per unit used for Claim Amount. Leave it empty or enter an amount above zero: 0 or less is refused with Unit Price cannot be Negative. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |