field name | data type | db field | description |
tiLayer_ID | integer | YearClosing.Layer_ID | Link to Layer |
tiYearClosingAccountingYear | integer | YearClosing.YearClosingAccountingYear | GL Calendar Year |
tlYearClosingIsTransPLToBal | logical | YearClosing.YearClosingIsTransPLToBal | Auto-Transfer Profit/Loss to BS |
tlYearClosingIsInclDivision | logical | YearClosing.YearClosingIsInclDivision | Include Sub-Accounts |
tcClosingPLGLCode | character | GL1.GLCode | A code identifying the GL account. |
tcClosingPLDivGLCode | character | GL2.GLCode | A code identifying the GL account. |
tcClosingBalanceGLCode | character | GL3.GLCode | A code identifying the GL account. |
tcClosingBalanceDivGLCode | character | GL4.GLCode | A code identifying the GL account. |
tcClosingTransferJournalCode | character | Journal3.JournalCode | A daybook code (maximum eight characters). |
tcClosingPLJournalCode | character | Journal2.JournalCode | A daybook code (maximum eight characters). |
tcClosingBalanceJournalCode | character | Journal1.JournalCode | A daybook code (maximum eight characters). |
tiYearClosing_ID | integer | YearClosing.YearClosing_ID | Record ID |
tiCompany_ID | integer | YearClosing.Company_ID | Link to Company |
tiClosingPLGL_ID | integer | YearClosing.ClosingPLGL_ID | Profit/Loss Closing Account |
tiClosingPLDivGL_ID | integer | YearClosing.ClosingPLDivGL_ID | Profit/Loss Closing Sub-Account |
tiClosingBalanceGL_ID | integer | YearClosing.ClosingBalanceGL_ID | Balance Sheet Closing Account |
tiClosingBalanceDivGL_ID | integer | YearClosing.ClosingBalanceDivGL_ID | Balance Sheet Closing Sub-Account |
tiClosingTransferJournal_ID | integer | YearClosing.ClosingTransferJournal_ID | Automated Profit/Loss Transfer Daybook |
tiClosingPLJournal_ID | integer | YearClosing.ClosingPLJournal_ID | Closing Profit/Loss Daybook |
tiClosingBalanceJournal_ID | integer | YearClosing.ClosingBalanceJournal_ID | Closing Balance Daybook |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(YearClosing),rowid(GL1),rowid(GL2),rowid(GL3),rowid(GL4),rowid(Journal1),rowid(Journal2),rowid(Journal3) |