| field name | data type | description |
|---|---|---|
| CInvoiceStage_ID | integer | |
| CInvoice_ID | integer | |
| PaymentConditionStaged_ID | integer | |
| CInvoiceStageDueDate | date | Due Date. The date when this stage should end. |
| CInvoiceStagePercent | decimal(10) | CInvoiceStagePercent Staged payments credit terms details of the invoice. The percentage of the invoice total that this stage stands for. |
| CInvoiceStageAmountTC | decimal(4) | CInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage. |
| CInvoiceStageAmountLC | decimal(4) | CInvoiceStageAmountBC Staged payments credit terms details of the invoice. The amount to pay in BC for this stage. |
| CInvoiceStageAmountCC | decimal(4) | CInvoiceStageAmountSC Staged payments credit terms details of the invoice. The amount to pay in SC for this stage. |
| CInvoiceStageAmtAppliedTC | decimal(4) | CInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage. |
| CInvoiceStageDiscDate | date | CInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given. |
| CInvoiceStageDiscPerc | 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. |
| CInvoiceStageTSMNumber | character | |
| 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
QadFitnesse