Sales order headers V3.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	AREPRICESINCLUDINGSALESTAX	ARETOTALSCALCULATED	CAMPAIGNID	CASHDISCOUNTCODE	CHARGECUSTOMERGROUPID	COMMISSIONCUSTOMERGROUPID	COMMISSIONSALESREPRESENTATIVEGROUPID	CONFIRMEDRECEIPTDATE	CONFIRMEDSHIPPINGDATE	CONTACTPERSONID	CREDITNOTEREASONCODE	CURRENCYCODE	CUSTOMERPAYMENTMETHODNAME	CUSTOMERPAYMENTMETHODSPECIFICATIONNAME	CUSTOMERPOSTINGPROFILEID	CUSTOMERREQUISITIONNUMBER	CUSTOMERSORDERREFERENCE	CUSTOMERTRANSACTIONSETTLEMENTTYPE	DEFAULTLEDGERDIMENSIONDISPLAYVALUE	DEFAULTSHIPPINGSITEID	DEFAULTSHIPPINGWAREHOUSEID	DELIVERYADDRESSCITY	DELIVERYADDRESSCOUNTRYREGIONID	DELIVERYADDRESSCOUNTRYREGIONISOCODE	DELIVERYADDRESSCOUNTYID	DELIVERYADDRESSDESCRIPTION	DELIVERYADDRESSDISTRICTNAME	DELIVERYADDRESSDUNSNUMBER	DELIVERYADDRESSLATITUDE	DELIVERYADDRESSLOCATIONID	DELIVERYADDRESSLONGITUDE	DELIVERYADDRESSNAME	DELIVERYADDRESSPOSTBOX	DELIVERYADDRESSSTATEID	DELIVERYADDRESSSTREET	DELIVERYADDRESSSTREETNUMBER	DELIVERYADDRESSTIMEZONE	DELIVERYADDRESSZIPCODE	DELIVERYBUILDINGCOMPLIMENT	DELIVERYMODECODE	DELIVERYREASONCODE	DELIVERYTERMSCODE	DIRECTDEBITMANDATEID	EINVOICEDIMENSIONACCOUNTCODE	EMAIL	EUSALESLISTCODE	EXCLUDEFROMMASTERPLANNING	EXPORTREASON	FIXEDDUEDATE	FIXEDEXCHANGERATE	FORMATTEDDELVERYADDRESS	FORMATTEDINVOICEADDRESS	FULFILLMENTPOLICYNAME	FULLRUNCTPSTATUS	INTRASTATPORTID	INTRASTATSTATISTICSPROCEDURECODE	INTRASTATTRANSACTIONCODE	INTRASTATTRANSPORTMODECODE	INVENTORYRESERVATIONMETHOD	INVOICEADDRESSCITY	INVOICEADDRESSCOUNTRYREGIONID	INVOICEADDRESSCOUNTRYREGIONISOCODE	INVOICEADDRESSCOUNTYID	INVOICEADDRESSDISTRICTNAME	INVOICEADDRESSLATITUDE	INVOICEADDRESSLONGITUDE	INVOICEADDRESSPOSTBOX	INVOICEADDRESSSTATEID	INVOICEADDRESSSTREET	INVOICEADDRESSSTREETNUMBER	INVOICEADDRESSTIMEZONE	INVOICEADDRESSZIPCODE	INVOICEBUILDINGCOMPLIMENT	INVOICECUSTOMERACCOUNTNUMBER	ISDELIVERYADDRESSORDERSPECIFIC	ISDELIVERYADDRESSPRIVATE	ISEINVOICEDIMENSIONACCOUNTCODESPECIFIEDPERLINE	ISENTRYCERTIFICATEREQUIRED	ISINVOICEADDRESSPRIVATE	ISONETIMECUSTOMER	ISOWNENTRYCERTIFICATEISSUED	ISSALESPROCESSINGSTOPPED	LANGUAGEID	LINEDISCOUNTCUSTOMERGROUPCODE	MULTILINEDISCOUNTCUSTOMERGROUPCODE	NUMBERSEQUENCEGROUPID	ORDERCREATIONDATETIME	ORDERHEADERTAXAMOUNT	ORDERINGCUSTOMERACCOUNTNUMBER	ORDERRESPONSIBLEPERSONNELNUMBER	ORDERTAKERPERSONNELNUMBER	ORDERTOTALAMOUNT	ORDERTOTALCHARGESAMOUNT	ORDERTOTALDISCOUNTAMOUNT	ORDERTOTALTAXAMOUNT	OVERRIDESALESTAX	PAYMENTSCHEDULENAME	PAYMENTTERMSBASEDATE	PAYMENTTERMSNAME
2	SO-000056	No	No						1900-01-01 00:00:00	1900-01-01 00:00:00			SAR			GEN	4600033688	4507266214	None	No active format for data entities has been set up. Set up an active format for each dimension format type.	UBS	UBS								.0000000000		.0000000000	CompanyA								SEA		SAC				IncludeNot	No		1900-01-01 00:00:00	.0000000000000000				Ready					None						.0000000000	.0000000000								CUS000001	No	No	No	No	No	No	No	No	en-US				2025-10-15 04:08:32	.000000	CUS000001	UB014	UB075	.000000	.000000	.000000	.000000	No		1900-01-01 00:00:00	60
3	SO-000058	No	No						1900-01-01 00:00:00	1900-01-01 00:00:00			USD			GEN	4600033688	4507414329	None	No active format for data entities has been set up. Set up an active format for each dimension format type.	UBS	UBS								.0000000000		.0000000000	CompanyA								SEA		SAC				IncludeNot	No		1900-01-01 00:00:00	.0000000000000000				Ready					None						.0000000000	.0000000000								CUS000001	No	No	No	No	No	No	No	No	en-US				2025-10-15 04:08:32	.000000	CUS000001	UB014	UB075	.000000	.000000	.000000	.000000	No		1900-01-01 00:00:00	60
4	SO-001948	No	No						1900-01-01 00:00:00	1900-01-01 00:00:00			SAR			GEN	4506319667	4506319667	None	No active format for data entities has been set up. Set up an active format for each dimension format type.	UBS	UBS		SAU	SA		الشركه			.0000000000	000000124	.0000000000	CompanyB	11422		المملكة العربي قر طق الماعي 65 81 Saudi A bah Airport Branch Rd Stret 65											IncludeNot	No		1900-01-01 00:00:00	.0000000000000000	المملكة العربي قر طق الماعي 65 81 Saudi A bah Airport Branch Rd Stret 65			Ready					None						.0000000000	.0000000000								CUS000002	No	No	No	No	No	No	No	No	en-US				2025-12-25 13:59:40	.000000	CUS000002	UB005	UB005	.000000	.000000	.000000	.000000	No		1900-01-01 00:00:00	60
5	SO-001949	No	No						1900-01-01 00:00:00	1900-01-01 00:00:00			SAR			GEN	4506291717	4506291717	None	No active format for data entities has been set up. Set up an active format for each dimension format type.	UBS	UBS		SAU	SA		الشركه			.0000000000	000000124	.0000000000	CompanyB	11422		المملكة العربي قر طق الماعي 65 81 Saudi A bah Airport Branch Rd Stret 65					Air		DDP				IncludeNot	No		1900-01-01 00:00:00	.0000000000000000	المملكة العربي قر طق الماعي 65 81 Saudi A bah Airport Branch Rd Stret 65			Ready					None						.0000000000	.0000000000								CUS000002	No	No	No	No	No	No	No	No	en-US				2025-12-25 14:09:48	.000000	CUS000002	UB005	UB005	.000000	.000000	.000000	.000000	No		1900-01-01 00:00:00	60
6
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