📊 HOMESAAZ Database Viewer
← Back to Tables

Table: dbo.CashMemo

CaMoIDPlaceIDFYIDAccountIDBindingIDBookSlipIDBookSlipNumCMNoCMDateSalManIDGrossAmtDiscPctDiscAmtTaxIDTaxAmtTaxFormIDTaxFormAmtNetAmtAuthBYPayModeCashPayModeCCardCCardIDBankIDBillAmtSlipNoSlipDateApprovalNoCMCancelledCMCancelReasonRemarksCustIDCustNameCustAddCreditDateAddDiscPctAddDiscAmtDirectDeliverToTailorRoundDiscTaxableTaxPaidAliasFlagSalesSchemeIDSalesSchemeNameCartAmtFCashMemoFInvoiceSiteManIDInvPayModeSaleFileRecIDCashPaymentAdvancePaymentApmtflagDelDateDummyPerformaIdJobIDDeliveredInClusiveTailorIDPerformaNoPFlagUserNameUseDateTCustNameTCustAddTCustPhoneTCustMobTCustStateTCustPinPONumCommIDCommPctFormNoOrgAmountModUserPrevAdvMemberNoPrevAmtPrevDateRemarksPTailEnqIDFloorExptInvFBitMuserModMuserCreditNoteIDTFPaidCrCustNameCreditcnoCMobileCStatusReUserReDateDAPRefNamePStatusMatCalQtyDetSMSMobileNoTailorTIDJPCCRefNoLastMemoValidCashcomputernameAdvCashMemoIdTaxInvQutationIdModDateFormDateRCardNoRUpdateCardDiscMOYRGGNPerIDDocCodeDocRecDocRecDateQTREQTRFStkIDStkRIDPASSEDRelidSalFSalAmtRelativeMO1YR1cartage3cartage3amtcartage5cartage5amtcartage12cartage12amtcartage18cartage18amtcartage28cartage28amtEWAYBILLlinktoacidSaleRemarksResPerForLocQRCODETCSAMTCCIRNQRImageTempInvoiceTempConvTempDateTempRemarksCCTOGSTIDDiscItemPerDiscInvoiceIDNotCreateFBDPERIDRGNPERIDLSPERIDTRFRGNTRFFBDTRFRJCTRFLSBossChkTrfDecoTCSPER
1141556781512013-09-16 00:00:002511742.5000.00.00001742.0000100.0000.000000-.50000000Show Room.0000101.000000000AB2013-09-16 00:00:0000.00000GIFT00ANIL00P000011001.000000000.00000000.0000000000
21415458229567821012013-09-16 00:00:00251412.2500.00.0000412.000001045822412.00002013-09-16 00:00:00045822.0000.000000-.250000014SEP SALE .0000011.000000100AB2013-09-16 00:00:000000.00000GIFT00ANIL00P000020001.000000000.00000000.0000000000
314154582295679100011022013-09-16 00:00:002513740.0400.00.00003740.0000010458223740.00002013-09-16 00:00:00045822.0000.000000-.040000014SEP SALE .0000011.000000100AB2013-09-16 00:00:000000.00000HS-RGN00ANIL00P000020001.000000000.00000000.0000000000
414154582295679100021032013-09-16 00:00:002511997.5100.00.00001997.0000010458221997.00002013-09-16 00:00:00045822.0000.000000-.510000014SEP SALE .0000011.000000100AB2013-09-16 00:00:000000.00000HS-RGN00ANIL00P000021001.000000000.00000000.0000000000
514151056784522013-09-16 00:00:002511615.0000.00.00001615.0000100.0000.000000.000000014SEP SALE .0000101.000000000AB2013-09-16 00:00:0000.00000GIFT00ANIL00P000010001.000000000.00000000.0000000000
614151056783532013-09-16 00:00:0016981122.0000.00.00001122.0000100.0000.000000.000000014SEP SALE .0000101.0000000002013-09-16 00:00:001122.000000.00000GIFT00ANILANIL00P000011001.000000000.00000000.0000000000
714154582205679100031042013-09-16 00:00:005393995.0400.00.00003995.0000010458223995.00002013-09-16 00:00:00045822.0000.000000-.040000014SEP SALE .0000011.000000100AB2013-09-16 00:00:000000.00000HS-RGN00ANIL00P000031001.000000000.00000000.0000000000
814154582205679100041052013-09-16 00:00:00357578.0000.00.0000578.000001045822578.00002013-09-16 00:00:00045822.0000.000000.000000014SEP SALE .0000011.000000100AB2013-09-16 00:00:000000.00000HS-RGN00ANIL00P000041001.000000000.00000000.0000000000
9141511567910006542013-09-16 00:00:001521739.5200.00.0000740.0000100.0000.000000.480000014SEP SALE .0000101.000000000HB2013-09-16 00:00:0000.00000HS-RGN00ANIL00P000010001.000000000.00000000.0000000000
101415115680101552013-09-16 00:00:001521775.2000.00.0000775.0000100.0000.000000-.200000014SEP SALE .0000101.0000000002013-09-16 00:00:00775.000000.00000BED & BATH00ANILANIL00P000010001.000000000.00000000.0000000000
11141511567910005562013-09-16 00:00:002512025.000050.001012.50001012.000010050.00001012.500000-.500000014SEP SALE .0000101.000000000HB2013-09-16 00:00:0000.00000HS-RGN00ANIL00P000011001.000000000.00000000.0000000000
121415567910007572013-09-16 00:00:001521142.8000.00.0000143.0000100.0000.000000.200000014SEP SALE .0000101.000000000HB2013-09-16 00:00:0000.00000HS-RGN00ANIL00P000011001.000000000.00000000.0000000000
13141545822125679100081062013-09-16 00:00:002514564.5000.00.00004564.0000010458224564.00002013-09-16 00:00:00045822.0000.000000-.500000014SEP SALE .00000115260.000000100SB2013-09-16 00:00:000000.00000HS-RGN00ANIL00P000050001.000000000.00000000.0000000000
14141545822125679100091072013-09-16 00:00:003571572.5000.00.00001572.0000010458221572.00002013-09-16 00:00:00045822.0000.000000-.500000014SEP SALE .000001114991.000000100SB2013-09-16 00:00:000000.00000HS-RGN00ANIL24800P000051001.000000000.00000000.0000000000
1514154582205679100101082013-09-16 00:00:002513463.7500.00.00003464.0000010458223464.00002013-09-16 00:00:00045822.0000.000000.250000014SEP SALE .000001115054.000000100AB2013-09-16 00:00:000000.00000HS-RGN00ANIL00P000061001.000000000.00000000.0000000000
161415567910011582013-09-16 00:00:0035697.0100.00.0000697.0000100.0000.000000-.010000014SEP SALE .0000101.000000000AB2013-09-16 00:00:0000.00000HS-RGN00ANIL00P000011001.000000000.00000000.0000000000
171415567910012592013-09-16 00:00:001425361.2500.00.0000361.0000100.0000.000000-.250000014SEP SALE .0000101.000000000AB2013-09-16 00:00:0000.00000HS-RGN00ANIL00P000011001.000000000.00000000.0000000000
18141556785602013-09-16 00:00:001425488.7500.00.0000489.0000100.0000.000000.250000014SEP SALE .0000101.000000000AB2013-09-16 00:00:0000.00000GIFT00ANIL00P000011001.000000000.00000000.0000000000
19141500612013-09-16 00:00:002511156.000015.00173.4000983.000010015.0000173.400000.400000014SEP SALE .0000101.000000000AB2013-09-16 00:00:0000.0000000ANIL00P000011001.000000000.00000000.0000000000
20141556786622013-09-16 00:00:002511059.1000.00.00001059.0000100.0000.000000-.100000014SEP SALE .0000101.000000000AB2013-09-16 00:00:0000.00000GIFT00ANIL00P000011001.000000000.00000000.0000000000
21141556787632013-09-17 00:00:00539467.5000.00.0000467.0000100.0000.000000-.500000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000GIFT00MAIN-0200P000011001.000000000.00000000.0000000000
2214151356789642013-09-17 00:00:00357739.5000.00.0000739.0000100.0000.000000-.500000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000GIFT00MAIN-0200P000010001.000000000.00000000.0000000000
2314151356788652013-09-17 00:00:00251210.0000.00.0000210.0000100.0000.000000.000000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000GIFT00MAIN-0200P000010001.000000000.00000000.0000000000
24141513567910019662013-09-17 00:00:00251786.2500.00.0000786.0000100.0000.000000-.250000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000010001.000000000.00000000.0000000000
25141513567910013672013-09-17 00:00:001009463.2500.00.0000463.0000100.0000.000000-.250000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000010001.000000000.00000000.0000000000
26141513567910016682013-09-17 00:00:00251322.1500.00.0000322.0000100.0000.000000-.150000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000010001.000000000.00000000.0000000000
27141513567910014692013-09-17 00:00:002511958.3900.00.00001958.0000100.0000.000000-.390000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000010001.000000000.00000000.0000000000
28141513567910017702013-09-17 00:00:0025111340.020040.004536.01006804.000010040.00004536.010000-.010000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000010001.000000000.00000000.0000000000
29141513567910018712013-09-17 00:00:0025111200.4500.00.000011200.0000100.0000.000000-.450000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000010001.000000000.00000000.0000000000
30141513567910015722013-09-17 00:00:00594867.0000.00.0000867.0000100.0000.000000.000000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000011001.000000000.00000000.0000000000
311415567910020732013-09-17 00:00:001009845.7500.00.0000846.0000100.0000.000000.250000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000011001.000000000.00000000.0000000000
32141545822145678101092013-09-17 00:00:002515678.00005.00283.90005394.0000010458225394.00002013-09-17 00:00:000458225.0000283.900000-.100000014SEP SALE .000001115007.000000100SB2013-09-17 00:00:000000.00000GIFT00MAIN-0224800P000070001.000000000.00000000.0000000000
33141545822145679100211102013-09-17 00:00:00251578.0000.00.0000578.000001045822578.00002013-09-17 00:00:00045822.0000.000000.000000014SEP SALE .0000011.000000100SB2013-09-17 00:00:000000.00000HS-RGN00MAIN-0200P000071001.000000000.00000000.0000000000
34141556324568201112013-09-17 00:00:002511676.0000.00.0000471676.0000000I-1276--2.5 MTR56324.0000.000000.000000014SEP SALE .0000011456017950.000002013-09-17 00:00:00021014561020JO,VIV,VIV2013-09-17 00:00:001676.0000VIV00.00000FURN Q00ANILANIL00ANIL1900-01-01 00:00:000PD00000HS-SERVER05002013-09-20 20:37:41.000000000.00000000.0000000000
351415563235682012013-09-17 00:00:0025141399.7500.00.00004741400.000000056323.0000.000000.250000014SEP SALE .0000011456011.000002013-09-17 00:00:00011014561010JO,VIV,VIV,VIV2013-09-17 00:00:0041400.0000VIV00.00000FURN Q00ANILANIL00ANIL1900-01-01 00:00:000PD00000HS-SERVER05102013-09-20 20:37:19.000000000.00000000.0000000000
361415567910022742013-09-17 00:00:0010091011.5000.00.00001011.0000100.0000.000000-.500000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000011001.000000000.00000000.0000000000
371415567910023752013-09-17 00:00:002511806.2500.00.00001806.0000100.0000.000000-.250000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000011001.000000000.00000000.0000000000
38141515567910024762013-09-17 00:00:0015211974.2900.00.00001974.0000100.0000.000000-.290000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000010001.000000000.00000000.0000000000
39141515567910025772013-09-17 00:00:00594268.6000.00.0000269.0000100.0000.000000.400000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000011001.000000000.00000000.0000000000
4014155683301782013-09-17 00:00:002513800.0000.00.00003800.0000100.0000.000000.000000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000QUILT00MAIN-0200P000011001.000000000.00000000.0000000000
41141516567910026792013-09-17 00:00:0035382.5100.00.0000382.0000100.0000.000000-.510000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000010001.000000000.00000000.0000000000
42141516567910027802013-09-17 00:00:0035272.0000.00.0000272.0000100.0000.000000.000000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000HS-RGN00MAIN-0200P000011001.000000000.00000000.0000000000
4314154582205678111122013-09-17 00:00:002514100.000050.002050.00002050.0000010458222050.00002013-09-17 00:00:0004582250.00002050.000000.000000014SEP SALE .0000011.000000100SB2013-09-17 00:00:000000.00000GIFT00MAIN-0200P000081001.000000000.00000000.0000000000
441415567812812013-09-17 00:00:00251110.5000.00.0000110.0000100.0000.000000-.500000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000GIFT00MAIN-0200P000011001.000000000.00000000.0000000000
4514155632756812011132013-09-17 00:00:0025110384.0000.00.000010384.000000056327.0000.000000.000000014SEP SALE .0000011456017950.000002013-09-17 00:00:0001014560SB2013-09-17 00:00:0000.00004FURNSHG00MAIN-0200MAIN-021900-01-01 00:00:000PD00000MAIN-02002013-09-17 18:20:49.000000000.00000000.0000000000
461415567910029822013-09-17 00:00:003571750.0000.00.00001750.0000100.0000.000000.000000014SEP SALE .0000101.000000000NP2013-09-17 00:00:0000.00000HS-RGN00MAIN-0100P000011001.000000000.00000000.0000000000
4714154582205679100281142013-09-17 00:00:001009755.6500.00.0000756.000001045822756.00002013-09-17 00:00:00045822.0000.000000.350000014SEP SALE .00000117961.000000100NP2013-09-17 00:00:000000.00000HS-RGN00MAIN-0100P000091001.000000000.00000000.0000000000
4814155632756812021152013-09-17 00:00:0025110384.0000.00.000010384.000000056327.0000.000000.000000014SEP SALE .0000011456017961.000002013-09-17 00:00:0001014560SB2013-09-17 00:00:0000.00004FURNSHG00MAIN-0200MAIN-021900-01-01 00:00:000PD00000MAIN-02002013-09-17 19:42:51.000000000.00000000.0000000000
4914155680102832013-09-17 00:00:00251339.1500.00.0000339.0000100.0000.000000-.150000014SEP SALE .0000101.000000000SB2013-09-17 00:00:0000.00000BED & BATH00ANIL00P000011001.000000000.00000000.0000000000
501415175683302842013-09-17 00:00:002511336.0000.00.00001336.0000100.0000.000000.000000014SEP SALE .0000101.000000000SB2013-09-17 00:00:001670.0000SB00.00000QUILT00ANILANIL0ANIL1900-01-01 00:00:000PD000010001.000000000.00000000.0000000000