Accounting

Accounting transactions are stored in a special General Journal Transaction table in the Sterling database and can be transferred to any accounting system.

• Batch number
• Company ID (when multiple companies are integrated)
• GJ transaction date
• GL Account
• Department sub account
• Description of transaction
• Origination (Sales, cash receipts, Trust, Commissions, Interest/Late Charges)
• Debit Amount
• Credit Amount
• Contract from which the transaction was generated

GL Packets are set up with GL packet triggers which determine the timing of the General Journal entry.  The Packet headers are stored in tblGL PacketHdr and the actual transaction for each debit and credit is stored in tblGLPacketDtl.