viw_ai_purpurchaseapply.md 8.89 KB

Edit Raw Blame History Permalink



viw_ai_purpurchaseapply（视图）


是否可更新： NO

定义者： 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
sEmployeeId
varchar(100)
NO


11
sManualNo
varchar(255)
YES


12
sMemo
text
YES


13
tCheckDate
datetime
YES


14
sCheckPerson
varchar(255)
YES


15
sSlaveId
varchar(100)
NO


16
iSlaveOrder
int
NO


17
sMaterialsId
varchar(100)
NO


18
sMaterialsStyle
varchar(255)
NO


19
dAuxiliaryQty
decimal(18,6)
NO


20
sAuxiliaryUnit
varchar(255)
NO


21
dMaterialsQty
decimal(18,6)
NO


22
dConversionQty
decimal(18,6)
NO


23
dMaterialsPrice
decimal(18,6)
NO


24
dMaterialsMoney
decimal(18,6)
NO


25
sSrcSlaveId
varchar(100)
NO


26
sSrcId
varchar(100)
NO


27
sSrcNo
varchar(255)
NO


28
dSrcQty
decimal(18,6)
YES


29
sSlaveMemo
text
YES


30
dMaterialsNoTaxPrice
decimal(18,6)
YES


31
dMaterialsNoTaxMoney
decimal(18,6)
YES


32
dMaterialsTaxMoney
decimal(18,6)
YES


33
dMaterialsTaxForeignMoney
decimal(18,6)
YES


34
dMaterialsForeignMoney
decimal(18,6)
YES


35
dOrderAuxiliaryQty
decimal(18,6)
NO


36
dOrderQty
decimal(18,6)
NO


37
sOrderId
varchar(100)
NO


38
sOrderNo
varchar(255)
NO


39
sWorkOrderId
varchar(100)
NO


40
sWorkOrderNo
varchar(255)
NO


41
sWorkOrderControlId
varchar(100)
NO


42
iIncrement
int
NO


43
sSupplyId
varchar(50)
YES


44
sMaterialsType
varchar(50)
YES


45
sSupplyName
varchar(255)
YES


46
sCity
varchar(255)
YES


47
sArea
varchar(255)
YES


48
sCompanyAddress
varchar(255)
YES


49
sContacts
varchar(255)
YES


50
sMobile
varchar(255)
YES


51
sTaxId
varchar(100)
YES


52
sGetPayId
varchar(100)
YES


53
sPhone1
varchar(255)
YES


54
sPhone2
varchar(255)
YES


55
sEmail
varchar(255)
YES


56
sPurchaseManId
varchar(100)
YES


57
sRemainderType
varchar(255)
YES


58
dKGQty
decimal(18,6)
YES


59
bQly
bit(1)
YES


60
dQlyQty
int
YES


61
dMaterialsTestAuxiliaryQty
decimal(18,6)
NO


62
dMaterialsTestQty
decimal(18,6)
NO


63
bMaterialsTestComplete
bit(1)
YES


64
iTestResult
bit(1)
YES


65
bInStoreComplete
bit(1)
YES


66
bFast
bit(1)
YES


67
tFastDate
datetime
YES


68
sFastPerson
varchar(255)
YES


69
sCustomerId
varchar(255)
YES


70
sMaterialsNo
varchar(50)
YES


71
sMaterialsName
varchar(100)
YES


