Table 114 Sales Cr.Memo Header

Base Application, Microsoft.Sales.History

159 fields

IdNameTypeVersions
2Sell-to Customer No.Code[20]17-29
3No.Code[20]17-29
4Bill-to Customer No.Code[20]17-29
5Bill-to NameText[100]17-29
6Bill-to Name 2Text[50]17-29
7Bill-to AddressText[100]17-29
8Bill-to Address 2Text[50]17-29
9Bill-to CityText[30]17-29
10Bill-to ContactText[100]17-29
11Your ReferenceText[35]17-29
12Ship-to CodeCode[10]17-29
13Ship-to NameText[100]17-29
14Ship-to Name 2Text[50]17-29
15Ship-to AddressText[100]17-29
16Ship-to Address 2Text[50]17-29
17Ship-to CityText[30]17-29
18Ship-to ContactText[100]17-29
20Posting DateDate17-29
21Shipment DateDate17-29
22Posting DescriptionText[100]17-29
23Payment Terms CodeCode[10]17-29
24Due DateDate17-29
25Payment Discount %Decimal17-29
26Pmt. Discount DateDate17-29
27Shipment Method CodeCode[10]17-29
28Location CodeCode[10]17-29
29Shortcut Dimension 1 CodeCode[20]17-29
30Shortcut Dimension 2 CodeCode[20]17-29
31Customer Posting GroupCode[20]17-29
32Currency CodeCode[10]17-29
33Currency FactorDecimal17-29
34Customer Price GroupCode[10]17-29
35Prices Including VATBoolean17-29
37Invoice Disc. CodeCode[20]17-29
40Customer Disc. GroupCode[20]17-29
41Language CodeCode[10]17-29
42Format RegionText[80]new in 23
43Salesperson CodeCode[20]17-29
46CommentBoolean17-29
47No. PrintedInteger17-29
51On HoldCode[3]17-29
52Applies-to Doc. TypeEnum "Gen. Journal Document Type"17-29
53Applies-to Doc. No.Code[20]17-29
55Bal. Account No.Code[20]17-29
60AmountDecimal17-29
61Amount Including VATDecimal17-29
70VAT Registration No.Text[20]17-29
72Registration NumberText[50]new in 24
73Reason CodeCode[10]17-29
74Gen. Bus. Posting GroupCode[20]17-29
75EU 3-Party TradeBoolean17-29
76Transaction TypeCode[10]17-29
77Transport MethodCode[10]17-29
78VAT Country/Region CodeCode[10]17-29
79Sell-to Customer NameText[100]17-29
80Sell-to Customer Name 2Text[50]17-29
81Sell-to AddressText[100]17-29
82Sell-to Address 2Text[50]17-29
83Sell-to CityText[30]17-29
84Sell-to ContactText[100]17-29
85Bill-to Post CodeCode[20]17-29
86Bill-to CountyText[30]17-29
87Bill-to Country/Region CodeCode[10]17-29
88Sell-to Post CodeCode[20]17-29
89Sell-to CountyText[30]17-29
90Sell-to Country/Region CodeCode[10]17-29
91Ship-to Post CodeCode[20]17-29
92Ship-to CountyText[30]17-29
93Ship-to Country/Region CodeCode[10]17-29
94Bal. Account TypeEnum "Payment Balance Account Type"17-29
97Exit PointCode[10]17-29
98CorrectionBoolean17-29
99Document DateDate17-29
100External Document No.Code[35]17-29
101AreaCode[10]17-29
102Transaction SpecificationCode[10]17-29
104Payment Method CodeCode[10]17-29
105Shipping Agent CodeCode[10]17-29
106Package Tracking No.Text[50]17-29changed in 27
107Pre-Assigned No. SeriesCode[20]17-29
108No. SeriesCode[20]17-29
111Pre-Assigned No.Code[20]17-29
112User IDCode[50]17-29
113Source CodeCode[10]17-29
114Tax Area CodeCode[20]17-29
115Tax LiableBoolean17-29
116VAT Bus. Posting GroupCode[20]17-29
119VAT Base Discount %Decimal17-29
134Prepmt. Cr. Memo No. SeriesCode[20]17-29
136Prepayment Credit MemoBoolean17-29
137Prepayment Order No.Code[20]17-29
163Company Bank Account CodeCode[20]new in 20
166Alt. VAT Registration No.Booleannew in 25
167Alt. Gen. Bus Posting GroupBooleannew in 25
168Alt. VAT Bus Posting GroupBooleannew in 25
171Sell-to Phone No.Text[30]17-29
172Sell-to E-MailText[80]17-29
179VAT Reporting DateDatenew in 21
181Rcvd.-from Count./Region CodeCode[10]new in 22
200Work DescriptionBlob17-29
210Ship-to Phone No.Text[30]new in 25
480Dimension Set IDInteger17-29
710Document Exchange IdentifierText[50]17-29
711Document Exchange StatusEnum "Sales Document Exchange Status"17-29changed in 18
712Doc. Exch. Original IdentifierText[50]17-29
1302PaidBoolean17-29
1303Remaining AmountDecimal17-29
1304Cust. Ledger Entry No.Integer17-29
1305Invoice Discount AmountDecimal17-29
1310CancelledBoolean17-29
1311CorrectiveBoolean17-29
5050Campaign No.Code[20]17-29
5052Sell-to Contact No.Code[20]17-29
5053Bill-to Contact No.Code[20]17-29
5055Opportunity No.Code[20]17-29
5700Responsibility CenterCode[10]17-29
5794Shipping Agent Service CodeCode[10]17-29
6601Return Order No.Code[20]17-29
6602Return Order No. SeriesCode[20]17-29
7000Price Calculation MethodEnum "Price Calculation Method"17-29
7001Allow Line Disc.Boolean17-29
7200Get Return Receipt UsedBoolean17-29
8001Draft Cr. Memo SystemIdGuid17-29
10005Ship-to UPS ZoneCode[2]17-29
10015Tax Exemption No.Text[30]17-29
10018STE Transaction IDText[20]17-29
10019Electronic Document SentBoolean17-29
10020Original Document XMLBlob17-29
10021No. of E-Documents SentInteger17-29
10022Original StringBlob17-29
10023Digital Stamp SATBlob17-29
10024Certificate Serial No.Text[250]17-29
10025Signed Document XMLBlob17-29
10026Digital Stamp PACBlob17-29
10030Electronic Document StatusOption17-29
10031Date/Time StampedText[50]17-29
10032Date/Time SentText[50]17-29
10033Date/Time CanceledText[50]17-29
10035Error CodeCode[10]17-29
10036Error DescriptionText[250]17-29
10037Date/Time Stamp ReceivedDateTimenew in 22
10038Date/Time Cancel SentDateTimenew in 22
10040PAC Web Service NameText[50]17-29
10041QR CodeBlob17-29
10042Fiscal Invoice Number PACText[50]17-29
10043Date/Time First Req. SentText[50]17-29
10050Foreign TradeBooleannew in 21
10055Transit-to LocationCode[10]new in 21
Removed, tag 26.0, obsolete since 22.5: Replaced with SAT Address ID.
10059SAT International Trade TermCode[10]new in 21
10060Exchange Rate USDDecimalnew in 21
27000CFDI PurposeCode[10]17-29
27001CFDI RelationCode[10]17-29
27002CFDI Cancellation Reason CodeCode[10]new in 19
27003Substitution Document No.Code[20]new in 19
27004CFDI Export CodeCode[10]new in 19
27007CFDI Cancellation IDText[50]new in 21
27008Marked as CanceledBooleannew in 21
27009SAT Address IDIntegernew in 22
27012CFDI Certificate of Origin No.Text[50]new in 26