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: 17 additional reference numbers Time zone Daylight savings indicator Excess transportation authorization Excess transportation reason code Excess transportation charge code Seal number Consignee shipment number
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.

Note: Extended mode processing has been added to the ASN. This mode is activated in the Hierarchical Configuration Definition program (P47HL). With extended mode, the packaging information is retrieved from both the F4216 and the F4620 tables. If Demand Scheduling is active and the ASN is in Extended Mode, Demand information is also extracted with the ASN.