Objects/Tables/Table 114 Sales Cr.Memo Header

Table 114 Sales Cr.Memo Header in 23

Jonas Paprotka, Base Application 23.5.16502.31399, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Sales.History

Fields, 120 Keys, 9 Procedures, 23 Events, 9

Versions17 18 19 20 21 222324 25 26 27 28 latest

Source29

Fields, 120

Id	Name	Type	Obsolete
2	Sell-to Customer No.	Code[20]	-
3	No.	Code[20]	-
4	Bill-to Customer No.	Code[20]	-
5	Bill-to Name	Text[100]	-
6	Bill-to Name 2	Text[50]	-
7	Bill-to Address	Text[100]	-
8	Bill-to Address 2	Text[50]	-
9	Bill-to City	Text[30]	-
10	Bill-to Contact	Text[100]	-
11	Your Reference	Text[35]	-
12	Ship-to Code	Code[10]	-
13	Ship-to Name	Text[100]	-
14	Ship-to Name 2	Text[50]	-
15	Ship-to Address	Text[100]	-
16	Ship-to Address 2	Text[50]	-
17	Ship-to City	Text[30]	-
18	Ship-to Contact	Text[100]	-
20	Posting Date	Date	-
21	Shipment Date	Date	-
22	Posting Description	Text[100]	-
23	Payment Terms Code	Code[10]	-
24	Due Date	Date	-
25	Payment Discount %	Decimal	-
26	Pmt. Discount Date	Date	-
27	Shipment Method Code	Code[10]	-
28	Location Code	Code[10]	-
29	Shortcut Dimension 1 Code	Code[20]	-
30	Shortcut Dimension 2 Code	Code[20]	-
31	Customer Posting Group	Code[20]	-
32	Currency Code	Code[10]	-
33	Currency Factor	Decimal	-
34	Customer Price Group	Code[10]	-
35	Prices Including VAT	Boolean	-
37	Invoice Disc. Code	Code[20]	-
40	Customer Disc. Group	Code[20]	-
41	Language Code	Code[10]	-
42	Format Region	Text[80]	-
43	Salesperson Code	Code[20]	-
46	Comment	Boolean	-
47	No. Printed	Integer	-
51	On Hold	Code[3]	-
52	Applies-to Doc. Type	Enum Gen. Journal Document Type	-
53	Applies-to Doc. No.	Code[20]	-
55	Bal. Account No.	Code[20]	-
60	Amount	Decimal	-
61	Amount Including VAT	Decimal	-
70	VAT Registration No.	Text[20]	-
73	Reason Code	Code[10]	-
74	Gen. Bus. Posting Group	Code[20]	-
75	EU 3-Party Trade	Boolean	-
76	Transaction Type	Code[10]	-
77	Transport Method	Code[10]	-
78	VAT Country/Region Code	Code[10]	-
79	Sell-to Customer Name	Text[100]	-
80	Sell-to Customer Name 2	Text[50]	-
81	Sell-to Address	Text[100]	-
82	Sell-to Address 2	Text[50]	-
83	Sell-to City	Text[30]	-
84	Sell-to Contact	Text[100]	-
85	Bill-to Post Code	Code[20]	-
86	Bill-to County	Text[30]	-
87	Bill-to Country/Region Code	Code[10]	-
88	Sell-to Post Code	Code[20]	-
89	Sell-to County	Text[30]	-
90	Sell-to Country/Region Code	Code[10]	-
91	Ship-to Post Code	Code[20]	-
92	Ship-to County	Text[30]	-
93	Ship-to Country/Region Code	Code[10]	-
94	Bal. Account Type	Enum Payment Balance Account Type	-
97	Exit Point	Code[10]	-
98	Correction	Boolean	-
99	Document Date	Date	-
100	External Document No.	Code[35]	-
101	Area	Code[10]	-
102	Transaction Specification	Code[10]	-
104	Payment Method Code	Code[10]	-
105	Shipping Agent Code	Code[10]	-
106	Package Tracking No.	Text[30]	-
107	Pre-Assigned No. Series	Code[20]	-
108	No. Series	Code[20]	-
111	Pre-Assigned No.	Code[20]	-
112	User ID	Code[50]	-
113	Source Code	Code[10]	-
114	Tax Area Code	Code[20]	-
115	Tax Liable	Boolean	-
116	VAT Bus. Posting Group	Code[20]	-
119	VAT Base Discount %	Decimal	-
134	Prepmt. Cr. Memo No. Series	Code[20]	-
136	Prepayment Credit Memo	Boolean	-
137	Prepayment Order No.	Code[20]	-
163	Company Bank Account Code	Code[20]	-
171	Sell-to Phone No.	Text[30]	-
172	Sell-to E-Mail	Text[80]	-
179	VAT Reporting Date	Date	-
180	Rcvd-from Country/Region Code	Code[10]	Removed 23.0
Use new field on range 181
181	Rcvd.-from Count./Region Code	Code[10]	-
200	Work Description	Blob	-
480	Dimension Set ID	Integer	-
710	Document Exchange Identifier	Text[50]	-
711	Document Exchange Status	Enum Sales Document Exchange Status	-
712	Doc. Exch. Original Identifier	Text[50]	-
1302	Paid	Boolean	-
1303	Remaining Amount	Decimal	-
1304	Cust. Ledger Entry No.	Integer	-
1305	Invoice Discount Amount	Decimal	-
1310	Cancelled	Boolean	-
1311	Corrective	Boolean	-
5050	Campaign No.	Code[20]	-
5052	Sell-to Contact No.	Code[20]	-
5053	Bill-to Contact No.	Code[20]	-
5055	Opportunity No.	Code[20]	-
5700	Responsibility Center	Code[10]	-
5794	Shipping Agent Service Code	Code[10]	-
6601	Return Order No.	Code[20]	-
6602	Return Order No. Series	Code[20]	-
7000	Price Calculation Method	Enum Price Calculation Method	-
7001	Allow Line Disc.	Boolean	-
7200	Get Return Receipt Used	Boolean	-
8000	Id	Guid	Removed 22.0
This functionality will be replaced by the systemID field
8001	Draft Cr. Memo SystemId	Guid	-

