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