X12 947 Warehouse Inventory Adjustment Advice

Warehouse Adjustment Identification

Functional Group Header

Transaction Set Header

Warehouse Adjustment Item Detail

Extended Reference Information

0400

Transaction Set Line Number

Extended Reference Information

1600

Optional

2100

Transaction Set Trailer

Functional Group Trailer

Interchange Control Trailer

IEA

ISA

Interchange Control Header

RequiredMax use 1

—

Example

ISA-01

I01

Authorization Information Qualifier

Required

Identifier (ID)

—

00: No Authorization Information Present (No Meaningful Information in I02)

ISA-02

I02

Authorization Information

Required

String (AN)

Min 10Max 10

—

ISA-03

I03

Security Information Qualifier

Required

Identifier (ID)

—

00: No Security Information Present (No Meaningful Information in I04)

ISA-04

I04

Security Information

Required

String (AN)

Min 10Max 10

—

ISA-05

I05

Interchange ID Qualifier

Required

Identifier (ID)

Min 2Max 2

—

Codes

01: Duns (Dun & Bradstreet)
02: SCAC (Standard Carrier Alpha Code)
03: FMC (Federal Maritime Commission)
04: IATA (International Air Transport Association)
07: Global Location Number (GLN)
08: UCC EDI Communications ID (Comm ID)
09: X.121 (CCITT)
10: Department of Defense (DoD) Activity Address Code
11: DEA (Drug Enforcement Administration)
12: Phone (Telephone Companies)
13: UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code)
14: Duns Plus Suffix
15: Petroleum Accountants Society of Canada Company Code
16: Duns Number With 4-Character Suffix
17: American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit)
18: Association of American Railroads (AAR) Standard Distribution Code
19: EDI Council of Australia (EDICA) Communications ID Number (COMM ID)
20: Health Industry Number (HIN)
21: Integrated Postsecondary Education Data System, or (IPEDS)
22: Federal Interagency Commission on Education, or FICE
23: National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES
24: The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP
25: ACT, Inc. 4-Digit Code of Postsecondary Institutions.
26: Statistics of Canada List of Postsecondary Institutions
27: Carrier Identification Number as assigned by Health Care Financing Administration (HCFA)
28: Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA)
29: Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA)
30: U.S. Federal Tax Identification Number
31: Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC)
32: U.S. Federal Employer Identification Number (FEIN)
33: National Association of Insurance Commissioners Company Code (NAIC)
34: Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA)
35: Statistics Canada Canadian College Student Information System Institution Codes
36: Statistics Canada University Student Information System Institution Codes
37: Society of Property Information Compilers and Analysts
38: The College Board and ACT, Inc. 6-Digit Code List of Secondary Institutions
AM: Association Mexicana del Codigo de Producto (AMECOP) Communication ID
NR: National Retail Merchants Association (NRMA) - Assigned
SA: User Identification Number as assigned by the Safety and Fitness Electronic Records (SAFER) System
SN: Standard Address Number
ZZ: Mutually Defined

ISA-06

I06

Interchange Sender ID

Required

String (AN)

Min 15Max 15

—

ISA-07

I05

Interchange ID Qualifier

Required

Identifier (ID)

Min 2Max 2

—

Codes

01: Duns (Dun & Bradstreet)
02: SCAC (Standard Carrier Alpha Code)
03: FMC (Federal Maritime Commission)
04: IATA (International Air Transport Association)
07: Global Location Number (GLN)
08: UCC EDI Communications ID (Comm ID)
09: X.121 (CCITT)
10: Department of Defense (DoD) Activity Address Code
11: DEA (Drug Enforcement Administration)
12: Phone (Telephone Companies)
13: UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code)
14: Duns Plus Suffix
15: Petroleum Accountants Society of Canada Company Code
16: Duns Number With 4-Character Suffix
17: American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit)
18: Association of American Railroads (AAR) Standard Distribution Code
19: EDI Council of Australia (EDICA) Communications ID Number (COMM ID)
20: Health Industry Number (HIN)
21: Integrated Postsecondary Education Data System, or (IPEDS)
22: Federal Interagency Commission on Education, or FICE
23: National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES
24: The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP
25: ACT, Inc. 4-Digit Code of Postsecondary Institutions.
26: Statistics of Canada List of Postsecondary Institutions
27: Carrier Identification Number as assigned by Health Care Financing Administration (HCFA)
28: Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA)
29: Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA)
30: U.S. Federal Tax Identification Number
31: Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC)
32: U.S. Federal Employer Identification Number (FEIN)
33: National Association of Insurance Commissioners Company Code (NAIC)
34: Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA)
35: Statistics Canada Canadian College Student Information System Institution Codes
36: Statistics Canada University Student Information System Institution Codes
37: Society of Property Information Compilers and Analysts
38: The College Board and ACT, Inc. 6-Digit Code List of Secondary Institutions
AM: Association Mexicana del Codigo de Producto (AMECOP) Communication ID
NR: National Retail Merchants Association (NRMA) - Assigned
SA: User Identification Number as assigned by the Safety and Fitness Electronic Records (SAFER) System
SN: Standard Address Number
ZZ: Mutually Defined

ISA-08

I07

Interchange Receiver ID

Required

String (AN)

Min 15Max 15

—

ISA-09

I08

Interchange Date

Required

Date (DT)

YYMMDD format

—

ISA-10

I09

Interchange Time

Required

Time (TM)

HHMM format

—

ISA-11

I65

Repetition Separator

Required

String (AN)

Min 1Max 1

—

^: Repetition Separator

ISA-12

I11

Interchange Control Version Number

Required

Identifier (ID)

—

00501: Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003

ISA-13

I12

Interchange Control Number

Required

Numeric (N0)

Min 9Max 9

