FTTH WorkFlow

Zone Entry

X-BOX Entry

Hub / FAT Entry

X-BOX Hub Name FAT Name Item Lookup Ports

Item Name Entry

Contractor Entry

Customer Entry

Contractor Price Entry

Contractor Item Project Region Unit Cost Effective From Effective To

Customer Price Entry

Customer Item Project Unit Sales Price Effective From Effective To

Cable Type Entry

Box Type Entry

DUID Entry

Zone / X-BOX / HUB DU ID from DUID Master

Contractor Master

2 contractors

Code	Contractor	Region	Status	Action
EGYTEL	Egytel Contractor	Alexandria	active
Karam	Karam	Alex	active

Customer Master

1 customers

Code	Customer	Region	Status	Action
TELECOM-CUSTOMER	Telecom Customer	-	active

Commercial Price Lists

Contractor prices drive cost. Customer prices drive auto sales order value.

2 prices

Type	Party	Project	Item Code	Item	Region	Unit Price	Effective From	Effective To
Contractor Cost	Karam	All	Preconnected 40	Pre-40	-	1,200.0000	2026-07-24	Open
Customer Sales	Telecom Customer	All	FIBER-CABLE	Fiber Cable	-	29,000.0000	2026-07-24	Open

Cable Type Master

11 types

Code	Cable Type	Cable Length (m)	Description	Status
cable	Drop Cable	-	-	active
duct	Duct / Conduit	-	-	active
fiber	Fiber (Optical)	-	-	active
mpo	MPO	-	-	active
00001	MPO 20	-	-	active
MPO 20	MPO 20	20	-	active
MPO 40	MPO 40	40	-	active
MPO 60	MPO 60	60	-	active
power	Power	-	-	active
preconn	Preconnected	-	-	active
Preconnected 20	Preconnected 20	20	-	active

Box Type Master

5 types

Code	Box Type	Shape	Color	Status
ENDBOX16	End-Box 16	triangle	#10b981	active
ENDBOX8	End-Box 8	circle	#10b981	active
SPLITTER	Splitter	diamond	#a21caf	active
SUBBOX16	Sub-Box 16	triangle	#0ea5e9	active
SUBBOX8	Sub-Box 8	circle	#0ea5e9	active

DUID Master

Upload an Excel sheet with a DU ID or DUID column. Existing IDs are updated without duplication.

75 DUIDs

DU ID	Zone	X-BOX	Line	HUB	Link Status
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X15_L01_TE_1	Pending master link	X15	L01	H1	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X15_L02_TE_1	Pending master link	X15	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X15_L03_TE_1	Pending master link	X15	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X15_L04_TE_1	Pending master link	X15	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X17_L01_TE_1	Pending master link	X17	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X17_L02_TE_1	Pending master link	X17	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X17_L03_TE_1	Pending master link	X17	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X17_L04_TE_1	Pending master link	X17	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X18_L01_TE_1	Pending master link	X18	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X18_L02_TE_1	Pending master link	X18	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X18_L03_TE_1	Pending master link	X18	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X18_L04_TE_1	Pending master link	X18	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X19_L01_TE_1	Pending master link	X19	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X19_L02_TE_1	Pending master link	X19	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X19_L03_TE_1	Pending master link	X19	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X19_L04_TE_1	Pending master link	X19	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X20_L01_TE_1	Pending master link	X20	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X20_L02_TE_1	Pending master link	X20	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X20_L03_TE_1	Pending master link	X20	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X20_L04_TE_1	Pending master link	X20	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X21_L01_TE_1	Pending master link	X21	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X21_L02_TE_1	Pending master link	X21	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X21_L03_TE_1	Pending master link	X21	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X21_L04_TE_1	Pending master link	X21	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X22_L02_TE_1	Pending master link	X22	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X22_L03_TE_1	Pending master link	X22	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X23_L01_TE_1	Pending master link	X23	L01	H1	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X23_L02_TE_1	Pending master link	X23	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X23_L03_TE_1	Pending master link	X23	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X24_L01_TE_1	Pending master link	X24	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X24_L02_TE_1	Pending master link	X24	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X24_L03_TE_1	Pending master link	X24	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X24_L04_TE_1	Pending master link	X24	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X25_L01_TE_1	Pending master link	X25	L01	H1	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X25_L03_TE_1	Pending master link	X25	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X25_L04_TE_1	Pending master link	X25	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X26_L01_TE_1	Pending master link	X26	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X26_L02_TE_1	Pending master link	X26	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X26_L03_TE_1	Pending master link	X26	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X26_L04_TE_1	Pending master link	X26	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X27_L01_TE_1	Pending master link	X27	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X27_L02_TE_1	Pending master link	X27	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X27_L03_TE_1	Pending master link	X27	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X27_L04_TE_1	Pending master link	X27	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X28_L01_TE_1	Pending master link	X28	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X28_L02_TE_1	Pending master link	X28	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X28_L03_TE_1	Pending master link	X28	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X28_L04_TE_1	Pending master link	X28	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X29_L01_TE_1	Pending master link	X29	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X29_L02_TE_1	Pending master link	X29	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X29_L03_TE_1	Pending master link	X29	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X29_L04_TE_1	Pending master link	X29	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X30_L01_TE_1	Pending master link	X30	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X30_L02_TE_1	Pending master link	X30	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X30_L03_TE_1	Pending master link	X30	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X37_L01_TE_1	Pending master link	X37	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X37_L02_TE_1	Pending master link	X37	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X37_L03_TE_1	Pending master link	X37	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X37_L04_TE_1	Pending master link	X37	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X38_L01_TE_1	Pending master link	X38	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X38_L02_TE_1	Pending master link	X38	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X38_L03_TE_1	Pending master link	X38	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X38_L04_TE_1	Pending master link	X38	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X42_L01_TE_1	Pending master link	X42	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X42_L02_TE_1	Pending master link	X42	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X42_L03_TE_1	Pending master link	X42	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X42_L04_TE_1	Pending master link	X42	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X43_L01_TE_1	Pending master link	X43	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X43_L02_TE_1	Pending master link	X43	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X43_L03_TE_1	Pending master link	X43	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X43_L04_TE_1	Pending master link	X43	L04	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X47_L01_TE_1	Pending master link	X47	L01	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X47_L02_TE_1	Pending master link	X47	L02	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X47_L03_TE_1	Pending master link	X47	L03	Pending HUB	Pending
FTTH_QODN_Alexandria_Awayed 4_Sector 1_Zone 5_X47_L04_TE_1	Pending master link	X47	L04	Pending HUB	Pending

