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