viw_cahpaymentmaster.md 6.3 KB

Edit Raw Blame History



viw_cahpaymentmaster (view)


VIEW


Updatable: YES

Definer: xlyprint@%


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
sBillType
varchar(255)
NO


9
sBillNo
varchar(255)
NO


10
sSupplyId
varchar(100)
NO


11
sContacts
varchar(255)
YES


12
sPhone
varchar(255)
YES


13
tDeliverDate
datetime
YES


14
sPurchaseId
varchar(100)
NO


15
sPurchaseManId
varchar(100)
NO


16
dTotalMoney
decimal(18,6)
NO


17
sGetPayId
varchar(100)
YES


18
tGetPayDate
datetime
YES


19
sConsignee
varchar(255)
YES


20
sConsigneeMobile
varchar(255)
YES


21
sDeliverId
varchar(100)
YES


22
sProvince
varchar(255)
YES


23
sCity
varchar(255)
YES


24
sArea
varchar(255)
YES


25
sDeliverTo
varchar(255)
YES


26
sManualNo
varchar(255)
YES


27
sMemo
text
YES


28
bCheck
bit(1)
NO


29
tCheckDate
datetime
YES


30
sCheckPerson
varchar(255)
YES


31
bPrint
bit(1)
NO


32
bCopyLimit
bit(1)
NO


33
dAdvanceMoney
decimal(18,6)
NO


34
dRealAdvanceMoney
decimal(18,6)
NO


35
sCurrency
varchar(255)
YES


36
dCurrencyRate
decimal(18,6)
YES


37
sStatus
varchar(255)
YES


38
bInvalid
bit(1)
NO


39
bAdvance
bit(1)
NO


40
sSettlementMode
varchar(255)
NO


41
sMReserve1
varchar(255)
YES


42
sMReserve2
varchar(255)
YES


43
sMReserve3
varchar(255)
YES


44
sMReserve4
varchar(255)
YES


45
sMReserve5
varchar(255)
YES


46
sMReserve6
varchar(255)
YES


47
dMReserve1
decimal(18,6)
YES


48
dMReserve2
decimal(18,6)
YES


49
dMReserve3
decimal(18,6)
YES


50
iMReserve1
int
YES


51
iMReserve2
int
YES


52
iMReserve3
int
YES


53
tMReserve1
datetime
YES


54
tMReserve2
datetime
YES


55
iIncrement
int
NO


Definition
select `xlyweberp_saas_ai`.`cahpaymentmaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sBillType` AS `sBillType`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sSupplyId` AS `sSupplyId`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sContacts` AS `sContacts`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sPhone` AS `sPhone`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`tDeliverDate` AS `tDeliverDate`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sPurchaseId` AS `sPurchaseId`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sPurchaseManId` AS `sPurchaseManId`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`dTotalMoney` AS `dTotalMoney`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sGetPayId` AS `sGetPayId`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`tGetPayDate` AS `tGetPayDate`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sConsignee` AS `sConsignee`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sConsigneeMobile` AS `sConsigneeMobile`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sDeliverId` AS `sDeliverId`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sProvince` AS `sProvince`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sCity` AS `sCity`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sArea` AS `sArea`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sDeliverTo` AS `sDeliverTo`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sManualNo` AS `sManualNo`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`bPrint` AS `bPrint`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`bCopyLimit` AS `bCopyLimit`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`dAdvanceMoney` AS `dAdvanceMoney`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`dRealAdvanceMoney` AS `dRealAdvanceMoney`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sCurrency` AS `sCurrency`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`dCurrencyRate` AS `dCurrencyRate`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`bAdvance` AS `bAdvance`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sSettlementMode` AS `sSettlementMode`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`cahpaymentmaster`.`iIncrement` AS `iIncrement` from (`xlyweberp_saas_ai`.`cahpaymentmaster` join `xlyweberp_saas_ai`.`viw_1cahpaymentslavesum` `b` on((`xlyweberp_saas_ai`.`b`.`sparentid` = `xlyweberp_saas_ai`.`cahpaymentmaster`.`sId`)))


Narrative

No human-written narrative yet.