On Feb 11, 2014, at 8:40 AM, Greg Payne <gpayne@...> wrote:
<div id="ygrps-yiv-1380681612ygrp-text"> <p>
looking at the dmt template builder for quote detail shows the quoteqty fields.
HTH
Greg
False
QuoteQty#QuoteNum
Int32
>>>>>>>>9
Quote number to which this line item detail record is associated with. This is part of the foreign key to OrderHed file.
False
QuoteQty#QuoteLine
Int32
>>>>>9
This field along with Company and QuoteNum make up the unique key to the table. The system generates this number during entry of new detail records. The system determines next available number by finding the QuoteDtl record for the Quote and the adding 1 to it.
False
QuoteQty#QtyNum
Int32
>>9
False
QuoteQty#OurQuantity
Decimal
>>>,>>>,>>>,>>9.99
False
QuoteQty#UnitPrice
Decimal
>,>>>,>>>,>>9.99999
False
QuoteQty#DocUnitPrice
Decimal
>,>>>,>>>,>>9.99999
False
QuoteQty#PricePerCode
String
x
False
QuoteQty#MtlBurMarkUp
Decimal
>>9.999%
False
QuoteQty#MaterialMarkUp
Decimal
>>9.999%
False
QuoteQty#SubcontractMarkUp
Decimal
>>9.999%
False
QuoteQty#LaborMarkUp
Decimal
>>9.999%
False
QuoteQty#BurdenMarkUp
Decimal
>>9.999%
False
QuoteQty#MiscCostDesc
String
X(30)
False
QuoteQty#MiscCost
Decimal
->>>,>>>,>>>,>>9.999
False
QuoteQty#MiscCostMarkUp
Decimal
>>9.999%
False
QuoteQty#CommissionPct
Decimal
>>9.999%
False
QuoteQty#PercentType
String
x
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of khambleton500@...
Sent: Monday, February 10, 2014 8:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9
We are moving to Epicor 9.05.702 from Vantage 6. We are using the DMT tool to move data. I have successfully moved our open qoute headers and lines but I am struggling on how to get the quantities and prices populated. Does anyone know if there is a DMT template for this informaiton?
Thanks,
Kathy Hambleton
Electron Energy Corporation
924 Links Ave
Landisville PA 17538
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
</div>