You are here: Reference Guide > Table Structures > Debtors > DB_Classification

DB_Classification

Purpose    

Debtor classification codes - used for reporting and collating purposes.  General ledger linking is also established in this table.  Individual debtor linking to the ledger can be overwritten in the debtor record.   Settings in jiwa.ini determine whether sales postings come from the debtors or the inventory classifications. (Refer:Getting Started, Appendix A )

Path          

System Debtor Control Maintenance Classification

Name

Type

Linked To/Supplied

DebtorClassificationID 

Text (20)

 

LastSavedDateTime 

Date/Time

 

Description

Text (50)

 

AccountID1 (Debtor Balance Sheet A/c)

Text (20)

GL_Ledger.GLLedgerID 

AccountID2 (Debtor Sales)

Text (20)

GL_Ledger.GLLedgerID 

AccountID3 (Debtor Discounts)

Text (20)

GL_Ledger.GLLedgerID 

AccountID4 (Debtor Sourced Invoice)

Text (20)

GL_Ledger.GLLedgerID 

AccountID5 (Debtor Sourced Debit Note)

Text (20)

GL_Ledger.GLLedgerID 

AccountID6 (Debtor Sourced Debit Jnl)

Text (20)

GL_Ledger.GLLedgerID 

AccountID7 (Debtor Sourced Receipt)

Text (20)

GL_Ledger.GLLedgerID 

AccountID8 (Debtor Sourced Credit Note)

Text (20)

GL_Ledger.GLLedgerID 

AccountID9 (Debtor Sourced Credit Jnl)

Text (20)

GL_Ledger.GLLedgerID 

AccountID10 (Debtor Freight)

Text (20)

GL_Ledger.GLLedgerID 

AccountID11 (Debtor Insurance)

Text (20)

GL_Ledger.GLLedgerID 

TermsDays 

Number (Integer)

 

TermsType 

Yes/No

0 = No, 1 = Yes

PriceSchemeID 

Text (20)

IN_PriceSchemes.Price;SchemeID

Copyright © 2012 Jiwa Financials. All rights reserved.