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