Export master data and journal entries

Run the Export master data and journal entries process to export master data from Isah (customers, suppliers, and the like) and journal entries created in Isah to an external financial application.

When exporting the master data and journal entries, Isah uses the settings specified on the Export/import and Financial databases tabs of the Financial form. If these forms do not contain any settings, or contain insufficient or incorrect settings, the data cannot be exported correctly or cannot be exported at all.

All exported journal entries will have a check mark in the Exported column on the Journal entries form. Also, the following columns on the Journal entries form are filled automatically:

The individual fields of each export table are described. The fields indicate the information available to the financial system when the fields are processed in the financial system.

Export data	Countries
Export table	T_Country
Stored proc export	IP_sel_CountryExportSet
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
CountryCode	Country code
Description	Description
ECMemberInd	EU member indicator

Export data	Currency
Export table	T_Currency
Stored proc export	IP_sel_CurrencyExportSet
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
CurrCode	Currency code
Description	Description
ExchRate	Exchange rate
BasicExchRateCurrCode	Base currency code
CurrConvertUnit	Exchange rate per
EMUCurrInd	EMU currency indicator
Sign	Currency symbol
ExchRateI	ExchRate x 1000000, numeric
ExchRateD	ExchRate x 1000000, integer

Export data	Delivery conditions
Export table	T_DeliveryTerm
Stored proc export	IP_sel_DeliveryTermExportSet
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
DelTermCode	Delivery condition code
Description	Description

Export data	Languages
Export table	T_Language
Stored proc export	IP_sel_LanguageExportSet
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
LangCode	Language code
Description	Description

Export data	Price list
Export table	T_PriceList
Stored proc export	IP_sel_PriceListRecordSet
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
PriceListCode	Price list code
Description	Description
PriceListType	Price list type (purchase, sales or calculation)

Export data	VAT codes
Export table	T_VAT
Stored proc export	IP_sel_VATExportSet
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
VATCode	VAT code
Perc	Percentage

Export data	Financial VAT codes
Export table	T_VATFin
Stored proc export	IP_sel_VATFinExportSet
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
VATFinCode	Financial VAT code
Description	Description
VATCode	VAT code
Perc	Percentage
LedgerCode	VAT ledger account
VATFinType	Financial type VAT code

Export data	Supplier groups
Export table	T_CustVendGrp
Stored proc export	IP_sel_VendGrpExportSet
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
Acct_Type	"CRD"
CustVendGrpCode	Supplier group code
Description	Description
CreditorLedgerCode	Creditor summary account

Export data	Customer groups
Export table	T_CustVendGrp
Stored proc export	IP_sel_CustGrpExportSet
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
Acct_Type	"DEB"
CustVendGrpCode	Customer group code
Description	Description
DebtorLedgerCode	Debtor summary account

