| Home » Categories » Solutions by Business Process » Profiler |
General Lookup File - EDI Order Processing |
|
Article Number: 1750 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 10:54 PM
|
|
Datafile Software General Lookup File - EDI Order Processing This file holds all the lookup information needed by the EDI order processing interface application.It holds specifically: ¨EAN location codes, representing the customer ordering and delivery locations ¨EAN product codes, representing the agreed industry-wide product codes ¨Tradacomslist code values, used to indicate aspects of the messages. Tradacoms lists often use single alphabetic or numeric codes, so the codes in this file are normally prefixed with additional characters to make them unique. For example, list 5 has just two entries "F” and "P”, so these values become "L05F” and "L05P” to ensure they are unique. See below for the prefix values used. Item Name Type Size Description 1 CODE X 14 The prime-index code for this file. 2 NAME X 35 The description of this code 3 INTERNAL-CODE X 16 The internal code for the prime-index code. If the prime-index code is (say) an EAN location, then this represents the sales ledger or internal delivery address code. If the prime-index code is (say) the product EAN code, then this is the internal product code. 4 PROC-FLAG X 1 This flag is used internally within the system. 5 WARN? ? 1 This flag can be used as a warning that the product in question needs special treatment. It can be set automatically via the stock/product file, or via a System Maintenance menu option. 6 DATE-ADDED E 10 The date this entry was created in the file 7 USER X 6 The user signed-on when the entry was created. 11 EANL? ? 1 Set to "Y” to show that this is an EAN location record. Your own EAN location codes set this value too. 12 EANP? ? 1 Set to "Y” to show that this is an EAN productrecord. 13 ANAC? ? 1 Set to "Y” to show that this is an entry 14 OWN? ? 1 Set to "Y” to show that this location is one of your locations, not a customer location. |
Attachments
There are no attachments for this article.
|
G4 – Krunch File, Compacting All Records
Viewed 1207 times since Thu, Jun 28, 2012
Create New Database
Viewed 3098 times since Fri, Jun 29, 2012
Screen Design - Allow 20 Lines per Screen Layout
Viewed 2574 times since Mon, Jun 11, 2012
User-Defined Reports - Update Excel Spreadsheet from Accumulators
Viewed 16061 times since Mon, Jun 11, 2012
G7 Rebuild Indexes
Viewed 2083 times since Thu, Jun 28, 2012
Global Updates - Update Numeric Values to Y-Type Items
Viewed 2222 times since Tue, Jun 12, 2012
Sales Ledger Extra Items - EDI Order Processing
Viewed 2098 times since Thu, Jul 5, 2012
Extract Between Databases
Viewed 2194 times since Fri, Jun 29, 2012
EDI Messages and Files
Viewed 2663 times since Thu, Jul 5, 2012
Select Current Application
Viewed 2273 times since Thu, Jun 28, 2012
|

