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

Compare with Current View Page History

« Previous Version 4 Next »

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

Decimal separator is a point

Date are given in Unix Timestamp. Example: "/Date(1520491871000)/" = GMT: Thursday, March 8, 2018 6:51:11 AM

Schema

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

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


Customer

Type: OM.Accounting.Customer

PropertyTypeId fieldFriendly property 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


ConditionalDiscountRatedecimal

Ex: 2.5
ConditionalDiscountDaysdecimal

Ex: 7
CommodityCodestring

Default intrastat code for the goods delivered (ex: "01022961")




Properties used for Logistics only
DiscountRate



GlobalDiscountRate



IsPartialDelivery



IsPartialDeliveryClosed






































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