Wayfair LLC X12 947 Warehouse Inventory Adjustment Advice

Wayfair

3 schema elements found

This Draft Standard schema for Trial Use contains the format and data contents of the schema for use within the context of an Electronic Data Interchange (EDI) environment.

ISA

ISA

Interchange Control Header

MMax: 1

To start and identify an interchange of zero or more functional groups and interchange-related control segments

ISA01
Authorization Information Qualifier
MIDMIN 2 MAX 2ID: I01

Code identifying the type of information in the Authorization Information

ISA02
Authorization Information
MANMIN 10 MAX 10ID: I02

Information used for additional identification or authorization of the interchange sender or the data in the interchange; the type of information is set by the Authorization Information Qualifier (I01)

ISA03
Security Information Qualifier
MIDMIN 2 MAX 2ID: I03

Code identifying the type of information in the Security Information

ISA04
Security Information
MANMIN 10 MAX 10ID: I04

This is used for identifying the security information about the interchange sender or the data in the interchange; the type of information is set by the Security Information Qualifier (I03)

ISA05
Interchange ID Qualifier
MIDMIN 2 MAX 2ID: I05

Code indicating the system/method of code structure used to designate the sender or receiver ID element being qualified

ISA06
Interchange Sender ID
MANMIN 15 MAX 15ID: I06

Identification code published by the sender for other parties to use as the receiver ID to route data to them; the sender always codes this value in the sender ID element

ISA07
Interchange ID Qualifier
MIDMIN 2 MAX 2ID: I05

Code indicating the system/method of code structure used to designate the sender or receiver ID element being qualified

ISA08
Interchange Receiver ID
MANMIN 15 MAX 15ID: I07

Identification code published by the receiver of the data; When sending, it is used by the sender as their sending ID, thus other parties sending to them will use this as a receiving ID to route data to them

ISA09
Interchange Date
MDTMIN 6 MAX 6ID: I08

Date of the interchange

ISA10
Interchange Time
MTMMIN 4 MAX 4ID: I09

Time of the interchange

ISA11
Repetition Separator
MMIN 1 MAX 1ID: I65

Type is not applicable; the repetition separator is a delimiter and not a data element; this field provides the delimiter used to separate repeated occurrences of a simple data element or a composite data structure; this value must be different than the data element separator, component element separator, and the segment terminator

ISA12
Interchange Control Version Number
MIDMIN 5 MAX 5ID: I11

Code specifying the version number of the interchange control segments

ISA13
Interchange Control Number
MN0MIN 9 MAX 9ID: I12

A control number assigned by the interchange sender

ISA14
Acknowledgment Requested
MIDMIN 1 MAX 1ID: I13

Code indicating sender's request for an interchange acknowledgment

ISA15
Usage Indicator
MIDMIN 1 MAX 1ID: I14

Code indicating whether data enclosed by this interchange envelope is test, production or information

ISA16
Component Element Separator
MMIN 1 MAX 1ID: I15

Type is not applicable; the component element separator is a delimiter and not a data element; this field provides the delimiter used to separate component data elements within a composite data structure; this value must be different than the data element separator and the segment terminator

GS

GS

Functional Group Header

MMax: 1

To indicate the beginning of a functional group and to provide control information

GS01
Functional Identifier Code
MIDMIN 2 MAX 2ID: 479

Code identifying a group of application related transaction sets

GS02
Application Sender's Code
MANMIN 2 MAX 15ID: 142

Code identifying party sending transmission; codes agreed to by trading partners

GS03
Application Receiver's Code
MANMIN 2 MAX 15ID: 124

Code identifying party receiving transmission; codes agreed to by trading partners

GS04
Date
MDTMIN 8 MAX 8ID: 373

Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year

GS05
Time
MTMMIN 4 MAX 8ID: 337

Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)

GS06
Group Control Number
MN0MIN 1 MAX 9ID: 28

Assigned number originated and maintained by the sender

GS07
Responsible Agency Code
MIDMIN 1 MAX 2ID: 455

Code identifying the issuer of the standard; this code is used in conjunction with Data Element 480

GS08
Version / Release / Industry Identifier Code
MANMIN 1 MAX 12ID: 480

Code indicating the version, release, subrelease, and industry identifier of the EDI standard being used, including the GS and GE segments; if code in DE455 in GS segment is X, then in DE 480 positions 1-3 are the version number; positions 4-6 are the release and subrelease, level of the version; and positions 7-12 are the industry or trade association identifiers (optionally assigned by user); if code in DE455 in GS segment is T, then other formats are allowed

