iiCompanyId | integer | Company id |
icBankStateTransactionType | character | |
icCanDoBankStateLines | character |
field name | data type | db field | description |
---|---|---|---|
ttBankStateLinePostingDate | date | BankStateLine.BankStateLinePostingDate | Posting Date |
tcLastModifiedUser | character | BankStateLine.LastModifiedUser | Last Modified User |
tiBankStateLine_ID | integer | BankStateLine.BankStateLine_ID | Record ID |
tcBankStateLineInOut | character | BankStateLine.BankStateLineInOut | In/Out |
tdBankStateLineAmountTC | decimal | BankStateLine.BankStateLineAmountTC | TC Amount |
tcBankStateLineDescription | character | BankStateLine.BankStateLineDescription | Description |
tcBankStateLineInformation | character | BankStateLine.BankStateLineInformation | Information |
tiAloccPosting_ID | integer | BankStateAlloc.Posting_ID | Link to Posting |
tdBankStateAllocBankAmountTC | decimal | BankStateAlloc.BankStateAllocBankAmountTC | TC Bank Amt |
tiCInvoice_ID | integer | BankStateAlloc.CInvoice_ID | Link to CInvoice |
tiDInvoice_ID | integer | BankStateAlloc.DInvoice_ID | Link to DInvoice |
tiBankStateAlloc_ID | integer | BankStateAlloc.BankStateAlloc_ID | Record ID |
tiAlocPostingVoucher | integer | Posting1.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. | ||
tiAlocPostingYear | integer | Posting1.PostingYear | The GL calendar year for the posting. |
tiAlocPeriod_ID | integer | Posting1.Period_ID | Link to Period |
tiAlocJournal_ID | integer | Posting1.Journal_ID | Daybook Code |
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. |
tiDInvJournal_ID | integer | DInvoice.Journal_ID | Daybook Code |
tiDInvPeriod_ID | integer | DInvoice.Period_ID | Link to Period |
tiDebBusRel_ID | integer | Debtor.BusinessRelation_ID | Business Relation |
tiCInvoiceVoucher | integer | CInvoice.CInvoiceVoucher | Voucher. This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is changed (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. |
tiCInvJournal_ID | integer | CInvoice.Journal_ID | Daybook Code |
tiCInvPeriod_ID | integer | CInvoice.Period_ID | Link to Period |
tiCrBusRel_ID | integer | Creditor.BusinessRelation_ID | Name |
ttPostingDate | date | Posting2.PostingDate | The accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod). |
tiPostingVoucher | integer | Posting2.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 | Posting2.PostingYear | The GL calendar year for the posting. |
tiJournal_ID | integer | Posting2.Journal_ID | Daybook Code |
tiPeriod_ID | integer | Posting2.Period_ID | Link to Period |
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 |
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 |
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. | ||
tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
tiCurrencyNumberOfDecimalsPost | integer | Currency1.CurrencyNumberOfDecimals | Number of Decimals |
tcPostingLineCurrency | character | Currency1.CurrencyCode | Currency Code |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tiCurrencyNumberOfDecimals | integer | Currency2.CurrencyNumberOfDecimals | Number of Decimals |
tcCurrencyCode | character | Currency2.CurrencyCode | Currency Code |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(BankState),rowid(BankStateLine),rowid(BankStateAlloc),rowid(CInvoice),rowid(Creditor),rowid(DInvoice),rowid(Debtor),rowid(Posting1),rowid(Posting2),rowid(PostingLine),rowid(Currency1),rowid(GL),rowid(Currency2) |