Export data	Suppliers
Export table	T_Vendor
Stored proc export	IP_sel_VendorExportSet
Input parameters	@UpdatedSince
Fields:		Field (DBF format)
ExtAdminCode	External administration code	EXTADMINCO
ExtBookYear	Export year	EXTBOOKYEA
VendId	Supplier code	VENDID
Mnem	Alias	MNEM
Sub_Nr	VendId + "2"	SUB_NR
Src_Code	SubString(ve.Mnem, 1, 4) + VendId + "2"	SRC_CODE
Acct_Type	"CRD"	ACCT_TYPE
Acct_Link	"3"	ACCT_LINK
Cred_Show	Convert(bit,1)	DEB_SHOW
Name	Supplier name	ACCT_NAME
NameExt	Supplier name, additional	ADDRESS1
Addr	Address	ADDRESS2
Addr2	Address line 2	ADDR2
Addr3	Address line 3	ADDR3
Postcode	ZIP code	POST_CODE
City	Town/city	CITY
CountryCode	Country code	COUNTRYCOD
ISOCountryCode	ISO country code	ISOCOUNTRY
Country	Country description	COUNTRY
Phone	Phone number	TELEPHONE
Fax	Fax	TLX_FAX
Email	Email address	EMAIL
CredLimit	Credit limit	CRED_LIM
CurrCode	Currency code	CUR_CODE
LangCode	Language code	LNG_CODE
Grpcode	Supplier group code	RPL_GRP
VATnr	VAT number	VAT_NR
PaymTermCode	Payment condition code	DISC_CODE
DelTermCode	Delivery condition code	DELTERMCOD
PriceListCode	Price list code	PRICELISTC
VATFinCode	Financial VAT code	VAT_CODE
DebtorLedgerCode	Summary account - Debtors	ACCT_NR
Seller	Seller	SELLER
WebSiteAddr	Website URL	WEBSITEADD
VendRelCode	Relation code (VendorRelation)	VENDRELCOD
RelationName	Relation's name	RELATIONNA
MobilePhone	Relation's mobile number	MOBILEPHON
VendCustRef	Customer code	VENTCUSTRE
BankAccount	Bank account 1	BANKACCOUN
IBAN	IBAN 1	IBAN1
BankId	Bank code 1	BANK1ID
Bank.BIC	BIC 1	BANK1BIC
Bank.Name	Bank name 1	BANK1NAME
Bank.Address1	Bank 1 address	BANK1ADDRE
Bank.Address2	Bank 1 address 1	BANK1ADDR1
Bank.Address3	Bank 1 address 2	BANK1ADDR2
Bank.PostCode	Bank 1 ZIP code	BANK1POSTC
Bank.City	Bank 1 town/city	BANK1CITY
Bank.Countrycode	Bank 1 country	BANK1COUNT
ISOCountryCode	Bank 1 ISO country code	BANK1ISOCO
Country.Description	Bank 1 country description	BANK1COUN1
BankAccount	Bank account 2	BANKACCOU1
IBAN	IBAN 2	IBAN2
BankId	Bank code 2	BANK2ID
Bank.BIC	BIC 2	BANK2BIC
Bank.Name	Bank name 2	BANK2NAME
Bank.Address1	Bank 2 address	BANK2ADDRE
Bank.Address2	Bank 2 address 1	BANK2ADDR1
Bank.Address3	Bank 2 address 2	BANK2ADDR2
Bank.PostCode	Bank 2 ZIP code	BANK2POSTC
Bank.City	Bank 2 town/city	BANK2CITY
Bank.Countrycode	Bank 2 country	BANK2COUNT
ISOCountryCode	Bank 2 ISO country code	BANK2ISOCO
Country.Description	Bank 2 country description	BANK2COUN1
BankAccount	Blocked bank account	BLOCKEDBAN
IBAN	Blocked IBAN	BLOCKEDIBA
BankId	Blocked bank code	BLOCKEDBA1
Bank.BIC	Blocked BIC	BLOCKEDBA2
Bank.Name	Blocked bank name	BLOCKEDBA3
Bank.Address1	Blocked bank address	BLOCKEDBA4
Bank.Address2	Blocked bank address 1	BLOCKEDBA5
Bank.Address3	Blocked bank address 2	BLOCKEDBA6
Bank.PostCode	Blocked bank ZIP code	BLOCKEDBA7
Bank.City	Blocked bank town/city	BLOCKEDBA8
country Bank.Countrycode	Blocked bank	BLOCKEDBA9
ISOCountryCode	Blocked bank ISO country code	BLOCKEDB10
Country.Description	Blocked bank country description	BLOCKEDB11
BankAccount	Giro account	CLEARINGAC
IBAN	Giro IBAN	CLEARINGIB
BankId	Giro bank code	CLEARINGBA
Bank.BIC	Giro BIC	CLEARINGBI
Bank.Name	Giro bank name	CLEARINGNA
Bank.Address1	Giro bank address	CLEARINGAD
Bank.Address2	Giro bank address 1	CLEARINGA1
Bank.Address3	Giro bank address 2	CLEARINGA2
Bank.PostCode	Giro bank ZIP code	CLEARINGPO
Bank.City	Giro bank town/city	CLEARINGCI
Bank.Countrycode	Giro bank country	CLEARINGCO
ISOCountryCode	Giro bank ISO country code	CLEARINGIS
Country.Description	Giro bank country description	CLEARINGC1

Export data	Banks
Export table	T_Vendor
Stored proc export	IP_sel_BankExportSet
Fields:
VendId	Supplier code (bank code)
Name	Name
Addr	Address
Addr2	Address2
Addr3	Address3
PostCode	ZIP code
City	Town/city
CountryCode	Country code
Country	Country description
BankInfo	Bank information (SWIFT code)
Selection	Remark
BankAccount	Account number
ClearingAccount	Giro account number

