Table 42811 "SL Hist. PurchOrd"

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	AckDateTime	DateTime	—
2	ASID	Integer	—
3	BatNbr	Text[10]	—
4	BillShipAddr	Integer	—
5	BlktExprDate	DateTime	—
6	BlktPONbr	Text[10]	—
7	Buyer	Text[10]	—
8	BuyerEmail	Text[80]	—
9	CertCompl	Integer	—
10	ConfirmTo	Text[10]	—
11	CpnyID	Text[10]	—
12	Crtd_DateTime	DateTime	—
13	Crtd_Prog	Text[8]	—
14	Crtd_User	Text[10]	—
15	CurrentNbr	Integer	—
16	CuryEffDate	DateTime	—
17	CuryFreight	Decimal	—
18	CuryID	Text[4]	—
19	CuryMultDiv	Text[1]	—
20	CuryPOAmt	Decimal	—
21	CuryPOItemTotal	Decimal	—
22	CuryRate	Decimal	—
23	CuryRateType	Text[6]	—
24	CuryRcptTotAmt	Decimal	—
25	CuryTaxTot00	Decimal	—
26	CuryTaxTot01	Decimal	—
27	CuryTaxTot02	Decimal	—
28	CuryTaxTot03	Decimal	—
29	CuryTxblTot00	Decimal	—
30	CuryTxblTot01	Decimal	—
31	CuryTxblTot02	Decimal	—
32	CuryTxblTot03	Decimal	—
33	EDI	Integer	—
34	FOB	Text[15]	—
35	Freight	Decimal	—
36	LastRcptDate	DateTime	—
37	LineCntr	Integer	—
38	LUpd_DateTime	DateTime	—
39	LUpd_Prog	Text[8]	—
40	LUpd_User	Text[10]	—
41	NoteID	Integer	—
42	OpenPO	Integer	—
43	PC_Status	Text[1]	—
44	PerClosed	Text[6]	—
45	PerEnt	Text[6]	—
46	POAmt	Decimal	—
47	PODate	DateTime	—
48	POItemTotal	Decimal	—
49	PONbr	Text[10]	—
50	POType	Text[2]	—
51	ProjectID	Text[16]	—
52	PrtBatNbr	Text[10]	—
53	PrtFlg	Integer	—
54	RcptStage	Text[1]	—
55	RcptTotAmt	Decimal	—
56	ReqNbr	Text[10]	—
57	S4Future01	Text[30]	—
58	S4Future02	Text[30]	—
59	S4Future03	Decimal	—
60	S4Future04	Decimal	—
61	S4Future05	Decimal	—
62	S4Future06	Decimal	—
63	S4Future07	DateTime	—
64	S4Future08	DateTime	—
65	S4Future09	Integer	—
66	S4Future10	Integer	—
67	S4Future11	Text[10]	—
68	S4Future12	Text[10]	—
69	ServiceCallID	Text[10]	—
70	ShipAddr1	Text[60]	—
71	ShipAddr2	Text[60]	—
72	ShipAddrID	Text[10]	—
73	ShipAttn	Text[30]	—
74	ShipCity	Text[30]	—
75	ShipCountry	Text[3]	—
76	ShipCustID	Text[15]	—
77	ShipEmail	Text[80]	—
78	ShipFax	Text[30]	—
79	ShipName	Text[60]	—
80	ShipPhone	Text[30]	—
81	ShipSiteID	Text[10]	—
82	ShipState	Text[3]	—
83	ShiptoID	Text[10]	—
84	ShiptoType	Text[1]	—
85	ShipVendAddrID	Text[10]	—
86	ShipVendID	Text[15]	—
87	ShipVia	Text[15]	—
88	ShipZip	Text[10]	—
89	Status	Text[1]	—
90	TaxCntr00	Integer	—
91	TaxCntr01	Integer	—
92	TaxCntr02	Integer	—
93	TaxCntr03	Integer	—
94	TaxID00	Text[10]	—
95	TaxID01	Text[10]	—
96	TaxID02	Text[10]	—
97	TaxID03	Text[10]	—
98	TaxTot00	Decimal	—
99	TaxTot01	Decimal	—
100	TaxTot02	Decimal	—
101	TaxTot03	Decimal	—
102	Terms	Text[2]	—
103	TxblTot00	Decimal	—
104	TxblTot01	Decimal	—
105	TxblTot02	Decimal	—
106	TxblTot03	Decimal	—
107	User1	Text[30]	—
108	User2	Text[30]	—
109	User3	Decimal	—
110	User4	Decimal	—
111	User5	Text[10]	—
112	User6	Text[10]	—
113	User7	DateTime	—
114	User8	DateTime	—
115	VendAddr1	Text[60]	—
116	VendAddr2	Text[60]	—
117	VendAddrID	Text[10]	—
118	VendAttn	Text[30]	—
119	VendCity	Text[30]	—
120	VendCountry	Text[3]	—
121	VendEmail	Text[80]	—
122	VendFax	Text[30]	—
123	VendID	Text[15]	—
124	VendName	Text[60]	—
125	VendPhone	Text[30]	—
126	VendState	Text[3]	—
127	VendZip	Text[10]	—
128	VouchStage	Text[1]	—
129	WSID	Integer	VouchStage caption

Keys

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