Table 42813 "SL Hist. SOHeader"

DynamicsSLHistoricalData · Microsoft.DataMigration.SL.HistoricalData · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation
1	AddressType	Text[1]	—
2	AdminHold	Integer	—
3	AppliedToDocRef	Text[15]	—
4	ApprDetails	Integer	—
5	ApprRMA	Integer	—
6	ApprTech	Integer	—
7	ARAcct	Text[10]	—
8	ARSub	Text[24]	—
9	ASID	Integer	—
10	ASID01	Integer	—
11	AuthNbr	Text[20]	—
12	AutoPO	Integer	—
13	AutoPOVendID	Text[15]	—
14	AwardProbability	Integer	—
15	BalDue	Decimal	—
16	BIInvoice	Text[1]	—
17	BillAddr1	Text[60]	—
18	BillAddr2	Text[60]	—
19	BillAddrSpecial	Integer	—
20	BillAttn	Text[30]	—
21	BillCity	Text[30]	—
22	BillCountry	Text[3]	—
23	BillName	Text[60]	—
24	BillPhone	Text[30]	—
25	BillState	Text[3]	—
26	BillThruProject	Integer	—
27	BillZip	Text[10]	—
28	BlktOrdNbr	Text[15]	—
29	BookCntr	Integer	—
30	BookCntrMisc	Integer	—
31	BuildAssyTime	Integer	—
32	BuildAvailDate	DateTime	—
33	BuildInvtID	Text[30]	—
34	BuildQty	Decimal	—
35	BuildQtyUpdated	Decimal	—
36	BuildSiteID	Text[10]	—
37	BuyerID	Text[10]	—
38	BuyerName	Text[60]	—
39	CancelDate	DateTime	—
40	Cancelled	Integer	—
41	CancelShippers	Integer	—
42	CertID	Text[2]	—
43	CertNoteID	Integer	—
44	ChainDisc	Text[15]	—
45	CmmnPct	Decimal	—
46	ConsolInv	Integer	—
47	ContractNbr	Text[30]	—
48	CpnyID	Text[10]	—
49	CreditApprDays	Integer	—
50	CreditApprLimit	Decimal	—
51	CreditChk	Integer	—
52	CreditHold	Integer	—
53	CreditHoldDate	DateTime	—
54	Crtd_DateTime	DateTime	—
55	Crtd_Prog	Text[8]	—
56	Crtd_User	Text[10]	—
57	CuryBalDue	Decimal	—
58	CuryEffDate	DateTime	—
59	CuryID	Text[4]	—
60	CuryMultDiv	Text[1]	—
61	CuryPremFrtAmtAppld	Decimal	—
62	CuryRate	Decimal	—
63	CuryRateType	Text[6]	—
64	CuryTotFrt	Decimal	—
65	CuryTotLineDisc	Decimal	—
66	CuryTotMerch	Decimal	—
67	CuryTotMisc	Decimal	—
68	CuryTotOrd	Decimal	—
69	CuryTotPmt	Decimal	—
70	CuryTotPremFrt	Decimal	—
71	CuryTotTax	Decimal	—
72	CuryTotTxbl	Decimal	—
73	CuryUnshippedBalance	Decimal	—
74	CuryWholeOrdDisc	Decimal	—
75	CustGLClassID	Text[4]	—
76	CustID	Text[15]	—
77	CustOrdNbr	Text[25]	—
78	DateCancelled	DateTime	—
79	Dept	Text[30]	—
80	DiscAcct	Text[10]	—
81	DiscPct	Decimal	—
82	DiscSub	Text[24]	—
83	Div	Text[30]	—
84	DropShip	Integer	—
85	EDI810	Integer	—
86	EDI856	Integer	—
87	EDIPOID	Text[10]	—
88	EventCntr	Integer	—
89	FOBID	Text[15]	—
90	FrtAcct	Text[10]	—
91	FrtCollect	Integer	—
92	FrtSub	Text[24]	—
93	FrtTermsID	Text[10]	—
94	GeoCode	Text[10]	—
95	InvcDate	DateTime	—
96	InvcNbr	Text[15]	—
97	IRDemand	Integer	—
98	LanguageID	Text[4]	—
99	LineCntr	Integer	—
100	LostSaleID	Text[2]	—
101	LUpd_DateTime	DateTime	—
102	LUpd_Prog	Text[8]	—
103	LUpd_User	Text[10]	—
104	MarkFor	Integer	—
105	MiscChrgCntr	Integer	—
106	NextFunctionClass	Text[4]	—
107	NextFunctionID	Text[8]	—
108	NoteId	Integer	—
109	OrdDate	DateTime	—
110	OrdNbr	Text[15]	—
111	OrigOrdNbr	Text[15]	—
112	PC_Status	Text[1]	—
113	PerPost	Text[6]	—
114	PmtCntr	Integer	—
115	PremFrtAmtApplied	Decimal	—
116	Priority	Integer	—
117	ProjectID	Text[16]	—
118	QuoteDate	DateTime	—
119	Released	Integer	—
120	ReleaseValue	Decimal	—
121	RequireStepAssy	Integer	—
122	RequireStepInsp	Integer	—
123	RlseForInvc	Integer	—
124	S4Future01	Text[30]	—
125	S4Future02	Text[30]	—
126	S4Future03	Decimal	—
127	S4Future04	Decimal	—
128	S4Future05	Decimal	—
129	S4Future06	Decimal	—
130	S4Future07	DateTime	—
131	S4Future08	DateTime	—
132	S4Future09	Integer	—
133	S4Future10	Integer	—
134	S4Future11	Text[10]	—
135	S4Future12	Text[10]	—
136	SellingSiteID	Text[10]	—
137	SFOOrdNbr	Text[15]	—
138	ShipAddr1	Text[60]	—
139	ShipAddr2	Text[60]	—
140	ShipAddrID	Text[10]	—
141	ShipAddrSpecial	Integer	—
142	ShipAttn	Text[30]	—
143	ShipCity	Text[30]	—
144	ShipCmplt	Integer	—
145	ShipCountry	Text[3]	—
146	ShipCustID	Text[15]	—
147	ShipGeoCode	Text[10]	—
148	ShipName	Text[60]	—
149	ShipPhone	Text[30]	—
150	ShipSiteID	Text[10]	—
151	ShipState	Text[3]	—
152	ShiptoID	Text[10]	—
153	ShiptoType	Text[1]	—
154	ShipVendID	Text[15]	—
155	ShipViaID	Text[15]	—
156	ShipZip	Text[10]	—
157	SlsperID	Text[10]	—
158	SOTypeID	Text[4]	—
159	Status	Text[1]	—
160	TaxID00	Text[10]	—
161	TaxID01	Text[10]	—
162	TaxID02	Text[10]	—
163	TaxID03	Text[10]	—
164	TermsID	Text[2]	—
165	TotCommCost	Decimal	—
166	TotCost	Decimal	—
167	TotFrt	Decimal	—
168	TotLineDisc	Decimal	—
169	TotMerch	Decimal	—
170	TotMisc	Decimal	—
171	TotOrd	Decimal	—
172	TotPmt	Decimal	—
173	TotPremFrt	Decimal	—
174	TotShipWght	Decimal	—
175	TotTax	Decimal	—
176	TotTxbl	Decimal	—
177	UnshippedBalance	Decimal	—
178	User1	Text[30]	—
179	User10	DateTime	—
180	User2	Text[30]	—
181	User3	Text[30]	—
182	User4	Text[30]	—
183	User5	Decimal	—
184	User6	Decimal	—
185	User7	Text[10]	—
186	User8	Text[10]	—
187	User9	DateTime	—
188	VendAddrID	Text[10]	—
189	WeekendDelivery	Integer	—
190	WholeOrdDisc	Decimal	—
191	WorkflowID	Integer	—
192	WorkflowStatus	Text[1]	—
193	WSID	Integer	—

Keys

PK: CpnyID, OrdNbr (clustered)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "SL Hist. SOHeader"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.