Brian,
I have been there -- done this.
Create three fields in your application -- one numeric field for the integer part of
your data, one for the decimal part, and sandwich in a literal period for your decimal
point. Map SAC05 to both data fields in your application record, and fill the decimal
with a period. You will get truncation warnings, that\'s the price you pay.
Art
\"Test, Brian\" <[EMAIL PROTECTED]> wrote:
> Hi All,
Once again I need to draw upon your expertise. I need your help with
regards to taking an amount field in the SAC segment (856 document), and
having it be formatted in such a way that it satisfies our applications
format requirement. My translator is a Harbinger 4.1/Unix version.
This is what should be sent to us on the SAC segment:
If freight charge is $25.12 the segment will look like:
SAC*C*D240***2512
If freight charge is $25.00 the segment will look like:
SAC*C*D240***2500
My application record should have the translated field look like 00025.12
(leading zeros are required)
My problem is that when I do a translation, I can not get the leading zeros,
since the translator justifies to the left. Any suggestions?
Thanks again,
Brian Test
E-Commerce Analyst
ACCO North America
300 Tower Parkway
Lincolnshire, IL 60069-3640
(800) 222-6462 x3973
(847) 419-4146 FAX
[EMAIL PROTECTED]
\"WorldSecure\" made the following
annotations on 04/17/01 06:43:21
------------------------------------------------------------------------------
[INFO] -- Virus Manager:
This message was scanned with Network Associates Viper,
and no viruses were detected.
==============================================================================
=======================================================================
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
=======================================================================
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
