947 Warehouse Inventory Adjustment Advice (003070)

This is the standard X12 003070 spec, with 8 loops and 35 segment positions, as OpenEDI JSON, an ediFabric C# template and an ediFabric Native model. To change it for a trading partner, customize it in the EDI Spec Builder.

Loading the spec…

The spec as an OpenAPI 3 schema with x-openedi-* extensions, for ediFabric Native, ediFabric Cloud and the EDI Spec Builder. Download OpenEDI (67 KB) Generate classes

The ediFabric .NET template, class TS947. It needs the common segments, composites and codes of X12 003070, one download for every transaction in the version. Download C# (1 KB) Common files (238 KB)

The intermediary model ediFabric Native loads with set_map. Download Native (50 KB)

Use the 947 spec in your code

ediFabric .NET

Add the C# template and its common files to your project, or reference the template NuGet package, and read 947 files into TS947 objects. See ediFabric .NET.

ediFabric Native

Map version 003070 to the Native model with set_map, then parse 947 files to JSON from Python, Java, C or C#. See Convert between EDI and JSON.

OpenEDI

Select Customize in Spec Builder to copy the spec under your own name, change it for your partner, and parse files against it in EdiNation, ediFabric Native or ediFabric Cloud. Read about OpenEDI.

Generate 947 classes in Python, Java, Node.js, Go, Rust or C

ediFabric Native returns each 947 as JSON, with the property names of the OpenEDI schema. To work with that JSON as typed objects, generate classes from the OpenEDI file in your language and deserialize the JSON into TS947. Serialize the objects back to JSON to build EDI with ediFabric Native. The classes keep the loops, segments, lengths and code lists, but not the EDI data formats, so validate files with ediFabric Native. Read more in Generate a class from OpenEDI.

Python: datamodel-code-generator. Node.js: openapi-typescript. Java, Go, Rust and C: OpenAPI Generator.

947 structure

Loops and segments of the standard 947, with their usage and maximum repeats.

ID	Name	Usage	Max use
ST	Transaction Set Header	Optional	1
W15	Warehouse Adjustment Identification	Mandatory	1
Loop N1	Name	Mandatory	100
N1	Name	Mandatory	1
N2	Additional Name Information	Optional	1
N3	Address Information	Optional	1
N4	Geographic Location	Optional	1
PER	Administrative Communications Contact	Optional	5
N9	Reference Identification	Optional	10
G61	Contact	Optional	3
G62	Date/Time	Optional	5
NTE	Note/Special Instruction	Optional	20
Loop LM	Code Source Information	Optional	10
LM	Code Source Information	Mandatory	1
LQ	Industry Code	Mandatory	100
Loop W19	Warehouse Adjustment Item Detail	Mandatory	>1
W19	Warehouse Adjustment Item Detail	Mandatory	1
G69	Line Item Detail - Description	Optional	5
N9	Reference Identification	Optional	10
CS	Contract Summary	Optional	1
AMT	Monetary Amount	Optional	1
G62	Date/Time	Optional	10
Loop LM	Code Source Information	Optional	10
LM	Code Source Information	Mandatory	1
LQ	Industry Code	Mandatory	100
Loop N1	Name	Optional	50
N1	Name	Mandatory	1
N2	Additional Name Information	Optional	2
N3	Address Information	Optional	2
N4	Geographic Location	Optional	1
G61	Contact	Optional	5
Loop LX	Assigned Number	Optional	>1
LX	Assigned Number	Mandatory	1
N9	Reference Identification	Optional	>1
G62	Date/Time	Optional	1
N1	Name	Optional	1
Loop LM	Code Source Information	Optional	10
LM	Code Source Information	Mandatory	1
LQ	Industry Code	Mandatory	100
Loop FA1	Type of Financial Accounting Data	Optional	>1
FA1	Type of Financial Accounting Data	Mandatory	1
FA2	Accounting Data	Mandatory	>1
SE	Transaction Set Trailer	Optional	1