Table 42815 "SL Hist. SOShipHeader"

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	AccrDocDate	DateTime	—
2	AccrPerPost	Text[6]	—
3	AccrRevAcct	Text[10]	—
4	AccrRevSub	Text[24]	—
5	AccrShipRegisterID	Text[10]	—
6	AddressType	Text[1]	—
7	AdminHold	Integer	—
8	AppliedToDocRef	Text[15]	—
9	ARAcct	Text[10]	—
10	ARBatNbr	Text[10]	—
11	ARDocType	Text[2]	—
12	ARSub	Text[24]	—
13	ASID	Integer	—
14	ASID01	Integer	—
15	AuthNbr	Text[20]	—
16	AutoReleaseReturn	Integer	—
17	BalDue	Decimal	—
18	BIInvoice	Text[1]	—
19	BillAddr1	Text[60]	—
20	BillAddr2	Text[60]	—
21	BillAddrSpecial	Integer	—
22	BillAttn	Text[30]	—
23	BillCity	Text[30]	—
24	BillCountry	Text[3]	—
25	BillName	Text[60]	—
26	BillPhone	Text[30]	—
27	BillState	Text[3]	—
28	BillThruProject	Integer	—
29	BillZip	Text[10]	—
30	BlktOrdNbr	Text[15]	—
31	BMICost	Decimal	—
32	BMICuryID	Text[4]	—
33	BMIEffDate	DateTime	—
34	BMIMultDiv	Text[1]	—
35	BMIRate	Decimal	—
36	BMIRtTp	Text[6]	—
37	BookCntr	Integer	—
38	BookCntrMisc	Integer	—
39	BoxCntr	Integer	—
40	BuildActQty	Decimal	—
41	BuildCmpltDate	DateTime	—
42	BuildInvtID	Text[30]	—
43	BuildLotSerCntr	Integer	—
44	BuildQty	Decimal	—
45	BuildTotalCost	Decimal	—
46	BuyerID	Text[10]	—
47	BuyerName	Text[60]	—
48	CancelBO	Integer	—
49	Cancelled	Integer	—
50	CancelOrder	Integer	—
51	CertID	Text[2]	—
52	CertNoteID	Integer	—
53	ChainDisc	Text[15]	—
54	CmmnPct	Decimal	—
55	ConsolInv	Integer	—
56	ContractNbr	Text[25]	—
57	CpnyID	Text[10]	—
58	CreditApprDays	Integer	—
59	CreditApprLimit	Decimal	—
60	CreditChk	Integer	—
61	CreditHold	Integer	—
62	CreditHoldDate	DateTime	—
63	Crtd_DateTime	DateTime	—
64	Crtd_Prog	Text[8]	—
65	Crtd_User	Text[10]	—
66	CuryBalDue	Decimal	—
67	CuryBuildTotCost	Decimal	—
68	CuryEffDate	DateTime	—
69	CuryID	Text[4]	—
70	CuryMultDiv	Text[1]	—
71	CuryPremFrtAmt	Decimal	—
72	CuryRate	Decimal	—
73	CuryRateType	Text[6]	—
74	CuryTotFrtCost	Decimal	—
75	CuryTotFrtInvc	Decimal	—
76	CuryTotInvc	Decimal	—
77	CuryTotLineDisc	Decimal	—
78	CuryTotMerch	Decimal	—
79	CuryTotMisc	Decimal	—
80	CuryTotPmt	Decimal	—
81	CuryTotTax	Decimal	—
82	CuryTotTxbl	Decimal	—
83	CuryWholeOrdDisc	Decimal	—
84	CustGLClassID	Text[4]	—
85	CustID	Text[15]	—
86	CustOrdNbr	Text[25]	—
87	DateCancelled	DateTime	—
88	Dept	Text[30]	—
89	DiscAcct	Text[10]	—
90	DiscPct	Decimal	—
91	DiscSub	Text[24]	—
92	Div	Text[30]	—
93	DropShip	Integer	—
94	EDI810	Integer	—
95	EDI856	Integer	—
96	EDIASNProcNbr	Text[10]	—
97	EDIInvcProcNbr	Text[10]	—
98	ETADate	DateTime	—
99	FOBID	Text[15]	—
100	FrtAcct	Text[10]	—
101	FrtCollect	Integer	—
102	FrtSub	Text[24]	—
103	FrtTermsID	Text[10]	—
104	GeoCode	Text[10]	—
105	INBatNbr	Text[10]	—
106	InvcDate	DateTime	—
107	InvcNbr	Text[15]	—
108	InvcPrint	Integer	—
109	LanguageID	Text[4]	—
110	LastAppendDate	DateTime	—
111	LastAppendTime	DateTime	—
112	LineCntr	Integer	—
113	LotSerialHold	Integer	—
114	LUpd_DateTime	DateTime	—
115	LUpd_Prog	Text[8]	—
116	LUpd_User	Text[10]	—
117	MarkFor	Integer	—
118	MiscChrgCntr	Integer	—
119	NextFunctionClass	Text[4]	—
120	NextFunctionID	Text[8]	—
121	NoteID	Integer	—
122	OKToAppend	Integer	—
123	OrdDate	DateTime	—
224	OrdNbr	Text[15]	—
124	OverridePerPost	Integer	—
125	PackDate	DateTime	—
126	PerClosed	Text[6]	—
127	PerPost	Text[6]	—
128	PickDate	DateTime	—
129	PmtCntr	Integer	—
130	PremFrt	Integer	—
131	PremFrtAmt	Decimal	—
132	Priority	Integer	—
133	ProjectID	Text[16]	—
134	RelDate	DateTime	—
135	ReleaseValue	Decimal	—
136	RequireStepAssy	Integer	—
137	RequireStepInsp	Integer	—
138	S4Future01	Text[30]	—
139	S4Future02	Text[30]	—
140	S4Future03	Decimal	—
141	S4Future04	Decimal	—
142	S4Future05	Decimal	—
143	S4Future06	Decimal	—
144	S4Future07	DateTime	—
145	S4Future08	DateTime	—
146	S4Future09	Integer	—
147	S4Future10	Integer	—
148	S4Future11	Text[10]	—
149	S4Future12	Text[10]	—
150	SellingSiteID	Text[10]	—
151	ShipAddr1	Text[60]	—
152	ShipAddr2	Text[60]	—
153	ShipAddrID	Text[10]	—
154	ShipAddrSpecial	Integer	—
155	ShipAttn	Text[30]	—
156	ShipCity	Text[30]	—
157	ShipCmplt	Integer	—
158	ShipCountry	Text[3]	—
159	ShipCustID	Text[15]	—
160	ShipDateAct	DateTime	—
161	ShipDatePlan	DateTime	—
162	ShipGeoCode	Text[10]	—
163	ShipName	Text[60]	—
164	ShipperID	Text[15]	—
165	ShipPhone	Text[30]	—
166	ShippingConfirmed	Integer	—
167	ShippingManifested	Integer	—
168	ShipRegisterID	Text[10]	—
169	ShipSiteID	Text[10]	—
170	ShipState	Text[3]	—
171	ShiptoID	Text[10]	—
172	ShiptoType	Text[1]	—
173	ShipVendAddrID	Text[10]	—
174	ShipVendID	Text[15]	—
175	ShipViaID	Text[15]	—
176	ShipZip	Text[10]	—
177	SiteID	Text[10]	—
178	SlsperID	Text[10]	—
179	SOTypeID	Text[4]	—
180	Status	Text[1]	—
181	TaxID00	Text[10]	—
182	TaxID01	Text[10]	—
183	TaxID02	Text[10]	—
184	TaxID03	Text[10]	—
185	TermsID	Text[2]	—
186	TotBoxes	Integer	—
187	TotCommCost	Decimal	—
188	TotCost	Decimal	—
189	TotFrtCost	Decimal	—
190	TotFrtInvc	Decimal	—
191	TotInvc	Decimal	—
192	TotLineDisc	Decimal	—
193	TotMerch	Decimal	—
194	TotMisc	Decimal	—
195	TotPallets	Integer	—
196	TotPmt	Decimal	—
197	TotShipWght	Decimal	—
198	TotTax	Decimal	—
199	TotTxbl	Decimal	—
200	TrackingNbr	Text[25]	—
201	TransitTime	Integer	—
202	User1	Text[30]	—
203	User10	DateTime	—
204	User2	Text[30]	—
205	User3	Text[30]	—
206	User4	Text[30]	—
207	User5	Decimal	—
208	User6	Decimal	—
209	User7	Text[10]	—
210	User8	Text[10]	—
211	User9	DateTime	—
212	WeekendDelivery	Integer	—
213	WholeOrdDisc	Decimal	—
214	WorkflowID	Integer	—
215	WorkflowStatus	Text[1]	—
216	WSID	Integer	—
217	WSID01	Integer	—
218	Zone	Text[6]	—

Keys

PK: CpnyID, ShipperID (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. SOShipHeader"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.