← Hub — NetSuite Data Model / ERD
v10.0
Design Reference — NetSuite Data Model
Entity Relationship
Diagrams
Visual reference for how NetSuite record types connect, field layouts flow between transactions, and status states progress. Design templates for building GFS-branded record UIs.
5
Domain Areas
28
Record Types
7
Sections
4
State Machines
02 Master ERD All major NetSuite record types and their relationships
CUSTOMER SALES ORDER ITEM FULFILL. INVOICE CUST. PAYMENT SALES (ORDER-TO-CASH) VENDOR PURCHASE ORDER ITEM RECEIPT VENDOR BILL VEND. PAYMENT PURCHASING (PROCURE-TO-PAY) ITEM INVENTORY BIN LOT TRANSFER ORDER INVENTORY & WAREHOUSING BOM WORK ORDER ASSEMBLY BUILD PRODUCTION (BUILD-TO-STOCK) CASE/SUPPORT RMA CREDIT MEMO REFUND QUALITY & RETURNS CUSTOMER LINK LEGEND Sales (Order-to-Cash) Purchasing (Procure-to-Pay) Inventory & Warehousing Production (Build-to-Stock) Quality & Returns Direct flow Cross-domain link Join point
■ 28 record types across 5 domains. Solid lines = direct transaction flow. Dashed lines = cross-domain references. Circles = shared entity joins.
03 Order-to-Cash Flow Complete O2C lifecycle with UI state at each stage
ESTIMATE / QUOTE OPEN Customer Good Eats Corp Items 3 line items Total $24,500.00 Valid Until 06/15/2026 Convert Print EST-10042 SALES ORDER PENDING Customer Good Eats Corp Ship Date 06/01/2026 Terms Net 30 Total $24,500.00 Fulfill Approve SO-78451 ITEM FULFILLMENT SHIPPED Ship Via LTL Freight Tracking PRO-84521 Ship Date 06/01/2026 Packages 1 of 1 Invoice IF-78451 INVOICE OPEN Due Date 07/01/2026 Amount $24,500.00 Balance $24,500.00 Terms Net 30 Receive Pmt INV-78451 CUST. PAYMENT DEPOSITED Payment Check #4521 Amount $24,500.00 Deposit DEP-6102 GL Impact 1200 → 1000 PMT-12884 GL IMPACT AT EACH STAGE Estimate No GL impact (memo only) Sales Order No GL impact (commitment) Fulfillment DR 5000 COGS CR 1300 Inventory Invoice DR 1200 A/R CR 4000 Revenue Payment DR 1000 Cash CR 1200 A/R
■ Each card shows the record's key fields, status badge, and available actions at that lifecycle stage. GL impact row shows journal entries created at each step.
04 Procure-to-Pay Flow Requisition through payment with UI state at each stage
REQUISITION PENDING APPR. Requested By Warehouse Mgr Department Operations Est. Total $18,200.00 Need Date 06/10/2026 Approve REQ-2041 PURCHASE ORDER PENDING RECV. Vendor Bongards Cheese Brand/Dept Commodity Ship Date 06/10/2026 Total $18,200.00 Receive Print PO-45210 ITEM RECEIPT RECEIVED Recv. Date 06/10/2026 Location Edgewood, NY Qty Received 500 CS Lot # LOT-24061 Bill IR-45210 VENDOR BILL OPEN Bill Date 06/12/2026 Due Date 07/12/2026 Amount $18,200.00 Ref # INV-BC-78210 Pay BILL-45210 VEND. PAYMENT PAID Method ACH Transfer Amount $18,200.00 Check # ACH-091542 GL Impact 2000 → 1000 PMT-V-6201 GL IMPACT AT EACH STAGE Requisition No GL impact (approval only) Purchase Order No GL impact (commitment) Item Receipt DR 1300 Inventory CR 2100 Accrued AP Vendor Bill DR 2100 Accrued AP CR 2000 A/P Payment DR 2000 A/P CR 1000 Cash
■ Procure-to-Pay mirrors O2C in reverse. Requisitions and POs are non-posting; GL impact begins at Item Receipt when inventory is recognized.
05 Production Flow Item through BOM, Work Order, Assembly Build, and into finished goods inventory
ITEM MASTER Type Assembly SKU CHD-640-BL Unit CS (40lb) Preferred Edgewood On Hand 1,240 CS BILL OF MATERIALS Component 1 Raw Cheddar Qty 40 lb Component 2 Packaging Qty 1 EA Component 3 Label Qty 1 EA WORK ORDER IN PROCESS Build Qty 200 CS Location Edgewood Start Date 06/05/2026 End Date 06/06/2026 Build WO-3401 COMPONENT PICK PICKED Raw Cheddar 8,000 lb Packaging 200 EA Labels 200 EA From Bin BIN-RAW-01 ASSEMBLY BUILD BUILT Output 200 CS Lot # LOT-26060 Variance $0.00 To Bin BIN-FG-03 BUILD-3401 FINISHED GOOD IN STOCK SKU CHD-640-BL Available 1,440 CS Location Edgewood Bin BIN-FG-03 Status Available GL IMPACT Assembly Build: DR 1300 FG Inventory, CR 1310 WIP Inventory, CR 1320 Raw Materials Component Pick: DR 1310 WIP Inventory, CR 1300 Raw Materials Inventory
■ BOM defines the recipe. Work Order authorizes production. Component Pick consumes raw materials. Assembly Build creates the finished good and credits WIP.
06 Field Mapping Diagrams How fields flow between related records with copy/calculated indicators
Sales Order → Fulfillment → Invoice
Sales Order Line SO-78451
itemList/Record
quantityFloat
rateCurrency
amountCurrency
locationList/Record
unitsList/Record
descriptionText
classList/Record
departmentList/Record
COPIES
→
Fulfillment Line IF-78451
itemCopied
quantityCopied
itemreceiveBoolean
locationCopied
unitsCopied
binNumbersNew
serialNumbersNew
inventorydetailSubrecord
orderlineInteger
COPIES
→
Invoice Line INV-78451
itemCopied
quantityCopied
rateCopied
amountCalculated
taxcodeCalculated
taxrateCalculated
grossamtCalculated
classCopied
departmentCopied
Purchase Order → Receipt → Bill
PO Line PO-45210
itemList/Record
quantityFloat
rateCurrency
amountCurrency
locationList/Record
departmentList/Record
expectedreceiptdateDate
vendornameText
COPIES
→
Receipt Line IR-45210
itemCopied
quantityCopied
locationCopied
itemreceiveBoolean
inventorydetailSubrecord
binNumbersNew
lotNumbersNew
orderlineInteger
COPIES
→
Bill Line BILL-45210
itemCopied
quantityCopied
rateCopied
amountCalculated
locationCopied
departmentCopied
taxcodeCalculated
landedcostNew
BOM Component → WO Component → Build Consumption
BOM Component BOM
itemList/Record
bomquantityFloat
unitsList/Record
componentyieldPercent
descriptionText
SCALES
→
WO Component WO-3401
itemCopied
quantityScaled
unitsCopied
quantitycommittedCalculated
quantityonhandCalculated
CONSUMES
→
Build Consumption BUILD-3401
itemCopied
quantityActual
unitcostAvg Cost
componentcostCalculated
inventorydetailSubrecord
Copied = field value transferred directly Calculated/Scaled = derived from source data New = field unique to this record type
■ Fields marked "Copied" transfer directly from parent. "Calculated" fields are derived at creation time. "New" fields are entered uniquely on the child record.
07 Record Card Design Patterns Reusable GFS UI templates for each record component type
Transaction Header Pattern Header
GLOBAL FOOD SOLUTIONS
131 Heartland Blvd, Edgewood, NY 11717
SALES ORDER
SO-78451
Status PENDING FULFILLMENT Billing OPEN
Date
05/28/2026
Customer
Good Eats Corp
Terms
Net 30
Ship Via
LTL Freight
Usage: Every transaction record header. 3px cobalt top border. GFS identity top-left, record type/ID top-right. Status badges in a row below. Metadata in a 4-column grid on var(--ice) background.
Line Item Sublist Pattern Sublist
Line Items
# Item Description Qty Rate Amount
1 CHD-640-BL Barrel Cheddar 640lb 200 $85.00 $17,000.00
2 MOZ-BLK-10 Mozzarella Block 10lb 100 $45.00 $4,500.00
3 SHR-AMR-05 Shredded American 5lb 200 $15.00 $3,000.00
Subtotal $24,500.00
Tax $0.00
Total $24,500.00
Usage: All transaction line item sublists. Cobalt header row with mono uppercase labels. Alternating ice rows. Item IDs in tufts blue (linked). Right-aligned numeric columns. Totals block right-aligned with cobalt grand total bar.
Communication Tab Pattern Tab
Messages
Notes
Files
Activity
Michael Levine 05/19/2026 2:30 PM
Confirmed ship date with warehouse. Carrier booked for 06/01 pickup. Customer notified.
System 05/18/2026 9:15 AM
Order approved by workflow. Status changed from Pending Approval to Pending Fulfillment.
Usage: Tabbed communication area on every record. Active tab has cobalt bottom border + bold text. Notes use the comments field (not messages). System entries on ice background. Add-note area always visible at bottom.
System Info Footer Pattern Footer
Internal ID
784510
Created By
M. Levine
Created
05/28/2026 8:42a
Last Modified
05/19/2026 2:30p
Usage: Bottom of every record. Fog background. 4-column grid: Internal ID, Created By, Created date, Last Modified date. Mono font throughout. User names link in tufts blue.
■ These four patterns form the complete anatomy of any NetSuite record UI in the GFS design system. Copy these templates exactly when building new record views.
08 Status Flow Visualizations State machine diagrams showing valid status transitions for key record types
Sales Order Lifecycle — 7 States
Pending Appr. Pending Fulfill. Partially Fulfilled Pending Billing Partially Billed Billed Closed Cancelled cancel approve fulfill bill bill pay close
Purchase Order Lifecycle — 6 States
Pending Appr. Pending Receipt Partially Received Pending Bill Fully Billed Closed Cancelled cancel approve receive bill pay close
Work Order Lifecycle — 5 States
Planned Released In Process Built Closed Cancelled cancel release start build close
Invoice Lifecycle — 4 States
Open Partially Paid Paid in Full Voided void partial pay full pay
Blue = Awaiting action
Yellow = In progress / partial
Green = Complete / positive
Red = Cancelled / void
Gray = Terminal / archived
■ All status badges follow the GFS semantic color system. Blue = awaiting action. Yellow = in progress. Green = complete. Red = cancelled/error. Gray = archived/terminal.
← Back to Hub · GFS Design System v10.0 · Global Food Solutions, Inc. · Edgewood, NY