Clothing Item

Added On: 06/04/12

SQL Table: CLOTHING_ITEM

Module: UniRun

Type: Entity Status: Active

Java Class: ClothingItem

Represents a clothing item purchased or returned by an employee.

Available Fields:

Clothing Article Design Fk
Clothing Article Fk
Create Date
Discount Amount
Employee Fk

Gross Amount
Id
Merchant Account Code
Name
Net Amount

Purchase Date
Purchase Order Fk
Return Date
Return Order Fk
Return Policy Cl

Size Cl

Clothing Article Design Fk

Added On: 06/04/12

SQL Column: CLOTHING_ARTICLE_DESIGN_FK

Java Field: clothingArticleDesign

Status: Active

SQL Type: bigint(20)

Java Type:

Attributes: Required

Design of the clothing article associated with this item

Clothing Article Fk

Added On: 06/04/12

SQL Column: CLOTHING_ARTICLE_FK

Java Field: clothingArticle

Status: Active

SQL Type: bigint(20)

Java Type:

References Clothing Article

Attributes: Required

Clothing article associated with this item

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

Discount Amount

Added On: 06/04/12

SQL Column: DISCOUNT_AMOUNT

Java Field: discountAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of any discount applied during purchase/return of the item

Employee Fk

Added On: 06/04/12

SQL Column: EMPLOYEE_FK

Java Field: employee

Status: Active

SQL Type: bigint(20)

Java Type:

References Employee

Attributes: Required

Reference to an employee that owns the item

Gross Amount

Added On: 06/04/12

SQL Column: GROSS_AMOUNT

Java Field: grossAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Gross (before discount) total amount paid/returned for the item

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.

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

Name of the item (copied from the Clothing Article and Clothing Article Design at the time of purchase/return)

Net Amount

Added On: 06/04/12

SQL Column: NET_AMOUNT

Java Field: netAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Net (after discount) total amount paid/returned for the item

Purchase Date

Added On: 06/04/12

SQL Column: PURCHASE_DATE

Java Field: purchaseDate

Status: Active

SQL Type: date

Java Type: Date

Attributes:

Date when the item was purchased

Purchase Order Fk

Added On: 06/04/12

SQL Column: PURCHASE_ORDER_FK

Java Field: purchaseOrder

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Employee Order

Attributes:

Reference to an order within which this item was purchased.

Return Date

Added On: 06/04/12

SQL Column: RETURN_DATE

Java Field: returnDate

Status: Active

SQL Type: date

Java Type: Date

Attributes:

Date when the item was returned

Return Order Fk

Added On: 06/04/12

SQL Column: RETURN_ORDER_FK

Java Field: returnOrder

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Employee Order

Attributes:

Reference to an order within which this item was returned.

Return Policy Cl

Added On: 06/04/12

SQL Column: RETURN_POLICY_CL

Java Field: returnPolicyCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Item Return Policy Classifier

Attributes: Required, Default:F

Item return policy applicable to this item

Size Cl

Added On: 06/04/12

SQL Column: SIZE_CL

Java Field: sizeCl

Status: Active

SQL Type: varchar(3)

Java Type: String

References Clothing Size Classifier

Attributes: Required

Size of the item