Alpha numeric identification of the entity Numeric identification of the entity To indicate if this is the default (main) entry in a collection (e.g. default="1") Label for user-defined fields Alpha numeric identification of the entity Notes can contain all kind of weird codes, makes sure to use a CDATA section ItemNumbers.ID Date: YYYY-MM-DD Date - Time YYYY-MM-DD HH:MM:SS Start Date: YYYY-MM-DD. Time is optional here; if it must be included then enter the time in the format HH:MM:SS and seperate the two parts with a capital 'T': YYYY-MM-DDTHH:MM:SS. However, please note that when the time part is included validation of this tag will fail when using the XML validator (import will not fail, of course...). End Date: YYYY-MM-DD. Time is optional here; if it must be included then enter the time in the format HH:MM:SS and seperate the two parts with a capital 'T': YYYY-MM-DDTHH:MM:SS. However, please note that when the time part is included validation of this tag will fail when using the XML validator (import will not fail, of course...). gbkmut.docdate xxx land.oms60 *land.landcode valuta.oms30 *valuta.valcode *valuta.active taal.oms30 *taal.taalcode N/A *N/A ItemCountries.AvailableFrom ItemCountries.AvailableUntil field User defined: Text field User defined: Date field User defined: Number field User defined: YesNo (boolean) field User defined: YesNo (boolean) field Mandatory in: GLAccounts grtbk.oms25 grtbk.kstplrek grtbk.kstdrrek grtbk.aantallen grtbk.UseItem grtbk.UseResource grtbk.UseProject grtbk.act_rek grtbk.afletteren grtbk.std_kstpl grtbk.std_kstdr grtbk.btw_code AccountClasses.Description *AccountClasses.ClassID (1..10) *AccountClasses.ItemClassCode gbkmut.reknr_naf grtbk.accountReportCategory (Cash Flow Statement) *grtbk.reknr Mandatory in: GLAccounts B=Balance. W=Profit - Loss A=Asset Account, B=Bank Account, C=Creditor Account, D=Debtor Account, G=Stock Account, H=Human resource Account, J=Revenue Account, K=Expense Acccount, N=Neutral Account, S=Cash Account, T=Suspence Account, V=VAT Account Mandatory in: GLAccounts D=Debit, C=Credit, G=None J=Yes, L=Empty, N=No To indicate if this GL Account is blocked, e.g. blocked="1") N=None, I=Inflation percentage, A=Agreement percentage I=Purchase, V=Sales, N=N/A G=Goods, D=Services, I=Investments, O=N/A, A=Always update VAT return C='Commission, broker''s fees, refunds, etc., E=Honorary fees or attendance fees, K=Expenses incurred by the beneficiary,V=Benefits in kind N=N/A humres.maiden_name humres.iso_taalcd humres.nat humres.mar_dat humres.mar_stat D=Divorced, L=Living together, M=Maried, S=Single hrloc.descr50 hrloc.telnr hrloc.faxnr humres.hrloc N/A humres.kamer humres.telnr_werk humres.toestel N/A humres.telnr_werk2 humres.mobile_short humres.mail humres.telnr_prv2 humres.email humres.geb_ldat humres.geb_pl humres.identiteit humres.ldatindienst humres.ldatuitdienst humres.cont_end_date humres.fte (tag goes obsolete) humres.rating humres.funcnivo humres.blocked humres.representative Mandatory in: Resources Mandatory in: Resources humres.comp Mandatory in: Resources humres.costcenter humres.kstdr_code Mandatory in: Resources humres.job_title Mandatory in: Resources humres.repto_id N/A humres.task humres.job_level hrroledefs.Description hrroledefs.id hrroles.rolelevel 1=Corporate, 2=Group, 3=Division, 4=Cost center group, 5 =Cost center, 10=Reseller humres.Scale humres.socsec_nr (tag goes obsolete) humres.crcard_expd humres.crcard_no humres.crcard_type A=American Express, M=Mastercard, V=VISA *humres.res_id Mandatory in: Resources humres.usr_id Mandatory in: Resources humres.emp_type A=Applicant, C=Contractor, E=Employee, R=Reseller, S=Student, T=Tempory, V=Vacancy humres.emp_stat A=Active, H=Hired, I=Exit, F=Fulfilled, R=Rejected, T=Future humres.mv1 Mandatory in: Accounts cicmpy.cmp_name cicmpy.cmp_e_mail cicmpy.cmp_web Mandatory in: Accounts Mandatory in: Accounts cicmpy.cmp_acc_man Used to match with the account in the relations system cicmpy.ChangeVATCode cicmpy.VATNumber cicmpy.ExemptNumber cicmpy.PaymentMethod cicmpy.PaymentCondition cicmpy.DeliveryMethod cisect.ml_desc *cisize.siz_code cicmpy.cmp_rating cisect.ml_desc SubSectors.Description *SubSectors.SubSectorID *cisect.sct_code cicmpy.Category01 to cicmpy.Category15 cicmpy.PayeeName cicmpy.DunsNumber *cicmpy.cmp_code cicmpy.cmp_wwn Mandatory in: Accounts cicmpy.cmp_type A=Associate, B=Bank, C=Customer, D=Division, E=Employee, L=Lead, N=Not validated, P=Prospect, R=Reseller, S=Supplier, T=Suspect Mandatory in: Accounts cicmpy.cmp_status A=Active, B=Blocked, E=Exit, N=Not validated, P=Pilot, R=Reference, S=Passive Type of account code for parent account Type of account code for parent account. The account will be either with account code only, debtor code or creditor code. C=Creditor code, D=Debtor code, A=Account code only F=Fixed assets, N=Non-financial, B=Batch, C=Contract, S=Sales Investment Date: YYYY-MM-DD Asset.residualValue A=Active, G=Not validated, D=Exit, C=Depreciated, B=Blocked, S=Sold P=Purchased, H=Hire purchase, R=Rented, L=Leased, E=Leasehold, D=Produced, O=Other, M=Maintenance Mandatory in: Projects PRProject.Description PRProject.VisibleMember Mandatory in: Projects PRProject.Security Mandatory in: Projects PRProject.InitialStartDate Mandatory in: Projects PRProject.InitialEndDate PrProject.Labour; C=Percentage of completion of costs, R=Percentage of completion of revenue, K=Completed contract method, S=Cost of sales method, N=No, P=To be Invoiced, D=Production Mandatory in: Projects PRProject.ProductLine PRProject.ItemCode Mandatory in: Projects PRProject.Responsible Mandatory in: Projects PRProject.IDJobGroup PRProject.IDCustomer Mandatory in: Projects PRProject.Image PRProject.Memo PRProject.ProjectNr Mandatory in: Projects PRProject.Type F=Fixed, H=Hourly, I=Internal, P=Production, O=Outsourced, T=Training PRProject.Status B=Blocked, A=Active, C=Completed, P=Proposed Mandatory in: Accounts Addresses.AddressLine1 Addresses.AddressLine2 Addresses.AddressLine3 Addresses.Postcode Mandatory in: Accounts Addresses.City Addresses.StateCode AddressStates.Description *Addresses.StateCode Mandatory in: Accounts Addresses.Country Addresses.Phone Addresses.Fax Addresses.Email Mandatory in: Accounts Addresses.Type AddressTypes.Description hrloc.descr50 hrloc.telnr hrloc.faxnr *hrloc.loc pred.aan_oms pred.aanhef pred.abbreviation *pred.predcode hrfree.decr60 *hrfree.reckey hrjbtl.decr50 hrjbtl.job_level hrjbtl.job_grp hrjbtl.vert_grp hrfree.decr60 *hrfree.reckey *hrjbtl.job_title BR 20.061.164:Change to optional BR 25.053.153, add ank creditor as this is a mandatory field in business component bnkacc.accncd accncd.oms_40 accncd.accnmask accncd.proeftype DDTests.Description *DDTests.DatabaseChar *accncd.accncd accncd.proeftype E=Elfproef, the Netherlands, G=Giro number, the Netherlands, B=97-test, Belgium, U=14 digits, UK, T=20 digits, UK, R=14 digits, UK, X=14 digits, UK, D=Kontonummer, Germany, F=La cle RIB, France, S=Codigo ,Cuenta Cliente, Spain, I=Bank account, Russia, Y=CDV 24 digits 8-16, Hungary, Z=CDV 24 digits 8-8-8, Hungary, K=Elfproef (blocked), the Netherlands, O=Giro number (blocked), the Netherlands, V=16 digits, Czech with specific symbol, W=16 digits, Czech, C=Kontonummer (EURO), Germany, J=Italian Bank Association, A=Bankgirot Sweden, H=Postgirot Sweden, P=Norwegian giro account number, L=Norwegian bank account number, M=IBAN, 0=Participant number, 5 digits, 1=Participant number, 9 digits, 2=Finnish bank account number, N=No check bnkacc.valcode bnkacc.bankcode bnkacc.naam bnkacc.swiftadres bnkacc.bank_rek *bnkacc.banknr 1|0 I=Purchase basis, V=Sales basis, A=VAT to pay, R=Extra duty to pay, O=VAT to claim, T=Total P=Positive, N=Negative *btwtrs.btwtrans btwtrs.code_iv V=Sales, I=Purchase, B=Both btwtrs.exclus E=Excluding, I=Including, N=N/A N/A rates.source_currency rates.target_currency rates.date_l rates.rate_exchange rates.rate_official I=Purchase basis, V=Sales basis, A=VAT to pay, R=Extra duty to pay, O=VAT to claim, T=Total P=Positive, N=Negative *btwtrs.btwtrans btwtrs.code_iv V=Sales, I=Purchase, B=Both btwtrs.exclus E=Excluding, I=Including, N=N/A I=Purchase basis, V=Sales basis, A=VAT to pay, R=Extra duty to pay, O=VAT to claim, T=Total P=Positive, N=Negative *btwtrs.btwtrans btwtrs.code_iv V=Sales, I=Purchase, B=Both btwtrs.exclus E=Excluding, I=Including, N=N/A I=Purchase basis, V=Sales basis, A=VAT to pay, R=Extra duty to pay, O=VAT to claim, T=Total P=Positive, N=Negative *btwtrs.btwtrans btwtrs.code_iv V=Sales, I=Purchase, B=Both btwtrs.exclus E=Excluding, I=Including, N=N/A I=Purchase basis, V=Sales basis, A=VAT to pay, R=Extra duty to pay, O=VAT to claim, T=Total P=Positive, N=Negative *btwtrs.btwtrans btwtrs.code_iv V=Sales, I=Purchase, B=Both btwtrs.exclus E=Excluding, I=Including, N=N/A S=Sales, P=Purchase An amount in the default currency. S=Sales, P=Purchase An amount in a foreign currency. S=Sales, P=Purchase *ItemUnits.Unit L=Length, W=Weight, T=Time, O=Other S=Sales, P=Purchase kstpl.oms25 kstpl.ext_dlnivo CostcenterClasses.Description CostcenterClasses.ClassId CostcenterClasses.CostCenterClassCode *kstpl.kstplcode kstdr.oms25 *kstpl.kstdrcode bedryf.bedrnm bedryf.valcode *bedryf.bedrnr cicntp.taalcode cicntp.cnt_dept Mandatory in: Accounts cicntp.cnt_job_desc cicntp.cnt_f_tel cicntp.cnt_email cicntp.cnt_id N/A 1|0 A=Active, E=Exit *betcd.betcond N=Other,K=Sales invoice,C=Sales credit note,T=Purchase invoice,Q=Purchase credit note,Z=Cash receipt,Y=Payment,R=Refund,P=Prepayment,S=Reversal credit note,D=Debit memo/Financial charge, F=Discount/Surcharge,M=Machine hours,L=Labor hours,E=Revaluation,A=Receipt,B=Fulfillment,G=Counts,H=Return fulfillment,J=Return receipt,W=Payroll,O=POS Sales Invoice,X=Year/Period Closing,U=Credit surcharge B=On credit, K=Cash, R=Credit card, C=Cheque, W=Letter of credit, I=Collection, O=Debt collection, F=Factoring, P=Payment on delivery, S=Settle, V=ESR payments, Y=ES payments, X=Payments in CHF and FC, E=EFT, H=Chipknip, M=Not accepted letter of credit, N=Promissory note BR 20.061.164:Change to optional The maximum length of the number attribute is 6. If code is filled, then number can be left empty. cicmpy.Currency cicmpy.InvoiceDebtor cicmpy.cmp_name cicmpy.CreditLine cicmpy.Discount cicmpy.DateLastReminder A=Yes, B=Back order, N=No cicmpy.AllowPartialShipment cicmpy.AllowBackOrders cicmpy.debcode cicmpy.debnr A=Associate, B=Bank, C=Customer, D=Division, E=Employee, L=Lead, N=Not validated, P=Prospect, R=Reseller, S=Supplie, T=Suspect The maximum length of the number attribute is 6. If code is filled, then number can be left empty. cicmpy.Currency cicmpy.CreditLine cicmpy.Discount cicmpy.crdcode *cicmpy.crdnr A=Associate, B=Bank, C=Customer, D=Division, E=Employee, L=Lead, N=Not validated, P=Prospect, R=Reseller, S=Supplier Item code, used for external references. ordlev.oms40 ordlev.direct_shipping *ordlev.levwijze N=Normal, C=Collected by receiver, P=Shipped by postal service including postal label, O=Other, E=Express Mandatory in: Items ItemAssortment.Description *ItemAssortment.Assortment *ItemAssortment.Code Mandatory in: Items Items.Description Items.Assortment ItemCountries.AvailableFrom/Until Items.Condition, BacoDiscussionFixedTypes.It_Status A=Active, B=Blocked, D=Discontinued, F=Future, E=Inactive Mandatory in: Items Items.IsSalesItem Items.IsPurchaseItem Items.IsSerialNumberItem Items.IsBatchItem Items.IsSubAssemblyItem Items.IsAssembledItem Items.IsStockItem Items.IsBackOrderItem Items.IsFractionAllowedItem Items.IsPriceRegulationItem Items.IsTextItem Items.IsDiscountItem Items.IsExplodeItem Items.IsPrintItem Items.RequiresApprovedSupplier ItemCountries.Note ItemClasses.Description *ItemClasses.ClassID (1..10) *ItemClasses.ItemClassCode Items.IsServiceItem *Items.ItemCode Items.Type S=Standard, B=Bulk, C=Contract, L=Labor hours, M=Machine hours, P=Phantom, R=Reason codes *Items.SearchCode P=Period, Y=Year Y=Yearly, P=Periodically, D=Daily To define the depreciation percentage for each periodes dagbk.oms25 dagbk.afk dagbk.valcode dagbk.reknr gbkmut.verwerknrl *dagbk.dagbknr B=Bank, G=Giro, I=Purchase, K=Cash, M=General Journal, T=Prepayments and Accruals, V=Sales BR 20.061.164:Change to optional BacoDiscussionSubCategory.SubCategory *BacoDiscussionSubCategories.SubCategory BacoDiscussionCategory.Category *BacoDiscussionCategories.Category *BacoDiscussionCategories.ID BacoDiscussionGroups.Description BacoDiscussionGroups.AllowReplies BacoDiscussionGroups.TemplateID *BacoDiscussionGroups.ID BacoDiscussionFixedTypes.VersionType BacoDiscussionFixedTypes.Attachment BacoDiscussionFixedTypes.It_default; Default Item BacoDiscussionFixedTypes.Pr_Default BacoDiscussionFixedTypes.As_Default BacoDiscussionFixedTypes.EditSecurity BacoDiscussionFixedTypes.It_Selection BacoDiscussionFixedTypes.Re_Selection BacoDiscussionFixedTypes.Ac_Selection BacoDiscussionFixedTypes.Pr_Selection BacoDiscussions.Type BacoDiscussions.GroupID BacoDiscussions.Category BacoDiscussions.SubCategory BacoDiscussions.ParentID BacoDiscussions.Subject BacoDiscussions.JobLevel, BacoDiscussionFixedTypes.DefSecurity BacoDiscussions.company BacoDiscussions.LanguageID BacoDiscussions.ProjectNr BacoDiscussions.HumResID BacoDiscussions.CmpWwn BacoDiscussions.Class_01 BacoDiscussions.ItemCode BacoDiscussions.Body Date: YYYY-MM-DD BacoDiscussions.EntryKey SELECT (g.CompanyCode+'.'+CONVERT(VARCHAR,g.bkjrcode)+'.'+LTRIM(g.periode)+'.'+LTRIM(RTRIM(ISNULL(g.bkstnr,'0')))+'.'+LTRIM(RTRIM(ISNULL(g.dagbknr,'0')))) AS Description FROM gbkmut g WHERE g.EntryGUID = ?BacoDiscussions.EntryKey BacoDiscussions.HID BacoDiscussions.ID 0=Standard, 1=Frontpage, 2=Headline Describes the Order / Invoice header elements frsrg.dummy11 V=Sales invoice, I=Commision invoice, B=Direct Invoice V=Sales order, I=Purchase order F=Fixed, H=Time_Material AbsenceTypes.Description *AbsenceTypes.ID Absences.Description Absences.StartDate. Only use when time is not required to be imported; to prevent validation errors use DateTimeStart when time must be included. Absences.EndDate. Only use when time is not required to be imported; to prevent validation errors use DateTimeEnd when time must be included. FC30.440.716 Absences.StartDateActual. Only use when time is not required to be imported; to prevent validation errors use DateTimeStart when time must be included. FC30.440.716 Absences.EndDateActual. Only use when time is not required to be imported; to prevent validation errors use DateTimeEnd when time must be included. FC30.440.716 Absences.DaysActual FC30.440.716 Absences.HoursActual FC30.440.716 Absences.AmountFC FC30.440.716 Absences.AmountFCActual Absences.EmpId Absences.CustomerID Absences.ItemCode *Absences.ItemCode_1 Absences.ItemCount_1 Absences.ItemCode_2 *Absences.ItemCode_2 Absences.ItemCount_2 Absences.HID 0=Open, 1=Approved, 2=Rejected, 3=Processed, 4=Realixed, 5=Draft DDTests.Description B=On credit, K=Cash, R=Credit card, C=Cheque, W=Letter of credit, I=Collection, O=Debt collection, F=Factoring, P=Payment on delivery, V=ESR payments, Y=ES payments, X=Payments in CHF and FC, E=EFT, H=Chipknip, S=To be settled betcd.oms30 betcd.termijn betcd.maanden betcd.dagvmnd betcd.kbdagen betcd.percentag betcd.kbdagen2 betcd.percentag2 *betcd.betcond 1=Date + payment term, 2=Date -> end of the month -> day of the month, 3=Date -> end of the next month -> day of the month, 4=Date + payment term -> end of the month -> day of the month, 5=Date + payment term -> end of the next month -> day of the month, 6=Date + payment term -> x.end of the month -> day of the month, 7=Date + payment term (in months), 8=Date > end of the month + x months, 9=Terms K=Credit surcharge, B=Settlement discount B=Gross, N=Net betcd.brut_net_f; B=Gross, N=Net betcd.termijnen Financial entry line: Detail line of the financial entry gbkmut.datum Date - Time YYYY-MM-DD HH:MM:SS Date - Time YYYY-MM-DD HH:MM:SS gbkmut.reknr gbkmut.oms25 gbkmut.kstplcode gbkmut.kstdrcode gbkmut.debnr gbkmut.crdnr gbkmut.landcode gbkmut.res_id gbkmut.artcode gbkmut.warehouse gbkmut.project gbkmut.aantal gbkmut.tegreknr gbkmut.volgnr_gbk VAT (Value Add Tax) data gbkmut.btw_bdr_3 gbkmut.btw_grond N/A gbkmut.btw_nummer gbkmut.rapnr gbkmut.raplist gbkmut.btw_code *gbkmut.paymentmethod *gbkmut.betcond gbkmut.exvalcode gbkmut.wisselkrs gbkmut.koers3 gbkmut.bkstnr_sub gbkmut.exvalbdr gbkmut.vervdatkrd gbkmut.vervdtkrd2 gbkmut.kredbep gbkmut.bdrkredbep gbkmut.bdrkredbp2 gbkmut.faktuurnr gbkmut.banktransactionid gbkmut.datelastreminder N/A gbkmut.vervdatfak gbkmut.betcond K=Cash, B=Bank, G=Giro, I=Collection, A=Giro collection slip, S=Bacs, W=Bill of exchange, D=Bill of exchange, M=Domiciliation, V=ESR payments, Y=ES payments, X=Payments in CHF and FC, Z=Bank cheques F=E-Invoice, A=E-Account, B=E-Payments, C=E-Bank, I=E-Collection, V=E-Assets, T=recurring entries, H=revaluation, O=opening new FY, K=E-Column, S=E-Cost Allocation, R=E-Stock Purchase, W=B/E accounts, E=IncInvReg., D=closing entry, P=E-Job Cost., L=E-Service Management, M=E-PAS, Y=E-Payroll , U=Budget, X=XML gbkmut.remindercount gbkmut.reminderlayout gbkmut.blockitem gbkmut.dbk_verwnr gbkmut.verwerknrl gbkmut.volgnr5 (tag goes obsolete, replaced by attribute in FinEntryLine) gbkmut.TransactionGuid2 (tag goes obsolete, replaced by attribute in FinEntryLine) gbkmut.docnumber gbkmut.docnumber (tag goes obsolete, replaced by YourRef) gbkmut.docdate gbkmut.stat_nr I=Invoice, P=Payment, T=Pay in installments, N=None, U=Budget, S=Reconcile B=Budget, C=Balance Correction, E=Elimination, F=Fiscal, I=Intercompany, N=Normal (default), O=Obligation, P=Opening balance correction, V=Void, X=Non ledger N=Other, K=Sales invoice, C=Sales credit note, T=Purchase invoice, Q=Purchase credit note, Z=Cash receipt, Y=Payment, R=Reversal, P=Prepayment, S=Reversal credit note, D=Debit memo, F=Financial charge, M=Machine hours, L=Labor hours, E=Revaluation, I=Disposal, V=Depreciation, A=Receipt, B=Fulfillment, G=Counts, H=Return fulfillment, J=Return receipt, W=Payroll A=Transaction in journal account, B=Transaction in account entry line, C=Transaction on exchange differences, D=Collective payment trans., offset entry, E=Collective payment trans., total payment, F=Transaction on write-off code 1, G=Write-off code 2 transaction, H=Write-off code 3 transaction, I=Transaction on write-off code 1, J=Euro calculation difference, K=Transaction in VAT account, L=Transaction in VAT charged account, M=Non-deductible VAT transaction, N=Differences correction transaction, O=Transaction in transit journal, P=Trans. from rev. led./debtors/creditors, Q=Transaction from consolidation, R=Transaction from closing entry, S=Transaction originates from opening B/S, T=Trans. originates from private section, U=Budget, X=Transaction from conversion N/A amutak.docdate (sales and purchase entries) amutak.project (sales and purchase entries) A header amount in foreign currency for sales/purchase journal. E=Entered, O=Posted, P=In Process, V=Void Header of a financial entry. Each financial entry has to be in balance and contains at least 2 detail lines (financial entry lines). The header contains data which are applicable for all financial entry lines which belongs to an header. gbkmut.CompanyCode gbkmut.bkjrcode gbkmut.periode gbkmut.datum Mandatory in: FinEntries gbkmut.dagbknr Mandatory in: FinEntries Entry number of the financial entry. ID to identify the Entry. gbkmut.volgnr5 TransactionGuid from gbkmut (to identify the budgetline). status="V=Free, B=Blocked, A=Active" FC 19.467.193: Add ReportingDate. (gbkmut.docdate) BR19.547.184 and FC19.467.193 FC 22.076.277 gbkmut.transactiontype (tag goes obsolete, is replaced by attribute in FinEntryLine) Date: YYYY-MM-DD Date - Time YYYY-MM-DD Date - Time YYYY-MM-DD type="A=Main item, B=Part item" status="V=Free, B=Blocked, A=Active" Mandatory element for status = 0, 1, 2, 3 Absences.EmpId; Mandatory element for status = 0, 1, 2, 3 Mandatory element for status = 0, 1, 2, 3 Mandatory element for status = 0, 1, 2, 3 Absences.Amount -1=Deleted, 0=Open, 1=Authorized, 2=Fulfilled, 3=Rejected Date and time in format YYYY-MM-DDTHH:MM:SS. Date and time in format YYYY-MM-DDTHH:MM:SS. Globe role. Name for a Globe role. Collection of Globe roles. ItemAccounts.AccountCode ItemAccounts.ItemCode Items.GLAccountITR staffl.LineType