Maintenance
Basic creditor details entered by a unique account number. Creditor balances are updated when purchase invoices and creditor transactions are activated and aged by End of Period processing.
Creditors
Maintenance
|
Name |
Type |
Linked To/Supplied |
|
CreditorID |
Text (20) |
|
|
LastSavedDateTime |
Date/Time |
|
|
AccountNo |
Text (50) |
|
|
Name |
Text (50) |
|
|
Address1 |
Text (50) |
|
|
Address2 |
Text (50) |
|
|
Address3 |
Text (50) |
|
|
Address4 |
Text (50) |
|
|
PostCode |
Text (10) |
|
|
Phone |
Text (20) |
|
|
Fax |
Text (20) |
|
|
BankName |
Text (50) |
|
|
BankAcc |
Text (50) |
|
|
BSBN |
Text (20) |
|
|
AccountName |
Text (50) |
|
|
DefaultPaymentType |
bit |
0 = Open Item; 1 = Balanced |
|
CreditLimit |
Number (Float) |
|
|
EarlyPayDisOnRemitDays |
Number (Integer) |
|
|
EarlyPayDisOnRemitAmt |
Number (Float) |
|
|
LastSaleDate |
Date/Time |
|
|
LastPaymentDate |
Date/Time |
|
|
ClassificationID |
Text (20) |
CR_Classification.CreditorClassificationID |
|
AccountOnHold |
Yes/No |
|
|
EmailAddress |
Text (200) |
|
|
CurrentBalance |
Number (Float) |
|
|
Period1 |
Number (Float) |
|
|
Period2 |
Number (Float) |
|
|
Period3 |
Number (Float) |
|
|
Period4 |
Number (Float) |
|
|
Period5 |
Number (Float) |
|
|
Period6 |
Number (Float) |
|
|
Period7 |
Number (Float) |
|
|
Period8 |
Number (Float) |
|
|
AltAccountNo |
Text (50) |
|
|
CommenceDate |
Date/Time |
|
| TermsDays | smallint | |
|
ACN |
Text (50) |
|
|
CurrencyID |
Text (20) |
FX_Currency.CurrencyID |
|
UsesFX |
Yes/No |
|
|
ABN |
Text (50) |
|
|
TermsType |
Yes/No |
|
|
AustPostDPID |
Text (20) |
|
|
AustPostBCSP |
Text (20) |
|
|
MinPOValue |
Float |
|
|
MaxPOValue |
Float |
|
| PeriodType | smallint | |
|
TradingName |
varchar (255) |
|
| CompanyName | varchar (255) | |
| ProprietorName | varchar (255) | |
| FXCurrentBalance | float | |
| FXPeriod1 - FXPeriod4 | float | |
| TradingStatus | bit | |
| LedgerIDCreditorControl | char (20) | |
| LedgerIDCreditorPurchases | char (20) | |
| LedgerIDCreditorDiscounts | char (20) | |
| LedgerIDCreditorSourcedPayments | char (20) | |
| LedgerIDCreditorSourcedDebitAdjustment | char (20) | |
| LedgerIDCreditorSourcedPurchase | char (20) | |
| LedgerIDCreditorSourcedCreditAdjustment | char (20) | |
| LedgerIDCreditorFreight | char (20) | |
| LedgerIDCreditorInsurance] | char (20) | |
| LedgerIDCreditorDuty | char (20) | |
| LedgerIDCreditorRealisedGainLoss | char (20) | |
| LedgerIDCreditorUnRealisedGainLoss | char (20) | |
| PO_Workflows_RecID |
char (36) |
|
| Country | varchar (50) |
Copyright © 2012 Jiwa Financials. All rights reserved.