PaymentConditionStaged.PaymentConditionStaged_ID = CInvoiceStage.PaymentConditionStaged_ID AND
PaymentCondition.PaymentCondition_ID = PaymentConditionStaged.StagedPaymentCondition_ID AND
| field name | data type | db field | description |
|---|
| tiCInvoice_ID | integer | CInvoiceStage.CInvoice_ID | Link to CInvoice |
| tiCInvoiceStage_ID | integer | PaySelLineStage.CInvoiceStage_ID | Link to CInvoiceStage |
| ttCInvoiceStageDiscDate | date | CInvoiceStage.CInvoiceStageDiscDate | CInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given. |
| tdCInvoiceStageDiscPerc | decimal | CInvoiceStage.CInvoiceStageDiscPerc | CInvoiceDiscPerc Payment discount percent. When the invoice is paid before the discount due date, this is the discount percentage that can be given. |
| ttCInvoiceStageDueDate | date | CInvoiceStage.CInvoiceStageDueDate | Due Date. The date when this stage should end. |
| tdCInvoiceStagePercent | decimal | CInvoiceStage.CInvoiceStagePercent | CInvoiceStagePercent Staged payments credit terms details of the invoice. The percentage of the invoice total that this stage stands for. |
| tcCInvoiceStageTSMNumber | character | CInvoiceStage.CInvoiceStageTSMNumber | Payment Reference |
| tiDInvoiceStage_ID | integer | PaySelLineStage.DInvoiceStage_ID | Link to DInvoiceStage |
| tiPaymentCondition_ID | integer | PaymentCondition.PaymentCondition_ID | Record ID |
| tcPaymentConditionCode | character | PaymentCondition.PaymentConditionCode | Credit Terms Code |
| tcPaymentConditionDescript | character | PaymentCondition.PaymentConditionDescript | Description |
| tdPaymentConditionPercentage | decimal | PaymentCondition.PaymentConditionPercentage | Discount Percentage |
| tiPaySelLine_ID | integer | PaySelLineStage.PaySelLine_ID | Link to PaySelLine |
| tiPaySelLineStage_ID | integer | PaySelLineStage.PaySelLineStage_ID | Record ID |
| tdPaySelLineStageDiscAmntTC | decimal | PaySelLineStage.PaySelLineStageDiscAmntTC | Discount Amount |
| tdPaySelLineStageIntAmtTC | decimal | PaySelLineStage.PaySelLineStageIntAmtTC | Interest Amount |
| tdPaySelLineStageOpenAmntTC | decimal | PaySelLineStage.PaySelLineStageOpenAmntTC | Open Amount |
| tdPaySelLineStageOrigAmntTC | decimal | PaySelLineStage.PaySelLineStageOrigAmntTC | Original Amount |
| tdPaySelLineStagePaymAmntTC | decimal | PaySelLineStage.PaySelLineStagePaymAmntTC | Payment Amount |
| tdPaySelLineStageWHTAmtTC | decimal | PaySelLineStage.PaySelLineStageWHTAmtTC | TC WHT Amount |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(PaySelLineStage),rowid(CInvoiceStage),rowid(PaymentConditionStaged),rowid(PaymentCondition) |
each PaySelLineStage where