| iiCompanyId | integer | Company id |
| iiDInvoice_ID | integer | DInvoice ID |
| iiBill_ID | integer | |
| icMovementType | character |
each DInvoice where
each DInvoiceMovement (inner-join) where
first PostingLine (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiBill_ID | integer | DInvoice.Bill_ID | Link to Bill |
| tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| ttDInvoiceCreationDate | date | DInvoice.DInvoiceCreationDate | Creation Date |
| ttDInvoiceDate | date | DInvoice.DInvoiceDate | Invoice Date. This field indicates the invoice creation date.This field is normallly prior to the posting date and within the same accounting period as the posting date. The date must be within the upper and lower date limits of an open GL period. The system uses the invoice date with the credit terms to calculate due date and discount date. |
| api annotation: | This field defaults to the DInvoicePostingDate. | ||
| ttDInvoiceDueDate | date | DInvoice.DInvoiceDueDate | Due Date. This field displays the date when payment is due, calculated by the system based on the credit terms and the invoice date. User can modify the due date without affecting the credit terms. If the credit terms have a base date specified, this is used in the due date calculations rather than the invoice creation date. |
| tiDInvoiceMovement_ID | integer | DInvoiceMovement.DInvoiceMovement_ID | Record ID |
| ttDInvoiceMovementPostDate | date | DInvoiceMovement.DInvoiceMovementPostDate | Posting Date. The Posting Date of the Invoice's movement. |
| tcDInvoiceMovementType | character | DInvoiceMovement.DInvoiceMovementType | CInvoiceMovementType. "Initial" indicates that the movement represents the initial creation of the invoice, "movement" stands for all subsequent modifications of the invoice balance (payments, adjustments etc). |
| tcDInvoiceType | character | DInvoice.DInvoiceType | Invoice Type. This field displays the invoice type. Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined. |
| api annotation: | PartialUpdate = yes - defaults to Invoice | ||
| ttPostingDate | date | PostingLine.PostingDate | Posting Date. |
| api annotation: | If this field is blank, it gets a default value equal to the value of PostingDate in tPosting. | ||
| tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
| tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
| tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
QadFinancials