Edit

Names

Internal name Name.

FieldTypeSizeNotes
ABUIDSMac Address Book Universal ID--set for imported address book entries only
Account NameT21The bank account name (e.g. XYZ Trading Company)
Address1T59Mailing Address (first line)
Address2T59Mailing Address (second line)
Address3T59Mailing Address (third line)
Address4T59Mailing Address (fourth line)
AfterhoursT11After hours phone number for contact 1
Afterhours2T11After hours phone number for contact 2
BankT7The customer's bank (e.g. BNZ)
BankAccountNumberT23The bank account number of the name, as supplied by their bank
BankBranchT21The bank branch (e.g. Main St.)
Category1T15User defined
Category2T15User defined
Category3T15User defined
Category4T15User defined
CCurrentNFor a creditor, the current balance.
CodeT11The name code. For non-sundries, only the first ten characters are used.
ColourNThe colour, represented internally as a numeric index in the range 0-7 but rendered as a textual colour name
CommentT1020A comment
ContactT25Contact person 1 in the company
Contact2T29Name of contact person 2
CreditCardExpiryT5Expiry date of credit card
CreditCardNameT19Name on credit card
CreditCardNumT19Credit card number
CreditLimitNThe credit limit for a debtor
CreditorTermsNIf > 0, within N days; if < 0, Nth day of month following
CurrencyT3Currency of customer/supplier (blank if local)
Custom1T255For your own use
Custom2T255For your own use
Custom3T15For your own use
Custom4T15For your own use
Custom5T15For your own use
Custom6T15For your own use
Custom7T15For your own use
Custom8T15For your own use
CustomerTypeN0 for not a customer, 1 for customer, 2 for debtor
CustPropmtPaymentDiscountNPrompt payment discount percentage
CustPromptPaymentTermsN0 for no prompt payment; > 0 for within N days; < 0 for by Nth date of following month
D30PlusNDebtor 30 day balance (1 cycle of manual ageing).
D60PlusNDebtor 60 day balance (2 cycles of manual ageing).
D90PlusNDebtor 90 days+ balance (3 cycles of manual ageing).
DateOfLastSaleDDate of last invoice or cash sale
DBalanceNSum of D90Plus, D60Plus, D30Plus and DCurrent
DCurrentNFor a debtor, the current balance. The total balance for the debtor is the sum of all the balance fields.
DDIT19Direct dial number for contact 1
DDI2T19Direct dial number for contact 2
DebtorTermsNIf > 0, within N days; if < 0, Nth day of month following
Delivery1T59Delivery address (first line)
Delivery2T59Delivery address (second line)
Delivery3T59Delivery address (third line)
Delivery4T59Delivery address (fourth line)
DeliveryPostcodeT12Postcode/zipcode of delivery address
DeliveryStateT4Sate of delivery address
DiscountNDiscount field for a customer
EInvoiceIDT31The ID to use for the customer when eInvoicing using a Peppol Access Point (e.g. ABN in Australia, NZBN in New Zealand)
emailT80email address for contact 1
email2T80email address for contact 2
FaxT19Facsimile number
FlagsNSee Names Flags table below
HoldB"True" if the debtor is on hold ("False" otherwise)
KindNThe kind of Name. 0 for a template, 1 for a normal
LastModifiedTimeSDate and Time the record was last modified
LastPaymentMethodNPaymentMethod used in previous transaction
MemoT255Memo/notes for contact 1
Memo2T255Memo/notes for contact 2
MobileT14Mobile phone number for contact 1
Mobile2T13Mobile phone number for contact 2
NameT255Name of company
PayAccountT7The Accounts Payable control account code for a creditor.
PaymentMethodNPayment method (0 = None, 1 = Cash, 2 = Cheque, 3 = Electronic, etc).
PhoneT19Phone number
PositionT29Position of contact person 1
Position2T29Position of contact 2
PostCodeT11Post code
ProductPricingT1Pricing level for customer. (A-F)
RecAccountT7The Accounts Receivable control account code for a debtor.
ReceiptMethodNPreferred payment method of customers. 1 = Cash, 2 = Cheque etc.
RoleNRoles for contact 1. This is a bit mapped field, with each bit representing a role.
Role2NRoles for contact 2. This is a bit mapped field, with each bit representing a role.
SalesPersonT5Code for salesperson for client--automatically copied to the transaction.salesperson field.
SalutationT39Salutation for contact 1
Salutation2T39Salutation for contact 2
SplitAcct1T13Account code for first split account
SplitAcct2T13Account code for remainder split account
SplitPercentNPercent of allocation to be put into SplitAcct1
StateT3State (for postal address)
SupplierTypeN0 for not a supplier, 1 for supplier, 2 for creditor
SuppPromptPaymentDiscountNPercentage amount of prompt payment discount offered by supplier
SupplierPromptPaymentTerms0 for no prompt payment; > 0 for within N days; < 0 for by Nth date of following month
TaggedTextT255Scriptable tag storage
TaxCodeA5Tax code override
TaxNumberT19Their tax number (GST#, VAT#, ABN etc, depending on country)
TheirRefT15The reference code by which the supplier or customer refers to your company.
UserNumNUser defined
UserTextT255User defined
WebURLT63Web URL

Name Flags

Use TestFlags(), Setflag(), and ClearFlag() functions for flags.

Requires order number0x0001