Debit Adjustment UCS & X12

08/26/2010 Credit/Debit Adjustment - 812 812 Credit/Debit Adjustment 005010 UCS & X12 CD Functional Group= Heading: Pos 0200 Id BCD 0400 N9 05...
Author: Ronald Bryan
12 downloads 4 Views 307KB Size
08/26/2010 Credit/Debit Adjustment - 812

812

Credit/Debit Adjustment 005010 UCS & X12

CD

Functional Group= Heading: Pos 0200

Id BCD

0400

N9

0500

PER

0700 DTM LOOP ID - N1 1000 N1 1200 N3 1300 N4

Segment Name Beginning Credit/Debit Adjustment Extended Reference Information Administrative Communications Contact Date/Time Reference

Req M

Max Use 1

Repeat

Notes N1/020

Usage Must use

O

>1

Used

O

>1

Used

O

>1

Used 200

Party Identification Party Location Geographic Location

M O O

1 2 1

Must use Used Used

Req

Max Use

O

1

Used

O O

1 >1

Used Used

Detail: Id Segment Name Pos LOOP ID - CDD 1600 CDD Credit/Debit Adjustment Detail 1700 LIN Item Identification 2000 N9 Extended Reference Information

1

Repeat >1

Notes

Usage

08/26/2010

Credit/Debit Adjustment - 812

BCD Beginning Credit/Debit

Pos: 0200 Max: 1 Heading - Mandatory Loop: N/A Elements: 14

Adjustment

User Option (Usage): Must use

Element Summary: Ref BCD01

Id 373

BCD02

475

BCD03

305

BCD04 BCD05

610 478

Element Name Req Type Date M DT BCD01 is the date assigned by the issuer of the credit or debit memo Credit/Debit Adjustment Number M AN BCD02 is number assigned by the issuer of the credit or debit memo. We will use “0”. Transaction Handling Code M ID Code Name B Debit/Credit Advice No Remittance Detail Amount M N2 Credit/Debit Flag Code M ID

BCD06

373

All valid standard codes are used. Date

O

BCD07 BCD08 BCD09

76 424 373

BCD06 should contain the date of the invoice. Invoice Number X Vendor Order Number O Date O

BCD10 BCD11 BCD12 BCD13

324 353 640 128

BCD09 should contain the date of the purchase order. Purchase Order Number Transaction Set Purpose Code Transaction Type Code Reference Identification Qualifier Code Name BT Batch Number

BCD14

127

Reference Identification

N9

Min/Max 8/8

Usage Must use

1/22

Must use

1/2

Must use

1/15 1/1

Must use Must use

DT

8/8

Must use

AN AN DT

1/22 1/22 8/8

Must use Must use Must use

X O O X

AN ID ID ID

1/22 2/2 2/2 2/3

Must use Used Used Used

X

AN

1/30

Used

Extended Reference Information

Pos: 0400 Max: >1 Heading - Optional Loop: N/A Elements: 3

User Option (Usage): Used

Element Summary: Ref N901

Id 128

Element Name Req Type Reference Identification Qualifier M ID Code Name 82 Data Item Description (DID) Reference CT TradePoint Contract Number ST Store Number

N902 N903

127 369

Reference Identification Free-form Description Note: This segment is used only when some unique internal number is required for tracking or problem resolution. 2

X X

AN AN

Min/Max 2/3

Usage Must use

1/30 1/45

Used Used

08/26/2010

Credit/Debit Adjustment - 812

Administrative Communications Contact

PER

Pos: 0500 Max: >1 Heading - Optional Loop: N/A Elements: 4

User Option (Usage): Used

Element Summary: Ref PER01

Id 366

Element Name Contact Function Code Name Code AD Accounting Department

PER02

93

Name

PER03

365

PER04

364

RASC – Regional Account Service Center Communication Number Qualifier Code Name TE Telephone Communication Number

Req M

Type ID

Min/Max 2/2

Usage Must use

O

AN

1/60

Used

X

ID

2/2

Used

X

AN

1/256

Used

PH: 615-232-9500 Pos: 0700 Max: >1 Heading - Optional Loop: N/A Elements: 2

DTM Date/Time Reference User Option (Usage): Used

Element Summary: Ref DTM01

Id 374

Element Name Date/Time Qualifier Name Code 015 Promotion Start 016 Promotion End

DTM02

373

Date

Req M

Type ID

Min/Max 3/3

Usage Must use

X

DT

8/8

Used

Pos: 1000 Max: 1 Heading - Mandatory Loop: N1 Elements: 4

Party Identification

N1

User Option (Usage): Must use

Element Summary: Ref N101

Id 98

Element Name Entity Identifier Code Code Name BY Buying Party (Purchaser) RL Reporting Location VN Vendor

N102

93

Name

66

BY = Kroger KMA/DIV VN = Vendor Name RL = Contains Kroger Div & Or warehouse & Account # Identification Code Qualifier X ID 1/2 Name Code 1 D-U-N-S Number, Dun & Bradstreet 9 D-U-N-S+4, D-U-N-S Number with Four Character Suffix

N103

3

Req M

Type ID

Min/Max 2/3

Usage Must use

X

AN

1/60

Must use

Must use

08/26/2010

Credit/Debit Adjustment - 812

N104

Identification Code

67

X

AN

2/80

Used

KMA/DIV Duns + Suffix Vendor Number