Keys, 9

Name	Fields	Obsolete
Key1, clustered	No.	-
Key2	Pre-Assigned No.	-
Key3	Return Order No.	-
Key4	Sell-to Customer No.	-
Key5	Prepayment Order No.	-
Key6	Bill-to Customer No.	-
Key7	Posting Date	-
Key8	Document Exchange Status	-
Key9	Salesperson Code	-

Procedures, 23

Name	Parameters	Returns	Access	Obsolete
SendRecords	()		public	-
SendProfile	(var Record Document Sending Profile)		public	-
StartTrackingSite	()		public	-
PrintRecords	(Boolean)		public	-
EmailRecords	(Boolean)		public	-
PrintToDocumentAttachment	(var Record Sales Cr.Memo Header)		public	-
Navigate	()		public	-
LookupAdjmtValueEntries	()		public	-
GetCustomerVATRegistrationNumber	()	Text	public	-
GetCustomerVATRegistrationNumberLbl	()	Text	public	-
GetCustomerGlobalLocationNumber	()	Text	public	-
GetCustomerGlobalLocationNumberLbl	()	Text	public	-
GetLegalStatement	()	Text	public	-
ShowDimensions	()		public	-
SetSecurityFilterOnRespCenter	()		public	-
GetDocExchStatusStyle	()	Text	public	-
ShowActivityLog	()		public	-
DocExchangeStatusIsSent	()	Boolean	public	-
ShowCanceledOrCorrInvoice	()		public	-
ShowCorrectiveInvoice	()		public	-
ShowCancelledInvoice	()		public	-
GetWorkDescription	()	Text	public	-
CheckNoPrinted	()		public	-

Events, 9

Kind	Name	Parameters	Obsolete
Integration event	OnBeforePrintRecords	(var Record Report Selections, var Record Sales Cr.Memo Header, Boolean, var Boolean)	-
Integration event	OnBeforeSendProfile	(var Record Report Selections, var Record Sales Cr.Memo Header, Text, var Boolean, var Record Document Sending Profile)	-
Integration event	OnBeforeSendRecords	(var Record Report Selections, var Record Sales Cr.Memo Header, Text, var Boolean)	-
Integration event	OnLookupAppliesToDocNoOnAfterSetFilters	(var Record Cust. Ledger Entry, Record Sales Cr.Memo Header)	-
Integration event	OnBeforeSetSecurityFilterOnRespCenter	(var Record Sales Cr.Memo Header, var Boolean)	-
Integration event	OnBeforeRunSalesInvoiceHeaderPage	(var Record Sales Invoice Header, var Integer, var Boolean)	-
Integration event	OnBeforeDoPrintToDocumentAttachment	(var Record Sales Cr.Memo Header, Boolean, var Boolean)	-
Integration event	OnBeforeEmailRecords	(var Record Report Selections, var Record Sales Cr.Memo Header, Text, var Boolean, var Boolean)	-
Integration event	OnBeforeCheckNoPrinted	(var Record Sales Cr.Memo Header, var Boolean)	-