Final Tableau Report

Final File.twb

0 [Customer_Master] Count true 0 "A1:N3753:no:A1:N3753:0" true 2 0 [Sales_Orders] Count true 18 "A1:M6584:no:A1:M6584:0" true 2 0 [Invoices_Generated] Count true 22 "A1:H6572:no:A1:H6572:0" true 6 0 [AR_Adjustments] Count true 22 "A1:N297:no:A1:N297:0" true 6 0 [Cash_Received] Count true 6 "A1:I5009:no:A1:I5009:0" true 6 0 [Shipments_Made] Count true 14 "A1:I6563:no:A1:I6563:0" true 6 Customer_Account_ID 20 [Customer_Account_ID] [Customer_Master] Customer_Account_ID 0 integer Sum true "I8" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Account_Name 130 [Customer_Account_Name] [Customer_Master] Customer_Account_Name 1 string Count true "WSTR" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_Street_Address1 130 [Customer_Physical_Street_Address1] [Customer_Master] Customer_Physical_Street_Address1 2 string Count true "WSTR" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_Street_Address2 130 [Customer_Physical_Street_Address2] [Customer_Master] Customer_Physical_Street_Address2 3 string Count true "WSTR" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_City 130 [Customer_Physical_City] [Customer_Master] Customer_Physical_City 4 string Count true "WSTR" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_State_Province 130 [Customer_Physical_State_Province] [Customer_Master] Customer_Physical_State_Province 5 string Count true "WSTR" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_ZipPostalCode 20 [Customer_Physical_ZipPostalCode] [Customer_Master] Customer_Physical_ZipPostalCode 6 integer Sum true "I8" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Active_Date 7 [Active_Date] [Customer_Master] Active_Date 7 date Year true "DATE" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Inactive_Date 7 [Inactive_Date] [Customer_Master] Inactive_Date 8 date Year true "DATE" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Transaction_Credit_Limit 20 [Transaction_Credit_Limit] [Customer_Master] Transaction_Credit_Limit 9 integer Sum true "I8" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Overall_Credit_Limit 20 [Overall_Credit_Limit] [Customer_Master] Overall_Credit_Limit 10 integer Sum true "I8" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Terms_Discount_Percentage 5 [Terms_Discount_Percentage] [Customer_Master] Terms_Discount_Percentage 11 real Sum 15 true "R8" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Terms_Discount_Days 20 [Terms_Discount_Days] [Customer_Master] Terms_Discount_Days 12 integer Sum true "I8" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Terms_Due_Days 20 [Terms_Due_Days] [Customer_Master] Terms_Due_Days 13 integer Sum true "I8" [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Sales_Order_ID 20 [Sales_Order_ID] [Sales_Orders] Sales_Order_ID 14 integer Sum true "I8" [Sales!Orders_1F185952615742729A875B0BC051F641] Sales_Order_Date 7 [Sales_Order_Date] [Sales_Orders] Sales_Order_Date 15 date Year true "DATE" [Sales!Orders_1F185952615742729A875B0BC051F641] Customer_Account_ID 20 [Customer_Account_ID (Sales!Orders)] [Sales_Orders] Customer_Account_ID 16 integer Sum true "I8" [Sales!Orders_1F185952615742729A875B0BC051F641] Sales_Order_Amount 5 [Sales_Order_Amount] [Sales_Orders] Sales_Order_Amount 17 real Sum 15 true "R8" [Sales!Orders_1F185952615742729A875B0BC051F641] Entered_By 20 [Entered_By] [Sales_Orders] Entered_By 18 integer Sum true "I8" [Sales!Orders_1F185952615742729A875B0BC051F641] Entered_Date 7 [Entered_Date] [Sales_Orders] Entered_Date 19 date Year true "DATE" [Sales!Orders_1F185952615742729A875B0BC051F641] Entered_Time 7 [Entered_Time] [Sales_Orders] Entered_Time 20 datetime Year true "DATE" [Sales!Orders_1F185952615742729A875B0BC051F641] Approved_By 20 [Approved_By] [Sales_Orders] Approved_By 21 integer Sum true "I8" [Sales!Orders_1F185952615742729A875B0BC051F641] Approved_Date 7 [Approved_Date] [Sales_Orders] Approved_Date 22 date Year true "DATE" [Sales!Orders_1F185952615742729A875B0BC051F641] Approved_Time 7 [Approved_Time] [Sales_Orders] Approved_Time 23 datetime Year true "DATE" [Sales!Orders_1F185952615742729A875B0BC051F641] Last_Modified_By 20 [Last_Modified_By] [Sales_Orders] Last_Modified_By 24 integer Sum true "I8" [Sales!Orders_1F185952615742729A875B0BC051F641] Last_Modified_Date 7 [Last_Modified_Date] [Sales_Orders] Last_Modified_Date 25 date Year true "DATE" [Sales!Orders_1F185952615742729A875B0BC051F641] Last_Modified_Time 7 [Last_Modified_Time] [Sales_Orders] Last_Modified_Time 26 datetime Year true "DATE" [Sales!Orders_1F185952615742729A875B0BC051F641] Invoice_ID 20 [Invoice_ID] [Invoices_Generated] Invoice_ID 27 integer Sum true "I8" [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_Date 7 [Invoice_Date] [Invoices_Generated] Invoice_Date 28 date Year true "DATE" [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_Due_Date 7 [Invoice_Due_Date] [Invoices_Generated] Invoice_Due_Date 29 date Year true "DATE" [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Sales_Order_ID 20 [Sales_Order_ID (Invoices!Generated)] [Invoices_Generated] Sales_Order_ID 30 integer Sum true "I8" [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Entered_By 20 [Entered_By (Invoices!Generated)] [Invoices_Generated] Entered_By 31 integer Sum true "I8" [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Entered_Date 7 [Entered_Date (Invoices!Generated)] [Invoices_Generated] Entered_Date 32 date Year true "DATE" [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Entered_Time 7 [Entered_Time (Invoices!Generated)] [Invoices_Generated] Entered_Time 33 datetime Year true "DATE" [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_Amount 5 [Invoice_Amount] [Invoices_Generated] Invoice_Amount 34 real Sum 15 true "R8" [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Adjustment_ID 20 [Adjustment_ID] [AR_Adjustments] Adjustment_ID 35 integer Sum true "I8" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_Type 130 [Adjustment_Type] [AR_Adjustments] Adjustment_Type 36 string Count true "WSTR" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Invoice_ID 20 [Invoice_ID (AR!Adjustments)] [AR_Adjustments] Invoice_ID 37 integer Sum true "I8" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_Date 7 [Adjustment_Date] [AR_Adjustments] Adjustment_Date 38 date Year true "DATE" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_Amount 5 [Adjustment_Amount] [AR_Adjustments] Adjustment_Amount 39 real Sum 15 true "R8" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Entered_By 20 [Entered_By (AR!Adjustments)] [AR_Adjustments] Entered_By 40 integer Sum true "I8" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Entered_Date 7 [Entered_Date (AR!Adjustments)] [AR_Adjustments] Entered_Date 41 date Year true "DATE" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Entered_Time 5 [Entered_Time (AR!Adjustments)] [AR_Adjustments] Entered_Time 42 real Sum 15 true "R8" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Approved_By 20 [Approved_By (AR!Adjustments)] [AR_Adjustments] Approved_By 43 integer Sum true "I8" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Approved_Date 7 [Approved_Date (AR!Adjustments)] [AR_Adjustments] Approved_Date 44 date Year true "DATE" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Approved_Time 7 [Approved_Time (AR!Adjustments)] [AR_Adjustments] Approved_Time 45 datetime Year true "DATE" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Last_Modified_By 20 [Last_Modified_By (AR!Adjustments)] [AR_Adjustments] Last_Modified_By 46 integer Sum true "I8" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Last_Modified_Date 7 [Last_Modified_Date (AR!Adjustments)] [AR_Adjustments] Last_Modified_Date 47 date Year true "DATE" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Last_Modified_Time 7 [Last_Modified_Time (AR!Adjustments)] [AR_Adjustments] Last_Modified_Time 48 datetime Year true "DATE" [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Receipt_ID 20 [Receipt_ID] [Cash_Received] Receipt_ID 49 integer Sum true "I8" [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_Date 7 [Receipt_Date] [Cash_Received] Receipt_Date 50 date Year true "DATE" [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Invoice_ID 20 [Invoice_ID (Cash!Received)] [Cash_Received] Invoice_ID 51 integer Sum true "I8" [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_Type 130 [Receipt_Type] [Cash_Received] Receipt_Type 52 string Count true "WSTR" [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_Amount 5 [Receipt_Amount] [Cash_Received] Receipt_Amount 53 real Sum 15 true "R8" [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Posting_Status 130 [Posting_Status] [Cash_Received] Posting_Status 54 string Count true "WSTR" [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Entered_By 20 [Entered_By (Cash!Received)] [Cash_Received] Entered_By 55 integer Sum true "I8" [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Entered_Date 7 [Entered_Date (Cash!Received)] [Cash_Received] Entered_Date 56 date Year true "DATE" [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Entered_Time 7 [Entered_Time (Cash!Received)] [Cash_Received] Entered_Time 57 datetime Year true "DATE" [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Shipment_ID 20 [Shipment_ID] [Shipments_Made] Shipment_ID 58 integer Sum true "I8" [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipment_Date 7 [Shipment_Date] [Shipments_Made] Shipment_Date 59 date Year true "DATE" [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipping_Document_ID 20 [Shipping_Document_ID] [Shipments_Made] Shipping_Document_ID 60 integer Sum true "I8" [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Sales_Order_ID 20 [Sales_Order_ID (Shipments!Made)] [Shipments_Made] Sales_Order_ID 61 integer Sum true "I8" [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Sales_Order_Date 7 [Sales_Order_Date (Shipments!Made)] [Shipments_Made] Sales_Order_Date 62 date Year true "DATE" [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Entered_By 20 [Entered_By (Shipments!Made)] [Shipments_Made] Entered_By 63 integer Sum true "I8" [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Entered_Date 7 [Entered_Date (Shipments!Made)] [Shipments_Made] Entered_Date 64 date Year true "DATE" [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Entered_Time 7 [Entered_Time (Shipments!Made)] [Shipments_Made] Entered_Time 65 datetime Year true "DATE" [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipping_Amount_Local 5 [Shipping_Amount_Local] [Shipments_Made] Shipping_Amount_Local 66 real Sum 15 true "R8" [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Customer_Account_ID 20 [Customer_Account_ID] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Account_ID 0 Customer_Master integer Sum 3752 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Account_Name 129 [Customer_Account_Name] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Account_Name 1 Customer_Master string Count 3645 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_Street_Address1 129 [Customer_Physical_Street_Address1] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_Street_Address1 2 Customer_Master string Count 3752 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_Street_Address2 129 [Customer_Physical_Street_Address2] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_Street_Address2 3 Customer_Master string Count 1 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_City 129 [Customer_Physical_City] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_City 4 Customer_Master string Count 1127 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_State_Province 129 [Customer_Physical_State_Province] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_State_Province 5 Customer_Master string Count 43 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_ZipPostalCode 20 [Customer_Physical_ZipPostalCode] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Customer_Physical_ZipPostalCode 6 Customer_Master integer Sum 1127 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Active_Date 133 [Active_Date] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Active_Date 7 Customer_Master date Year 1479 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Inactive_Date 133 [Inactive_Date] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Inactive_Date 8 Customer_Master date Year 816 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Transaction_Credit_Limit 20 [Transaction_Credit_Limit] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Transaction_Credit_Limit 9 Customer_Master integer Sum 3 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Overall_Credit_Limit 20 [Overall_Credit_Limit] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Overall_Credit_Limit 10 Customer_Master integer Sum 3 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Terms_Discount_Percentage 5 [Terms_Discount_Percentage] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Terms_Discount_Percentage 11 Customer_Master real Sum 2 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Terms_Discount_Days 20 [Terms_Discount_Days] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Terms_Discount_Days 12 Customer_Master integer Sum 1 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Terms_Due_Days 20 [Terms_Due_Days] [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Terms_Due_Days 13 Customer_Master integer Sum 1 true [Customer!Master_EF9A85C0D4CF4ADD9DF63A28AAF0BF8B] Sales_Order_ID 20 [Sales_Order_ID] [Sales!Orders_1F185952615742729A875B0BC051F641] Sales_Order_ID 14 Sales_Orders integer Sum 6583 true [Sales!Orders_1F185952615742729A875B0BC051F641] Sales_Order_Date 133 [Sales_Order_Date] [Sales!Orders_1F185952615742729A875B0BC051F641] Sales_Order_Date 15 Sales_Orders date Year 276 true [Sales!Orders_1F185952615742729A875B0BC051F641] Customer_Account_ID 20 [Customer_Account_ID (Sales!Orders)] [Sales!Orders_1F185952615742729A875B0BC051F641] Customer_Account_ID 16 Sales_Orders integer Sum 2179 true [Sales!Orders_1F185952615742729A875B0BC051F641] Sales_Order_Amount 5 [Sales_Order_Amount] [Sales!Orders_1F185952615742729A875B0BC051F641] Sales_Order_Amount 17 Sales_Orders real Sum 5643 true [Sales!Orders_1F185952615742729A875B0BC051F641] Entered_By 20 [Entered_By] [Sales!Orders_1F185952615742729A875B0BC051F641] Entered_By 18 Sales_Orders integer Sum 104 true [Sales!Orders_1F185952615742729A875B0BC051F641] Entered_Date 133 [Entered_Date] [Sales!Orders_1F185952615742729A875B0BC051F641] Entered_Date 19 Sales_Orders date Year 276 true [Sales!Orders_1F185952615742729A875B0BC051F641] Entered_Time 135 [Entered_Time] [Sales!Orders_1F185952615742729A875B0BC051F641] Entered_Time 20 Sales_Orders datetime Year 5172 true [Sales!Orders_1F185952615742729A875B0BC051F641] Approved_By 20 [Approved_By] [Sales!Orders_1F185952615742729A875B0BC051F641] Approved_By 21 Sales_Orders integer Sum 6 true [Sales!Orders_1F185952615742729A875B0BC051F641] Approved_Date 133 [Approved_Date] [Sales!Orders_1F185952615742729A875B0BC051F641] Approved_Date 22 Sales_Orders date Year 422 true [Sales!Orders_1F185952615742729A875B0BC051F641] Approved_Time 135 [Approved_Time] [Sales!Orders_1F185952615742729A875B0BC051F641] Approved_Time 23 Sales_Orders datetime Year 3993 true [Sales!Orders_1F185952615742729A875B0BC051F641] Last_Modified_By 20 [Last_Modified_By] [Sales!Orders_1F185952615742729A875B0BC051F641] Last_Modified_By 24 Sales_Orders integer Sum 6 true [Sales!Orders_1F185952615742729A875B0BC051F641] Last_Modified_Date 133 [Last_Modified_Date] [Sales!Orders_1F185952615742729A875B0BC051F641] Last_Modified_Date 25 Sales_Orders date Year 422 true [Sales!Orders_1F185952615742729A875B0BC051F641] Last_Modified_Time 135 [Last_Modified_Time] [Sales!Orders_1F185952615742729A875B0BC051F641] Last_Modified_Time 26 Sales_Orders datetime Year 4700 true [Sales!Orders_1F185952615742729A875B0BC051F641] Invoice_ID 20 [Invoice_ID] [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_ID 27 Invoices_Generated integer Sum 6571 true [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_Date 133 [Invoice_Date] [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_Date 28 Invoices_Generated date Year 441 true [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_Due_Date 133 [Invoice_Due_Date] [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_Due_Date 29 Invoices_Generated date Year 441 true [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Sales_Order_ID 20 [Sales_Order_ID (Invoices!Generated)] [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Sales_Order_ID 30 Invoices_Generated integer Sum 6571 true [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Entered_By 20 [Entered_By (Invoices!Generated)] [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Entered_By 31 Invoices_Generated integer Sum 1 true [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Entered_Date 133 [Entered_Date (Invoices!Generated)] [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Entered_Date 32 Invoices_Generated date Year 441 true [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Entered_Time 135 [Entered_Time (Invoices!Generated)] [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Entered_Time 33 Invoices_Generated datetime Year 4175 true [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_Amount 5 [Invoice_Amount] [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Invoice_Amount 34 Invoices_Generated real Sum 5868 true [Invoices!Generated_9E39A2EA9BE547C5AA707EAC4ADCF7EB] Adjustment_ID 20 [Adjustment_ID] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_ID 35 AR_Adjustments integer Sum 296 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_Type 129 [Adjustment_Type] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_Type 36 AR_Adjustments string Count 1 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Invoice_ID 20 [Invoice_ID (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Invoice_ID 37 AR_Adjustments integer Sum 294 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_Date 133 [Adjustment_Date] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_Date 38 AR_Adjustments date Year 204 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_Amount 5 [Adjustment_Amount] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Adjustment_Amount 39 AR_Adjustments real Sum 295 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Entered_By 20 [Entered_By (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Entered_By 40 AR_Adjustments integer Sum 1 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Entered_Date 133 [Entered_Date (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Entered_Date 41 AR_Adjustments date Year 206 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Entered_Time 5 [Entered_Time (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Entered_Time 42 AR_Adjustments real Sum 295 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Approved_By 20 [Approved_By (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Approved_By 43 AR_Adjustments integer Sum 1 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Approved_Date 133 [Approved_Date (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Approved_Date 44 AR_Adjustments date Year 195 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Approved_Time 135 [Approved_Time (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Approved_Time 45 AR_Adjustments datetime Year 296 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Last_Modified_By 20 [Last_Modified_By (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Last_Modified_By 46 AR_Adjustments integer Sum 1 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Last_Modified_Date 133 [Last_Modified_Date (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Last_Modified_Date 47 AR_Adjustments date Year 195 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Last_Modified_Time 135 [Last_Modified_Time (AR!Adjustments)] [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Last_Modified_Time 48 AR_Adjustments datetime Year 296 true [AR!Adjustments_3BD415A16F87401EA791B2780B252BC7] Receipt_ID 20 [Receipt_ID] [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_ID 49 Cash_Received integer Sum 5008 true [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_Date 133 [Receipt_Date] [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_Date 50 Cash_Received date Year 354 true [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Invoice_ID 20 [Invoice_ID (Cash!Received)] [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Invoice_ID 51 Cash_Received integer Sum 5008 true [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_Type 129 [Receipt_Type] [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_Type 52 Cash_Received string Count 1 true [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_Amount 5 [Receipt_Amount] [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Receipt_Amount 53 Cash_Received real Sum 5008 true [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Posting_Status 129 [Posting_Status] [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Posting_Status 54 Cash_Received string Count 1 true [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Entered_By 20 [Entered_By (Cash!Received)] [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Entered_By 55 Cash_Received integer Sum 2 true [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Entered_Date 133 [Entered_Date (Cash!Received)] [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Entered_Date 56 Cash_Received date Year 360 true [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Entered_Time 135 [Entered_Time (Cash!Received)] [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Entered_Time 57 Cash_Received datetime Year 3303 true [Cash!Received_BF6A53616ED7469EA2A0BB08F398654B] Shipment_ID 20 [Shipment_ID] [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipment_ID 58 Shipments_Made integer Sum 6562 true [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipment_Date 133 [Shipment_Date] [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipment_Date 59 Shipments_Made date Year 424 true [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipping_Document_ID 20 [Shipping_Document_ID] [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipping_Document_ID 60 Shipments_Made integer Sum 6562 true [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Sales_Order_ID 20 [Sales_Order_ID (Shipments!Made)] [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Sales_Order_ID 61 Shipments_Made integer Sum 6562 true [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Sales_Order_Date 133 [Sales_Order_Date (Shipments!Made)] [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Sales_Order_Date 62 Shipments_Made date Year 278 true [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Entered_By 20 [Entered_By (Shipments!Made)] [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Entered_By 63 Shipments_Made integer Sum 1 true [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Entered_Date 133 [Entered_Date (Shipments!Made)] [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Entered_Date 64 Shipments_Made date Year 424 true [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Entered_Time 135 [Entered_Time (Shipments!Made)] [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Entered_Time 65 Shipments_Made datetime Year 4045 true [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipping_Amount_Local 5 [Shipping_Amount_Local] [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] Shipping_Amount_Local 66 Shipments_Made real Sum 1986 true [Shipments!Made_6B78C0FDD44942F18019FDEA4ED28D0D] "[federated.15klil913yqj9217dgued16gu8ge].[sum:Adjustment_Amount:qk]" "[federated.15klil913yqj9217dgued16gu8ge]" "[federated.15klil913yqj9217dgued16gu8ge].[sum:Calculation_410953467594194961:qk]" "[federated.15klil913yqj9217dgued16gu8ge].[sum:Invoice_Amount:qk]" "[federated.15klil913yqj9217dgued16gu8ge].[avg:Calculation_410953467537244169:qk]" "[federated.15klil913yqj9217dgued16gu8ge].[sum:Invoice_Amount:qk]" "[federated.15klil913yqj9217dgued16gu8ge].[usr:Calculation_410953467601080338:qk]" 1.0 11703.4 [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[usr:Calculation_410953467601080338:qk] ([federated.15klil913yqj9217dgued16gu8ge].[none:Invoice_ID:ok] / [federated.15klil913yqj9217dgued16gu8ge].[none:Customer_Account_ID:ok]) [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[mn:Invoice_Date:ok] ([federated.15klil913yqj9217dgued16gu8ge].[sum:Invoice_Amount:qk] + [federated.15klil913yqj9217dgued16gu8ge].[sum:Adjustment_Amount:qk]) [federated.15klil913yqj9217dgued16gu8ge].[sum:Order to Ship Days (copy)_410953467564957707:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Sales_Order_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[none:Invoice_ID:ok] ([federated.15klil913yqj9217dgued16gu8ge].[none:Invoice_ID:ok] / ([federated.15klil913yqj9217dgued16gu8ge].[none:Sales_Order_ID:ok] / [federated.15klil913yqj9217dgued16gu8ge].[none:Shipment_ID:ok])) [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] What is the Monthly Average time for Orders Completion? [federated.15klil913yqj9217dgued16gu8ge].[avg:Order to Ship Days (copy)_410953467564957707:qk] [federated.15klil913yqj9217dgued16gu8ge].[tmn:Sales_Order_Date:qk] Do your customers pay on time? [federated.15klil913yqj9217dgued16gu8ge].[avg:Calculation_410953467568107532:qk] [federated.15klil913yqj9217dgued16gu8ge].[tmn:Invoice_Date:qk] [federated.15klil913yqj9217dgued16gu8ge].[avg:Calculation_410953467568107532:qk] What is the trend of monthly total sales? What is the Average time for every phase in O2C process? [federated.15klil913yqj9217dgued16gu8ge].[mn:Sales_Order_Date (Shipments!Made):ok] ([federated.15klil913yqj9217dgued16gu8ge].[tmn:Sales_Order_Date (Shipments!Made):ok] / ([federated.15klil913yqj9217dgued16gu8ge].[avg:Order to Ship Days 2 (copy)_410953467570892815:ok] / ([federated.15klil913yqj9217dgued16gu8ge].[avg:Order to Ship Days 2 (copy)_410953467570524173:ok] / [federated.15klil913yqj9217dgued16gu8ge].[avg:Order to Ship Days (copy)_410953467564957707:ok]))) [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] How early can an invoice be converted into receipt? [federated.15klil913yqj9217dgued16gu8ge].[tmn:Invoice_Date:ok] "[federated.15klil913yqj9217dgued16gu8ge].[sum:Invoice_Amount:qk]" "[federated.15klil913yqj9217dgued16gu8ge].[sum:Receipt_Amount:qk]" "[federated.15klil913yqj9217dgued16gu8ge].[sum:Adjustment_Amount:qk]" [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[tmn:Invoice_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[tmn:Invoice_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[sum:Sales_Order_Amount:qk] [federated.15klil913yqj9217dgued16gu8ge].[mn:Sales_Order_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Customer_Account_Name:nk] [federated.15klil913yqj9217dgued16gu8ge].[sum:Sales_Order_Amount:qk] [federated.15klil913yqj9217dgued16gu8ge].[mn:Sales_Order_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[dy:Sales_Order_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[dy:Sales_Order_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[tmn:Invoice_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[tmn:Invoice_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[Multiple Values] #2020-03-01 00:00:00# "[federated.15klil913yqj9217dgued16gu8ge].[usr:Calculation_410953467601080338:qk]" -1.3824319466948509e-10 [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[none:Invoice_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Sales_Order_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Shipment_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Invoice_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Sales_Order_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Shipment_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Shipment_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] 300062467 100038867 #2020-01-04# 200035491 "[federated.15klil913yqj9217dgued16gu8ge]" [federated.15klil913yqj9217dgued16gu8ge].[none:Customer_Account_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Invoice_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[yr:Invoice_Due_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[mn:Invoice_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[sum:Order to Ship Days (copy)_410953467564957707:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[mn:Sales_Order_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Invoice_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Shipment_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[none:Shipment_ID:ok] [federated.15klil913yqj9217dgued16gu8ge].[tdy:Shipment_Date:qk] [federated.15klil913yqj9217dgued16gu8ge].[yr:Shipment_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[avg:Order to Ship Days (copy)_410953467564957707:qk] [federated.15klil913yqj9217dgued16gu8ge].[yr:Sales_Order_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[yr:Invoice_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[mn:Sales_Order_Date (Shipments!Made):ok] [federated.15klil913yqj9217dgued16gu8ge].[sum:Order to Ship Days (copy)_410953467564957707:ok] [federated.15klil913yqj9217dgued16gu8ge].[sum:Order to Ship Days 2 (copy)_410953467570524173:ok] [federated.15klil913yqj9217dgued16gu8ge].[sum:Order to Ship Days 2 (copy)_410953467570683918:ok] [federated.15klil913yqj9217dgued16gu8ge].[sum:Order to Ship Days 2 (copy)_410953467570892815:ok] [federated.15klil913yqj9217dgued16gu8ge].[avg:Order to Ship Days 2 (copy)_410953467570892815:ok] [federated.15klil913yqj9217dgued16gu8ge].[tmn:Invoice_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[tmn:Invoice_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[yr:Invoice_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[mn:Sales_Order_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[:Measure Names] [federated.15klil913yqj9217dgued16gu8ge].[dy:Sales_Order_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[mn:Sales_Order_Date:ok] [federated.15klil913yqj9217dgued16gu8ge].[yr:Sales_Order_Date:ok]