Employee Order

Added On: 06/04/12

SQL Table: EMPLOYEE_ORDER

Module: UniRun

Type: Entity Status: Active

Java Class: EmployeeOrder

Represents an apparel order made for an employee

Available Fields:

Approval Date
Create Date
Creator Code
Discount Amount
Document Fk

Employee Fk
Employee Record Fk
Gross Amount
Id
Is Return

Item Count
Merchant Account Code
Net Amount
Order Notes
Review Notes

Ship To Account
Status Cl

Approval Date

Added On: 01/09/13

SQL Column: APPROVAL_DATE

Java Field: approvalDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

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

Creator Code

Added On: 06/04/12

SQL Column: CREATOR_CODE

Java Field: creatorCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes: Required

User that created this order

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

Document Fk

Added On: 07/20/12

SQL Column: DOCUMENT_FK

Java Field: document

Status: Active

SQL Type: bigint(20)

Java Type:

References Document

Attributes:

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 placed the order

Employee Record Fk

Added On: 06/04/12

SQL Column: EMPLOYEE_RECORD_FK

Java Field: employeeRecord

Status: Active

SQL Type: bigint(20)

Java Type:

Attributes: Required

Reference to an employee record (of the employee placing the order) active at the time of the order

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 of the order

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 Return

Added On: 06/04/12

SQL Column: IS_RETURN

Java Field: isReturn

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

When set to true, indicates that the order is created to process item returns.

Item Count

Added On: 06/04/12

SQL Column: ITEM_COUNT

Java Field: itemCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Count of items in the order

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.

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 order amount

Order Notes

Added On: 06/04/12

SQL Column: ORDER_NOTES

Java Field: orderNotes

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Notes added at the time when the order is placed

Review Notes

Added On: 06/04/12

SQL Column: REVIEW_NOTES

Java Field: reviewNotes

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Notes added during the order review process

Ship To Account

Added On: 08/02/12

SQL Column: SHIP_TO_ACCOUNT

Java Field: shipToAccount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Status Cl

Added On: 06/04/12

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Employee Order Status Classifier

Attributes: Required, Default:S

Current status of the order