| field name | data type | db field | description |
|---|
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tiDInvoiceStage_ID | 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. |
| tiPaymentConditionStaged_ID | integer | DInvoiceStage.PaymentConditionStaged_ID | Credit Terms Code |
each DInvoice where