transactionSets

Loop: transactionSets

ST

Transaction Set Header

MMax: 1Area: 1Seq: 0100

To indicate the start of a transaction set and to assign a control number

ST01
Transaction Set Identifier Code
MIDMIN 3 MAX 3ID: 143

Code uniquely identifying a Transaction Set

947Warehouse Inventory Adjustment Advice
ST02
Transaction Set Control Number
MANMIN 4 MAX 9ID: 329

Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set

W15

Warehouse Adjustment Identification

MMax: 1Area: 1Seq: 0200

To provide identifying numbers and dates and other basic data for this transaction set

W1501
Date
MDTMIN 8 MAX 8ID: 373

Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year

W1502
Adjustment Number
CANMIN 1 MAX 22ID: 31

Identification assigned to an inventory level or status adjustment

W1503
Adjustment Number
CANMIN 1 MAX 22ID: 31

Identification assigned to an inventory level or status adjustment

947Inventory Adjustment
W1504
Transaction Set Purpose Code
OIDMIN 2 MAX 2ID: 353

Code identifying purpose of transaction set

04Change

Loop: N1_loop

Repeat: 100
N1

Name

MMax: 1Area: 1Seq: 0400

To identify a party by type of organization, name, and code

N101
Entity Identifier Code
MIDMIN 2 MAX 3ID: 98

Code identifying an organizational entity, a physical location, property or an individual

DEDepositor
N102
Name
CANMIN 1 MAX 60ID: 93

Free-form name

N103
Identification Code Qualifier
CIDMIN 1 MAX 2ID: 66

Code designating the system/method of code structure used for Identification Code (67)

ZZMutually Defined
N104
Identification Code
CANMIN 2 MAX 80ID: 67

Code identifying a party or other code

Loop: W19_loop

Repeat: >1
W19

Warehouse Adjustment Item Detail

MMax: 1Area: 2Seq: 0200

To designate those items that were adjusted

W1901
Quantity or Status Adjustment Reason Code
MIDMIN 2 MAX 2ID: 181

Code indicating reason for change in level or status of inventory

AAPHYSICAL COUNT (CYCLE COUNT)
AUDamaged in Transit
AVDamaged in Facility
AKTransfer (Back to FC)
AHOther
AERe-Identification
BRRegrade
BDNon-Recoverable
BKOff Specification
CDProduct Donations
05On Hold (Photo Studio)
55Product Taken Off Hold
52Recoup/Rework of Damaged Inventory
04Receipt Less than Previously Reported
54Receipt Greater than Previously Reported
53Shipment Less than Previously Reported
03Shipment Greater than Previously Reported
W1902
Credit/Debit Quantity
MRMIN 1 MAX 10ID: 477

Number of supplier units credited or debited

W1903
Unit or Basis for Measurement Code
MIDMIN 2 MAX 2ID: 355

Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

EAEach
W1905
Product/Service ID Qualifier
CIDMIN 2 MAX 2ID: 235

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

VNVendor Number
W1906
Product/Service ID
CANMIN 1 MAX 48ID: 234

Identifying number for a product or service

G69

Line Item Detail - Description

OMax: 5Area: 2Seq: 0300

To describe an item in free-form format

G6901
Free-form Description
MANMIN 1 MAX 45ID: 369

Free-form descriptive text

N9

Reference Identification

OMax: 10Area: 2Seq: 0400

To transmit identifying information as specified by the Reference Identification Qualifier

N901
Reference Identification Qualifier
MIDMIN 2 MAX 3ID: 128

Code qualifying the Reference Identification

COCustomer Order Number
7BPurchase Order Number of Shipment Received since Last Reporting Date
ZZMutually Defined
N902
Reference Identification
CANMIN 1 MAX 50ID: 127

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

AMT

Monetary Amount

OMax: 1Area: 2Seq: 0700

To indicate the total monetary amount

AMT01
Amount Qualifier Code
MIDMIN 1 MAX 3ID: 522

Code to qualify amount

GXTotal Credit
AMT02
Monetary Amount
MRMIN 1 MAX 18ID: 782

Monetary amount

SE

Transaction Set Trailer

MMax: 1Area: 2Seq: 2100

To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)

SE01
Number of Included Segments
MN0MIN 1 MAX 10ID: 96

Total number of segments included in a transaction set including ST and SE segments

SE02
Transaction Set Control Number
MANMIN 4 MAX 9ID: 329

Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set