Posted Sales table in Microsoft Dynamics 365 Business Central. 119 fields, 0 records in Cronus demo.
Sales Cr.Memo Line stores the line-level detail of posted sales credit memos. Each row represents a returned or credited item, G/L account charge, or resource with its quantity, unit price, and amounts. Referenced in returns processing, revenue adjustments, and credit memo reporting.
The primary key uniquely identifies each record in this table. It consists of: Document No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 2 | Sell-to Customer No. | Code | Normal | → Customer #18 |
| 3 | Document No. PK | Code | Normal | → Sales Cr.Memo Header #114 |
| 4 | Line No. PK | Integer | Normal | |
| 5 | Type | Option | Normal | |
| 6 | No. | Code | Normal | |
| 7 | Location Code | Code | Normal | → Location #14 |
| 8 | Posting Group | Code | Normal | |
| 10 | Shipment Date | Date | Normal | |
| 11 | Description | Text | Normal | |
| 12 | Description 2 | Text | Normal | |
| 13 | Unit of Measure | Text | Normal | |
| 15 | Quantity | Decimal | Normal | |
| 22 | Unit Price | Decimal | Normal | |
| 23 | Unit Cost (LCY) | Decimal | Normal | |
| 25 | VAT % | Decimal | Normal | |
| 27 | Line Discount % | Decimal | Normal | |
| 28 | Line Discount Amount | Decimal | Normal | |
| 29 | Amount | Decimal | Normal | |
| 30 | Amount Including VAT | Decimal | Normal | |
| 32 | Allow Invoice Disc. | Boolean | Normal | |
| 34 | Gross Weight | Decimal | Normal | |
| 35 | Net Weight | Decimal | Normal | |
| 36 | Units per Parcel | Decimal | Normal | |
| 37 | Unit Volume | Decimal | Normal | |
| 38 | Appl.-to Item Entry | Integer | Normal | |
| 40 | Shortcut Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 41 | Shortcut Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 42 | Customer Price Group | Code | Normal | → Customer Price Group #6 |
| 45 | Project No. | Code | Normal | → Job #167 |
| 52 | Work Type Code | Code | Normal | → Work Type #200 |
| 65 | Order No. | Code | Normal | |
| 66 | Order Line No. | Integer | Normal | |
| 68 | Bill-to Customer No. | Code | Normal | → Customer #18 |
| 69 | Inv. Discount Amount | Decimal | Normal | |
| 74 | Gen. Bus. Posting Group | Code | Normal | → Gen. Business Posting Group #250 |
| 75 | Gen. Prod. Posting Group | Code | Normal | → Gen. Product Posting Group #251 |
| 77 | VAT Calculation Type | Option | Normal | |
| 78 | Transaction Type | Code | Normal | → Transaction Type #258 |
| 79 | Transport Method | Code | Normal | → Transport Method #259 |
| 80 | Attached to Line No. | Integer | Normal | → Sales Cr.Memo Line #115 |
| 81 | Exit Point | Code | Normal | → Entry/Exit Point #282 |
| 82 | Area | Code | Normal | → Area #284 |
| 83 | Transaction Specification | Code | Normal | → Transaction Specification #285 |
| 84 | Tax Category | Code | Normal | |
| 85 | Tax Area Code | Code | Normal | → Tax Area #318 |
| 86 | Tax Liable | Boolean | Normal | |
| 87 | Tax Group Code | Code | Normal | → Tax Group #321 |
| 88 | VAT Clause Code | Code | Normal | → VAT Clause #560 |
| 89 | VAT Bus. Posting Group | Code | Normal | → VAT Business Posting Group #323 |
| 90 | VAT Prod. Posting Group | Code | Normal | → VAT Product Posting Group #324 |
| 97 | Blanket Order No. | Code | Normal | → Sales Header #36 |
| 98 | Blanket Order Line No. | Integer | Normal | → Sales Line #37 |
| 99 | VAT Base Amount | Decimal | Normal | |
| 100 | Unit Cost | Decimal | Normal | |
| 101 | System-Created Entry | Boolean | Normal | |
| 103 | Line Amount | Decimal | Normal | |
| 104 | VAT Difference | Decimal | Normal | |
| 106 | VAT Identifier | Code | Normal | |
| 107 | IC Partner Ref. Type | Option | Normal | |
| 108 | IC Partner Reference | Code | Normal | |
| 123 | Prepayment Line | Boolean | Normal | |
| 130 | IC Partner Code | Code | Normal | → IC Partner #413 |
| 131 | Posting Date | Date | Normal | |
| 138 | IC Item Reference No. | Code | Normal | |
| 145 | Pmt. Discount Amount | Decimal | Normal | |
| 180 | Line Discount Calculation | Option | Normal | |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 1001 | Project Task No. | Code | Normal | → Job Task #1001 |
| 1002 | Project Contract Entry No. | Integer | Normal | |
| 1700 | Deferral Code | Code | Normal | → Deferral Template #1700 |
| 5402 | Variant Code | Code | Normal | |
| 5403 | Bin Code | Code | Normal | → Bin #7354 |
| 5404 | Qty. per Unit of Measure | Decimal | Normal | |
| 5407 | Unit of Measure Code | Code | Normal | |
| 5415 | Quantity (Base) | Decimal | Normal | |
| 5600 | FA Posting Date | Date | Normal | |
| 5602 | Depreciation Book Code | Code | Normal | → Depreciation Book #5611 |
| 5605 | Depr. until FA Posting Date | Boolean | Normal | |
| 5612 | Duplicate in Depreciation Book | Code | Normal | → Depreciation Book #5611 |
| 5613 | Use Duplication List | Boolean | Normal | |
| 5700 | Responsibility Center | Code | Normal | → Responsibility Center #5714 |
| 5709 | Item Category Code | Code | Normal | |
| 5710 | Catalog | Boolean | Normal | |
| 5711 | Purchasing Code | Code | Normal | → Purchasing #5721 |
| 5725 | Item Reference No. | Code | Normal | |
| 5726 | Unit of Measure (Item Ref.) | Code | Normal | |
| 5727 | Item Reference Type | Option | Normal | |
| 5728 | Item Reference Type No. | Code | Normal | |
| 5811 | Appl.-from Item Entry | Integer | Normal | |
| 6210 | Sustainability Account No. | Code | Normal | → Sustainability Account #6210 |
| 6211 | Sustainability Account Name | Text | Normal | |
| 6212 | Sustainability Account Category | Code | Normal | → Sustain. Account Category #6211 |
| 6213 | Sustainability Account Subcategory | Code | Normal | → Sustain. Account Subcategory #6212 |
| 6214 | CO2e per Unit | Decimal | Normal | |
| 6215 | Total CO2e | Decimal | Normal | |
| 6217 | EPR Fee per Unit | Decimal | Normal | |
| 6218 | Total EPR Fee | Decimal | Normal | |
| 6600 | Return Receipt No. | Code | Normal | |
| 6601 | Return Receipt Line No. | Integer | Normal | |
| 6608 | Return Reason Code | Code | Normal | → Return Reason #6635 |
| 7000 | Price Calculation Method | Option | Normal | |
| 7001 | Allow Line Disc. | Boolean | Normal | |
| 7002 | Customer Disc. Group | Code | Normal | → Customer Discount Group #340 |
| 7012 | Sell-to Customer Name ⚡ FLOW | Text | FlowField | |
| 8051 | Subscription Contract No. | Code | Normal | → Customer Subscription Contract #8052 |
| 8052 | Subscription Contract Line No. | Integer | Normal | → Cust. Sub. Contract Line #8062 |
| 8053 | Recurring Billing from | Date | Normal | |
| 8054 | Recurring Billing to | Date | Normal | |
| 10500 | Reverse Charge Item | Boolean | Normal | |
| 10501 | Reverse Charge | Decimal | Normal | |
| 10507 | Reverse Charge Item | Boolean | Normal | |
| 10508 | Reverse Charge | Decimal | Normal | |
| 30103 | Shopify Refund Id | BigInteger | Normal | → Shpfy Refund Header #30142 |
| 30104 | Shopify Refund Line Id | BigInteger | Normal | |
| 2000000000 | System ID | GUID | Normal | |
| 2000000001 | Created At | DateTime | Normal | |
| 2000000002 | Created By | GUID | Normal | |
| 2000000003 | Modified At | DateTime | Normal | |
| 2000000004 | Modified By | GUID | Normal |
Tables referenced by fields on the Sales Cr.Memo Line table through TableRelation properties.