|
Element_ID
|
Name
|
Format
|
Length
|
Description
|
LOB
|
|
|
|
|
Account_Status_entity
|
Common
|
|
ASE02
|
Account_Status
|
Alpha
|
8
|
ACTIVE
INACTIVE
NEW
DELETED
|
|
|
|
|
|
Customer_Type_Entity
|
Common
|
|
TE01
|
Type
|
Alpha
|
20
|
CONSUMER
BUSINESS
ACADEMIC
GOVERNMENT
DANFORTH_INTERNAL
|
|
|
|
|
|
Order_Type_Entity
|
Sales, Finance
|
|
TE01
|
Type
|
Alpha
|
20
|
MANUFACTURE
ASSEMBLE
SERVICE
TESTING
|
|
|
|
|
|
Priority_Type_Entity
|
Common
|
|
TE01
|
Type
|
Alpha
|
20
|
CRITICAL
HIGH
REGULAR
LOW
|
|
|
|
|
|
|
|
|
|
Address_Entity
|
Common
|
|
AE01
|
Address_Line1
|
AlphaNumeric
|
25
|
address line 1
|
|
|
AE02
|
Address_Line2
|
AlphaNumeric
|
25
|
address line 2
|
|
|
AE03
|
Address_Line3
|
AlphaNumeric
|
25
|
address line 3
|
|
|
AE04
|
Address_State
|
Alpha
|
2
|
state code
|
|
|
AE05
|
|
ISO 3166
|
2
|
country code
|
|
|
AE06
|
Address_Postal_Code
|
AlphaNumeric
|
6
|
postal code
|
|
|
|
|
|
Contact_Entity
|
Common
|
|
COE01
|
Phone_Business
|
Numeric
|
15
|
business phone
|
|
|
COE02
|
Phone_Residence
|
Numeric
|
15
|
resi phone
|
|
|
COE03
|
Phone_Mobile
|
Numeric
|
15
|
mobile phone
|
|
|
COE04
|
Email_Address
|
AlphaNumeric
|
40
|
email
|
|
|
COE05
|
Pager_Number
|
Numeric
|
15
|
pager number
|
|
|
COE06
|
Fax_Number
|
Numeric
|
15
|
fax number
|
|
|
|
|
|
|
|
|
|
|
|
|
Customer_Entity
|
Sales, Finance, Marketing,
Manufact
|
|
CSE01
|
Customer_ID
|
AlphaNumeric
|
10
|
unique ID for cust
|
|
|
CSE02
|
Customer_Name
|
AlphaNumeric
|
25
|
customer name
|
|
|
CSE03
|
Customer_Address
|
Address_Entity
|
75
|
address of customer
|
|
|
CSE04
|
Customer_Contact
|
Contact_Entity
|
50
|
contact details of customer
|
|
|
CSE05
|
Customer_Account_Status
|
AccountStatus_Entity
|
8
|
account status
|
|
|
CSE06
|
Customer_Type
|
Customer_Type_entity
|
20
|
customer type
|
|
|
|
|
|
Part_Entity
|
Manufact, Finance
|
|
IPR01
|
Item_ID
|
AlphaNumeric
|
10
|
unique id for every part
|
|
|
IPR02
|
Item_Name
|
AlphaNumeric
|
10
|
name of part
|
|
|
IPR03
|
Item_Description
|
AlphaNumeric
|
75
|
description of part
|
|
|
IPR04
|
Item_Hazardous_Material
|
AlphaNumeric
|
50
|
contact details of customer
|
|
|
IPR05
|
Item_Special_Handling
|
AlphaNumeric
|
75
|
any special handling instructions
|
|
|
IPR06
|
Item_Order_Approval_Needed
|
Alpha
|
20
|
approval needed for ordering - approving
dept.
|
|
|
|
|
|
Inventory_Item_Entity
|
Manufact, Finance
|
|
INVE01
|
Invent_Item_ID
|
AlphaNumeric
|
10
|
name of customer
|
|
|
INVE02
|
Item_Serial_Start
|
AlphaNumeric
|
10
|
unique ID for cust
|
|
|
INVE03
|
Item_Serial_End
|
AlphaNumeric
|
75
|
address of customer
|
|
|
INVE04
|
Item_Auto_Reorder
|
boolean
|
1
|
if item gets reordered Y/N
|
|
|
INVE05
|
Item_Auto_Reorder_Threshold
|
Numeric
|
16
|
quantity at which items gets reordered
|
|
|
INVE06
|
Item_Auto_Reorder_Quantity
|
Numeric
|
16
|
reorder quantity
|
|
|
INVE07
|
Item_Current_Quantity
|
Numeric
|
16
|
current stock
|
|
|
|
|
|
Supplier_Entity
|
Manufact, Finance
|
|
SUE01
|
Supplier_ID
|
AlphaNumeric
|
10
|
unique ID for cust
|
|
|
SUE02
|
Supplier_Name
|
AlphaNumeric
|
25
|
name of supplier
|
|
|
SUE03
|
Supplier_Address
|
Address_Entity
|
75
|
address of supplier
|
|
|
SUE04
|
Supplier_Contact
|
Contact_Entity
|
50
|
contact details of supplier
|
|
|
SUE05
|
Supplier_Account_Status
|
AccountStatus_Entity
|
8
|
account status
|
|
|
SUE06
|
Supplier_Rating
|
Alpha
|
20
|
preferred, semi-preferred, regular,
contained
|
|
|
|
|
|
Order_Entity
|
Manufact, Finance, Sales
|
|
ORE01
|
Order_ID
|
AlphaNumeric
|
10
|
order unique ID
|
|
|
ORE02
|
Order_Description
|
AlphaNumeric
|
10
|
order description
|
|
|
ORE03
|
Order_Type
|
Order_Type_Entity
|
20
|
type of the order
|
|
|
ORE04
|
Order_Priority
|
Priority_Entity
|
20
|
priority of order
|
|
|
CSE01
|
Customer_ID
|
Customer_ID
|
10
|
customer who placed the order
|
|
|
ORE06
|
Order_Creation_Date
|
ISO 8061
|
16
|
date of creation
|
|
|
ORE07
|
Order_Planned_Start
|
ISO 8061
|
16
|
target start date
|
|
|
ORE08
|
Order_Planned_End
|
ISO 8061
|
|
target end date
|
|
|
ORE09
|
Order_Status
|
Alpha
|
20
|
status of order
|
|
|
ORE10
|
Order_Department
|
AlphaNumeric
|
25
|
name of the department who will fulfill
order
|
|
|
ORE11
|
Order_Reference
|
AlphaNumeric
|
75
|
customer reference fields for order
|
|
|
ORE12
|
Order_Special_Instructions
|
AlphaNumeric
|
75
|
special instructions for order
|
|
|
ORE13
|
Order_Quantity
|
Numeric
|
10
|
quantity of order
|
|
|
|
|
|
Invoice_Entity
|
Sales, Finance
|
|
INVE01
|
Invoice_ID
|
AlphaNumeric
|
10
|
Invoice unique ID
|
|
|
INVE02
|
Invoice_Description
|
AlphaNumeric
|
10
|
Invoice description
|
|
|
INVE03
|
Invoice_Type
|
AlphaNumeric
|
20
|
type of the Invoice, recurring payment or
one time
|
|
|
ORE01
|
Order_ID
|
AlphaNumeric
|
10
|
order unique ID
|
|
|
CSE01
|
Customer_ID
|
Customer_ID
|
10
|
customer who placed the order
|
|
|
ORE02
|
Order_Description
|
AlphaNumeric
|
10
|
order description
|
|
|
ORE03
|
Order_Type
|
Order_Type_Entity
|
20
|
type of the order
|
|
|
ORE11
|
Order_Reference
|
AlphaNumeric
|
75
|
customer reference fields for order
|
|
|
ORE12
|
Order_Special_Instructions
|
AlphaNumeric
|
75
|
special instructions for order
|
|
|
ORE13
|
Order_Quantity
|
Numeric
|
10
|
quantity of order
|
|
|
ORE11
|
Invoice_Amount
|
Numeric
|
16
|
total invoice amount
|
|
|
INVE04
|
Payment_Due_Date
|
ISO 8061
|
16
|
due date for payment
|
|
|
INVE05
|
Late_Payment_Date
|
ISO 8061
|
|
final date for accepting late payment
|
|
|
INVE06
|
Late_Fee
|
Numeric
|
16
|
late fee
|
|
|
|
|
|
Employee_Entity
|
HR, Finance, Sales, Manufact
|
|
EMPE01
|
Employee_ID
|
AlphaNumeric
|
10
|
unique ID for cust
|
|
|
EMPE02
|
Employee_Name
|
AlphaNumeric
|
25
|
Employee name
|
|
|
EMPE03
|
Employee_Address
|
Address_Entity
|
75
|
address of Employee
|
|
|
EMPE04
|
Employee_Contact
|
Contact_Entity
|
50
|
contact details of Employee
|
|
|
EMPE05
|
Employee_Account_Status
|
AccountStatus_Entity
|
8
|
account status
|
|
|
EMPE06
|
Strategic_Label
|
AlphaNumeric
|
20
|
Employee type
|
|
|
EMPE07
|
Hours_Work
|
Numeric
|
20
|
regular hours per week
|
|
|
|
|
|
Warehouse_Entity
|
Sales, Manufact, Finance
|
|
WHE01
|
Warehouse_ID
|
AlphaNumeric
|
10
|
unique ID for warehouse
|
|
|
WHE02
|
Warehouse_Name
|
AlphaNumeric
|
25
|
Warehouse name
|
|
|
WHE03
|
Warehouse_Address
|
Address_Entity
|
75
|
address of Warehouse
|
|
|
WHE05
|
Workers
|
Array
|
300
|
list of employee ids in warehouse
|
|
|
WHE06
|
Inventory
|
Array
|
3000
|
List of items in warehouse
|
|
|
APE01
|
Cost_Id
|
Cost_ID
|
20
|
cost center
|
|
|
|
|
|
Accounts_Payable_Entity
|
Sales, Finance
|
|
APE01
|
Cost_Id
|
AlphaNumeric
|
10
|
unique ID for warehouse
|
|
|
APE02
|
Description
|
AlphaNumeric
|
25
|
Accounts_Payable name
|
|
|
APE03
|
Amount
|
Numeric
|
100
|
amount
|
|
|
APE04
|
Date
|
ISO8527
|
16
|
ISO date and time format
|
|
|
APE05
|
Check_Number
|
Numeric
|
30
|
check or card number
|
|
|
INV01
|
Invoice_ID
|
Invoice_Id
|
20
|
invoice associated
|
|
|
SUP01
|
Supplier_ID
|
Supplier_ID
|
20
|
supplier associated
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts_Recievable_Entity
|
Sales, Finance
|
|
APE01
|
Cost_Id
|
AlphaNumeric
|
10
|
unique ID for warehouse
|
|
|
ARE02
|
Description
|
AlphaNumeric
|
25
|
Accounts_Recievable name
|
|
|
ARE03
|
Amount
|
Numeric
|
100
|
amount
|
|
|
ARE04
|
Date
|
ISO8527
|
16
|
ISO date and time format
|
|
|
ARE05
|
Check_Number
|
Numeric
|
30
|
check or card number
|
|
|
INV01
|
Invoice_ID
|
Invoice_Id
|
20
|
invoice associated
|
|
|
SUP01
|
Supplier_ID
|
Supplier_ID
|
20
|
supplier associated
|
|
|
|
|
|
Benefits_Entity
|
HR, Sales
|
|
BENE01
|
Benefits_ID
|
AlphaNumeric
|
10
|
unique ID for Benefits
|
|
|
EMPE01
|
Employee_Id
|
Employee_Id
|
25
|
name of employee
|
|
|
BENE03
|
Date
|
ISO8527
|
16
|
ISO Date time format
|
|
|
BENE05
|
Workers
|
Array
|
300
|
list of employee ids in Benefits
|
|
|
BENE06
|
Amount
|
Numeric
|
50
|
benefit amount
|
|
|
|
|
|
Payroll_Entity
|
Finance, HR
|
|
PYRE01
|
Payroll_ID
|
AlphaNumeric
|
10
|
unique ID for Payroll
|
|
|
EMPE01
|
Employee_Id
|
Employee_Id
|
25
|
name of employee
|
|
|
PYRE03
|
Date
|
ISO8527
|
16
|
ISO Date time format
|
|
|
ACPE01
|
Cost_Id
|
Cost_ID
|
300
|
cost center associated
|
|
