Table 42810 "SL Hist. POTran"

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	Acct	Text[10]	—
2	AcctDist	Integer	—
3	AddlCost	Decimal	—
4	AddlCostPct	Decimal	—
5	AddlCostVouch	Decimal	—
6	AlternateID	Text[30]	—
7	AltIDType	Text[1]	—
8	APLineID	Integer	—
9	APLineRef	Text[5]	—
10	BatNbr	Text[10]	—
11	BMICuryID	Text[4]	—
12	BMIEffDate	DateTime	—
13	BMIExtCost	Decimal	—
14	BMIMultDiv	Text[1]	—
15	BMIRate	Decimal	—
16	BMIRtTp	Text[6]	—
17	BMITranAmt	Decimal	—
18	BMIUnitCost	Decimal	—
19	BMIUnitPrice	Decimal	—
20	BOMLineRef	Text[5]	—
21	BOMSequence	Integer	—
22	CnvFact	Decimal	—
23	CostVouched	Decimal	—
24	CpnyID	Text[10]	—
25	Crtd_DateTime	DateTime	—
26	Crtd_Prog	Text[8]	—
27	Crtd_User	Text[10]	—
28	CuryAddlCost	Decimal	—
29	CuryAddlCostVouch	Decimal	—
30	CuryCostVouched	Decimal	—
31	CuryExtCost	Decimal	—
32	CuryID	Text[4]	—
33	CuryMultDiv	Text[1]	—
34	CuryRate	Decimal	—
35	CuryTranAmt	Decimal	—
36	CuryUnitCost	Decimal	—
37	DrCr	Text[1]	—
38	ExtCost	Decimal	—
39	ExtWeight	Decimal	—
40	FlatRateLineNbr	Integer	—
41	InvtID	Text[30]	—
42	JrnlType	Text[3]	—
43	Labor_Class_Cd	Text[4]	—
44	LineID	Integer	—
45	LineNbr	Integer	—
46	LineRef	Text[5]	—
47	LUpd_DateTime	DateTime	—
48	LUpd_Prog	Text[8]	—
49	LUpd_User	Text[10]	—
50	NoteID	Integer	—
51	OrigRcptDate	DateTime	—
52	OrigRcptNbr	Text[10]	—
53	OrigRetRcptNbr	Text[10]	—
54	PC_Flag	Text[1]	—
55	PC_ID	Text[20]	—
56	PC_Status	Text[1]	—
57	PerEnt	Text[6]	—
58	PerPost	Text[6]	—
59	POLineID	Integer	—
60	POLineNbr	Integer	—
61	POLIneRef	Text[5]	—
62	PONbr	Text[10]	—
63	POOriginal	Text[1]	—
64	ProjectID	Text[16]	—
65	PurchaseType	Text[2]	—
66	Qty	Decimal	—
67	QtyVouched	Decimal	—
68	RcptConvFact	Decimal	—
69	RcptDate	DateTime	—
70	RcptLineRefOrig	Text[5]	—
71	RcptMultDiv	Text[1]	—
72	RcptNbr	Text[10]	—
73	RcptNbrOrig	Text[10]	—
74	RcptQty	Decimal	—
75	RcptUnitDescr	Text[6]	—
76	ReasonCd	Text[6]	—
77	Refnbr	Text[10]	—
78	S4Future01	Text[30]	—
79	S4Future02	Text[30]	—
80	S4Future03	Decimal	—
81	S4Future04	Decimal	—
82	S4Future05	Decimal	—
83	S4Future06	Decimal	—
84	S4Future07	DateTime	—
85	S4Future08	DateTime	—
86	S4Future09	Integer	—
87	S4Future10	Integer	—
88	S4Future11	Text[10]	—
89	S4Future12	Text[10]	—
90	ServiceCallID	Text[10]	—
91	SiteID	Text[10]	—
92	SOLineID	Integer	—
93	SOLineRef	Text[5]	—
94	SOOrdNbr	Text[15]	—
95	SOTypeID	Text[4]	—
96	SpecificCostID	Text[25]	—
97	StepNbr	Integer	—
98	Sub	Text[24]	—
99	SvcContractID	Text[10]	—
100	SvcLineNbr	Integer	—
101	TaskID	Text[32]	—
102	TaxCat	Text[10]	—
103	TaxIDDflt	Text[10]	—
104	TranAmt	Decimal	—
105	TranDate	DateTime	—
106	TranDesc	Text[60]	—
107	TranType	Text[2]	—
108	UnitCost	Decimal	—
109	UnitDescr	Text[6]	—
110	UnitMultDiv	Text[1]	—
111	UnitWeight	Decimal	—
112	User1	Text[30]	—
113	User2	Text[30]	—
114	User3	Decimal	—
115	User4	Decimal	—
116	User5	Text[10]	—
117	User6	Text[10]	—
118	User7	DateTime	—
119	User8	DateTime	—
120	VendId	Text[15]	—
121	VouchStage	Text[1]	—
122	WhseLoc	Text[10]	—
123	WIP_COGS_Acct	Text[10]	—
124	WIP_COGS_Sub	Text[24]	—
125	WOBomRef	Text[5]	—
126	WOCostType	Text[2]	—
127	WONbr	Text[10]	—
128	WOStepNbr	Text[5]	—

Keys

PK: RcptNbr, 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. POTran"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.