SOExp-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	INVOICECUSTOMERACCOUNTNUMBER	DELIVERYADDRESSLOCATIONID	AREPRICESINCLUDINGSALESTAX	ARETOTALSCALCULATED	CAMPAIGNID	CASHDISCOUNTCODE	CHARGECUSTOMERGROUPID	COMMISSIONCUSTOMERGROUPID	COMMISSIONSALESREPRESENTATIVEGROUPID	CONFIRMEDRECEIPTDATE	CONFIRMEDSHIPPINGDATE	CONTACTPERSONID	CREDITNOTEREASONCODE	CURRENCYCODE	CUSTOMERPAYMENTMETHODNAME	CUSTOMERPAYMENTMETHODSPECIFICATIONNAME	CUSTOMERPOSTINGPROFILEID	CUSTOMERREQUISITIONNUMBER	CUSTOMERSORDERREFERENCE	CUSTOMERTRANSACTIONSETTLEMENTTYPE	DEFAULTSHIPPINGSITEID	DEFAULTSHIPPINGWAREHOUSEID	DELIVERYMODECODE	DELIVERYREASONCODE	DELIVERYTERMSCODE	DIRECTDEBITMANDATEID	EINVOICEDIMENSIONACCOUNTCODE	EMAIL	EUSALESLISTCODE	EXCLUDEFROMMASTERPLANNING	EXPORTREASON	FIXEDDUEDATE	FIXEDEXCHANGERATE	FORMATTEDINVOICEADDRESS	FULFILLMENTPOLICYNAME	FULLRUNCTPSTATUS	INTRASTATPORTID	INTRASTATSTATISTICSPROCEDURECODE	INTRASTATTRANSACTIONCODE	INTRASTATTRANSPORTMODECODE	INVENTORYRESERVATIONMETHOD	INVOICEADDRESSCITY	INVOICEADDRESSCOUNTRYREGIONID	INVOICEADDRESSCOUNTRYREGIONISOCODE	INVOICEADDRESSCOUNTYID	INVOICEADDRESSDISTRICTNAME	INVOICEADDRESSLATITUDE	INVOICEADDRESSLONGITUDE	INVOICEADDRESSPOSTBOX	INVOICEADDRESSSTATEID	INVOICEADDRESSSTREET	INVOICEADDRESSSTREETNUMBER	INVOICEADDRESSTIMEZONE	INVOICEADDRESSZIPCODE	INVOICEBUILDINGCOMPLIMENT	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	PRICECUSTOMERGROUPCODE	PROJECTID	QUOTATIONNUMBER	REPORTINGCURRENCYFIXEDEXCHANGERATE	REQUESTEDRECEIPTDATE	REQUESTEDSHIPPINGDATE	RETAILCHANNELTABLE	REVRECCONTRACTENDDATE	REVRECCONTRACTSTARTDATE	REVRECFOLLOWORIGINALPRICINGMETHOD	REVRECLATESTREVERSEJOURNAL	REVRECMULTIPLESOREALLOCATION	REVRECREALLOCATIONID	SALESORDERNAME	SALESORDERORIGINCODE	SALESORDERPOOLID	SALESORDERPROCESSINGSTATUS	SALESORDERPROMISINGMETHOD	SALESORDERSTATUS
2	SO-000082	CUS000002	000000124	No	No						1900-01-01 00:00:00	1900-01-01 00:00:00			EUR			GEN	4300655867	4300655867	None	UBS	UBS	DHL		DDP				IncludeNot	No		1900-01-01 00:00:00	.0000000000000000			Ready					None															No	No	No			No		No	en-US				2025-10-15 04:08:37		CUS000002	UBSCO006	UBSCO081					No		1900-01-01 00:00:00	60				.0000000000000000	2024-12-15 00:00:00	2024-12-15 00:00:00	0	1900-01-01 00:00:00	1900-01-01 00:00:00	No	0	No		Customer Name 001			Active	None	Backorder
3
4
5
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