dbo.FulfillmentView

Information

Type: MS SQL View
Schema: dbo
Data Origin:Join eiBox Office and STG tables, providing a dataframe that will track production for fulfillment agents. The view spans the past 1,095 days or a trailing 3 year period.
Refresh Schedule: This is a live data source connected to eiBox Office, user information updates weekly at 3AM on Monday's.
Script File Locations: N/A
Tables:
- KC.eiboxoffice.dbo.SellOrder
- STG.users.employeedirectory

Data Dictionary

Column Name	Data Type	Description
SellOrderID	Numeric	Sell order identifier.
ClientID	Factor	Client identifier.
SellOrderStatusTypeID	Factor	Sell order status type represented as numeric factors. Factors include: 1 - InProcess; 2 - Finalized; 3 - Canceled; 4 - Shipped; 5 - OnHold; 6 - Consignment Returned; 7 - Out On Consignment; 8 - PreOrder.
InvoiceNumber	Numeric	Invoice number.
ShippingTrackingCode	Character	Shipping tracking code includes the type of order, it's tracking number if there is one, and the fulfillment agent that processed the order. Processed orders are marked as completed by agents starting at "$" and followed by their 3-digit eiBox Office user ID.
ShippingMethodID	Factor	The shipping method, or carrier ID for the company that will be delivering the order.
ShippingCompany	Character	Name of the company that the ticket was sold through. This is often an exchange such as StubHub, VividSeats, Gametime, etc.
ShippingAttn	Character	Name of the company that the ticket was sold through. This is often an exchange such as StubHub, VividSeats, Gametime, etc.
BillingCompany	Character	Name of the company that the ticket was sold through. This is often an exchange such as StubHub, VividSeats, Gametime, etc.
Email	Character	Email of the company that the ticket was sold through. This is often an exchange such as StubHub, VividSeats, Gametime, etc.
PurchaseAmount	Numeric	Amount that the ticketgroup sold for.
ShippingAmount	Numeric	Cost of shipping.
TotalAmount	Numeric	Amount that the ticketgroup sold for.
FinalizedDateTime	Datetime	The date and time that the invoice was created.
ShippedDateTime	Datetime	The date and time that the order was shipped to the customer. This is often the same as FinalizedDateTime because a lot of tickets are instant deliveries.
CancelDateTime	Datetime	The date and time the order was canceled.
UpdatedDateTime	Datetime	The date and time the order was updated.
WorkStatus	Character	This field is a combination of timestamps that have broker names and statuses on them.
WorkStatusTypeID	Factor	Work status of the invoiced order including: 0 - None; 1 - Invoiced; 2 - Working; 3 - Complete.
ExternalReferenceNumber	Character	External reference number is the order number according to the exchange, normally the order number given by the billing company.
ExternalComments	Character	Comments made by fulfillment agents on the invoice.
DeliveryDate	Date	Date that the order was delivered.
ShippingStatusCode	Factor	Shipping status.
ShippingStatusDescription	Character	Shipping status name.
EstimatedShipDate	Date	Estimated date the order will be shipped to the customer.
BuyerBrokerID	Factor	Broker ID.
userid	Numeric	Employee ID in Ticket Boat's internal portal.
useridjoin	Numeric	This is the column that is used to join the tables, it extracts the userid from the ShippingTrackingCode by: REPLACE(SUBSTRING(SO.[ShippingTrackingCode], CHARINDEX('$', SO.[ShippingTrackingCode]), 5), '$', '') AS useridjoin
Employee	Character	Employee is the concatenated value of firstname and lastname dimensions.
firstname	Character	The first name of the employee.
lastname	Character	The last name of the employee.
login	Character	The employee login ID that is used to log into eiBox Office.
eiuserid	Numeric	This is the user ID in eiBox Office.
active	Boolean	This is a True/False column indicating if the employee is still working at Ticket Boat.
Directory Email	Character	The employee's Ticket Boat email address.
Department	Character	The department that the employee works in at Ticket Boat.
Position	Character	The employee's official position at Ticket Boat.
CompanyID	Numeric	This indicates the company that the employee works for.
Phone Numbers	Character	This is the employee's personal phone number or contact number.
usergroupid	Factor	This identification number corresponds to the eiBox Office group that the user is in, this can indicate if the user is an administrator/manager/etc. Most should have the usergroup with the highest access.
token	Character	Unique identifier token.

Data Governance

dbo.FulfillmentView

Information

Data Dictionary

Schema Diagram

Related content