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