Sales order lines V2.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV
1	SALESORDERNUMBER	INVENTORYLOTID	ALLOWEDOVERDELIVERYPERCENTAGE	ALLOWEDUNDERDELIVERYPERCENTAGE	BOMID	BUNDLELINESTATUS	BUNDLELINETYPE	CATALOG	COMMISSIONSALESREPRESENTATIVEGROUPID	CONFIRMEDRECEIPTDATE	CONFIRMEDSHIPPINGDATE	CREDITNOTEREASONCODE	CURRENCYCODE	CUSTOMERREQUISITIONNUMBER	CUSTOMERSLINENUMBER	DEFAULTLEDGERDIMENSIONDISPLAYVALUE	DEFAULTLINENUMBERFROMLINECREATIONSEQUENCENUMBER	DELIVERYADDRESSCITY	DELIVERYADDRESSCOUNTRYREGIONID	DELIVERYADDRESSCOUNTRYREGIONISOCODE	DELIVERYADDRESSCOUNTYID	DELIVERYADDRESSDESCRIPTION	DELIVERYADDRESSDISTRICTNAME	DELIVERYADDRESSDUNSNUMBER	DELIVERYADDRESSLATITUDE	DELIVERYADDRESSLOCATIONID	DELIVERYADDRESSLONGITUDE	DELIVERYADDRESSNAME	DELIVERYADDRESSPOSTBOX	DELIVERYADDRESSSTATEID	DELIVERYADDRESSSTREET	DELIVERYADDRESSSTREETNUMBER	DELIVERYADDRESSTIMEZONE	DELIVERYADDRESSZIPCODE	DELIVERYBUILDINGCOMPLIMENT	DELIVERYMODECODE	DELIVERYTERMSID	EINVOICEDIMENSIONACCOUNTCODE	EXCLUDEFROMMASTERPLANNING	EXTERNALITEMNUMBER	FIXEDPRICECHARGES	FORMATTEDDELVERYADDRESS	FULFILLMENTSTATUS	FULFILLMENTSTOREID	FULLRUNCTPSTATUS	GIFTCARDBUYEREMAIL	GIFTCARDBUYERNAME	GIFTCARDGIFTMESSAGE	GIFTCARDNUMBER	GIFTCARDRECIPIENTEMAIL	GIFTCARDRECIPIENTNAME	GIFTCARDTYPE	INTRASTATCOMMODITYCODE	INTRASTATPORTID	INTRASTATSPECIALMOVEMENTCODE	INTRASTATSTATISTICSPROCEDURECODE	INTRASTATTRANSACTIONCODE	INTRASTATTRANSPORTMODECODE	INVENTORYRESERVATIONMETHOD	INVENTORYSERVICEADJUSTMENTOFFSETDATASOURCE	INVENTORYSERVICEADJUSTMENTOFFSETPHYSICALMEASURE	INVENTORYSERVICERESERVATIONID	ISDELIVERYADDRESSORDERSPECIFIC	ISDELIVERYADDRESSPRIVATE	ISINTRASTATTRIANGULARDEAL	ISLINESTOPPED	ISPRICELOCKED	ISSOFTRESERVEDEXTERNALLY	ITEMBATCHNUMBER	ITEMNUMBER	ITEMSERIALNUMBER	ITEMWITHHOLDINGTAXCODEGROUPCODE	LINEAMOUNT	LINECREATIONSEQUENCENUMBER	LINEDESCRIPTION	LINEDISCOUNTAMOUNT	LINEDISCOUNTPERCENTAGE	LINENUMBER	MAINACCOUNTIDDISPLAYVALUE	MULTILINEDISCOUNTAMOUNT	MULTILINEDISCOUNTPERCENTAGE	ORDEREDCATCHWEIGHTQUANTITY	ORDEREDINVENTORYSTATUSID	ORDEREDSALESQUANTITY	OVERRIDESALESTAX	PACKINGUNITSYMBOL	PLANNINGPRIORITY	PRODUCTCOLORID	PRODUCTCONFIGURATIONID	PRODUCTSIZEID	PRODUCTSTYLEID	PRODUCTVERSIONID	PROJECTCATEGORYID	PROJECTID	PROJECTLINEPROPERTYID	REQUESTEDRECEIPTDATE	REQUESTEDSHIPPINGDATE	RETAILCALCULATEDLINEDISCOUNTAMOUNT	RETAILCALCULATEDLINEDISCOUNTPERCENTAGE	RETAILCALCULATEDMANUALLINEDISCOUNTAMOUNT
2	SO-000056	UBS-006008	.000000	.000000		None	None	0		1900-01-01 00:00:00	1900-01-01 00:00:00		SAR	4600033688	0		No								.0000000000		.0000000000									SEA	SAC		No		.000000		Unknown		Ready							Email							None				No	No	No	No	No	No		Gate Valve			123	1		.000000	.000000	1.0000000000000000		.000000	.000000	.000000		3.000000	No		.00									2024-11-18 00:00:00	2024-11-18 00:00:00	.000000	.000000	.000000
3	SO-000056	UBS-006009	.000000	.000000		None	None	0		1900-01-01 00:00:00	1900-01-01 00:00:00		SAR	4600033688	2		No								.0000000000		.0000000000									SEA	SAC		No		.000000		Unknown		Ready							Email							None				No	No	No	No	No	No		Gate Valve			246	2		.000000	.000000	2.0000000000000000		.000000	.000000	.000000		1.000000	No		.00									2024-11-18 00:00:00	2024-11-18 00:00:00	.000000	.000000	.000000
4	SO-000058	UBS-006010	.000000	.000000		None	None	0		1900-01-01 00:00:00	1900-01-01 00:00:00		USD	4600033688	1		No								.0000000000		.0000000000									SEA	SAC		No		.000000		Unknown		Ready							Email							None				No	No	No	No	No	No		Check Valve 2			432	1		.000000	.000000	1.0000000000000000		.000000	.000000	.000000		1.000000	No		.00									2024-11-18 00:00:00	2024-11-18 00:00:00	.000000	.000000	.000000
5	SO-001948	UBS-010859	.000000	.000000		None	None	0		1900-01-01 00:00:00	1900-01-01 00:00:00		SAR	4506319667	0	No active format for data entities has been set up. Set up an active format for each dimension format type.	No		SAU	SA		الشركه			.0000000000	000000124	.0000000000	CompanyB	11422		المملكة العربي قر طق الماعي 65 81 Saudi A bah Airport Branch Rd Stret 65								No		.000000	المملكة العربي قر طق الماعي 65 81 Saudi A bah Airport Branch Rd Stret 65	Unknown		Ready							Email							None				No	No	No	No	No	No		0P1439AB			5345	1	PCB ASSY SDC CONTROLLER	.000000	.000000	1.0000000000000000		.000000	.000000	.000000		1.000000	No		.00									2026-01-01 00:00:00	2026-01-01 00:00:00	.000000	.000000	.000000
6	SO-001949	UBS-010860	.000000	.000000		None	None	0		1900-01-01 00:00:00	1900-01-01 00:00:00		SAR	4506291717	0	No active format for data entities has been set up. Set up an active format for each dimension format type.	No		SAU	SA		الشركه			.0000000000	000000124	.0000000000	CompanyB	11422		المملكة العربي قر طق الماعي 65 81 Saudi A bah Airport Branch Rd Stret 65					Air	DDP		No		.000000	المملكة العربي قر طق الماعي 65 81 Saudi A bah Airport Branch Rd Stret 65	Unknown		Ready							Email							None				No	No	No	No	No	No		730-0912			345	1	sdlkfjsldkjfdslkjf	.000000	.000000	1.0000000000000000		.000000	.000000	.000000		1.000000	No		.00									2025-12-20 00:00:00	2025-12-20 00:00:00	.000000	.000000	.000000
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100