PaymentConditionStaged.PaymentConditionStaged_ID = DInvoiceStage.PaymentConditionStaged_ID AND
PaymentCondition.PaymentCondition_ID = PaymentConditionStaged.StagedPaymentCondition_ID AND
| field name | data type | db field | description |
|---|
| tiDInvoice_ID | integer | DInvoiceStage.DInvoice_ID | Link to DInvoice |
| tiDInvoiceStage_ID | integer | DInvoiceStage.DInvoiceStage_ID | Record ID |
| tdDInvoiceStageAmountTC | decimal | DInvoiceStage.DInvoiceStageAmountTC | TC Amount. CInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage. |
| tdDInvoiceStageAmtAppliedTC | decimal | DInvoiceStage.DInvoiceStageAmtAppliedTC | TC Applied Amount. CInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage. |
| ttDInvoiceStageDiscDate | date | DInvoiceStage.DInvoiceStageDiscDate | CInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given. |
| tdDInvoiceStageDiscPerc | decimal | DInvoiceStage.DInvoiceStageDiscPerc | CInvoiceDiscPerc Payment discount percent. When the invoice is paid before the discount due date, this is the discount percentage that can be given. |
| ttDInvoiceStageDueDate | date | DInvoiceStage.DInvoiceStageDueDate | Due Date. The date when this stage should end. |
| tlDInvoiceStageIsSelected | logical | DInvoiceStage.DInvoiceStageIsSelected | Used to indicate if a customer invoice stage is included on a payment selection. |
| tdDInvoiceStagePercentage | decimal | DInvoiceStage.DInvoiceStagePercentage | Percentage. CInvoiceStagePercent Staged payments credit terms details of the invoice. The percentage of the invoice total that this stage stands for. |
| tcPaymentConditionCode | character | PaymentCondition.PaymentConditionCode | Credit Terms Code |
| tdPaymentConditionLateInt | decimal | PaymentCondition.PaymentConditionLateInt | Daily Overdue Int Percentage |
| tdPaymentConditionPercentage | decimal | PaymentCondition.PaymentConditionPercentage | Discount Percentage |
| tiPaymentConditionStaged_ID | integer | PaymentConditionStaged.PaymentConditionStaged_ID | Record ID |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DInvoiceStage),rowid(PaymentConditionStaged),rowid(PaymentCondition) |
each DInvoiceStage where