Export data	Customers
Export table	T_Customer
Stored proc export	IP_sel_CustomerExportSet
Input parameters	@UpdatedSince, @CustomerAddrType
Fields:		Field (DBF format)
ExtAdminCode	External administration code	EXTADMINCO
ExtBookYear	Export year	EXTBOOKYEA
CustId	Customer code	CUSTID
Mnem	Alias	MNEM
Sub_Nr	CustId + "1"	SUB_NR
Src_Code	SubString(ve.Mnem, 1, 4) + CustId + "1"	SRC_CODE
Acct_Type	"DEB"	ACCT_TYPE
Acct_Link	"2"	ACCT_LINK
Deb_Show	Convert(bit,1)	DEB_SHOW
Name	Customer name	ACCT_NAME
NameExt	Customer name, additional	ADDRESS1
Addr	Address	ADDRESS2
Addr2	Address line 2	ADDR2
Addr3	Address line 3	ADDR3
Postcode	Postcode	POST_CODE
City	Town/city	CITY
CountryCode	Country code	COUNTRYCOD
ISOCountryCode	ISO country code	ISOCOUNTRY
Country	Country description	COUNTRY
Phone	Phone number	TELEPHONE
Fax	Fax	TLX_FAX
Email	Email address	EMAIL
CredLimit	Credit limit	CRED_LIM
CurrCode	Currency code	CUR_CODE
LangCode	Language code	LNG_CODE
Grpcode	Customer group code	RPL_GRP
VATnr	VAT number	VAT_NR
PaymTermCode	Payment condition code	DISC_CODE
DelTermCode	Delivery condition code	DELTERMCOD
PriceListCode	Price list code	PRICELISTC
VATFinCode	Financial VAT code	VAT_CODE
DebtorLedgerCode	Summary account - Debtors	ACCT_NR
Seller	Seller	SELLER
WebSiteAddr	Website URL	WEBSITEADD
CustRelCode	Relation code (CustomerRelation)	CUSTRELCOD
RelationName	Relation's name	RELATIONNA
MobilePhone	Relation's mobile number	MOBILEPHON
VendCustRef	Supplier code	CUSTVENDRE
COCnr	Chamber of Commerce number	COCNR
BankAccount	Bank account 1	BANKACCOUN
IBAN	IBAN 1	IBAN1
BankId	Bank code 1	BANK1ID
Bank.BIC	BIC 1	BANK1BIC
Bank.Name	Bank name 1	BANK1NAME
Bank.Address1	Bank 1 address	BANK1ADDRE
Bank.Address2	Bank 1 address 1	BANK1ADDR1
Bank.Address3	Bank 1 address 2	BANK1ADDR2
Bank.PostCode	Bank 1 ZIP code	BANK1POSTC
Bank.City	Bank 1 town/city	BANK1CITY
Bank.Countrycode	Bank 1 country	BANK1COUNT
ISOCountryCode	Bank 1 ISO country code	BANK1ISOCO
Country.Description	Bank 1 country description	BANK1COUN1
BankAccount	Bank account 2	BANKACCOU1
IBAN	IBAN 2	IBAN2
BankId	Bank code 2	BANK2ID
Bank.BIC	BIC 2	BANK2BIC
Bank.Name	Bank name 2	BANK2NAME
Bank.Address1	Bank 2 address	BANK2ADDRE
Bank.Address2	Bank 2 address 1	BANK2ADDR1
Bank.Address3	Bank 2 address 2	BANK2ADDR2
Bank.PostCode	Bank 2 ZIP code	BANK2POSTC
Bank.City	Bank 2 town/city	BANK2CITY
Bank.Countrycode	Bank 2 country	BANK2COUNT
ISOCountryCode	Bank 2 ISO country code	BANK2ISOCO
Country.Description	Bank 2 country description	BANK2COUN1
BankAccount	Blocked bank account	BLOCKEDBAN
IBAN	Blocked IBAN	BLOCKEDIBA
BankId	Blocked bank code	BLOCKEDBA1
Bank.BIC	Blocked BIC	BLOCKEDBA2
Bank.Name	Blocked bank name	BLOCKEDBA3
Bank.Address1	Blocked bank address	BLOCKEDBA4
Bank.Address2	Blocked bank address 1	BLOCKEDBA5
Bank.Address3	Blocked bank address 2	BLOCKEDBA6
Bank.PostCode	Blocked bank ZIP code	BLOCKEDBA7
Bank.City	Blocked bank town/city	BLOCKEDBA8
country Bank.Countrycode	Blocked bank	BLOCKEDBA9
ISOCountryCode	Blocked bank ISO country code	BLOCKEDB10
Country.Description	Blocked bank country description	BLOCKEDB11
BankAccount	Giro account	CLEARINGAC
IBAN	Giro IBAN	CLEARINGIB
BankId	Giro bank code	CLEARINGBA
Bank.BIC	Giro BIC	CLEARINGBI
Bank.Name	Giro bank name	CLEARINGNA
Bank.Address1	Giro bank address	CLEARINGAD
Bank.Address2	Giro bank address 1	CLEARINGA1
Bank.Address3	Giro bank address 2	CLEARINGA2
Bank.PostCode	Giro bank ZIP code	CLEARINGPO
Bank.City	Giro bank town/city	CLEARINGCI
Bank.Countrycode	Giro bank country	CLEARINGCO
ISOCountryCode	Giro bank ISO country code	CLEARINGIS
Country.Description	Giro bank country description	CLEARINGC1

