viw_ai_salrejectgoods.md 16.5 KB

viw_ai_salrejectgoods(视图)

  • 是否可更新: YES
  • 定义者: xlyprint@%

字段

# 名称 类型 可空
1 sId varchar(100) NO
2 sBrandsId varchar(100) NO
3 sSubsidiaryId varchar(100) NO
4 tCreateDate datetime NO
5 tUpdateDate datetime NO
6 sMakePerson varchar(255) NO
7 iOrder int NO
8 sFormId varchar(100) NO
9 sBillNo varchar(255) NO
10 sCustomerId varchar(100) NO
11 sContacts varchar(255) YES
12 sPhone varchar(255) YES
13 tDeliverDate datetime YES
14 sSalesManId varchar(100) YES
15 sGetPayId varchar(100) YES
16 tGetPayDate datetime YES
17 sConsignee varchar(255) YES
18 sConsigneeMobile varchar(255) YES
19 sDeliverId varchar(100) NO
20 sProvince varchar(255) YES
21 sCity varchar(255) YES
22 sArea varchar(255) YES
23 sDeliverTo varchar(255) YES
24 sManualNo varchar(255) YES
25 sMemo text YES
26 bCheck bit(1) NO
27 tCheckDate datetime YES
28 sCheckPerson varchar(255) YES
29 bPrint bit(1) NO
30 bCopyLimit bit(1) NO
31 dAdvanceMoney decimal(18,6) YES
32 tAdvanceDate datetime YES
33 dRealAdvanceMoney decimal(18,6) YES
34 sCurrency varchar(255) YES
35 dCurrencyRate decimal(18,6) YES
36 sStatus varchar(255) YES
37 bInvalid bit(1) NO
38 sMReserve1 varchar(255) YES
39 sMReserve2 varchar(255) YES
40 sMReserve3 varchar(255) YES
41 sMReserve4 varchar(255) YES
42 sMReserve5 varchar(255) YES
43 sMReserve6 varchar(255) YES
44 dMReserve1 decimal(18,6) YES
45 dMReserve2 decimal(18,6) YES
46 dMReserve3 decimal(18,6) YES
47 iMReserve1 int YES
48 iMReserve2 int YES
49 iMReserve3 int YES
50 tMReserve1 datetime YES
51 tMReserve2 datetime YES
52 sSlaveId varchar(100) NO
53 iSlaveOrder int NO
54 sProductId varchar(100) NO
55 dProductQty decimal(18,6) NO
56 dProductPrice decimal(18,6) NO
57 dProductMoney decimal(18,6) NO
58 sMaterialsMemo text YES
59 sProcessMemo text YES
60 sSrcSlaveId varchar(100) NO
61 sSrcId varchar(100) NO
62 sSrcNo varchar(255) NO
63 dSrcQty decimal(18,6) YES
64 dProductPQty decimal(18,6) YES
65 bCheckingComplete bit(1) NO
66 sSlaveMemo text YES
67 sTaxId varchar(100) YES
68 dProductNoTaxPrice decimal(18,6) YES
69 dProductNoTaxMoney decimal(18,6) YES
70 dProductTaxMoney decimal(18,6) YES
71 dProductTaxForeignMoney decimal(18,6) YES
72 dProductForeignMoney decimal(18,6) YES
73 dCheckingQty decimal(18,6) NO
74 dReceiptMoney decimal(18,6) NO
75 sWebOrderNo varchar(255) NO
76 sWebOrderId varchar(100) NO
77 sBarcode varchar(255) YES
78 dGiveQty decimal(18,6) NO
79 dDeliverQty decimal(18,6) NO
80 sDefineNo varchar(100) NO
81 sDefineNo2 varchar(100) NO
82 sWareHouseId varchar(100) NO
83 sLocationId varchar(100) NO
84 sWareHouseLocationId varchar(100) NO
85 sOrderId varchar(100) NO
86 sOrderNo varchar(255) NO
87 sWorkOrderId varchar(100) NO
88 sWorkOrderNo varchar(255) NO
89 sCustomerOrderNo varchar(255) YES
90 sSReserve1 varchar(255) YES
91 sSReserve2 varchar(255) YES
92 sSReserve3 varchar(255) YES
93 sSReserve4 varchar(255) YES
94 sSReserve5 varchar(255) YES
95 sSReserve6 varchar(255) YES
96 dSReserve1 decimal(18,6) YES
97 dSReserve2 decimal(18,6) YES
98 dSReserve3 decimal(18,6) YES
99 iSReserve1 int YES
100 iSReserve2 int YES
101 iSReserve3 int YES
102 tSReserve1 datetime YES
103 tSReserve2 datetime YES
104 sWorkOrderSlaveId varchar(100) NO
105 sOrderSlaveId varchar(100) NO
106 bInvoiceComplete bit(1) NO
107 dInvoiceMoney decimal(18,6) NO
108 dProductForeignPrice decimal(18,6) NO
109 sType varchar(255) NO
110 iIncrement int NO
111 dNProductPrice decimal(18,6) NO
112 dNProductMoney decimal(18,6) NO
113 sAuxiliaryUnit varchar(100) NO
114 dMaterialsQty decimal(18,6) NO
115 dCostPrice decimal(18,6) YES
116 dCostMoney decimal(18,6) YES
117 sVoucherBillminusNo varchar(255) NO
118 sVoucherBillminusId varchar(255) NO
119 sVoucherBillNo varchar(255) NO
120 sVoucherBillId varchar(255) NO
121 sMaterialsStyle varchar(100) NO
122 sMinusSrcId varchar(255) NO
123 sRejType varchar(255) YES
124 sDeliverSrcId varchar(255) YES
125 sDeliverSrcSlaveId varchar(255) YES
126 sDeliverSrcNo varchar(255) YES
127 dSingleReceiptQty decimal(18,6) NO
128 bNoObject bit(1) NO
129 bSingleReceipt int NO
130 bFinance int NO
131 dRemainderQty decimal(18,2) NO
132 dStockupQty decimal(18,6) NO
133 dBackRemainderQty decimal(18,2) NO
134 dPresentQty decimal(18,6) NO
135 sWareHouseName varchar(255) NO
136 sCustomerName varchar(255) NO
137 sProductName varchar(100) NO

