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) |