SURYA SGFMaterial Inward · Gate-In → Account-Entry DashboardInwardMastersCompany MapOps BoardUploadAPIAdmin

SGF — Whole-Company Map

Procure → produce → slit → sell → collect → plan. 30 core entities · 1,255,100 rows loaded · one connected model. green = loaded, dashed = schema ready (loader next).

Keys that thread the whole company: Material raw→jumbo→FG   Batch jumbo→slit   Customer order→dispatch→ledger   Sales Order order→slit→dispatch   Plant everywhere
1 · PROCURE
Raw materials in the gate
115
Vendor
vendor_code
1,296
GateEntry
gate_entry_no
1,392
InwardLine
line_uid
1,394
MiroPosting
miro_no
⛓ Material(raw) · Gate Entry No
◆ MASTERS
The canonical key spine (threads everything)
344
FGMaterial
fg_code
274
JumboMaterial
jumbo_code
166
FGJumboLink
m2m
1,010
Customer
customer_code
23
SalesPerson
actual_name
22
MaterialGroup
group
7,472
PriceListItem
eff_date
30,490
TargetLine
cust×month
⛓ Material · Customer · Sales Person · Plant
2 · JUMBO
Cast film → master rolls
—
ProcessOrder
order_no
5,848
JumboProductionEvent
mat_doc
5,833
JumboRoll
jumbo_batch
⛓ Material(jumbo) · Batch · Process Order
3 · SLIT
Master roll → customer widths
212,580
SlitProductionEvent
mat_doc
212,746
SlitRoll
slit_batch
551,363
BatchMovement
batch×doc×SO
⛓ Material(FG) · Width · Batch · Sales Order
4 · ORDER
Customer demand
23,638
SalesOrder
sale_document
105,895
OrderLine
SO×item
3,436
OrderPunch
sap_order
⛓ Customer · Material(FG) · Sales Order
5 · DISPATCH
Invoice + ship
13,787
Invoice
gst_invoice
74,608
DispatchLine
inv×mat×width
⛓ Customer · Material · Invoice
6 · LEDGER
Receivables
634
CustomerLedgerSnapshot
cust×date
⛓ Customer
7 · PLAN (MIS)
The daily dashboard we regenerate
—
PlanRun
plant×date
—
PlanLine
jumbo/slit
—
DispatchClearance
clearance
621
ShipToLocation
location
36
MisTask
task
77
TransporterBillCycle
freight
⛓ all of the above → one morning report

Built from the 26-entity key spec, verified by 3 adversarial reviews. Masters + inward loaded; production/sales/mis schema is live and linked, fact-loaders are the next step.