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 | DPaySelLineStg.DInvoiceStage_ID | Link to DInvoiceStage |
| tiDInvoiceStage_ID1 | integer | DInvoiceStage.DInvoiceStage_ID | Record ID |
| tdDInvoiceStageAmountCC | decimal | DInvoiceStage.DInvoiceStageAmountCC | SC Amount. CInvoiceStageAmountSC Staged payments credit terms details of the invoice. The amount to pay in SC for this stage. |
| tdDInvoiceStageAmountLC | decimal | DInvoiceStage.DInvoiceStageAmountLC | BC Amount. CInvoiceStageAmountBC Staged payments credit terms details of the invoice. The amount to pay in BC for this stage. |
| 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. |
| 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. |
| tiDPaySelLine_ID | integer | DPaySelLineStg.DPaySelLine_ID | Link to DPaySel |
| tiDPaySelLineStg_id | integer | DPaySelLineStg.DPaySelLineStg_ID | Record ID |
| tdDPaySelLineStgDiscAmtTC | decimal | DPaySelLineStg.DPaySelLineStgDiscAmtTC | TC Discount Amount |
| tdDPaySelLineStgIntRate | decimal | DPaySelLineStg.DPaySelLineStgIntRate | Interest Rate |
| tdDPaySelLineStgOpenAmtTC | decimal | DPaySelLineStg.DPaySelLineStgOpenAmtTC | TC Open Amount |
| tdDPaySelLineStgOrigAmtTC | decimal | DPaySelLineStg.DPaySelLineStgOrigAmtTC | TC Orig Amount |
| tdDPaySelLineStgPaymAmtTC | decimal | DPaySelLineStg.DPaySelLineStgPaymAmtTC | TC Payment Amount |
| tcDPaySelLineStgStatus | character | DPaySelLineStg.DPaySelLineStgStatus | Status |
| tcDPaySelPayRefBankRef | character | DPaySelPayRef.DPaySelPayRefBankRef | Bank Reference |
| tcDPaySelPayRefCode | character | DPaySelPayRef.DPaySelPayRefCode | Payment Reference Code |
| tcPaymentConditionCode | character | PaymentCondition.PaymentConditionCode | Credit Terms Code |
| tdPaymentConditionLateInt | decimal | PaymentCondition.PaymentConditionLateInt | Daily Overdue Int Percentage |
| tiPaymentConditionStaged_ID | integer | DInvoiceStage.PaymentConditionStaged_ID | Credit Terms Code |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DPaySelLineStg),rowid(DInvoiceStage),rowid(PaymentConditionStaged),rowid(PaymentCondition),rowid(DPaySelPayRef) |
each DPaySelLineStg where