viw_qlycomematerialstest_purpurchasearrive.md 7.06 KB

Edit Raw Blame History



viw_qlycomematerialstest_purpurchasearrive (view)


Updatable: YES


Columns


#
Name
Type
Null


1
sId
varchar(100)
NO


2
sBrandsId
varchar(100)
NO


3
sSubsidiaryId
varchar(100)
NO


4
tCreateDate
datetime
NO


5
sMakePerson
varchar(255)
NO


6
iOrder
int
NO


7
sFormId
varchar(100)
NO


8
sBillNo
varchar(255)
NO


9
sSupplyId
varchar(100)
NO


10
sManualNo
varchar(255)
YES


11
sMemo
text
YES


12
bCheck
bit(1)
NO


13
tCheckDate
datetime
YES


14
sCheckPerson
varchar(255)
YES


15
bPrint
bit(1)
NO


16
bCopyLimit
bit(1)
NO


17
sStatus
varchar(255)
YES


18
bInvalid
bit(1)
NO


19
sMReserve1
varchar(255)
YES


20
sMReserve2
varchar(255)
YES


21
sMReserve3
varchar(255)
YES


22
sMReserve4
varchar(255)
YES


23
sMReserve5
varchar(255)
YES


24
sMReserve6
varchar(255)
YES


25
dMReserve1
decimal(18,6)
YES


26
dMReserve2
decimal(18,6)
YES


27
dMReserve3
decimal(18,6)
YES


28
iMReserve1
int
YES


29
iMReserve2
int
YES


30
iMReserve3
int
YES


31
tMReserve1
datetime
YES


32
tMReserve2
datetime
YES


33
sTestStandardId
char(0)
NO


34
sSlaveId
varchar(100)
NO


35
sMaterialsId
varchar(100)
NO


36
sSrcSlaveId
varchar(100)
NO


37
sSrcId
varchar(100)
NO


38
sSrcNo
varchar(255)
NO


39
dSrcQty
decimal(18,6)
YES


40
sMaterialsStyle
varchar(255)
NO


41
dAuxiliaryQty
decimal(18,6)
NO


42
sAuxiliaryUnit
varchar(255)
NO


43
dMaterialsQty
decimal(18,6)
NO


44
dConversionQty
decimal(18,6)
NO


45
dSampleQty
int
NO


46
dQualifyQty
int
NO


47
dNoQualifyQty
int
NO


48
dRejectQty
int
NO


49
dInStoreAuxiliaryQty
decimal(18,6)
NO


50
dInStoreQty
decimal(18,6)
NO


51
sDefineNo
char(0)
NO


52
sDefineNo2
char(0)
NO


53
sTestPersonId
char(0)
NO


54
sOrderSlaveId
char(0)
NO


55
bInstoreComplete
bit(1)
NO


56
sWorkOrderSlaveId
char(0)
NO


57
sWorkOrderMaterialsTbId
char(0)
NO


58
sPurchaseOrderId
varchar(100)
NO


59
sPurchaseOrderSlaveId
varchar(100)
NO


60
sPurchaseOrderNo
varchar(255)
NO


61
dPresentAuxiliaryQty
decimal(18,6)
NO


62
dPresentQty
decimal(18,6)
NO


63
dGiveAuxiliaryQty
decimal(18,6)
NO


64
dGiveQty
decimal(18,6)
NO


65
dMaterialsPrice
decimal(18,6)
NO


66
dMaterialsMoney
decimal(18,6)
NO


67
dMaterialsTaxMoney
decimal(18,6)
YES


68
sWorkOrderNo
varchar(4000)
NO


69
sTaxId
varchar(100)
YES


70
dMaterialsNoTaxPrice
decimal(18,6)
YES


71
dMaterialsNoTaxMoney
decimal(18,6)
YES


72
dMaterialsTaxForeignMoney
decimal(18,6)
YES


73
dMaterialsForeignMoney
decimal(18,6)
YES


74
sOrderId
varchar(100)
NO


75
sOrderNo
varchar(255)
NO


76
sWorkOrderId
varchar(100)
NO


77
sWorkOrderControlId
varchar(100)
NO


78
iTestResult
int
YES


79
iTypeResult
int
YES


80
bVMI
bit(1)
YES


81
bQly
bit(1)
YES


82
dQlyQty
int
YES


83
sPurchaseApplyId
varchar(100)
YES


84
sPurchaseApplySlaveId
varchar(100)
YES


85
sPurchaseApplyNo
varchar(255)
YES


86
sGetPayId
varchar(100)
YES


87
bFast
bit(1)
YES


88
tFastDate
datetime
YES


89
sFastPerson
varchar(255)
YES


