0
SQL
Data Source=ACCROBIZ\ACCROBIZSERVER;Initial Catalog=AccroBIZDB
Specify a user name and password for data source AccroBIZDBDataSet:
DataBase
c0c825f4-73f5-4b10-b72f-b2a7063008b7
AccroBIZDBDataSet
/* Local Query */
IMGID
System.Int32
BarcodePIC
System.Byte[]
AccroBIZDBDataSet
D:\PROJECTS 2\ERP\AccroBIZPro169B\AccroBIZ\AccroBIZ\AccroBIZDBDataSet.xsd
BarcodeImageTbl
Fill
GetData
BarcodeImageTblTableAdapter
AccroBIZDBDataSet
/* Local Query */
ComID
System.Int32
ComName
System.String
ComTaxNo
System.String
ComCountry
System.String
ComState
System.String
ComAddress
System.String
ComLogo
System.Byte[]
ComCurrencyMode
System.String
ComMajorCur
System.String
ComMinorCur
System.String
ComSymbol
System.String
ComFinancialYearStart
System.DateTime
ComFinancialYearEnd
System.DateTime
ComDesimalPls
System.String
ComBranch
System.String
AccroBIZDBDataSet
D:\PROJECTS 2\ERP\AccroBIZPro169B\AccroBIZ\AccroBIZ\AccroBIZDBDataSet.xsd
CompanyTBL
Fill
GetData
CompanyTBLTableAdapter
AccroBIZDBDataSet
SELECT
ItemHeadTbl.ItemID
,ItemHeadTbl.ItemName
,ItemHeadTbl.ItemNameOthLang
,ItemHeadTbl.ItemCode
,ItemHeadTbl.ItemBarcode
,ItemHeadTbl.ItemMode
,ItemHeadTbl.ItemUnit
,ItemHeadTbl.ItemUnitConv
,ItemHeadTbl.ItemCategory
,ItemHeadTbl.ItemManufacturer
,ItemHeadTbl.ItemRack
,ItemHeadTbl.ItemCostRate
,ItemHeadTbl.ItemSaleRate
,ItemHeadTbl.ItemWholesaleRate
,ItemHeadTbl.ItemMRPRate
,ItemHeadTbl.ItemTAXClass
,ItemHeadTbl.ItemTotalVatPer
,ItemHeadTbl.ItemPurchaseVatPer
,ItemHeadTbl.ItemSalesVatPer
,ItemHeadTbl.ItemSGSTPer
,ItemHeadTbl.ItemCGSTPer
,ItemHeadTbl.ItemIGSTPer
,ItemHeadTbl.ItemCESSPer
,ItemHeadTbl.ItemImage
,ItemHeadTbl.ItemDescription
,ItemHeadTbl.ItemReOrderLevel
,ItemHeadTbl.ItemDeActive
,ItemHeadTbl.ItemDiscountPer
,ItemHeadTbl.ItemFollowUp
,ItemHeadTbl.ItemBatchStatus
,ItemHeadTbl.ItemAvailableQty
,ItemHeadTbl.ItemStockValue
,ItemHeadTbl.ItemWarranty
,ItemHeadTbl.ItemCountryOfOrigin
,ItemHeadTbl.ItemMinMaxStatus
,ItemHeadTbl.ItemMinRate
,ItemHeadTbl.ItemMaxRate
,ItemHeadTbl.ReOrderCalc
,ItemHeadTbl.StockIN
,ItemHeadTbl.StockOUT
,ItemHeadTbl.ItemSection
,ItemHeadTbl.ItemServiceReminder
,ItemHeadTbl.ItemServiceRemindDays
,ItemHeadTbl.ItemDueTittle
,ItemHeadTbl.PriceList01
,ItemHeadTbl.PriceList02
,ItemHeadTbl.PriceList03
,ItemHeadTbl.PriceList04
,ItemHeadTbl.PriceList05
,ItemHeadTbl.PropertyAvailability
,ItemHeadTbl.PropertyLeaseCustomer
,ItemHeadTbl.PropertyLeaseDate
,ItemHeadTbl.PropertyLeaseExpiryDate
,ItemHeadTbl.PropertyType
,ItemHeadTbl.PropertyPayScheme
,ItemHeadTbl.ItemRetailPlusTax
FROM
ItemHeadTbl
ItemID
System.Int32
ItemName
System.String
ItemNameOthLang
System.String
ItemCode
System.String
ItemBarcode
System.String
ItemMode
System.String
ItemUnit
System.String
ItemUnitConv
System.String
ItemCategory
System.String
ItemManufacturer
System.String
ItemRack
System.String
ItemCostRate
System.Decimal
ItemSaleRate
System.Decimal
ItemWholesaleRate
System.Decimal
ItemMRPRate
System.Decimal
ItemTAXClass
System.String
ItemTotalVatPer
System.Decimal
ItemPurchaseVatPer
System.Decimal
ItemSalesVatPer
System.Decimal
ItemSGSTPer
System.Decimal
ItemCGSTPer
System.Decimal
ItemIGSTPer
System.Decimal
ItemCESSPer
System.Decimal
ItemImage
System.Byte[]
ItemDescription
System.String
ItemReOrderLevel
System.Decimal
ItemDeActive
System.String
ItemDiscountPer
System.Decimal
ItemFollowUp
System.String
ItemBatchStatus
System.String
ItemAvailableQty
System.Decimal
ItemStockValue
System.Decimal
ItemWarranty
System.String
ItemCountryOfOrigin
System.String
ItemMinMaxStatus
System.String
ItemMinRate
System.Decimal
ItemMaxRate
System.Decimal
ReOrderCalc
System.String
StockIN
System.Decimal
StockOUT
System.Decimal
ItemSection
System.String
ItemServiceReminder
System.String
ItemServiceRemindDays
System.String
ItemDueTittle
System.String
PriceList01
System.Decimal
PriceList02
System.Decimal
PriceList03
System.Decimal
PriceList04
System.Decimal
PriceList05
System.Decimal
PropertyAvailability
System.String
PropertyLeaseCustomer
System.String
PropertyLeaseDate
System.DateTime
PropertyLeaseExpiryDate
System.DateTime
PropertyType
System.String
PropertyPayScheme
System.String
ItemRetailPlusTax
System.Decimal
AccroBIZDBDataSet
D:\PROJECTS 2\ERP\AccroBIZPro169B\AccroBIZ\AccroBIZ\AccroBIZDBDataSet.xsd
ItemHeadTbl
Fill
GetData
ItemHeadTblTableAdapter
AccroBIZDBDataSet
SELECT
BatchHead.BatchID
,BatchHead.BatchCode
,BatchHead.BatchPackingDate
,BatchHead.BatchExpiry
,BatchHead.BatchItemName
,BatchHead.BatchItemNameOlang
,BatchHead.BatchItemCode
,BatchHead.BatchItemBarcode
,BatchHead.BatchCost
,BatchHead.BatchRetail
,BatchHead.BatchWholsale
,BatchHead.BatchMRP
,BatchHead.BatchAvailableQty
,BatchHead.BatchStkIN
,BatchHead.BatchStkOUT
,BatchHead.BatchRetailPlusTax
FROM
BatchHead
BatchID
System.Int32
BatchCode
System.String
BatchPackingDate
System.DateTime
BatchExpiry
System.DateTime
BatchItemName
System.String
BatchItemNameOlang
System.String
BatchItemCode
System.String
BatchItemBarcode
System.String
BatchCost
System.Decimal
BatchRetail
System.Decimal
BatchWholsale
System.Decimal
BatchMRP
System.Decimal
BatchAvailableQty
System.Decimal
BatchStkIN
System.Decimal
BatchStkOUT
System.Decimal
BatchRetailPlusTax
System.Decimal
AccroBIZDBDataSet
D:\PROJECTS 2\ERP\AccroBIZPro169B\AccroBIZ\AccroBIZ\AccroBIZDBDataSet.xsd
BatchHead
Fill
GetData
BatchHeadTableAdapter
=First(Fields!BarcodePIC.Value, "Barcode")
image/jpeg
Fit
0.20832in
0.10429in
0.38184in
1.15301in
true
true
=First(Fields!ComName.Value, "Company")
ComName
0.09047in
0.11785in
1.36667in
1
White
Middle
true
true
=First(Fields!BatchItemName.Value, "BachCode")
ItemName
0.73562in
0.12612in
1.36667in
2
White
true
true
=Sum(Fields!BatchRetailPlusTax.Value, "BachCode")
ItemSaleRate
0.59823in
0.13739in
1.36667in
3
Top
0.96607in
1.38502in
1in
1.5in
4
2
Inch
bbaae2dd-c53d-4df2-8dd9-d7dcf92c3b9f