定义
select `xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`tCreateDate` AS `tUpdateDate`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sEmployeeId` AS `sEmployeeId`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sManualNo` AS `sManualNo`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`iOrder` AS `iSlaveOrder`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sMaterialsId` AS `sMaterialsId`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sMaterialsStyle` AS `sMaterialsStyle`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsQty` AS `dMaterialsQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dConversionQty` AS `dConversionQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsPrice` AS `dMaterialsPrice`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsMoney` AS `dMaterialsMoney`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sSrcSlaveId` AS `sSrcSlaveId`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sSrcId` AS `sSrcId`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sSrcNo` AS `sSrcNo`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dSrcQty` AS `dSrcQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sSlaveMemo` AS `sSlaveMemo`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsNoTaxPrice` AS `dMaterialsNoTaxPrice`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsNoTaxMoney` AS `dMaterialsNoTaxMoney`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsTaxMoney` AS `dMaterialsTaxMoney`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsTaxForeignMoney` AS `dMaterialsTaxForeignMoney`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsForeignMoney` AS `dMaterialsForeignMoney`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dOrderAuxiliaryQty` AS `dOrderAuxiliaryQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dOrderQty` AS `dOrderQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sOrderId` AS `sOrderId`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sOrderNo` AS `sOrderNo`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sWorkOrderId` AS `sWorkOrderId`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sWorkOrderNo` AS `sWorkOrderNo`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sWorkOrderControlId` AS `sWorkOrderControlId`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`elematerials`.`sSupplyId` AS `sSupplyId`,`xlyweberp_saas_ai`.`elematerials`.`sMaterialsType` AS `sMaterialsType`,`xlyweberp_saas_ai`.`elesupply`.`sSupplyName` AS `sSupplyName`,`xlyweberp_saas_ai`.`elesupply`.`sCity` AS `sCity`,`xlyweberp_saas_ai`.`elesupply`.`sArea` AS `sArea`,`xlyweberp_saas_ai`.`elesupply`.`sCompanyAddress` AS `sCompanyAddress`,`xlyweberp_saas_ai`.`elesupply`.`sContacts` AS `sContacts`,`xlyweberp_saas_ai`.`elesupply`.`sMobile` AS `sMobile`,`xlyweberp_saas_ai`.`elesupply`.`sTaxId` AS `sTaxId`,`xlyweberp_saas_ai`.`elesupply`.`sGetPayId` AS `sGetPayId`,`xlyweberp_saas_ai`.`elesupply`.`sPhone1` AS `sPhone1`,`xlyweberp_saas_ai`.`elesupply`.`sPhone2` AS `sPhone2`,`xlyweberp_saas_ai`.`elesupply`.`sEmail` AS `sEmail`,`xlyweberp_saas_ai`.`elesupply`.`sPurchaseManId` AS `sPurchaseManId`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sRemainderType` AS `sRemainderType`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dKGQty` AS `dKGQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`bQly` AS `bQly`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dQlyQty` AS `dQlyQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsTestAuxiliaryQty` AS `dMaterialsTestAuxiliaryQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`dMaterialsTestQty` AS `dMaterialsTestQty`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`bMaterialsTestComplete` AS `bMaterialsTestComplete`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`iTestResult` AS `iTestResult`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`bInStoreComplete` AS `bInStoreComplete`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`bFast` AS `bFast`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`tFastDate` AS `tFastDate`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sFastPerson` AS `sFastPerson`,`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sCustomerId` AS `sCustomerId`,`xlyweberp_saas_ai`.`elematerials`.`sMaterialsNo` AS `sMaterialsNo`,`xlyweberp_saas_ai`.`elematerials`.`sMaterialsName` AS `sMaterialsName` from (((`xlyweberp_saas_ai`.`purpurchaseapplymaster` join `xlyweberp_saas_ai`.`purpurchaseapplyslave` on((`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sParentId` = `xlyweberp_saas_ai`.`purpurchaseapplymaster`.`sId`))) left join `xlyweberp_saas_ai`.`elematerials` on((`xlyweberp_saas_ai`.`purpurchaseapplyslave`.`sMaterialsId` = `xlyweberp_saas_ai`.`elematerials`.`sId`))) left join `xlyweberp_saas_ai`.`elesupply` on((`xlyweberp_saas_ai`.`elematerials`.`sSupplyId` = `xlyweberp_saas_ai`.`elesupply`.`sId`)))


说明

暂无人工说明。