Model

Explanation of the conditions model:
Attribute Type  Description

GLN

Required

 string(13)

 Global Location Number of the supplier

  • exact 13 characters
  • numeric

AllowanceGroup

Required

 string(35)

 Discount group

  • maximum of 35 characters
  • Not allowed characters: “%”, “?”, “[“, “]”
  • Character “*” can be used as a wildcard. So only * means all discount groups, and 123* means all groups starting with with 123 comply.

TradeItemId

Optional

 string(35)

 Trade item

  • maximum of 35 characters

GTIN

Optional

 string(14)

 Global Trade Item Number

NetPrice

Optional

 decimal(11,4)

Net price

  • numeric 11 digits before the decimal point, 4 digits after the decimal point
  • If filled, minimum > 0
  • Or net prices or discount percentage 1 must be filled (one or the other, not both)

AllowancePercentage1

Optional

 decimal(3,4)

 Discount percentage 1

  • numeric 3 digits before the decimal point,  4 digits after the decimal point
  • maximum 100, minimum >= 0
  • Or net prices or discount percentage 1 must be filled (one or the other, not both)

AllowancePercentage2

Optional

 decimal(3,4)

Discount percentage 2

  • numeric 3 digits before the decimal point, 4 digtis after the decimal point
  • maximum 100, minimum >= 0

AllowancePercentage3

Optional

 decimal(3,4)

Discount percentage 3

  • numeric 3 digits before the decimal point, 4 digits after the decimal point
  • maximum 100, minimum >= 0

ValidityStartDate

Required

 date

Start date of the condition

ValidityEndDate

Optional

 date

End data of the condition

TermsTypeCode

Required

 string(2)

Type of condition

  • AC = Action condition
  • BC = Base condition
  • PC = Project condition, if filled, then ProjectNumber required

ProjectNumber

Optional

 string(17)

 Project number

  • If filled, then TermsTypeCode = “PC”

BracketLowerLimit

Required

 integer

 Bracket lower limit from which this condition is valid

  • Minimum 0
     
This site is registered on wpml.org as a development site.