Basic debtor details entered by a unique account number. Debtor balances are updated and aged with Process Sales Orders, activating debtor Receipts, Credit notes and journals and End of Period processing. A new debtor record automatically creates a record in the Contact table.
|
Name |
Type |
Linked To/Supplied by |
|
DebtorID |
Text20 |
|
|
LastSavedDateTime |
Date/Time8 |
|
|
AccountNo |
Text50 |
|
|
Name |
Text200 |
|
|
Address1 |
Text50 |
|
|
Address2 |
Text50 |
|
|
Address3 |
Text50 |
|
|
Address4 |
Text50 |
|
|
PostCode |
Text10 |
|
|
Phone |
Text20 |
|
|
Fax |
Text20 |
|
|
BankName |
Text50 |
|
|
BankAcc |
Text50 |
|
|
BSBN |
Text20 |
|
|
AccountName |
Text50 |
|
|
TaxExemptNo |
Text20 |
|
|
AccountType |
Yes/No1 |
|
|
CreditLimit |
Double8 |
|
|
EarlyPayDisOnStatsDays |
Integer2 |
|
|
EarlyPayDisOnStatsAmt |
Double8 |
|
|
LastPurchaseDate |
Date/Time8 |
|
|
LastPaymentDate |
Date/Time8 |
|
|
StandingDisOnInvoices |
Double8 |
|
|
ClassificationID |
Text20 |
|
|
AccountOnHold |
Yes/No1 |
|
|
EmailAddress |
Text200 |
|
|
CurrentBalance |
Double8 |
|
|
Period1 |
Double8 |
|
|
Period2 |
Double8 |
|
|
Period3 |
Double8 |
|
|
Period4 |
Double8 |
|
|
AltAccountNo |
Text50 |
|
|
NotifyRequired |
Yes/No1 |
|
|
NotifyAddress |
Text50 |
|
|
CommenceDate |
Date/Time8 |
|
|
WebAccess |
Yes/No1 |
|
|
ParentDebtorID |
Text20 |
|
|
AllocLastSavedDateTime |
Date/Time8 |
|
|
PriceSchemeID |
Text20 |
|
|
AustPostDPID |
Text20 |
|
|
AustPostBCSP |
Text20 |
|
|
TradingName |
Text255 |
|
|
CompanyName |
Text255 |
|
|
ACN |
Text50 |
|
|
ProprietorsName |
Text255 |
|
|
FaxHeader |
Text255 |
|
|
LedgerIDDebtorControl |
Text20 |
|
|
LedgerIDDebtorSales |
Text20 |
|
|
LedgerIDDebtorDiscounts |
Text20 |
|
|
LedgerIDDebtorSourcedInvoices |
Text20 |
|
|
LedgerIDDebtorSourcedDebitNote |
Text20 |
|
|
LedgerIDDebtorSourcedDebitJournal |
Text20 |
|
|
LedgerIDDebtorSourcedReceipts |
Text20 |
|
|
LedgerIDDebtorCreditNote |
Text20 |
|
|
LedgerIDDebtorCreditJournal |
Text20 |
|
|
LedgerIDDebtorFreight |
Text20 |
|
|
LedgerIDDebtorInsurance |
Text20 |
|
|
LedgerIDDebtorRealisedGainLoss |
Text20 |
|
|
LedgerIDDebtorUnRealisedGainLoss |
Text20 |
|
|
PeriodType |
Integer2 |
|
|
TermsDays |
Integer2 |
|
|
TermsType |
Integer2 |
|
|
ABN |
Text50 |
|
|
ExcludeFromAging |
Yes/No1 |
|
|
BPayReference |
Text50 |
|
|
UsesFX |
Yes/No1 |
|
|
FXCurrencyID |
Text20 |
|
|
FXCurrentBalance |
Double8 |
|
|
FXPeriod1 |
Double8 |
|
|
FXPeriod2 |
Double8 |
|
|
FXPeriod3 |
Double8 |
|
|
FXPeriod4 |
Double8 |
|
|
TradingStatus |
Yes/No |
|
|
Category1ID |
Text36 |
|
|
Category2ID |
Text36 |
|
|
Category3ID |
Text36 |
|
|
Category4ID |
Text36 |
|
|
Category5ID |
Text36 |
|
Copyright © 2012 Jiwa Financials. All rights reserved.