Table 42816 "SL Hist. SOShipLine"

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	AlternateID	Text[30]	—
2	AltIDType	Text[1]	—
3	AvgCost	Decimal	—
4	BMICost	Decimal	—
5	BMICuryID	Text[4]	—
6	BMIEffDate	DateTime	—
7	BMIExtPriceInvc	Decimal	—
8	BMIMultDiv	Text[1]	—
9	BMIRate	Decimal	—
10	BMIRtTp	Text[6]	—
11	BMISlsPrice	Decimal	—
12	ChainDisc	Text[15]	—
13	CmmnPct	Decimal	—
14	CnvFact	Decimal	—
15	COGSAcct	Text[10]	—
16	COGSSub	Text[24]	—
17	CommCost	Decimal	—
18	Cost	Decimal	—
19	CpnyID	Text[10]	—
20	Crtd_DateTime	DateTime	—
21	Crtd_Prog	Text[8]	—
22	Crtd_User	Text[10]	—
23	CuryCommCost	Decimal	—
24	CuryCost	Decimal	—
25	CuryListPrice	Decimal	—
26	CurySlsPrice	Decimal	—
27	CuryTaxAmt00	Decimal	—
28	CuryTaxAmt01	Decimal	—
29	CuryTaxAmt02	Decimal	—
30	CuryTaxAmt03	Decimal	—
31	CuryTotCommCost	Decimal	—
32	CuryTotCost	Decimal	—
33	CuryTotInvc	Decimal	—
34	CuryTotMerch	Decimal	—
35	CuryTxblAmt00	Decimal	—
36	CuryTxblAmt01	Decimal	—
37	CuryTxblAmt02	Decimal	—
38	CuryTxblAmt03	Decimal	—
39	Descr	Text[60]	—
40	DescrLang	Text[30]	—
41	DiscAcct	Text[10]	—
42	DiscPct	Decimal	—
43	DiscSub	Text[24]	—
44	Disp	Text[3]	—
45	InspID	Text[2]	—
46	InspNoteID	Integer	—
47	InvAcct	Text[10]	—
48	InvSub	Text[24]	—
49	InvtID	Text[30]	—
50	IRDemand	Integer	—
51	IRInvtID	Text[30]	—
52	IRSiteID	Text[10]	—
53	ItemGLClassID	Text[4]	—
54	LineNbr	Integer	—
55	LineRef	Text[5]	—
56	ListPrice	Decimal	—
57	LotSerCntr	Integer	—
58	LUpd_DateTime	DateTime	—
59	LUpd_Prog	Text[8]	—
60	LUpd_User	Text[10]	—
61	ManualCost	Integer	—
62	ManualPrice	Integer	—
63	NoteID	Integer	—
64	OrdLineRef	Text[5]	—
65	OrdNbr	Text[15]	—
66	OrigBO	Decimal	—
67	OrigINBatNbr	Text[10]	—
68	OrigInvcNbr	Text[15]	—
69	OrigInvtID	Text[30]	—
70	OrigShipperID	Text[15]	—
71	OrigShipperLineRef	Text[5]	—
72	ProjectID	Text[16]	—
73	QtyBO	Decimal	—
74	QtyFuture	Decimal	—
75	QtyOrd	Decimal	—
76	QtyPick	Decimal	—
77	QtyPrevShip	Decimal	—
78	QtyShip	Decimal	—
79	RebateID	Text[10]	—
80	RebatePer	Text[6]	—
81	RebateRefNbr	Text[10]	—
82	S4Future01	Text[30]	—
83	S4Future02	Text[30]	—
84	S4Future03	Decimal	—
85	S4Future04	Decimal	—
86	S4Future05	Decimal	—
87	S4Future06	Decimal	—
88	S4Future07	DateTime	—
89	S4Future08	DateTime	—
90	S4Future09	Integer	—
91	S4Future10	Integer	—
92	S4Future11	Text[10]	—
93	S4Future12	Text[10]	—
94	Sample	Integer	—
95	Service	Integer	—
96	ShipperID	Text[15]	—
97	ShipWght	Decimal	—
98	SiteID	Text[10]	—
99	SlsAcct	Text[10]	—
100	SlsperID	Text[10]	—
101	SlsPrice	Decimal	—
102	SlsPriceID	Text[15]	—
103	SlsSub	Text[24]	—
104	SplitLots	Integer	—
105	Status	Text[1]	—
106	TaskID	Text[32]	—
107	Taxable	Integer	—
108	TaxAmt00	Decimal	—
109	TaxAmt01	Decimal	—
110	TaxAmt02	Decimal	—
111	TaxAmt03	Decimal	—
112	TaxCat	Text[10]	—
113	TaxID00	Text[10]	—
114	TaxID01	Text[10]	—
115	TaxID02	Text[10]	—
116	TaxID03	Text[10]	—
117	TaxIDDflt	Text[10]	—
118	TotCommCost	Decimal	—
119	TotCost	Decimal	—
120	TotInvc	Decimal	—
121	TotMerch	Decimal	—
122	TxblAmt00	Decimal	—
123	TxblAmt01	Decimal	—
124	TxblAmt02	Decimal	—
125	TxblAmt03	Decimal	—
126	UnitDesc	Text[6]	—
127	UnitMultDiv	Text[1]	—
128	User1	Text[30]	—
129	User10	DateTime	—
130	User2	Text[30]	—
131	User3	Text[30]	—
132	User4	Text[30]	—
133	User5	Decimal	—
134	User6	Decimal	—
135	User7	Text[10]	—
136	User8	Text[10]	—
137	User9	DateTime	—

Keys

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