Definition
select `m`.`sId` AS `sId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`sMakePerson` AS `sMakePerson`,`m`.`iOrder` AS `iOrder`,`m`.`sFormId` AS `sFormId`,`m`.`sBillNo` AS `sBillNo`,`m`.`sSupplyId` AS `sSupplyId`,`m`.`sManualNo` AS `sManualNo`,`m`.`sMemo` AS `sMemo`,`m`.`bCheck` AS `bCheck`,`m`.`tCheckDate` AS `tCheckDate`,`m`.`sCheckPerson` AS `sCheckPerson`,`m`.`bPrint` AS `bPrint`,`m`.`bCopyLimit` AS `bCopyLimit`,`m`.`sStatus` AS `sStatus`,`m`.`bInvalid` AS `bInvalid`,`m`.`sMReserve1` AS `sMReserve1`,`m`.`sMReserve2` AS `sMReserve2`,`m`.`sMReserve3` AS `sMReserve3`,`m`.`sMReserve4` AS `sMReserve4`,`m`.`sMReserve5` AS `sMReserve5`,`m`.`sMReserve6` AS `sMReserve6`,`m`.`dMReserve1` AS `dMReserve1`,`m`.`dMReserve2` AS `dMReserve2`,`m`.`dMReserve3` AS `dMReserve3`,`m`.`iMReserve1` AS `iMReserve1`,`m`.`iMReserve2` AS `iMReserve2`,`m`.`iMReserve3` AS `iMReserve3`,`m`.`tMReserve1` AS `tMReserve1`,`m`.`tMReserve2` AS `tMReserve2`,'' AS `sTestStandardId`,`s`.`sId` AS `sSlaveId`,`s`.`sMaterialsId` AS `sMaterialsId`,`s`.`sId` AS `sSrcSlaveId`,`m`.`sId` AS `sSrcId`,`s`.`sSrcNo` AS `sSrcNo`,`s`.`dSrcQty` AS `dSrcQty`,`s`.`sMaterialsStyle` AS `sMaterialsStyle`,`s`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`s`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`s`.`dMaterialsQty` AS `dMaterialsQty`,`s`.`dConversionQty` AS `dConversionQty`,0 AS `dSampleQty`,0 AS `dQualifyQty`,0 AS `dNoQualifyQty`,0 AS `dRejectQty`,`s`.`dInStoreAuxiliaryQty` AS `dInStoreAuxiliaryQty`,`s`.`dInStoreQty` AS `dInStoreQty`,'' AS `sDefineNo`,'' AS `sDefineNo2`,'' AS `sTestPersonId`,'' AS `sOrderSlaveId`,`s`.`bInStoreComplete` AS `bInstoreComplete`,'' AS `sWorkOrderSlaveId`,'' AS `sWorkOrderMaterialsTbId`,`s`.`sPurchaseOrderId` AS `sPurchaseOrderId`,`s`.`sPurchaseOrderSlaveId` AS `sPurchaseOrderSlaveId`,`s`.`sPurchaseOrderNo` AS `sPurchaseOrderNo`,`s`.`dPresentAuxiliaryQty` AS `dPresentAuxiliaryQty`,`s`.`dPresentQty` AS `dPresentQty`,`s`.`dGiveAuxiliaryQty` AS `dGiveAuxiliaryQty`,`s`.`dGiveQty` AS `dGiveQty`,`s`.`dMaterialsPrice` AS `dMaterialsPrice`,`s`.`dMaterialsMoney` AS `dMaterialsMoney`,`s`.`dMaterialsTaxMoney` AS `dMaterialsTaxMoney`,`s`.`sWorkOrderNo` AS `sWorkOrderNo`,`s`.`sTaxId` AS `sTaxId`,`s`.`dMaterialsNoTaxPrice` AS `dMaterialsNoTaxPrice`,`s`.`dMaterialsNoTaxMoney` AS `dMaterialsNoTaxMoney`,`s`.`dMaterialsTaxForeignMoney` AS `dMaterialsTaxForeignMoney`,`s`.`dMaterialsForeignMoney` AS `dMaterialsForeignMoney`,`s`.`sOrderId` AS `sOrderId`,`s`.`sOrderNo` AS `sOrderNo`,`s`.`sWorkOrderId` AS `sWorkOrderId`,`s`.`sWorkOrderControlId` AS `sWorkOrderControlId`,`s`.`iTestResult` AS `iTestResult`,`s`.`iTypeResult` AS `iTypeResult`,`s`.`bVMI` AS `bVMI`,`s`.`bQly` AS `bQly`,`s`.`dQlyQty` AS `dQlyQty`,`s`.`sPurchaseApplyId` AS `sPurchaseApplyId`,`s`.`sPurchaseApplySlaveId` AS `sPurchaseApplySlaveId`,`s`.`sPurchaseApplyNo` AS `sPurchaseApplyNo`,`m`.`sGetPayId` AS `sGetPayId`,`s`.`bFast` AS `bFast`,`s`.`tFastDate` AS `tFastDate`,`s`.`sFastPerson` AS `sFastPerson` from (`purpurchasearrivemaster` `m` join `purpurchasearriveslave` `s` on((`s`.`sParentId` = `m`.`sId`)))


Narrative

No human-written narrative yet.