Family Dollar 810 EDI Mapping For TDS, CAD, SAC segments
Family Dollar 810 EDI Mapping Notes given below establish necessary guidelines for the Invoice Transaction Set (810) mapping practice (TDS, CAD, SAC). The Family Dollar 810 EDI Mapping guidelines described in this blog post are presented in the form of notes and do not cover all the requirements set to Family Dollar vendors.
TDS Segment
- TDS01: INVOICE TOTAL( NET AMOUNT) [QUANTITY( IT102) * GROSS UNIT PRICE ( IT104)] +CHARGES (SAC01=C) – ALLOWANCES (SACO1=A)
- TDS02: Total GROSS Invoice Amount =Unit quantity * Unit cost (Gross)
- TDS03: This is the $ Amount of what Family Dollar is allowed to deduct from the vendor if paid within the vendor’s terms. Example: 2%30 days on a $1000.00 invoice would be $20.00. This must be a positive number. If your system only handles negatives provide a mapping that would multiply this number by a – 1
- The 810 must resemble the paper copy submitted to Family Dollar Stores prior to the production of 810‟s. You will need to send the Detail SAC SEGMENT if you provide us an allowance and have gross and net cost
- TDS02 is required if the dollar value subject to discount is not equal to the dollar value of TDS01
CAD Segment
- CAD07: Bill of Lading not mandatory if it’s vendor managed inventory at the store level or the invoice is not against a Family Dollar PO
- CAD08: Vendor Bill of lading if it’s a trailer then Number is the Container number & If it’s a container Shipper tracking number for UPS/Air
- R0504 – At least one of CAD05,CAD04 is required
- C0708 – If CAD07 is present, then all of CAD08 are required
SAC Segment
- YOU CANNOT SEND A NEGATIVE VALUE IN THE SAC SEGMENT. The allowance ‘A’ or charge ‘C’ indicator will alert FD as to how the dollar value should be handled
- R0203 – At least one of SAC02,SAC03 is required FDS 810 Guidelines 38 For internal use only 03/08/02 Invoice – 810
- P0304 – If either SAC03,SAC04 is present, then all are required
- P0607 – If either SAC06,SAC07 is present, then all are required
- P0910 – If either SAC09,SAC10 is present, then all are required
- C1110 – If SAC11 is present, then all of SAC10 are required
- L130204 – If SAC13 is present, then at least one of SAC02,SAC04 is required
- C1413 – If SAC14 is present, then all of SAC13 are required
- C1615 – If SAC16 is present, then all of SAC15 are required
- SAC04 may be used to uniquely identify the service, promotion, allowance, or charge. In addition, it may be used in conjunction with SAC03 to further define SAC02.
- In some business applications, it is necessary to advise the trading partner of the actual dollar amount that a particular allowance, charge, or promotion was based on to reduce ambiguity. This amount is commonly referred to as “Dollar Basis Amount”. It is represented in the SAC segment in SAC10 using the qualifier “DO” – Dollars in SAC09
- YOU CANNOT SEND A NEGATIVE VALUE IN THE SAC SEGMENT. The allowance ‘A’ or charge ‘C’ indicator will alert FD as to how the dollar value should be handled. Also all allowances and charges on the summary level should be separate and should not be added together for the entire invoice. In case the codes and amounts do not match the terms, the invoice will be rejected and an 864 message will be generated