Previous  Next          Contents  Index  Navigation  Glossary  Library

Record Layout Codes Summary

Record layout codes are indicated in positions 96-97 of the record key.

Several data elements relate to each other and can be found in several standard transactions. These related elements, for example, include addresses, contact data, and flexfields. The actual content of any record is qualified by the record layout qualifier, for example, ST or ST1 for ship-to address, and BT or BT1 for bill-to address.

Attention: You can modify these record layouts. However, any changes may affect the EDI translator data map you may be using.

Common Records for Inbound and Outbound Transactions

Seq. Record Layout Codes Description Meaning
1 A1 Flexfield Layout 1 Flexfields Layout 1
Layout 1 contains the Flexfield Context plus attributes each with length 80.
The interface table has the flexfield with the full length of 150 characters if needed.
2 A2 Flexfield Layout 2 Flexfields Layout 2.
Layout 2 contains attributes each with length 80.
The interface table has the flexfield with the full length of 150 characters if needed.
3 A3 Flexfield Layout 3 Flexfields Layout 3
Layout 3 contains the Flexfield Context plus attributes each with length 100. The interface table has the attribute with the full length of 150 characters if needed.
4 A4 Flexfield Layout 4 Attribute /Flexfields Layout 4.
Layout 4 contains attributes each with length 100.
The interface table has the flexfield with the full length of 150 characters if needed.
5 CT Control Record Control Record to start each transaction
 
6 CN Contact Record-Format 1 Primary Personnel Contact, title and phones.
7 CM Contact Record-Format 2 Phones

Transactions have both external and internal codes contained in the data file. This facilitates research on extracted application data and the data that resulted from code conversions. Inbound transactions do not have the internal fields in the file updated by the EDI Gateway. However, they are defined in the file in case code conversion is performed by the EDI translator or another process outside the EDI Gateway.

Reusable record layouts are listed in the following table.

Common Records for Outbound Transactions

  Record Layout Codes Description Meaning
1 AD Address Record Full Name and Addresses and Codes for each business entity where State and county codes are explicit.
This is usually data from RA-tables.
2 AX Address Record Full Name and Addresses and Codes for each business entity where REGION 1, REGION2, REGION3 contain the state and county.
This is usually data from HR-tables.
3 A5 Flexfield Layout 5 Attribute /Flexfields Layout 5
Layout 5 contains four pairs of internal defined flexfields and its external converted codes plus the Flexfield Context.
The interface table has the flexfield with the full length of 150 characters if needed.
4 A6 Flexfield Layout 6 Attribute /Flexfields Layout 6
Layout 6 contains four pairs of internal defined flexfields and its external converted codes.
The interface table has the flexfield with the full length of 150 characters if needed.

See Also

Overview of Data File Structure

Control Record Layout

Record Key (1-100)

Reusable Record Layout Details

Provide Additional Values

Extensible EDI Gateway Architecture

Changing the Data File


         Previous  Next          Contents  Index  Navigation  Glossary  Library