Vendor Partnership Guide

EDI 810 (Invoice) Mapping

 

EDI 810 (Invoice) must contain a valid Bealls Outlet Purchase Order number in order to match the invoice for payment.

 

Bealls Outlet must receive a separate individual invoice for each store per Purchase Order.  Consolidated Invoices cannot be accepted at this time.  Purchase Orders should be billed in eaches (by UPC).

 

In the event that the vendor’s invoice errors out of the Bealls Outlet Accounts Payable system, Bealls Outlet will communicate via e-mail any failed invoice information for correction and re-transmission with a new invoice number (append a letter to the current invoice number or generate a new invoice number).

 

It is mandatory to list the correct Bill of Lading (BOL) number within the EDI transmission. With the correct information, invoices can be processed more swiftly and accurately.

 

Deviation from the below EDI 810 (Invoice) format may impact our ability to expedite payment in a timely fashion.

 

Note:  Functional Acknowledgments will be sent for all documents transmitted to Bealls Outlet by vendors

 

Header

SEG. ID

NAME

REQ. DES.

MAX USE

LOOP REPEAT

ST

Transaction Set Header

M

1

 

BIG

Beginning Segment for Invoice

M

1

 

REF

Reference Identification

M

1

 

LOOP ID – N1

4

N1

Name

M

1

 

N2

Additional Name Information

O

1

 

N3

Address Information

O

1

 

N4

Geographic Location

O

1

 

ITD

Terms of Sale/Deferred Terms of Sale

O

1

 

DTM

Date/Time Reference

O

2

 

FOB

F.O.B. Related Instructions

O

1

 

Detail

LOOP ID – IT1

9999

IT1

Baseline Item Data

M

1

 

LOOP ID – IT1/PID

3

PID

Product/Item Description

O

>1

 

Summary

TDS

Total Monetary Value Summary

M

>1

 

CAD

Carrier Detail

M

>1

 

LOOP ID – SAC

1

SAC

Service, Promotion, Allowance, or Charge Information

O

1

 

ISS

Invoice Shipment Summary

M

1

 

CTT

Transaction Totals

M

1

 

SE

Transaction Set Trailer

M

1

 

 


 

Header

STTRANSACTION SET HEADER Segment: ST Transaction Set Header

Usage: Mandatory

Max Use: 1

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

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

ST01

143

Transaction Set Identifier Code

Code uniquely identifying a Transaction Set

810 Invoice

M

ID

3/3

ST02

329

Transaction Set Control Number

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

M

AN

4/9

 

 

RXEQPORTING DATE/ACTION Segment: BIG Beginning Segment for Invoice

Usage: Mandatory

Max Use: 1

Purpose: To indicate the beginning of invoice transaction set and transmit identifying numbers and dates

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

BIG01

373

Invoice Date

Date expressed as CCYYMMDD

M

DT

8/8

BIG02

76

Invoice Number

Identifying number assigned by issuer

M

AN

1/10

BIG04

324

Purchase Order Number

Identifying number for Purchase Order assigned by Bealls, the original 7 character Purchase Order number that always starts with a zero

M

AN

7/7

BIG08

353

Transaction Set Purpose Code

Code identifying purpose of transaction set

00 Original

M

ID

2/2

 

 

RNE9FERENCE IDENTIFICATION Segment: REF Reference Identification

Usage: Mandatory

Max Use: 1

Purpose: To specify identifying information

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

REF01

128

Reference Identification Qualifier

Code qualifying the Reference Identification

DP Bealls Outlet assigned department number

M

ID

2/2

REF02

127

Reference Identification

Bealls Outlet assigned 3 character numeric department number

C

AN

3/6

 


RXEQPORTING DATE/ACTION Segment: N1 Name

Usage: Mandatory

Max Use: 1

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

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

N101

98

Entity Identifier Code

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

BY Buying Party, Bealls Outlet Store Number

SF Ship from

RI Remit-to

ST Ship to, Bealls Outlet DC

M

ID

2/3

N102

93

Name

Free-form name

O

AN

3/3

N103

66

Identification Code Qualifier

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

92 Assigned by Buyer, when N101 is BY or ST, or

1 DUNS#, when N101 is RI or SF

M

ID

2/2

N104

67

Identification Code

Code identifying a party or other code

115 Bealls Outlet DC ID, when N101 is ST or BY  

When N101 is SF, Vendor’s DUNS#

When N101 is RI and remit directly to the vendor, Vendor’s DUNS#; otherwise,  Bealls Outlet Factor Number for factor payment

M

AN

3/3

N106

98

Entity Identifier Code

Factor Code, for factor payments only

O4 Factor

O

ID

2/3

 

RXEQPORTING DATE/ACTION Segment: N2 Additional Name Information

Usage: Optional

Max Use: 1

Purpose: To specify additional names or those longer than 35 characters in length

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

N201

93

Name

M

AN

1/30

N202

93

Name

O

AN

1/30

 

RXEQPORTING DATE/ACTION Segment: N3 Address Information

Usage: Optional

Max Use: 1

Purpose: To specify the location of the named party

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

N301

166

Address Information

M

ID

1/30

N302

166

Address Information

O

ID

1/30

 

RXEQPORTING DATE/ACTION Segment: N4 Name

Usage: Optional

Max Use: 1

Purpose: To specify the geographic place of the named party

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

N401

19

City Name

O

AN

2/30

N402

156

State or Province Code

O

ID

2/2

N403

116

Postal Code

O

ID

3/15

N404

26

Country Code

M

ID

2/3


 

RXEQPORTING DATE/ACTION Segment: ITD Terms of Sale/Deferred Terms of Sale

Usage: Mandatory

Max Use: 1

Purpose: To specify terms of sale

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

ITD01

336

