| field name | data type | description |
|---|---|---|
| DInvoiceStage_ID | integer | |
| DInvoice_ID | integer | |
| PaymentConditionStaged_ID | integer | |
| DInvoiceStageDueDate | date | Due Date. The date when this stage should end. |
| DInvoiceStagePercentage | decimal(10) | Percentage. CInvoiceStagePercent Staged payments credit terms details of the invoice. The percentage of the invoice total that this stage stands for. |
| DInvoiceStageAmountTC | decimal(4) | TC Amount. CInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage. |
| DInvoiceStageAmountLC | decimal(4) | BC Amount. CInvoiceStageAmountBC Staged payments credit terms details of the invoice. The amount to pay in BC for this stage. |
| DInvoiceStageAmountCC | decimal(4) | SC Amount. CInvoiceStageAmountSC Staged payments credit terms details of the invoice. The amount to pay in SC for this stage. |
| DInvoiceStageAmtAppliedTC | decimal(4) | TC Applied Amount. CInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage. |
| DInvoiceStageDiscDate | date | CInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given. |
| DInvoiceStageDiscPerc | decimal(3) | CInvoiceDiscPerc Payment discount percent. When the invoice is paid before the discount due date, this is the discount percentage that can be given. |
| DInvoiceStageIsSelected | logical | Used to indicate if a customer invoice stage is included on a payment selection. |
| tcPaymentConditionCode | character | Credit Terms Code. This field idetifies the Credit Term used in this stage. |
| tcPaymentConditionDescript | character | Description. This field displays the description of the Credit Term used in this stage. |
| tdPaymentConditionPercentage | decimal(3) | Discount Percentage. This field indicates the discount rate used in the stage. This field is calculated using the Credit Term. |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |
QadFinancials