定义

select `xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`tCreateDate` AS `tUpdateDate`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sCustomerId` AS `sCustomerId`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sContacts` AS `sContacts`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sPhone` AS `sPhone`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`tDeliverDate` AS `tDeliverDate`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sSalesManId` AS `sSalesManId`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sGetPayId` AS `sGetPayId`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`tGetPayDate` AS `tGetPayDate`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sConsignee` AS `sConsignee`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sConsigneeMobile` AS `sConsigneeMobile`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sDeliverId` AS `sDeliverId`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sProvince` AS `sProvince`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sCity` AS `sCity`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sArea` AS `sArea`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sDeliverTo` AS `sDeliverTo`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sManualNo` AS `sManualNo`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`bPrint` AS `bPrint`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`bCopyLimit` AS `bCopyLimit`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`dAdvanceMoney` AS `dAdvanceMoney`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`tAdvanceDate` AS `tAdvanceDate`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`dRealAdvanceMoney` AS `dRealAdvanceMoney`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sCurrency` AS `sCurrency`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`dCurrencyRate` AS `dCurrencyRate`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`iOrder` AS `iSlaveOrder`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sProductId` AS `sProductId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductQty` AS `dProductQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductPrice` AS `dProductPrice`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductMoney` AS `dProductMoney`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sMaterialsMemo` AS `sMaterialsMemo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sProcessMemo` AS `sProcessMemo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSrcSlaveId` AS `sSrcSlaveId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSrcId` AS `sSrcId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSrcNo` AS `sSrcNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dSrcQty` AS `dSrcQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductPQty` AS `dProductPQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`bCheckingComplete` AS `bCheckingComplete`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSlaveMemo` AS `sSlaveMemo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sTaxId` AS `sTaxId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductNoTaxPrice` AS `dProductNoTaxPrice`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductNoTaxMoney` AS `dProductNoTaxMoney`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductTaxMoney` AS `dProductTaxMoney`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductTaxForeignMoney` AS `dProductTaxForeignMoney`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductForeignMoney` AS `dProductForeignMoney`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dCheckingQty` AS `dCheckingQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dReceiptMoney` AS `dReceiptMoney`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sWebOrderNo` AS `sWebOrderNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sWebOrderId` AS `sWebOrderId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sBarcode` AS `sBarcode`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dGiveQty` AS `dGiveQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dDeliverQty` AS `dDeliverQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sDefineNo2` AS `sDefineNo2`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sWareHouseId` AS `sWareHouseId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sLocationId` AS `sLocationId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sWareHouseLocationId` AS `sWareHouseLocationId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sOrderId` AS `sOrderId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sOrderNo` AS `sOrderNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sWorkOrderId` AS `sWorkOrderId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sWorkOrderNo` AS `sWorkOrderNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sCustomerOrderNo` AS `sCustomerOrderNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSReserve1` AS `sSReserve1`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSReserve2` AS `sSReserve2`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSReserve3` AS `sSReserve3`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSReserve4` AS `sSReserve4`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSReserve5` AS `sSReserve5`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSReserve6` AS `sSReserve6`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dSReserve1` AS `dSReserve1`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dSReserve2` AS `dSReserve2`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dSReserve3` AS `dSReserve3`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`iSReserve1` AS `iSReserve1`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`iSReserve2` AS `iSReserve2`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`iSReserve3` AS `iSReserve3`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`tSReserve1` AS `tSReserve1`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`tSReserve2` AS `tSReserve2`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sWorkOrderSlaveId` AS `sWorkOrderSlaveId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sOrderSlaveId` AS `sOrderSlaveId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`bInvoiceComplete` AS `bInvoiceComplete`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dInvoiceMoney` AS `dInvoiceMoney`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dProductForeignPrice` AS `dProductForeignPrice`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sType` AS `sType`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dNProductPrice` AS `dNProductPrice`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dNProductMoney` AS `dNProductMoney`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dMaterialsQty` AS `dMaterialsQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dCostPrice` AS `dCostPrice`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dCostMoney` AS `dCostMoney`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sVoucherBillminusNo` AS `sVoucherBillminusNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sVoucherBillminusId` AS `sVoucherBillminusId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sVoucherBillNo` AS `sVoucherBillNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sVoucherBillId` AS `sVoucherBillId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sMaterialsStyle` AS `sMaterialsStyle`,`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sMinusSrcId` AS `sMinusSrcId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sRejType` AS `sRejType`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sDeliverSrcId` AS `sDeliverSrcId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sDeliverSrcSlaveId` AS `sDeliverSrcSlaveId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sDeliverSrcNo` AS `sDeliverSrcNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dSingleReceiptQty` AS `dSingleReceiptQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`bNoObject` AS `bNoObject`,0 AS `bSingleReceipt`,0 AS `bFinance`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dRemainderQty` AS `dRemainderQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dStockupQty` AS `dStockupQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dBackRemainderQty` AS `dBackRemainderQty`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`dPresentQty` AS `dPresentQty`,`xlyweberp_saas_ai`.`siswarehouse`.`sName` AS `sWareHouseName`,`xlyweberp_saas_ai`.`elecustomer`.`sCustomerName` AS `sCustomerName`,`xlyweberp_saas_ai`.`eleproduct`.`sProductName` AS `sProductName` from ((((`xlyweberp_saas_ai`.`salrejectgoodsmaster` join `xlyweberp_saas_ai`.`salrejectgoodsslave` on((`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sParentId` = `xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sId`))) join `xlyweberp_saas_ai`.`siswarehouse` on((`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sWareHouseId` = `xlyweberp_saas_ai`.`siswarehouse`.`sId`))) join `xlyweberp_saas_ai`.`elecustomer` on((`xlyweberp_saas_ai`.`salrejectgoodsmaster`.`sCustomerId` = `xlyweberp_saas_ai`.`elecustomer`.`sId`))) join `xlyweberp_saas_ai`.`eleproduct` on((`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sProductId` = `xlyweberp_saas_ai`.`eleproduct`.`sId`)))

说明

暂无人工说明。