Clothing Article Design

Added On: 06/04/12

SQL Table: CLOTHING_ARTICLE_DESIGN

Module: UniRun

Type: Entity Status: Active

Java Class: ClothingArticleDesign

Design of a clothing article available for purchase by employees

Available Fields:

Clothing Article Fk
Count 2XL
Count 3XL
Count 4XL
Count L

Count M
Count OS
Count S
Count XL
Count XS

Create Date
Id
Is Active
Merchant Account Code
Name

Clothing Article Fk

Added On: 06/04/12

SQL Column: CLOTHING_ARTICLE_FK

Java Field: clothingArticle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Clothing Article

Attributes: Required

Reference to a clothing article for which the design option is defined

Count 2XL

Added On: 06/04/12

SQL Column: COUNT_2XL

Java Field: count2Xl

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of 2XL articles available in this design

Count 3XL

Added On: 06/27/12

SQL Column: COUNT_3XL

Java Field: count3Xl

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of 3XL articles available in this design

Count 4XL

Added On: 06/27/12

SQL Column: COUNT_4XL

Java Field: count4Xl

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of 4XL articles available in this design

Count L

Added On: 06/04/12

SQL Column: COUNT_L

Java Field: countL

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of L articles available in this design

Count M

Added On: 06/04/12

SQL Column: COUNT_M

Java Field: countM

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of M articles available in this design

Count OS

Added On: 06/04/12

SQL Column: COUNT_OS

Java Field: countOs

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of one-size articles available in this design

Count S

Added On: 06/04/12

SQL Column: COUNT_S

Java Field: countS

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of S articles available in this design

Count XL

Added On: 06/04/12

SQL Column: COUNT_XL

Java Field: countXl

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of XL articles available in this design

Count XS

Added On: 06/04/12

SQL Column: COUNT_XS

Java Field: countXs

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of XS articles available in this design

Create Date

Added On: 06/04/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Added On: 06/04/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Identifier of the object used for references; auto-incremented integer value.

Is Active

Added On: 06/04/12

SQL Column: IS_ACTIVE

Java Field: isActive

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:1

Indicates whether the record is currently active.

Merchant Account Code

Added On: 06/04/12

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required, CreateOnly

Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Name

Added On: 06/04/12

SQL Column: NAME

Java Field: Name

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes: Required, Default:1

Name of the design/color