HMobis

Tables (9)

Account

  • Id (Account iD) — id(18) — Primary key — NOT NULL
  • Name (Account Name) — Text

ApprovalHistory (승인 이력)

  • Id (Approval History ID) — id(18) — Primary key — NOT NULL
  • ApprovalProcess (Approval Process Id) — Lookup(ApprovalProcess) — Foreign key → ApprovalProcess.Id — NOT NULL
  • Approver (Contact ID) — Lookup(Contact) — Foreign key → Contact.Id — NOT NULL
  • ApprovalUser (User Id) — Lookup(User) — Foreign key → User.Id — NOT NULL
  • Stage (Approval Stage) — Picklist
  • Status (Approval Status) — Picklist
  • ApprovalType (Approval Type) — Picklist
  • RequestDate (Request Datetime) — Datetime
  • ApprovalDate (ApprovalDatetime) — Datetime
  • SiteUrl (Site URL) — URL
  • Comment — Long Text Area
  • SortSeq (Sort Sequence) — Number

ApprovalPath (결재선)

  • Id (Approval Path ID) — id(18) — Primary key — NOT NULL
  • Name (Approval Path Name) — Text
  • Type (Approval Type) — Picklist
  • ReportType (Report Type) — Picklist
  • Contact (Contact ID) — Lookup(Contact) — Foreign key → Contact.Id — NOT NULL
  • Stage (Approval Stage) — Picklist
  • Owner (Approval Path Owner) — Lookup(User) — Foreign key → User.Id — NOT NULL
  • ApprovalUser (User Id) — Lookup(User) — Foreign key → User.Id — NOT NULL
  • CreateDate (Create date) — Datetime

ApprovalProcess (결재진행)

  • Id (Approval Process Id) — id(18) — Primary key — NOT NULL
  • ReportType (Report Type) — Picklist
  • ReportOrder (How many approval requests?) — Number
  • Title (Report Title) — Text
  • Description — Rich Text
  • QuipURL (Embedded QuipURL) — URL
  • Quip_PDF_Url (Quip Pdf URL) — URL
  • Owner (Approval Process Owner) — Lookup(User) — Foreign key → User.Id — NOT NULL
  • Status (Approval Status) — Picklist
  • CreateDate (Create Date) — Datetime
  • LastModifiedDate (Last Modified Date) — Datetime
  • LastModifiedById (User Id) — Lookup(User) — Foreign key → User.Id — NOT NULL
  • Opportunity (Opportunity ID) — Lookup(Opportunity) — Foreign key → Opportunity.Id — NOT NULL

Contact (고객사담당자/임직원)

  • Id (Contact ID) — id(18) — Primary key — NOT NULL
  • Name (Contact Name) — Text
  • AccountId (Account iD) — Lookup(Account) — Foreign key → Account.Id — NOT NULL
  • IsEmployee (Whether employees) — Checkbox
  • Field

Opportunity (영업기회)

  • Id (Opportunity ID) — id(18) — Primary key — NOT NULL
  • Name (Opportunity Name) — Text
  • AccountId (Account Id) — Lookup(Account) — Foreign key → Account.Id — NOT NULL
  • StageName (Stage) — Picklist
  • LostReason (Lost Reason) — Picklist
  • Vehicle (Vehicle Id) — Lookup(Vehicle) — Foreign key → Vehicle.Id — NOT NULL
  • Field
  • SourcingProduct (Product Id) — Lookup(Product2) — Foreign key → Product2.Id — NOT NULL
  • QuipDoc (RFQ Receipt Report) — URL
  • QuipDoc2 (RFQ Briefing Document) — URL
  • QuipDoc3 (RFQ Quotation Report) — URL
  • QuipDoc4 (Order Confirmation Report) — URL
  • QuipDoc5 (Failed order report) — URL
  • QuipDoc6 (Order Cancellation Report) — URL
  • QuipDoc7 (RFQ Quotation Report 2nd) — URL
  • QuipDoc8 (RFQ Quotation Report 3rd) — URL
  • Field10

Product2 (제품)

  • Id (Product Id) — id(18) — Primary key — NOT NULL
  • Name (Product Name) — Text
  • ProductCode (Code) — Text
  • BU — Picklist
  • Group1 — Picklist
  • Group2 — Picklist
  • Field

User (사용자)

  • Id (User Id) — id(18) — Primary key — NOT NULL
  • Name (Full Name) — Text
  • Field

Vehicle (차종)

  • Id (Vehicle Id) — id(18) — Primary key — NOT NULL
  • Name (Vehicle Name) — Text
  • Id (Account iD) — id(18) — Foreign key → Account.Id — NOT NULL
  • VehicleCode (Code) — Text
  • Field