You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Schema

The customer entity is referencing several other entities. The schema  is this one:

  • Customer
    • Third
      • DefautAddress
      • Addresses        (List of TORM.OM.Address)
      • Contacts         (List of TORM.OM.Third_Contact)


For the type, "OM" stand for "Winbooks.TORM.OM"

Customer

Type: OM.Accounting.Customer

PropertyTypeId fieldFriendly codeComment
Codestring

Should be the same as the code of the Third
Vat
OM.Accounting.VatAccount
Vat_Id
VatCodeDefault Vat (ex: 21)
Category
OM.CustomerCategory
CustomerCategory_Id
CategoryCode

GLAccountDefault
OM.Accounting.GLAccount
GLAccount_Id
GLAccountDefaultCode
Default account for the base (ex: "700000")
GLAccountCentral
OM.Accounting.GLAccount
GLAccount2_IdGLAccountCentralCodeCentral account for the clients (ex: "400000")
GLTemplate
OM.Accounting.GLTemplate
GLTemplate_IdGLTemplateCodeBooking template
PayCode
OM.Accounting.PayCode
PayCode_IdPayCodeCodePayment conditions (ex: "30")
VatApplicableint

0 - Undefined
1 - Subject to
2 - Exempt from
3 - Not subject to

LastReminderLevelshort


LastReminderDateDateTime


IsReminderBlockedbool

true - the customer will not receive any reminder of payment
IsLockedbool

true - we cannot book anymore on this Customer
IsHiddenbool

true - we don't see the customer anymore
MemoTypeshort

0 - None
1 - Green
5 - Yellow
9 - Red
Memostring


Third

PropertyTypeId fieldFriendly codeComment
Codestring

Should be the same as the code of the Customer
ThirdCivility
TORM.OM.ThirdCivility
ThirdCivility_Id
CivilityCode
Ex: "NV"
VatCountry
TORM.OM.Country
VatCountry_Id
VatCountryCodeEx: "BE"
Language
TORM.OM.Language
Language_IdLanguageCodeEx: "nl"
Currency
TORM.OM.Currency
Currency_IdCurrencyCodeEx: "EUR"
DefautAddress
TORM.OM.DefaultAddress



Addresses
List of OM.Address



Contacts
List of TORM.OM.Third_Contact



VatNumberstring

Ex: "0000000196" (without formating)
WebSitestring

Ex: "www.bebop.be"
















  • No labels