|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
RE: 856 Standard vs Pick and Pack Structure
One way is to create multiple table structures -
For SOPI, its tables with S (Header), SO (FKey from S), SOP (FKey from SO),
SOPI (FKey from SOP).
For SOIP, its tables with S (Header), SO (Fkey from S), SOI (FKey from SO),
SOIP (FKey from SOI)
So, it's 6 tables you create - S, SO, SOP, SOPI, SOI, SOIP. The application
layout tree in EDI software would look like -
S
O
P
I
I
P
For Inbound, based on HL, the appropriate hierarchy is mapped and generated
into database. Like wise, for Outbound, data is fetched for both the
hierarchies and appropriate HL is created. Note, this enables supporting
both SOPI and SOIP hierarchies in the same transaction (ST/SE pair), in case
it is required.
Other approaches can also be used to get the same result. Some will require
less of tables but may be more of processing (programming) and key
manipulations.
I do not know how your EDI translator supports this.
Hope this helps and reaches you before your meeting.
Ajay K Sanghi
Managing Director
ABO Software Private Limited
"EDISPHERE", XML/EDI Translation System
B102 Gulmohar Park New Delhi 110049
Tel: +91 11 2-6512822, 2-6968976 Fax: 2-6518873
website: www.abosoftware.com
-----Original Message-----
From: edipro1212 [mailto:
Sent: Monday, October 06, 2003 9:01 AM
To:
Subject: [EDI-L] 856 Standard vs Pick and Pack Structure
Good Monday morning all,
I'll try to make this as short as possible...
All of our customers want their 856's in Pick and Pack Structure
(SOPI). We have a new customer who wants their 856 in Standard
Structure (SOIP). It is my understanding that shipping
software/systems (I don't know exactly what to call it) are set up to
do either P&P or Standard--not both. At other jobs, we have had to
programmatically re-sort the P&P data and write a new physical file
for the data in Standard format. I'm trying to explain this to our
programmer, be he insists that a new logical file over the Pick and
Pack physical will work if we use different keys. This just doesn't
seem to make sense to me--how can one file have both one item to many
packs AND one pack to many items, no matter how you sort it? Am I
crazy? I'm relatively new at this job, so I have not built up enough
credibility for anyone to believe what I'm saying. I have a meeting
with him in an hour, so any quick second (third, fourth) opinion is
very welcome.
Thank you!
Tracy
AS400, BPCS ERP, Varsity shipping software, SSA modified version of
Harbiner 3.2 translator
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/OIFolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
Message Identifiers: <SALES>, <JOBS>,
<LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at:
http://groups.yahoo.com/group/EDI-L
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]
To unsubscribe from this group, send an email to:
Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
<OFF-TOPIC>
Access the list online at: http://groups.yahoo.com/group/EDI-L
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
