PaymentConditionStaged.PaymentConditionStaged_ID = CInvoiceStage.PaymentConditionStaged_ID AND
PaymentCondition.PaymentCondition_ID = PaymentConditionStaged.StagedPaymentCondition_ID AND
| field name | data type | db field | description |
|---|
| tiCInvoiceStage_ID | integer | CInvoiceStage.CInvoiceStage_ID | Record ID |
| tdCInvoiceStageAmountTC | decimal | CInvoiceStage.CInvoiceStageAmountTC | CInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage. |
| tdCInvoiceStageAmtAppliedTC | decimal | CInvoiceStage.CInvoiceStageAmtAppliedTC | CInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage. |
| ttCInvoiceStageDiscDate | date | CInvoiceStage.CInvoiceStageDiscDate | CInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given. |
| ttCInvoiceStageDueDate | date | CInvoiceStage.CInvoiceStageDueDate | Due Date. The date when this stage should end. |
| 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 |
each CInvoiceStage where