PurchaseManage
Tables (9)
Untitled (dbo.t_purchase_customertable)
- Field (ID) — int
- Field (CustomerGroup) — varchar
- Field (UserGroupName) — varchar
- Field (CustomerCode) — varchar
- Field (TotalWeight) — int
- Field (AllotPWeight) — int
- Field (BuyPWeight) — int
- Field (AllotKWeight) — int
- Field (BuyKWeight) — int
- Field (AllotJWeight) — int
- Field (BuyJWeight) — int
- Field (ResidentNumert) — varchar
- Field (PhoneNumber) — varchar
- Field (BankName) — varchar
- Field (BankCode) — varchar
- Field (ZipCode) — varchar
- Field (Address) — varchar
- Field (Remarks) — varchar
Untitled (dbo.t_purchase_dryingtable)
- Field (ID) — int
- Field (Mois1) — int
- Field (Mois2) — int
- Field (Mois3) — int
- Field (Mois4) — int
- Field (Mois5) — int
- Field (Mois6) — int
- Field (Mois7) — int
- Field (Mois8) — int
- Field (Mois9) — int
- Field (Moist10) — int
- Field (Dry1) — int
- Field (Dry2) — int
- Field (Dry3) — int
- Field (Dry4) — int
- Field (Dry5) — int
- Field (Dry6) — int
- Field (Dry7) — int
- Field (Dry8) — int
- Field (Dry9) — int
- Field (Dry10) — int
Untitled (dbo.t_purchase_othertable)
- Field (ID) — int
- Field (PMois) — int
- Field (KMois) — int
- Field (JMois) — int
- Field (CalPoint) — int
- Field (GrainPoint) — int
- Field (PointMethod) — int
- Field (SetWeight) — int
- Field (dryPayAll) — int
- Field (dryPayGov) — int
- Field (dryPayCon) — int
- Field (dryPaySelf) — int
- Field (DryAll) — int
- Field (TransAll) — int
- Field (LeadAll) — int
- Field (InvestmentAll) — int
- Field (AnteAll) — int
- Field (BusAll) — int
- Field (OtherAll) — int
- Field (DryAt) — int
- Field (Trans) — int
- Field (Lead) — int
- Field (Investment) — int
- Field (Ante) — int
- Field (Bus) — int
- Field (Other) — int
- Field (DryAt2) — int
- Field (Trans2) — int
- Field (Lead2) — int
- Field (Investment2) — int
- Field (Ante2) — int
- Field (Bus2) — int
- Field (Other2) — int
- Field (DryAt3) — int
- Field (Trans3) — int
- Field (Lead3) — int
- Field (Investment3) — int
- Field (Ante3) — int
- Field (Bus3) — int
- Field (Other3) — int
- Field (SubsidyAll) — int
- Field (TPTAll) — int
- Field (OPayAll) — int
- Field (SubsidyG) — int
- Field (TPTG) — int
- Field (OPayG) — int
- Field (SubsidyC) — int
- Field (OPayC) — int
- Field (Subsidyl) — int
- Field (TPTl) — int
- Field (OPayl) — int
- Field (AllUse) — int
- Field (GPUse) — int
- Field (CPUse) — int
- Field (IPUse) — int
- Field (AutoCal) — int
- Field (govDown) — int
- Field (conDown) — int
- Field (selfDown) — int
Untitled (dbo.t_purchase_scaleportset)
- Field (ID) — int
- Field (ScaleCdoe) — varchar
- Field (Scale) — varchar
- Field (Port) — varchar
- Field (Speed) — varchar
- Field (ParityBit) — varchar
- Field (DataBit) — varchar
- Field (StopBit) — varchar
- Field (InputSpace) — varchar
- Field (OutputSpace) — varchar
- Field (Use) — int
- Field (meterial) — varchar
- Field (Moc) — varchar
Untitled (dbo.t_purchase_usergrouptable)
- Field (ID) — int
- Field (UserGroupCode) — varchar
- Field (UserGroupName) — varchar
Untitled (dbo.t_purchase_PMtable)
- Field (MCODE) — int
- Field (ScaleCode) — varchar
- Field (ScaleDay) — varchar
- Field (ScaleTime) — varchar
- Field (ScaleName) — varchar
- Field (InputCount) — int
- Field (ScaleTank) — varchar
- Field (GroupCode) — varchar
- Field (CustomerGroup) — varchar
- Field (Customer) — varchar
- Field (CustomerCode) — varchar
- Field (CustomerLisence) — varchar
- Field (PhoneNumber) — varchar
- Field (BankName) — varchar
- Field (AccountNumber) — varchar
- Field (Address) — varchar
- Field (AccountDate) — varchar
- Field (ArticleCode) — int
- Field (ArticleKind) — varchar
- Field (ArticleName) — varchar
- Field (InputSection) — varchar
- Field (TransportSection) — varchar
- Field (Weight) — int
- Field (WeightCount) — int
- Field (Mixing) — int
- Field (ConversionWeight) — int
- Field (AvrMois) — int
- Field (PIndex) — int
- Field (KIndex) — int
- Field (JIndex) — int
- Field (PJS) — int
- Field (KJS) — int
- Field (JJS) — int
- Field (PApportionment0) — int
- Field (PApportionment1) — int
- Field (PApportionment2) — int
- Field (PApportionment3) — int
- Field (KApportionment0) — int
- Field (KApportionment1) — int
- Field (KApportionment2) — int
- Field (KApportionment3) — int
- Field (JApportionment0) — int
- Field (JApportionment1) — int
- Field (JApportionment2) — int
- Field (JApportionment3) — int
- Field (PCount0) — varchar
- Field (PCount1) — varchar
- Field (PCount2) — varchar
- Field (PCount3) — varchar
- Field (KCount0) — varchar
- Field (KCount1) — varchar
- Field (KCount2) — varchar
- Field (KCount3) — varchar
- Field (JCount0) — varchar
- Field (JCount1) — varchar
- Field (JCount2) — varchar
- Field (JCount3) — varchar
- Field (PWeight0) — int
- Field (PWeight1) — int
- Field (PWeight2) — int
- … +21
dbo.t_purchase_companytable
- ID — int
- CompanyName — varchar
- RepresentativeName — varchar
- Re[resentativeName2 — varchar
- ManagementDepartment — varchar
- Address — varchar
- ZipCode — varchar
- PhoneNumber — varchar
- ExchangeNumbers — varchar
- FaxNumber — varchar
- Memo3 — varchar
- PurchaseAauthority — varchar
- InspectionOfficials — varchar
- IOName — varchar
- Surveyor — varchar
- SurveyorName — varchar
- SurveyorSector — varchar
- Entrant — varchar
- CheckWear — varchar
- CheckWearName — varchar
- Payment — varchar
- PaymentName — varchar
- Acceptor — varchar
- AcceptorName — varchar
- AcceptorSector — varchar
- WarehouseNumber — varchar
- Remarks2 — varchar
dbo.t_purchase_scaletable
- ScaleCode — int
- ScaleClass — varchar
- ScaleName — varchar
dbo.t_purchase_transportsection
- TransportCode — int
- TransportName — varchar