Terms Type Code

Code identifying type of payment terms

14 Previously agreed upon

M

ID

2/2

ITD02

333

Terms Basis Date Code

Code identifying the beginning of the terms period

3 Invoice Date

15 Receipt of Goods

O

ID

1/2

ITD12

373

Description

A free-form description to clarify the related data elements and their content

O

AN

1/80

ITD14

107

Payment Method Code

A free-form description to clarify the related data elements and their content

C Pay by Check

L Letter of Credit

T Wire Transfer

O

ID

1/2

 

 

RXEQPORTING DATE/ACTION Segment: DTM Date/Time Reference

Usage: Optional

Max Use: 2

Purpose: To specify pertinent dates and times

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

DTM01

374

Date/Time Qualifier

Code specifying type of date

001 Cancel After

010 Requested Ship

M

ID

3/3

DTM02

373

Date

Date expressed as CCYYMMDD, Bealls requested ship / cancel date

C

DT

8/8

 

 

RNE9FERENCE IDENTIFICATION Segment: FOB F.O.B Related Instructions

Usage: Optional

Max Use: 1

Purpose: To specify transportation instructions relating to shipment

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

FOB01

146

Shipment Method of Payment

Code identifying payment terms for transportation charges

CC Collect

DF Defined by Bealls Outlet and Vendor

PP Prepaid by Vendor

M

ID

2/2

FOB02

309

Location Qualifier

Code identifying type of location

DE Destination

FA Factory

C

ID

2/2

 


 

Detail

ILTINEM IDENTIFICATION Segment: IT1 Baseline Item Data

Usage: Mandatory

Purpose: To specify basic and most frequently used line item data

105 Notes: Items must be billed in eaches by UPC.

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

IT102

358

Quantity Invoiced

Quantity ordered as a whole number only, decimal values will not post to Bealls Outlet A/P system

M

N0

1/15

IT103

355

Unit or Basis for Measurement Code

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

EA Each

M

ID

2/2

IT104

212

Unit Price

Cost per unit of product when the SLN is not sent; when the SLN is sent the cost is in the SLN06

C

R

1/17

IT106

235

Product/Service ID Qualifier

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

UP UPC (1-5-5-1)

C

ID

2/2

IT107

234

Product/Service ID

UPC or Vendor Style Number

C

AN

1/12

 

 

RXEQPORTING DATE/ACTION Segment: PID Product/Item Description

Usage: Optional

Max Use: 3

Purpose: To describe a product in free-form format

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

PID01

349

Item Description Type

Code indicating the format of a description

F Free-form

M

ID

1/1

PID02

750

Product/Process Characteristic Code

Code identifying the general class of a product or process characteristic

08 Product description, or for Bealls Outlet Import orders, packing requirement, item description, and label description

73 Vendor color description

74 Vendor size description

M

ID

2/2

PID05

352

Description

A free-form description to clarify the related data elements and their content

M

AN

1/80

 

 


 

Summary

RXEQPORTING DATE/ACTION Segment: TDS Total Monetary Value Summary

Usage: Mandatory

Max Use: 1

Purpose: To specify the total invoice amount

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

TDS01

610

Amount

Total invoice amount

M

N2

1/15

 

 

RXEQPORTING DATE/ACTION Segment: CAD Carrier Detail

Usage: Mandatory

Max Use: 1

Purpose: To specify transportation details for the transaction set

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

CAD04

140

SCAC

M

ID

2/4

CAD05

387

Routing

Free form description of routing

M

AN

1/35

CAD07

128

Reference Identification Qualifier

Code qualifying the Reference Identification

BM Bill of Lading Number

M

ID

2/3

CAD08

127

Reference Identification

Bill of Lading Number

M

ID

2/30

 

 

RNE9FERENCE IDENTIFICATION Segment: SAC Service, Promotion, Allowance, or Charge Information

Usage: Optional

Max Use: 1

Purpose: To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

SAC01

248

Allowance or Charge Indicator

Code which indicates an allowance or charge for the service specified

C Charge

M

ID

1/1

SAC02

1300

Service, Promotion, Allowance, or Charge Code

Code identifying the service, promotion, allowance, or charge

D240 Freight (discount off cost), or Prepaid Freight

Any other charges sent will be applied as miscellaneous

M

ID

4/4

SAC05

610

Amount

Monetary amount

M

N2

1/15

SAC12

331

Allowance or Charge Method of Handling Code

Code indicating method of handling for an allowance or charge

02 Off Invoice

O

ID

2/2

SAC15

352

Description

A free-form description to clarify the related data elements and their content

O

AN

1/80

 


 

RXEQPORTING DATE/ACTION Segment: ISS Invoice Shipment Summary

Usage: Mandatory

Max Use: 1

Purpose: To specify summary details of total items shipped in terms of quantity

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

ISS01

382

Number of Units Shipped

Total units shipped

M

N0

1/15

ISS02

355

Unit or Basis for Measurement Code

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

EA Each

M

ID

2/2

 

 

RXEQPORTING DATE/ACTION Segment: CTT Transaction Totals

Usage: Mandatory

Max Use: 1

Purpose: To transmit a hash total for a specific element in the transaction set

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

CTT01

354

Number of Line Items

Total number of line items in the transaction set

   The number of IT1 segments present in the transaction set

M

ID

1/1

 

 

STERANSACTION SET TRAILER Segment: SE Transaction Set Trailer

Usage: Mandatory

Max Use: 1

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

Data Element Summary

REF. DES.

DATA ELEMENT

NAME

ATTRIBUTES

SE01

96

Number of Included Segments

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

M

N0

1/10

SE02

329

Transaction Set Control Number

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

9 This will be the same number as is in the ST segment (ST02) for the transaction set.

M

AN

4/9