—

ISA-14

I13

Acknowledgment Requested

Required

Identifier (ID)

Min 1Max 1

—

0: No Interchange Acknowledgment Requested
1: Interchange Acknowledgment Requested (TA1)

ISA-15

I14

Interchange Usage Indicator

Required

Identifier (ID)

Min 1Max 1

—

I: Information
P: Production Data
T: Test Data

ISA-16

I15

Component Element Separator

Required

String (AN)

Min 1Max 1

—

>: Component Element Separator

Functional Group Header

RequiredMax use 1

—

Example

GS-01

479

Functional Identifier Code

Required

Identifier (ID)

—

AW: Warehouse Inventory Adjustment Advice (947)

GS-02

142

Application Sender's Code

Required

String (AN)

Min 2Max 15

—

GS-03

124

Application Receiver's Code

Required

String (AN)

Min 2Max 15

—

GS-04

Date

Required

Date (DT)

CCYYMMDD format

—

GS-05

337

Time

Required

Time (TM)

HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format

—

GS-06

Group Control Number

Required

Numeric (N0)

Min 1Max 9

—

GS-07

455

Responsible Agency Code

Required

Identifier (ID)

Min 1Max 2

—

T: Transportation Data Coordinating Committee (TDCC)
X: Accredited Standards Committee X12

GS-08

480

Version / Release / Industry Identifier Code

Required

String (AN)

—

005010: Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003

Heading

0100

Heading > ST

Transaction Set Header

RequiredMax use 1

—

Example

ST-01

143

Transaction Set Identifier Code

Required

Identifier (ID)

—

947: Warehouse Inventory Adjustment Advice

ST-02

329

Transaction Set Control Number

Required

Numeric (N)

Min 4Max 9

—

W15

0200

Heading > W15

Warehouse Adjustment Identification

RequiredMax use 1

—

Example

At least one of Adjustment Number (W15-02) or Adjustment Number (W15-03) is required

W15-01

Date

Required

Date (DT)

CCYYMMDD format

—

W15-02

Adjustment Number

Optional

String (AN)

Min 1Max 22

—

W15-03

Adjustment Number

Optional

String (AN)

Min 1Max 22

—

0100 Loop

RequiredMax >1

0400

Heading > 0100 Loop > N1

Party Identification

RequiredMax use 1

—

Example

At least one of Name (N1-02) or Identification Code Qualifier (N1-03) is required

If either Identification Code Qualifier (N1-03) or Identification Code (N1-04) is present, then the other is required

N1-01

Entity Identifier Code

Required

Identifier (ID)

—

WH: Warehouse

N1-02

Name

Optional

String (AN)

Min 1Max 60

—

N1-03

Identification Code Qualifier

Optional

Identifier (ID)

—

54: Warehouse

N1-04

Identification Code

Optional

String (AN)

Min 2Max 80

—

0100 Loop end

G62

1100

Heading > G62

Date/Time

OptionalMax use 5

—

Example

If either Date Qualifier (G62-01) or Date (G62-02) is present, then the other is required

At least one of Date Qualifier (G62-01) or Time Qualifier (G62-03) is required

If either Time Qualifier (G62-03) or Time (G62-04) is present, then the other is required

G62-01

432

Date Qualifier

Optional

Identifier (ID)

—

AB: Warehouse Inventory Stock

G62-02

Date

Optional

Date (DT)

CCYYMMDD format

—

G62-03

176

Time Qualifier

Optional

Identifier (ID)

—

W: Effective Time

G62-04

337

Time

Optional

Time (TM)

HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format

—

Heading end

Detail

0300 Loop

RequiredMax >1

W19

0200

Detail > 0300 Loop > W19

Warehouse Adjustment Item Detail

RequiredMax use 1

—

Example

At least one of U.P.C. Case Code (W19-04) or Product/Service ID Qualifier (W19-05) is required

If either Product/Service ID Qualifier (W19-05) or Product/Service ID (W19-06) is present, then the other is required

If either Product/Service ID Qualifier (W19-07) or Product/Service ID (W19-08) is present, then the other is required

W19-01

181

Quantity or Status Adjustment Reason Code

Required

Identifier (ID)

—

06: Book Adjustment Decrease
56: Book Adjustment Increase
AC: Condition Change
—

W19-02

477

Credit/Debit Quantity

Required

Decimal number (R)

Min 1Max 10

—

W19-03

355

Unit or Basis for Measurement Code

Required

Identifier (ID)

Min 2Max 2

—

W19-04

438

U.P.C. Case Code

Optional

String (AN)

Min 12Max 12

—

W19-05

235

Product/Service ID Qualifier

Optional

Identifier (ID)

Min 2Max 2

—

W19-06

234

Product/Service ID

Optional

String (AN)

Min 1Max 48

—

W19-07

235

Product/Service ID Qualifier

Optional

Identifier (ID)

Min 2Max 2

—

W19-08

234

Product/Service ID

Optional

String (AN)

Min 1Max 48

—

0400

Detail > 0300 Loop > N9

Extended Reference Information

OptionalMax use 10

—

Example

At least one of Reference Identification (N9-02) or Free-form Description (N9-03) is required

N9-01

128

Reference Identification Qualifier

Required

Identifier (ID)

Min 2Max 3

—

N9-02

127

Reference Identification

Optional

String (AN)

Min 1Max 50

—

N9-03

369

Free-form Description

Optional

String (AN)

Min 1Max 45

—

G62

0800

Detail > 0300 Loop > G62

Date/Time

OptionalMax use 10

—

Example

If either Date Qualifier (G62-01) or Date (G62-02) is present, then the other is required

G62-01

432

Date Qualifier

Optional

Identifier (ID)

—

36: Expiration Date

G62-02