OData - Table Headings
- Alex Morrisson
Lead Conversion | Lead Conversion by Sales Rep | Lead Reports | Lead Analysis | Lead Analysis by Branch | Lead Sources | Leads Report | Lead Source Matrix |
LeadPkId | LeadPkId | Id | LeadPkId | LeadPkId | PkId | LeadsID | Id |
Branch | SalesRep | DateAppointment | Descn | Descn | LeadsID | SalesRep | vDescn |
MOption | MOption | Flg | DateAppointment | Month | LeadNo | LeadNo | DateReceived |
LeadNo | LeadNo | LeadNo | Year | Week | Key | LeadStatus | Year |
OrderNo | OrderNo | Rep | Month | Day | Answer | DateTaken | Month |
OrderAmt | OrderAmt | SalesRepPkId | Week | LeadNo | Date | AppointmentDate | Week |
LeadStatusPkId | LeadStatusPkId | LeadItems | Day | CreationDate |
| EndTime | CompType |
CreationDate | CreationDate | LastName | LeadNo | LeadStatusPkId |
| Branch | CreationDate |
|
| OrderItems | SalesRepPkId | BranchPkId |
| Customer |
|
|
| AddSuburb | LeadStatusPkId | SeqNo |
| ContactTyp |
|
|
| MOCompType | SeqNo |
|
| Title |
|
|
| DateDoc |
|
|
| FirstName |
|
|
| MOType |
|
|
| LastName |
|
|
| OrderStatus |
|
|
| SourceType |
|
|
| Amt |
|
|
| SourceCompType |
|
|
| LeadStatus |
|
|
| Area |
|
|
| Descn |
|
|
| Suburb |
|
|
| DirectPhone |
|
|
| PostCode |
|
|
| Mobile |
|
|
| State |
|
|
|
|
|
| Notes |
| |
|
| LeadStatusPkId |
|
|
| LeadCreationDate |
|
|
|
|
|
|
| LeadEnteredBy |
|
Product Ordered | Sales Conversion by Product | Sales Orders | Sales Report |
Id | Id | Id | OrderID |
DateDoc | Descn | OrderNo | OrderNo |
LineNumber | Won | OrderRev | OrderRef |
AcceptedDate | Followup | OrderDate | Order_Type |
ItemWidth | Lost | AcceptedDate | Order_Status |
InvoicedDate | Converted | OrderDescn | Order_Item_No |
ItemHeight |
| InvoiceNo | Order_Item_Sub_No |
UnitCost |
| InvoicedDate | DateDoc |
Qty |
| OrderDiscPer | Order_CreatedBy |
Amt |
| OrderFlag | Date_Order_Accepted |
RefNo |
| TotalReceipts | Date_Invoiced |
Flg |
| ItemDescn | Order_Quantity |
Revision |
| LineNumber | Order_Unit_Cost |
ProdDescn |
| FixedLine | Order_Starting_Price |
Colour |
| ItemWidth | Order_Amount_ExTax |
InventoryGroup |
| ItemHeight | Order_Tax |
Material |
| ItemQty | Order_Amount_IncTax |
MatlType |
| ItemQtyInvd | Order_Amount_Received |
DrName |
| ItemUnitCost | Order_History_LastActionDate |
OrderStatusPkId |
| ItemAmtInvd | Sales_Representative |
InventoryGroupPkId |
| ItemTax | Customer |
FixedLine |
| ItemRRP | CustomerGroup |
|
| ItemDiscPer | Contact_EmailAddress |
|
| ItemDiscAmt | Contact_Phone |
|
| ItemAmt | Contact_Mobile |
|
| ItemCommission | Inventory_Group |
|
| ItemInstallCost | Inventory_Item |
|
| CustomerCode | Inventory_RptCat |
|
| CustomerName | Workflow_Job_Tracking_Status |
|
| InventoryCode | Workflow_Job_Tracking_Process |
|
| InventoryDescn | Workflow_Job_Tracking_Line |
|
| SalesRepCode | Workflow_Job_Tracking_DateCompleted |
|
| SalesRepName | DispatchDate |
|
| BranchName | Workflow_Dispatch_Status |
|
| Title | Dispatch_Post_Code |
|
| FirstName | Dispatch_State |
|
| LastName | Dispatch_Suburb |
|
| DirectPhone | Area |
|
| Mobile |
|
|
| OrderStatus |
|
|
| IsPriceMatch |
|
|
| InvGrpCode |
|
|
|
| |
|
| OrderType |
|
|
| SalesRepPkId |
|
|
| OrderStatusPkId |
|
Job Line Levels | Jobs Schedule Detailed | JobsScheduleSummary | Jobs Schedule Summary Shutters | Work in Progress |
Id | Id |
| Id | Id |
Descn | Customer |
| ProdDate | Descn |
Qty | RefNo |
| OrderNo | DateDoc |
Amt | Descn |
| Ref | AcceptedDate |
Tax | AcceptedDate |
| Qty | RefNo |
Day | DateScheduled |
| SQM | Revision |
WeekNo | Installer |
| ProdnStatus | OrderStatus |
Month | InstallationType |
| Customer | SalesRep |
Year | FixedLine |
| Suburb | Customer |
DateComp | OrderItemDescn |
| PCode | OrderItemDescn |
ProductionLinePkId | InventoryItem |
| InstallDate | FixedLine |
| ItemWidth |
| Installer | LineNumber |
| ItemHeight |
| InstallStatus | Qty |
| Qty |
| CustMob | InventoryItem |
| Cost |
| CustEmail | DateCurrStg |
| Amt |
| ProductionLinePkId | ProductionProcess |
| ProductionLine |
| ProductionStatusPkId | InstallationStatus |
| ProductionStatus |
| CUSTPkId | DateScheduled |
| ProductionProcess |
| ProdnLine | Installer |
| InstallationStatus |
|
| InstallationType |
| ProdnDateComp |
|
| OrderStatusPkId |
| ProductionLinePkId |
|
| ProductionStatusPkId |
| OrderStatusPkId |
|
| SalesRepPkId |
| InstallationStatusPkId |
|
| InstallationStatusPkId |
| ProductionStatusPkId |
|
| ProductionLinePkId |
| SalesRepPkId |
|
| ProductionLine |
| CustomerPkId |
|
| Amt |
| DateDoc |
|
| Tax |
| OrderStatus |
|
| AcceptedBy |
| SalesRep |
|
| CustomerGroup |
| LineNumber |
|
| CreditLimit |
| DateCurrStg |
|
| ProductionStatus |
| Tax |
|
|
|
|
Dispatch Schedule (not working) |
|
|
|
Banking Transaction Summary | Deposits Held |
Id | Id |
Descn | Descn |
DateReceived | DateReceived |
RefNo | Amount |
PaymentType | PaymentType |
AccNumber | DateDoc |
BSB | DepositNo |
AccountDescn | Orders |
DateDoc |
|
Amount |
|