N3

Pos: 1200 Max: 2 Heading - Optional Loop: N1 Elements: 2

Party Location

User Option (Usage): Used

Element Summary: Ref N301 N302

Id 166 166

Element Name Address Information Address Information

Req M O

Type AN AN

Min/Max 1/55 1/55

Usage Must use Used

This segment is normally not used in this transaction

N4

Pos: 1300 Max: 1 Heading - Optional Loop: N1 Elements: 3

Geographic Location

User Option (Usage): Used

Element Summary: Ref N401 N402 N403

Id 19 156 116

Element Name City Name State or Province Code Postal Code

Req O X O

Type AN ID ID

Min/Max 2/30 2/2 3/15

Usage Used Used Used

This segment is normally not used in this transaction

CDD Credit/Debit Adjustment

Pos: 1600 Max: 1 Detail - Optional Loop: CDD Elements: 10

Detail

User Option (Usage): Used

Element Summary: Ref CDD01 CDD02 CDD03 CDD04 CDD07 CDD08 CDD10

Id 426 478 350 610 477 355 236

Element Name Adjustment Reason Code Credit/Debit Flag Code Assigned Identification Amount Credit/Debit Quantity Unit or Basis for Measurement Code Price Identifier Code Name Code UCP Unit cost price

CDD11 CDD12

212 236

CDD13

212

Req M M O X X X X

Type ID ID AN N2 R ID ID

Min/Max 2/2 1/1 1/20 1/15 1/10 2/2 3/3

Usage Must use Must use Used Used Used Used Used

Unit Price Price Identifier Code Name Code UCP Unit cost price

X X

R ID

1/17 3/3

Used Used

Unit Price Receiver Price #

X

R

1/17

Used

4

08/26/2010

Credit/Debit Adjustment - 812

LIN

Pos: 1700 Max: 1 Detail - Optional Loop: CDD Elements: 5

Item Identification

User Option (Usage): Used

Element Summary: Ref LIN01 LIN02

Id 350 235

Element Name Assigned Identification Product/Service ID Qualifier Name Code

IN UA UK

Req O M

Type AN ID

Min/Max 1/20 2/2

Usage Used Must use

Buyer's Item Number U.P.C. Case Code (2-5-5 format) GTIN 14-digit Data Structure

LIN03

234

Product/Service ID

M

AN

1/48

Must use.

LIN04

235

Product/Service ID Qualifier Code Name

X

ID

2/2

Used

LIN05

234

X

AN

1/48

Used

IN

Buyer's Item Number

Product/Service ID Internal Line #

N9

Extended Reference Information

Pos: 2000 Max: >1 Detail - Optional Loop: CDD Elements: 3

User Option (Usage): Used

Element Summary: Ref N901

Id 128

Element Name Reference Identification Qualifier Code Name LI Line Item Identifier (Seller's) PD Promotion/Deal Number ST Store Number

N902 N903

127 369

Reference Identification Free-form Description

5

Req M

Type ID

Min/Max 2/3

Usage Must use

X X

AN AN

1/30 1/45

Used Used

08/26/2010

Credit/Debit Adjustment - 812

DATA SAMPLE SAMPLE with ALL ITEMS Converted to GTINs ST*812*59905001~ BCD*20100825*0*B*210000*C*20100803*0953229928*016730*20100726*71002***BT*010237~ PER*AD*RASC*TE*615-232-9500~ N1*BY*RALPHS*9*0381769211000~ N1*VN* Your Company *1*016730~ N3*FILE 54530~ N4*LOS ANGELES*CA*900744530~ CDD*02*C*12066*64800***180*CA**UCP*3.6~ LIN**UK*10021000340799*IN*54575~ N9*LI**NSQK CHOCOLATE MILK~ CDD*02*C*12066*129600***360*CA**UCP*3.6~ LIN**UK*00021000778699*IN*54597~ N9*LI**NSQK STRAWBERRY MILK~ CDD*02*C*11629*15600***65*CA**UCP*2.4~ LIN**UK*20043000180629*IN*23931~ N9*LI**NSQK CHOC MILK 100 CAL~ SE*17*59905001~ SAMPLE with NO ITEMS Converted to GTINs CDD*02*C*12066*64800***180*CA**UCP*3.6~ LIN**UA*002100034079*IN*54575~ N9*LI**NSQK CHOCOLATE MILK~ CDD*02*C*12066*129600***360*CA**UCP*3.6~ LIN**UA*002100077869*IN*54597~ N9*LI**NSQK STRAWBERRY MILK~ CDD*02*C*11629*15600***65*CA**UCP*2.4~ LIN**UA*004300018062*IN*23931~ N9*LI**NSQK CHOC MILK 100 CAL~ SAMPLE with SOME ITEMS Converted to GTINs Manufacturer ID 21000 has been converted Manufacturer ID 43000 has NOT been converted CDD*02*C*12066*64800***180*CA**UCP*3.6~ LIN**UK*10021000340799*IN*54575~ N9*LI**NSQK CHOCOLATE MILK~ CDD*02*C*12066*129600***360*CA**UCP*3.6~ LIN**UK*00021000778699*IN*54597~ N9*LI**NSQK STRAWBERRY MILK~ CDD*02*C*11629*15600***65*CA**UCP*2.4~ LIN**UA*004300018062*IN*23931~

6