Table 42809 "SL Hist. POReceipt"

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	APRefno	Text[10]	—
2	BatNbr	Text[10]	—
3	CpnyID	Text[10]	—
4	CreateAD	Integer	—
5	Crtd_DateTime	DateTime	—
6	Crtd_Prog	Text[8]	—
7	Crtd_User	Text[10]	—
8	CuryEffDate	DateTime	—
9	CuryFreight	Decimal	—
10	CuryID	Text[4]	—
11	CuryMultDiv	Text[1]	—
12	CuryRate	Decimal	—
13	CuryRateType	Text[6]	—
14	CuryRcptAmt	Decimal	—
15	CuryRcptAmtTot	Decimal	—
16	CuryRcptCtrlAmt	Decimal	—
17	CuryRcptItemTotal	Decimal	—
18	DfltFromPO	Text[1]	—
19	ExcludeFreight	Text[1]	—
20	Freight	Decimal	—
21	InBal	Integer	—
22	LineCntr	Integer	—
23	LUpd_DateTime	DateTime	—
24	LUpd_Prog	Text[8]	—
25	LUpd_User	Text[10]	—
26	NoteID	Integer	—
27	OpenDoc	Integer	—
28	PC_Status	Text[1]	—
29	PerClosed	Text[6]	—
30	PerEnt	Text[6]	—
31	PONbr	Text[10]	—
32	ProjectID	Text[16]	—
33	RcptAmt	Decimal	—
34	RcptAmtTot	Decimal	—
35	RcptCtrlAmt	Decimal	—
36	RcptCtrlQty	Decimal	—
37	RcptDate	DateTime	—
38	RcptItemTotal	Decimal	—
39	RcptNbr	Text[10]	—
40	RcptQty	Decimal	—
41	RcptQtyTot	Decimal	—
42	RcptType	Text[1]	—
43	ReopenPO	Integer	—
44	Rlsed	Integer	—
45	RMAID	Text[15]	—
46	S4Future01	Text[30]	—
47	S4Future02	Text[30]	—
48	S4Future03	Decimal	—
49	S4Future04	Decimal	—
50	S4Future05	Decimal	—
51	S4Future06	Decimal	—
52	S4Future07	DateTime	—
53	S4Future08	DateTime	—
54	S4Future09	Integer	—
55	S4Future10	Integer	—
56	S4Future11	Text[10]	—
57	S4Future12	Text[10]	—
58	ServiceCallID	Text[10]	—
59	ShipperID	Text[15]	—
60	Status	Text[1]	—
61	User1	Text[30]	—
62	User2	Text[30]	—
63	User3	Decimal	—
64	User4	Decimal	—
65	User5	Text[10]	—
66	User6	Text[10]	—
67	User7	DateTime	—
68	User8	DateTime	—
69	VendID	Text[15]	—
70	VendInvcNbr	Text[10]	—
71	VouchStage	Text[1]	—
72	WayBillNbr	Text[10]	—

Keys

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