金蝶云星空销售、MRP、采购、生产、委外全流程跟踪SQL

select SalesOrderNumber,SalesReviewStatus,SalesClosedStatus,SalesOrderDate,SalesCustom,SalesItemNumber,
SalesItemName,SalesQty,SalesPrice,SalesTaxPrice,SalesOriginalCurrency,SalesAmountInBaseCurrency,SalesTaxRate,
SalesOriginalCurrencyTax,SalesBaseCurrencyTax,SalesTotalOriginalCurrencyPriceAndTax,SalesTotalBaseCurrencyPriceTax,
SalesCumulativeShipmentQty,SalesCumulativeOutboundQty,SalesCumulativeNumberOfReturn,SalesCumulativeReturnQty,PlannedOrderNumber,
PlannedOrderReviewStatus,PlannedOrderBusinessStatus,PlannedOrderItemNumber,PlannedOrderItemName,PlannedOrderItemDescription,PlannedOrderSuggestedQty,
PlannedOrderNetRequirements,PlannedOrderRequirementDate,PlannedOrderProposedPurchaseDate,PlannedOrderSuggestedArrivalDate,PlannedOrderRequirementDocumentNumber,
PlannedOrderRequirementDocumentNumber,BomVersion,ProductionOrderNumber,ProductionOrderDate,ProductionOrderReviewStatus,ProductionOrderItemNumber,ProductionOrderItemName,
ProductionOrderItemDescription,ProductionOrderQty,ProductionOrderFlnishedProductQty,ProductionOrderBusinessStatus,ProductionOrderPickingStatus,ProductionPickListNumber,
ProductionPicklistApprovalStatus,ProductionPicklistItemNumber,ProductionPicklistItemName,ProductionPicklistRequestQty,ProductionPickinglistActuallssusedQty,ProductionReceiptNumber,
ProductionReceiptOrderApprovalStatus,ProductionReceiptItemNumber,ProductionReceiptItemName,ProductionReceiptQtyReceivable,ProductionReceiptQtyReceived,ProductionReturnOrderNumber,
ProductionReturnOrderReviewStatus,ProductionReturnOrderItemNumber,ProductionReturnOrderItemName,ProductionReturnQtyReceivable,ProductionReturnQtyReceived,PurchaseRequisitionNumber,
PurchaseRequisitionDate,PurchaseRequisitionReviewStatus,PurchaseRequisitionItemNumber,PurchaseRequisitionItemName,PurchaseRequisitionRequestQty,PurchaseRequisitionApprovedQty,PurchaseRequisitionArrivalDate,
PurchaseRequisitionPrice,PurchaseRequisitionTaxPrice,PurchaseRequisitionRate,PurchaseRequisitionAmount,PurchaseRequisitionTaxAmount,PurchaseRequisitionProposalSupplierNumber,
PurchaseRequisitionProposalSupplierName,PurchaseOrderNumber,PurchaseOrderReviewStatus,PurchaseOrderSupplierNumber,PurchaseOrderSupplierName,PurchaseOrderItemNumber,PurchaseOrderItemName,PurchaseOrderPurchaseQty,
PurchaseOrderQuotationQty,PurchaseOrderPrice,PurchaseOrderTaxPrice,PurchaseOrderTax,PurchaseOrderAmount,PurchaseOrderTaxAmount,PurchaseOrderCumulativeReceiptQty,PurchaseOrderRemainingReceiptQty,
PurchaseOrderCumulativeInventoyQty,PurchaseOrderRemainingInventoryQty,PurchaseOrderCumulativeReturnQty,OutsourcingOrderNumber,OutsourcingOrderReviewStatus,OutsourcingOrderSupplierNumber,OutsourcingOrderSupplierName,
OutsourcingOrderItemNumber,OutsourcingOrderItemName,OutsourcedOrderOutsourcingQty,OutesourcedOrderReceiptQty,OutsourcedOrderUnstockedQty,OutsourcedOrderPlanStartDate,OutsourcedOrderPlannedCompletionDate,
OutsourcingOrderPickingStatus,OutsourcedOrderBusinessStatus,OutsourcedMaterialRequisitionNumber,OutsourcedMaterialRequisitionReviewStatus,OutsourcedPickingListSupplierNumber,OutsourcedPickingListSupplierName,
OutsourcedPickingListItemNumber,OutsourcedPickingListItemName,OutsourcedPickingListApplicationQty,QuantityOfOutsourcedMaterialRequisition,QuantityOfMaterialReturnedFromSubcontractingPicking from 
(select  tsorder.FBILLNO as SalesOrderNumber,
case tsorder.FDOCUMENTSTATUS WHEN 'A' THEN '创建'WHEN 'B' THEN '审核中'WHEN 'Z' THEN '暂存'WHEN 'C' THEN '已审核'WHEN 'D' THEN '重新审核'ELSE 'NULL'END as SalesReviewStatus,
case tsorder.FCLOSESTATUS	when 'B' then '关闭'when 'A' then '未关闭'else 'NULL'end AS SalesClosedStatus,tsorder.FDATE as SalesOrderDate,tbdcustoml.FNAME as SalesCustom,tbdmat.FNUMBER as SalesItemNumber,
tbdmatl.FNAME as SalesItemName,tsorderentry.FQTY as SalesQty,tsorderentryf.FPRICE as SalesPrice , tsorderentryf.FTAXPRICE as SalesTaxPrice,tsorderentryf.FAMOUNT as SalesOriginalCurrency,
tsorderentryf.FAMOUNT_LC as SalesAmountInBaseCurrency,tsorderentryf.FTAXRATE as SalesTaxRate,tsorderentryf.FTAXAMOUNT as SalesOriginalCurrencyTax,tsorderentryf.FTAXAMOUNT_LC as SalesBaseCurrencyTax,
tsorderentryf.FALLAMOUNT as SalesTotalOriginalCurrencyPriceAndTax,tsorderentryf.FALLAMOUNT_LC as SalesTotalBaseCurrencyPriceTax,tsorderentryr.FDeliQty as SalesCumulativeShipmentQty,
tsorderentryr.FStockOutQty as SalesCumulativeOutboundQty,tsorderentryr.FRetNoticeQty as SalesCumulativeNumberOfReturn,tsorderentryr.FReturnQty as SalesCumulativeReturnQty,tplnplan.FBILLNO as PlannedOrderNumber
,case tplnplan.FDOCUMENTSTATUS WHEN 'A' THEN '创建'WHEN 'B' THEN '审核中'WHEN 'Z' THEN '暂存'WHEN 'C' THEN '已审核'WHEN 'D' THEN '重新审核'ELSE