Understanding ASN Information Extraction
You typically run the EDI Advance Ship Notice Extraction program (R47032) after confirming shipments using the Shipment Confirmation program (P4205). You can run the extraction automatically from the Transportation Shipment Confirmation program (P49645) or manually from the menu.
The system retrieves shipment data from these tables:
F4201
F4211
F4215
F4217
F4216
F40R11
F4620
F46091
F40R14
When the system extracts shipment data, it converts the data to the ASN structure and writes the information to these tables:
Table |
Notes |
---|---|
F470371 |
Fields from the F4211 table and the F4216 table are carried forward to the F470371 table. (Release 9.2 Update) When you request for Advance Shipping Notice (R47032), the F470371 table is now able to store the global location number (GLN) of the origin branch plant in the Shipping Branch Plant GLN (GSHIB) field. As you run the R47032 Conversion Program (R47032C), you now receive 256 fields in the flat file for record type 2 from F470371 table with the GLN of the origin branch plant in the 256th field. |
F470372 |
Based on the Extended ASN option that you set in the Hierarchical Configuration Definition program (P47HL), the system populates this table with F40R11 information, such as Assembly Line Location, Job Sequence Number, Dock, and Model Year. The system also populates this table with F4942 information, such as CUM Quantity Shipped and CUM Quantity Shipped UOM. |
F470373 |
Information from the F4215, F4217, and F4720 tables are carried to the F470373 table. This includes these types of information:
|
F470374 |
Based on the Extended ASN option that you set in the Hierarchical Configuration Definition program (P47HL), the system populates this table with the address-related information from the F40R14 table. |
F470375 |
Based on the Extended ASN option in the Hierarchical Configuration Definition Revisions program (P47HL), the system uses this table to store the packaging detail, carton changes, and totals by carton type for each level on the ASN. The system calculates the total number of packages by container type within each ASN hierarchical level. The packaging information comes from the F4620 table. The system also calculates total charges for expendable containers. The charges for expendable cartons are created as sales order lines during shipment confirmation. The system totals these lines according to ASN hierarchical definition. |
The data in the ASN tables can then be converted into a flat file using the R47032 Conversion program (R47032C). The translator then maps the various tables or the flat file into the 856 or DESADV format.