Export data	Journal entries
Export table	T_FinJournal
Stored proc export	IP_sel_FinJournalExportSet
Input parameters:
@FromFinJournalGrpCode	From journal entry category
@ToFinJournalGrpCode	To journal entry category
@FromFinJournalDate	From journal date
@ToFinJournalDate	To journal date
@FinJournalPeriodType	Period type (entered manually or based on period table)
@ExtBookYear	Fiscal year
@FinJournalPeriod	Fiscal period
@FinAdminCode	Financial administration code
@ExportToAllocatedAdminsInd	Export to specified financial administration code
@IsahUserCode	User name
@LogProgramCode	Program code
@InitLogDate	OUTPUT: Export date
@ExportNr	OUTPUT: Export number
Fields:
ExtAdminCode	External administration code
ExtBookYear	Export year
FinJournalCode	Journal line number (unique)
FinJournalNr	Journal
Period	Period
FinJournalGrpCode	Journal entry category
FinJournalTypeCode	Journal entry type
FinJournalDate	Journal date
BookNr	Entry number
LedgerCode	Ledger account
CostCenterCode	Cost center
ExportSpecification	Description
CurrCode	Currency code
VATFinCode	Financial VAT code
FinJournalType	Journal type
CurrExclVATAmount	Sum excluding VAT
CurrVatAmount	VAT sum
CurrInclVatAmount	Sum including VAT
ExchRate	Exchange rate
CurrConvertUnit	Exchange rate per
BasicCurrExclVATAmount	Sum in base currency excluding VAT
BasicCurrVatAmount	VAT sum in base currency
BasicCurrInclVatAmount	Sum in base currency including VAT
CustId	Customer code
VendId	Supplier code
PaymTermCode	Payment condition
TermOfPaym	Payment days
TermOfCred	Credit charge payment days
CredPerc	Credit charge percentage
InvCode	Invoice code
InvLineNr	Invoice line number
PurInvCode	Purchase invoice code
PurInvLineNr	Purchase invoice line number
VATCode	Financial VAT code
VATPerc	VAT percentage
DossierCode	File code
ProdHeaderDossierCode	Production file code
DetailCode	Sales line
DetailSubCode	Sales subline
ShipDocCode	Shipping note
ShipLineNr	Shipping note line number
ToolCode	Equipment code
ExtOperCode	External operation code
ProdBOMLineNr	Part calculation line
ProdBOTLineNr	Equipment calculation line
ProdBOELineNr	External operation calculation line
PurDocCurrCode	Purchase order currency code
CurrFormerFrozenCostPrice	Old FVP currency code
CurrFrozenCostPrice	FVP currency code
FormerInvtQty	Previous stock quantity
InvtQty	Stock
CurrPurPrice	Purchase price
FixedPurCost	Fixed purchase costs
PartGrpCode	Part group code
BurdenCode	Coverage code
PartCode	Part code
QuotNr	Offer code
OrdNr	Order code
CustVendId	Customer/supplier code
Inv_Nr	Invoice code
ExchRateI	Exchange rate x 1000000, numeric
ExchRateD	Exchange rate x 1000000, integer
ScenarioCode	Scenario code
ExportNr	Export number
InvoiceDate	Invoice date
TermOfPayInvoiceDate	Payment date based on invoice date
InvoicePayDate	Payment date
VendInvCode	Supplier code
FinAdminCode	Administration code of financial application
ReverseChargeVATCode	Reverse-charged VAT code
ReverseChargeVATPerc	Reverse-charged VAT percentage

Export data	Marking exported journal entries as Final
Export table	T_FinJournalExportBusy & T_FinJournal
Stored proc export	IP_upd_FinJournalExport
Description	Table containing "journal entries for export" T_FinJournalExportBusy Procedure to be used for marking journal entries in T_FinJournal as "exported" and/or emptying the table TFinJournalExportBusy (either completely or by book number/type) IP_upd_FinJournalExport
Input parameters:
@FromFinJournalGrpCode	From journal entry category
@ToFinJournalGrpCode	To journal entry category
@FromFinJournalDate	From journal date
@ToFinJournalDate	To journal date
@FinJournalPeriodType	Period type (entered manually or based on period table)
@ExtBookYear	Fiscal year
@FinJournalPeriod	Fiscal period
@FinAdminCode	Financial administration code
@BookNr	Entry number
@FinJournalGrpCode	Journal entry category
@Exported	Exported
@ExportPeriod	Export period
@ExportYear	Export year
@ExportFinAdminCode	Export of financial administration code
@IsahUserCode	Isah user name
@LogProgramCode	Program code
@InitLogDate	Processing date
@ExportNr	Export number

Export number:	Filled with a unique number for the relevant export
Export period:	Filled with the fiscal period based on the fiscal period table and the journal date
Export year:	Filled with the fiscal year based on the fiscal period table and the journal date
Database code of financial application:	Based on the specified financial database
Export user:	(not visible on the form)
Export date and time:	(not visible on the form)