Current Master Tables

Table	Zone	X-BOX	Hub / FAT	Item	Ports	Status
Zone	Alexandriz / AWAYED / 1 / Zone5	-	-	-	-	active
Zone	Mayami / Zone1 / Sector1 / Mayami	-	-	-	-	active
X-BOX	Alexandriz / AWAYED / 1 / Zone5	X25	-	-	-	active
X-BOX	Alexandriz / AWAYED / 1 / Zone5	X44	-	-	-	active
X-BOX	Alexandriz / AWAYED / 1 / Zone5	X50	-	-	-	active
X-BOX	Mayami / Zone1 / Sector1 / Mayami	X12	-	-	-	active
X-BOX	Mayami / Zone1 / Sector1 / Mayami	X13	-	-	-	active
Hub / FAT	Alexandriz / AWAYED / 1 / Zone5	X25	H1	Hub Box	0	active
Hub / FAT	Alexandriz / AWAYED / 1 / Zone5	X25	H2	Hub Box	2	active
Hub / FAT	Alexandriz / AWAYED / 1 / Zone5	X44	H1	Hub Box	0	active
Item	-	-	-	XBOX - X-Box	pcs	serial
Item	-	-	-	FIBER-CABLE - Fiber Cable	m	serial
Item	-	-	-	Preconnected 40 - Pre-40	pcs	bulk
Item	-	-	-	PRE0002 - Preconnected 40	pcs	serial
Item	-	-	-	DRAWING-OBJECT - Drawing Object	pcs	bulk
Item	-	-	-	ENDBOX - End-Box	pcs	bulk
Item	-	-	-	CABLE-FIBER - Fiber (Optical) Cable	pcs	bulk
Item	-	-	-	CABLE-MPO-20-20M - MPO 20 Cable	pcs	bulk
Item	-	-	-	CABLE-MPO - MPO Cable	pcs	bulk
Item	-	-	-	CABLE-PRECONN-100M - Preconnected 100m Cable	pcs	bulk
Item	-	-	-	CABLE-PRECONNECTED-20-20M - Preconnected 20 Cable	pcs	bulk
Item	-	-	-	CABLE-PRECONN-50M - Preconnected 50m Cable	pcs	bulk
Item	-	-	-	CABLE-PRECONN - Preconnected Cable	pcs	bulk
Item	-	-	-	SUBBOX - Sub-Box	pcs	bulk
Item	-	-	-	END_BOX - End Box	pcs	serial
Item	-	-	-	HUBBOX - Hub Box	pcs	serial
Item	-	-	-	SUB_BOX - Sub Box	pcs	serial
Item	-	-	-	CUSTOMER_TAG - Customer Tag	pcs	bulk
Item	-	-	-	POWER-TEST - Power Test Activity	port	bulk
Item	-	-	-	SPLICE - Splicing Activity	point	bulk
Item	-	-	-	SPLITTER - Splitter	pcs	serial

Zone Entry

X-BOX Entry

Hub / FAT Entry

Item Name Entry

Contractor Entry

Customer Entry

Contractor Price Entry

Customer Price Entry

Cable Type Entry

Box Type Entry

DUID Entry

Edit Master Record

Contractor Master

Customer Master

Commercial Price Lists

Cable Type Master

Box Type Master

DUID Master

Current Master Tables