EDI 810 TDS Segment: Total Monetary Value & N2 Implied Decimal Guide
TDS01–TDS04 use ANSI X12 data type N2 (implied 2 decimal places in cents). Learn how TDS01 relates to IT1 line totals and SAC allowances—and prevent 100x QuickBooks import errors.
Drop your file below, check the order, then download for QuickBooks Desktop (.IIF).
- 1Load your order file
- 2Check it and match your SKUs
Drop your EDI order file here
.edi, .x12 or .txt. The file is read on your computer and is not uploaded.
No chargeback risks found. This order passes every check.
Checked against the Amazon supplier guide for EDI 810.
- Invoice 3-way math balanced: IT1 Subtotal ($2330.00) + SAC ($-25.00) === TDS01 ($2305.00).
Raw EDI Code Inspector
29 linesPrimary header of an EDI 810 Invoice linking your accounting invoice number back to the retailer Purchase Order.
Commercial Invoice Summary & Line Items
| Line | Your SKU | Retailer Item # / UPC | Description | Invoiced Qty | Unit Price | Line Total |
|---|---|---|---|---|---|---|
| #1 | Item: B08N5WRWNW UPC: 012345678905 | ORGANIC COTTON BATH TOWEL ROYAL BLUE | 100 EA | $12.50 | $1250.00 | |
| #2 | Item: B09X1KLMNP UPC: 012345678912 | LUXURY WAFFLE ROBE WHITE XL | 60 EA | $18.00 | $1080.00 |
Download for your software
Pick where the order is going, then download. Files are ready for Excel, QuickBooks, Shopify or a thermal printer.
Field mapping table: which EDI segment fills which column (for IT & bookkeepers)
TDS Segment Elements (TDS01 – TDS04) N2 Implied Decimal Conversion
Deterministic segment-to-column mapping rules enforced by our client-side X12 engine
| Source X12 Segment / Element | Sample Raw Value | Target ERP / CSV Column | Transformation & Validation Logic |
|---|---|---|---|
| TDS01 (Total Invoice Amount) | 230500 | $2,305.00 (Net Invoice Total) | Divided by 100. Must equal Sum(IT102 × IT104) + Sum(SAC*C) - Sum(SAC*A). |
| TDS02 (Amount Subject to Terms Discount) | 233000 | $2,330.00 (Merchandise Subtotal) | Divided by 100. Gross merchandise amount before allowances/freight. |
| TDS03 (Discounted Amount Due) | 225840 | $2,258.40 (Net Due if Paid in 10 Days) | Divided by 100. Amount payable if buyer takes the ITD early-payment discount. |
| TDS04 (Terms Discount Amount) | 4660 | $46.60 (2% Early Pay Discount) | Divided by 100. Dollar value of early-payment terms discount. |
Critical Chargeback & Import Pitfalls We Prevent
Common EDI mistakes that trigger $250+ retailer fines or accounting balance errors
Writing a Decimal Point Inside TDS01 (e.g., TDS*2305.00~)
Risk: 997 AK4 Syntax RejectionBecause TDS01 is type N2 (not type R), a literal period "." is an illegal character that crashes X12 translators.
Forgetting to Divide TDS01 by 100 When Importing to QuickBooks
Risk: 100x Overstated A/R BalanceGeneric CSV scripts import "230500" as $230,500.00 instead of $2,305.00.
TDS01 Not Subtracting SAC*A Promotional Allowances
Risk: 824 Out-of-Balance RejectionIf merchandise is $2,330.00 and SAC*A is $25.00 (2500), TDS01 must be 230500, while TDS02 is 233000.
How to Audit & Fix TDS01 Implied Decimal Totals
Zero middleware setup — complete in under 60 seconds
Inspect TDS01, TDS02, TDS03, and TDS04 in the Amazon 810 sample.
Confirm that IT1 Subtotal + SAC Net === TDS01.
Download accounting files with properly scaled dollar amounts.
Frequently Asked Technical Questions
ANSI X12 specification details, retail companion rules, and ERP import answers
Why does IT104 have a decimal point (12.50) while TDS01 does not (230500)?
In the ANSI X12 standard, unit prices (PO104 / IT104) use data type "R" (Real decimal number, allowing fractional prices like $0.125), whereas monetary summary totals (TDS01 / SAC05) use data type "N2" (integer cents with 2 implied decimal places).
What happens if my 810 file illegally contains a decimal point in TDS01?
Our Chargeback Linter flags TDS01_ILLEGAL_DECIMAL immediately, and clicking "Auto-Fix All Issues" converts it to the valid integer-cent format.
Related EDI Converters, Retailer Guides & X12 Segment References
- X12 referenceEDI 997 & 824 Rejection Codes Lookup & 1-Click Auto-Fix Tool
- X12 referenceEDI 850 BEG Segment: Beginning Segment for Purchase Order Guide
- X12 referenceEDI 850 PO1 Segment & Product Qualifiers (UP, IN, VN, BP, UK) Guide
- X12 referenceEDI 850 SDQ Segment: Cross-Dock Store Allocation Guide & Excel Splitter
- X12 referenceEDI 856 BSN Segment: Beginning Segment for Ship Notice Guide
- ToolsConvert EDI X12 Files (850 / 856 / 810) to Excel (.XLSX) & CSV
- Transaction setsEDI 846 Inventory Inquiry/Advice Parser & CSV Converter
- IntegrationsConvert EDI 850 Purchase Orders to QuickBooks Desktop (.IIF)
- RetailersTarget EDI 850 / 856 / 810 Converter, DPCI Mapper & ASN Validator