iiCompanyId | integer | Company id |
icCandoBRCode | character | |
icCandoDebtorCode | character | |
icCandoGLCode | character | |
icFromBRCode | character | |
icFromDebtorCode | character | |
icFromGLCode | character | |
iiFromYearPeriod | integer | |
icToBRCode | character | |
icToDebtorCode | character | |
icToGLCode | character | |
iiToYearPeriod | integer |
field name | data type | db field | description |
---|---|---|---|
tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
tiCurrencyNumberOfDecimals | integer | Currency.CurrencyNumberOfDecimals | Number of Decimals |
tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
tcDebtorCode | character | Debtor.DebtorCode | A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation. |
api annotation: | If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. | ||
tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
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. | ||
tcDInvoiceDescription | character | DInvoice.DInvoiceDescription | Description. A brief description of the invoice. This field is mandatory. |
ttDInvoiceDiscountDueDate | date | DInvoice.DInvoiceDiscountDueDate | Discount Due Date. This field displays the last date a discount applies, calculated by the system based on the credit terms and the invoice date. You 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. |
tcDInvoiceDIText | character | DInvoice.DInvoiceDIText | CIDescription. A brief description for the SI posting. |
api annotation: | This field defaults from the DInvoiceDescription. | ||
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. |
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). |
ttDInvoicePostingDate | date | DInvoice.DInvoicePostingDate | Posting Date. This field displays the date the sales-related invoice was generated by Invoice Post and Print. This field is updated when the invoice is validated and saved. |
api annotation: | This field defaults from the invoice creation date. | ||
tiDInvoicePostingYear | integer | DInvoice.DInvoicePostingYear | Year.This field indicates the accounting year for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly. |
api annotation: | This field defaults to the accounting year associated with the posting date. | ||
tiDInvoicePostingYearPeriod | integer | DInvoice.DInvoicePostingYearPeriod | Year/Period. This field indicates the accounting year and period for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly. |
api annotation: | This field defaults to the accounting year and period associated with the posting date. | ||
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 | ||
tiDInvoiceVoucher | integer | DInvoice.DInvoiceVoucher | Voucher.This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is charged(after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field. |
tiGL_ID | integer | GL.GL_ID | Record ID |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tcGLDescription | character | GL.GLDescription | A description of the GL account. |
tcGLTypeCode | character | GL.GLTypeCode | A code identifying the type of account. |
tcInvoiceJournalCode | character | Journal2.JournalCode | A daybook code (maximum eight characters). |
tiJournal_ID | integer | Journal1.Journal_ID | Record ID |
tcJournalCode | character | Journal1.JournalCode | A daybook code (maximum eight characters). |
tcJournalDescription | character | Journal1.JournalDescription | A brief description of the daybook. |
api annotation: | Value for this field defaults to null. | ||
tcJournalTypeCode | character | Journal1.JournalTypeCode | A daybook type code. |
api annotation: | Value for this field defaults to "Journal Entries". | ||
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. | ||
tcPostingInvoiceReferenceTxt | character | Posting.PostingInvoiceReferenceTxt | When the posting is part of an invoice posting, then this field contains the invoice number (Year/Daybook/Voucher extended with supplier invoice Reference in case of a supplier invoice). Used for information purpose on reports and browsers. |
api annotation: | Value for this field defaults to blank | ||
tdPostingLineCreditCC | decimal | PostingLine.PostingLineCreditCC | SC Credit |
api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field | ||
tdPostingLineCreditLC | decimal | PostingLine.PostingLineCreditLC | BC Credit |
api annotation: | Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field. | ||
tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
tdPostingLineDebitCC | decimal | PostingLine.PostingLineDebitCC | SC Debit |
api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field. | ||
tdPostingLineDebitLC | decimal | PostingLine.PostingLineDebitLC | BC Debit |
api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field. | ||
tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
tcPostingLineLegalDocNbr | character | PostingLine.PostingLineLegalDocNbr | Legal Document Nbr |
tiPostingLineSequence | integer | PostingLine.PostingLineSequence | Sequence |
tcPostingLineText | character | PostingLine.PostingLineText | Description |
api annotation: | Value for this field defaults to blank. Note: if a new record is created through the user interface, the default value is as same as the value of "PostingText" of tPosting. | ||
tcPostingParentText | character | Posting.PostingParentText | Contains the description field from the parent object that triggered the posting. When the posting is an invoice posting, this field contains the invoice description. When the posting is a banking entry posting, the description of the bank statement line is copied to this field, etc. Used for information purposes on reports and browses. |
api annotation: | Value for this field defaults to blank. | ||
tiPostingPeriod | integer | Posting.PostingPeriod | The GL period for the posting. The period must be open. |
tcPostingText | character | Posting.PostingText | Free text describing the posting. |
api annotation: | Value for this field defaults to blank | ||
tiPostingVoucher | integer | Posting.PostingVoucher | Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code). |
api annotation: | In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record. | ||
tiPostingYear | integer | Posting.PostingYear | The GL calendar year for the posting. |
tiPostingYearPeriod | integer | Posting.PostingYearPeriod | The GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear". |
api annotation: | If Partial Update is true, the value defaults using PostingPeriod and PostingYear. |