XML eGateway Import Account for Exchequer Enterprise


XML eGateway:: Features; Document Type Definition; Example XML Transaction; External Code Conversion; System Settings; User Manual; Test Program; Example XML; Price


Import XML Entities:: Account; Transaction; Transaction Line; Stock; Job


Pro Version:: Export Data


Latest News:: Sign-up for Newsletter; Follow us on Facebook; Follow us on Twitter

: Bookmark page; Send to a Friend; Print this page


Experts in:: Importation; Exchequer; Bespoke Solutions for Exchequer

XML eGateway Import: Account Entity

This represents Customer/Supplier record within Exchequer Software. These fields can also be specified in Transaction Entity.

Handles Long external account numbers

see Examples

FieldName	DataType	Length	DefaultValue	Notes
acAccStatus	Integer		0	0=Open,1=Notes,2=Hold,3=Closed
acAccType	String	1	C	C/S Customer/Supplier
acAddress1	String	30		If over 30 chars will word wrap to next line
acAddress2	String	30		If over 30 chars will word wrap to next line
acAddress3	String	30		If over 30 chars will word wrap to next line
acAddress4	String	30		If over 30 chars will word wrap to next line
acAddress5	String	30
acPostcode	String	20
acAddCountryCode	String	2		GB, US etc. Defaults to GB
acAltCode	String	20		Alt Search code for external systems
acArea	String	4
acBankAcc	String	20
acBankRef	String	28
acBankSort	String	15
acCCEnd	Date			Credit Card end date
acCCName	String	50		Credit Card info
acCCNumber	String	30		Credit Card info
acCCStart	Date			Credit Card start date
acCCSwitch	String	4		Credit Card info
acCode	String	6		Account ID. Required, but not if set to match by acAltCode
acCompany	String	45		Company Name
acContact	String	25		Contact Name
acCOSGL	Integer		†	Cost Of Sales GL
acCostCentre	String	3		Default Analysis code
acCreditLimit	Decimal
acCurrency	Integer		1 †	0-29,1=Sterling
acDatedNotes_AlarmDate	Date		♦	Add date notes to account
acDatedNotes_Note	String	65	♦	Add date notes to account
acDatedNotes_User	String	10	♦	Add date notes to account
acDefSettleDays	Integer			Settlement give if less than x days
acDefSettleDisc	Integer			Settlement discount percent
acDefTagNo	Integer			Default Tag no
acDelAddress1	String	30		Delivery Address, If over 30 chars will word wrap to next line
acDelAddress2	String	30		Delivery Address, If over 30 chars will word wrap to next line
acDelAddress3	String	30		Delivery Address, If over 30 chars will word wrap to next line
acDelAddress4	String	30		Delivery Address, If over 30 chars will word wrap to next line
acDelAddress5	String	30		Delivery Address
acDelPostcode	String	20		Delivery Postcode
acDelCountryCode	String	2		GB, US etc Defaults to GB
acDepartment	String	3		Default Analysis code
acDirDebMode	Integer
acDiscount	Decimal			Discount Percent 0.1=10%
acDiscountBand	String	1		Discount Band A-H
acDocDeliveryMode	Integer			see SDK Notes
acDrCrGl	Integer		†	Control GL
acEBusPword	String	20
acECMember	Boolean			Yes/No/True/False/1/0
acEmailAddr	String	100
acFax	String	30
acFormSet	Integer			Default forms
acGeneralNotes	STRING			Word Wrapped General notes Not exported if CSV First 500 chrs, "<br/>" is used for new line This gets appended to notes on every update
acInvoiceTo	String	6		Send Invoice to account code
acLinkDoc1_Description	String	60		Add Linked document
acLinkDoc1_FileName	String	84		Add Linked document
acLinkDoc2_Description	String	60		Add Linked document
acLinkDoc2_FileName	String	84		Add Linked document
acLocation	String	3	†	Default Location
acMatchByExternalRef	Boolean			If Yes then: Identify account record based on acAltCode Set to Yes if using an external system with long account codes If Yes then will automatically generate acCode if not specified according to AUTOCreateAccountFormat system setting
acOLECode	String	6	♦	If different from system settings then will change company
acOrderConsolidationMode	Integer			see SDK Notes
acPayTerms	Integer			Pay days for default due date
acPayType	String	1		B=Bank,C=Cheque,3,2
acPhone	String	30
acPhone2	String	30
acPostCode	String	20
acSalesGL	Integer		†	Default Sales GL
acSSDDeliveryTerms	String	5		Intrastat details
acSSDModeOfTransport	Integer			Intrastat details
acStateDeliveryMode	Integer			see SDK Notes
acStatementTo	String	6		Send Statement to account code
acTheirAcc	String	10
acTradeTerms1	String	60
acTradeTerms2	String	60
acUseForEBus	Boolean			Yes/No/True/False/1/0 NOT SUPPORTED as crashes the Toolkit
acUserDef1-2	String	20
acUserDef3-10	String	30
acVATCode	String	1	†	S,Z,E,1,2,3,4,5,6,7,8,9,A,D,T,X
acVATRegNo	String	30

† = These fields are defined as string in DTD to allow for conversion in PostTrans

♦ Not exported in Pro version, import only

For Example, for Exchequer Software Account update, in XML

<?xml version="1.0" ?>

<acCompany>Comtek Accounts</acCompany >

<acAddress1>Venture House</acAddress1>

<acAddress2>Venture Court</acAddress2>

<acAddress3>Bolness Rd.</acAddress3>

<acAddress4>Wisbech</acAddress4>

<acAddress5>Cambs</acAddress5>

<acContact>Sam Smith</acContact>

<acGeneralNotes>General Note can be imported against the Account/Transaction

</acGeneralNotes>

</Account>

</ExchequerData>

More examples included with test program

Long external account numbers

if <MatchOnID>acAltCode</MatchOnID> is on system settings, then XML eGateway will create a new account using AltCode as the ID for that account. This allows XML eGateway to handle long account numbers (20 chrs) held in external systems. The acCode can optional be specified in this case. If not specified XML eGateway will assign a new Exchequer account code, automatically according to the rules in system setting

<AUTOCreateAccountBasedOn>acCompany</AUTOCreateAccountBasedOn>

Important: It is advisable to make sure the account codes generated do not clash with the opposing ledger.