• No results found

810 - Invoice. Set Number Set Name - Invoice Functional Group - IN

N/A
N/A
Protected

Academic year: 2021

Share "810 - Invoice. Set Number Set Name - Invoice Functional Group - IN"

Copied!
29
0
0

Loading.... (view fulltext now)

Full text

(1)
(2)

07/10/14 Page 2

810 - Invoice

 Set Number - 810

 Set Name - Invoice

 Functional Group - IN

This standard contains the format and establishes the data contents of the Invoice Transaction Set (810) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide for customary and established business and industry practice relative to the billing for goods and services provided.

(3)

07/10/14 Page 3

810 - Invoice Segments

Pos Seg Name Req Max Loop

Header Level

010 ISA Transmission Control Header M 1

020 GS Functional Group Header M 1

030 ST Transaction Set Header M 1 040 BIG Beginning Segment for Invoice M 1 050 CUR Currency R 1 LOOP ID-N1 Loop Repeat-200

060 N1 Name R 1 070 N2 Additional Name Information O 1 080 N3 Address Information R 1 090 N4 Geographic Location R 1 100 REF Reference Numbers R 1

110 ITD Terms of Sale/Deferred Terms of Sale R 5 Item Level

LOOP ID-IT1 Loop Repeat-200000

120 IT1 Baseline Item Data (Invoice) M 1 130 TXI Tax Information M 10 LOOP ID-PID Loop Repeat-0

140 PID Product/Item Description O 1 150 REF Reference Numbers M 2 LOOP ID-SAC Loop Repeat-25

160 SAC Service, Promotion, Allowance, or Charge Information

O 1 Summary Level

170 TDS Total Monetary Value Summary M 1 180 TXI Tax Information M 10

190 AMT Monetary Amount M 3

LOOP ID-SAC Loop Repeat-25 200 SAC Service, Promotion, Allowance, or Charge

Information

O 1 210 CTT Transaction Totals M 1 220 SE Transaction Set Trailer M 1

230 GE Functional Control Trailer M 1

(4)

07/10/14 Page 4

ISA – Transmission Control Header

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

Seq Elem Name Attribute Description 01 101 Authorization information

Qualifier

M ID 02/02 “00” 02 102 Authorization information M AN 10/10 Blank 03 103 Security information Qualifier M ID 02/02 “00” 04 104 Security Information M AN 10/10 Blank

05 105 Sender ID Qualifier M ID 02/02 Define by Sender

06 107 Sender ID M ID 15/15 Define by Sender

07 105 Receiver ID Qualifier M ID 02/02 “12”

08 107 Receiver ID M ID 15/15 Test – 4166602000 Prod - 4166602000 09 108 Interchange Date M DT 06/06 YYMMDD Format 10 109 Interchange Time M TM 04/04 HHMM Format 11 110 Interchange Standard ID M ID 01/01 “U”

12 111 Interchange Version ID M ID 05/05 “00400”

13 112 Interchange Control Number M N0 09/09 Sequentially Assigned Number

14 113 Acknowledgement Requested M ID 01/01 “1”

(5)

07/10/14 Page 5

GS – Functional Group Header

To start and identify functional groups control segments.

Seq Elem Name Attribute Description 01 479 Functional Identifier Code M ID 02/02 “IN”

02 142 Application sender‟s Code M ID 02/12 Define by Sender 03 124 Application Receiver‟s Code M ID 02/12 Test – 4166602000

Prod - 4166602000 04 029 Group date M DT 10/10 CCYYMMDD Format

05 030 Group Time M TM 02/02 HHMM Format

06 028 Group Control Number M N0 15/15 Sequentially Assigned Number

07 455 Responsibility Agency Code M ID 02/02 “X”

(6)

07/10/14 Page 6

ST - Transaction Set Header

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

Seq Elem Name Attribute Description 01 143 Transaction Set Identifier Code M ID 3/3 “810”

02 329 Transaction Set Control Number M AN 4/9 Identifying control number assigned by the originator for a

transaction set.

(7)

07/10/14 Page 7

BIG - Beginning Segment for Invoice

To indicate the beginning of an invoice transaction set and to transmit identifying numbers and dates.

Seq Elem Name Attribute Description 01 373 Invoice Date M DT 8/8 Invoice date

(CCYYMMDD)

02 76 Invoice Number M AN 1/10 Sender invoice number 03 323 Purchase Order Date N

(8)

07/10/14 Page 8

CUR - Currency

To specify the currency (dollars pounds francs etc.) used in a transaction.

Seq Elem Name Attribute Description 01 98 Entity Identifier Code M ID 2/3 “VN” = Vendor 02 100 Currency Code M ID 3/3 Currency code 03 280 Exchange Rate N

(9)

07/10/14 Page 9

N1 - Name

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

Seq Elem Name Attribute Description 01 98 Entity Identifier Code M ID 2/3 “ST”= Ship-to

“BY”= Buying Party “SE”= Selling Party 02 93 Name C AN 1/35

03 66 Identification Code Qualifier C ID 1/2 “92” = Assigned by Buyer

04 67 Identification Code C AN 2/13 ST= TRU

Store/Warehouse Number SE= TRU Vendor Number BY= TRU Id

(10)

07/10/14 Page 10

N2 - Additional Name Information

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

Seq Elem Name Attribute Description 01 93 Name M AN 1/35

(11)

07/10/14 Page 11

N3 - Address Information

To specify the location of the named party.

Seq Elem Name Attribute Description

01 166 Address Information O AN 1/35 ST = ”Ship-To Address” SE = ”Seller Address” 02 166 Address Information O AN 1/35 ST = ”Ship-To Address”

(12)

07/10/14 Page 12

N4 - Geographic Location

To specify the geographic place of the named party.

Seq Elem Name Attribute Description 01 19 City Name O AN 2/19 ST= Ship-to City

SE= Seller City 02 156 State or Province Code O 2/2 ST= Ship-to state

SE= Seller state 03 116 Postal Code O 3/9 ST= Ship-To post code

SE= Seller post code 04 26 Country Code O 2/3 ST= Ship-to country

code

SE= Seller country code

(13)

07/10/14 Page 13

REF - Reference Numbers

To specify identifying numbers.

Seq Elem Name Attribute Description 01 128 Reference Number Qualifier M ID 2/3 “GT” Goods and

Services Tax Registration 02 127 Reference Number C AN 1/20 Tax registration

(14)

07/10/14 Page 14

ITD - Terms of Sale/Deferred Terms of Sale

To specify terms of sale.

Seq Elem Name Attribute Description 01 336 Terms Type Code R ID 2/2 “01”=Basic

“03”=Fixed date “10”=Instant

“12”=Ten Days after EOM

“22”=Cash Discount Terms Apply

02 333 Terms Basis Date Code R ID 1/2 “2”=From delivery date “3”=From invoice Date “4”=Specified Date 03 338 Terms Discount Percent R R 1/5 Ex: 2.05 for 2.05 % 04 370 Terms Discount Due Date C DT 8/8 Discount Due Date 05 351 Terms Discount Days Due C N0 1/3 Discount Days 06 446 Terms Net Due Date C DT 8/8 Net Due Date 07 386 Terms Net Days C N0 1/3 Net Days 08 362 Terms Discount Amount N 09 388 Terms Deferred Due Date N 10 389 Deferred Amount Due N 11 342 Percent of Invoice Payable N

12 352 Description R AN 1/80 Term Code Description 13 765 Day of Month N

14 107 Payment Method Code N 15 954 Percent N

Payment terms with vendors can be as follows: 1. Immediate Payment at Invoice Date:

In this case the vendor will send ITD01 = “10” and applicable code in ITD02. 2. Fixed Date:

In this case the vendor will send ITD01 = “03” and ITD02 = “4”, and provide the date in ITD06 3. EOM 10:

In this case the vendor will send ITD01 = “12”, applicable code in ITD02, and provide the date in ITD06 4. Cash Discount Payment Terms:

In this case the vendor will send ITD01= “22” , applicable code in ITD02, supply a date in ITD04, days in ITD05, and provide the discount percentage in ITD03.

5. Net Payment terms:

(15)

07/10/14 Page 15 6. Cash discount and Basic:

(16)

07/10/14 Page 16

IT1 - Baseline Item Data (Invoice)

To specify the basic and most frequently used line item data for the invoice and related transactions.

Seq Elem Name Attribute Description 01 350 Assigned Identification M AN 6/6 Line Number 02 358 Quantity Invoiced M R 1/9 Number of units

invoiced 03 355 Unit or Basis for Measurement

Code

M ID 2/2 “EA”= Each “CT”= Carton 04 212 Unit Price M R 1/11 Unit price 05 639 Basis of Unit Price Code N

06 235 Product/Service ID Qualifier R ID 2/2 “UP”=UPC Code 07 234 Product/Service ID R AN 13/13 UPC Code 08 235 Product/Service ID Qualifier R 2/2 “IT”=TRU SKN 09 234 Product/Service ID R R 1/6 TRU SKN

10 235 Product/Service ID Qualifier R 2/2 “VA” = Manufacture‟s Number

(17)

07/10/14 Page 17

TXI - Tax Information

To specify tax information.

Seq Elem Name Attribute Description

01 963 Tax Type Code M ID 1/2 GS – Goods and Services Tax

SP – State/Provincial Tax OH – Other Taxes

02 782 Monetary Amount C R 1/13 Tax amount

03 954 Percent C R 1/10 Tax rate (EX:17.5 for 17.5 %)

04 955 Tax Jurisdiction Code Qualifier N 05 956 Tax Jurisdiction Code N 06 441 Tax Exempt Code N 07 662 Price Relationship Code N 08 828 Dollar Basis For Percent N 09 325 Tax Identification Number N

1. Tax Type Code:

(18)

07/10/14 Page 18

PID - Product/Item Description

To describe a product or process in coded or free-form format

Seq Elem Name Attribute Description 01 349 Item Description Type M ID 1/1 “F”= Free format 02 750 Product/Process Characteristic

Code

N

03 559 Agency Qualifier Code N 04 751 Product Description Code N

05 352 Description R 1/35 Item Description in Free Format

06 752 Surface/Layer/Position Code N 07 822 Source Subqualifier N 08 1073 Yes/No Condition or Response

Code

(19)

07/10/14 Page 19

REF - Reference Numbers

To specify identifying numbers.

Seq Elem Name Attribute Description

01 128 Reference Number Qualifier M ID 2/3 “ON” = Order Number “PK” = Packing slip number

02 127 Reference Number C AN 1/20 ON = Order Number

(20)

07/10/14 Page 20

SAC - Service, Promotion, Allowance, or Charge

Information

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

Seq Elem Name Attribute Description 01 248 Allowance or Charge Indicator M AN 1/1 “A”= Allowance

“C”= Charge 02 1300 Service, Promotion, Allowance,

or Charge Code

N

03 559 Agency Qualifier Code N 04 1301 Agency Service, Promotion,

Allowance, or Change Co

N

05 610 Amount R N2 1/13 Allowance/charge amount 06 378 Allowance/ Charge Percent

Qualifier

N

07 332 Allowance or Charge Percent R N2 1/8 08 359 Allowance or Charge Rate N 09 355 Unit or Basis for Measurement

Code

N

10 339 Allowance or Charge Quantity N 11 339 Allowance or Charge Quantity N 12 331 Allowance or Charge Method of

Handling Code

R AN 2/2 „02‟ = Off invoice 13 127 Reference Number R AN 1/3 TRU Allowance Code 14 770 Option Number N

15 352 Description R AN 1/35 TRU Allowance Codes:

ADV ADVERTISING AFA ADDL FREIGHT ALLOW CLD CARLOAD CNT CONTAINER DEF DEFECTIVE DST DISTRIBUTN ALLOW EBD EARLY BUY DISCOUNT ESA EARLY SHIP ALLOWANC EXP EXPORT ALLOWANCE FFA FREE FREIGHT ALLOW LES LESS

MKD MARKDOWN ALL NSA NEW STORE ALLOWANCE NVA NEW VENDOR ALLOWANCE PLA PRODUCT LIABILITY PRM PROMOTIONAL RGD RETURN GOODS RTO ROTO

(21)

07/10/14 Page 21

TDS - Total Monetary Value Summary

To specify the total invoice discounts and amounts

Seq Elem Name Attribute Description

01 361 Total Invoice Amount M N2 1/13 Amount of invoice before Terms Discount.

(Including Charges, less Allowances)

02 390 Amount Subject to Terms Discount

N

(22)

07/10/14 Page 22

TXI - Tax Information

To specify tax information.

Seq Elem Name Attribute Description

01 963 Tax Type Code M ID 2/2 GS – Goods and Services Tax

SP – State/Provincial Tax OH – Other Taxes

02 782 Monetary Amount R N2 1/13 Tax amount 03 954 Percent R R 1/10 Tax rate

Ex: 17.5 for 17.5 %) 04 955 Tax Jurisdiction Code Qualifier N

05 956 Tax Jurisdiction Code N 06 441 Tax Exempt Code N 07 662 Price Relationship Code N

08 828 Dollar Basis For Percent R N2 1/13 Taxable Amount 09 325 Tax Identification Number N

1. Tax Type Code:

(23)

07/10/14 Page 23

AMT – Monetary Amount

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

Seq Elem Name Attribute Description 01 522 Amount Qualifier Code M ID T – Total Tax

KN – Gross Amount of Payment

KF - Net Paid Amount KN+T -/+ allowance/ change = KF

(24)

07/10/14 Page 24

SAC - Service, Promotion, Allowance, or Charge

Information

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

Seq Elem Name Attribute Description 01 248 Allowance or Charge Indicator M AN 1/1 “A”= Allowance

“C”= Charge 02 1300 Service, Promotion, Allowance,

or Charge Code

N

03 559 Agency Qualifier Code N 04 1301 Agency Service, Promotion,

Allowance, or Change Co

N

05 610 Amount R N2 1/13 Allowance/charge amount 06 378 Allowance/ Charge Percent

Qualifier

N

07 332 Allowance or Charge Percent N 08 359 Allowance or Charge Rate N 09 355 Unit or Basis for Measurement

Code

N

10 339 Allowance or Charge Quantity N 11 339 Allowance or Charge Quantity N 12 331 Allowance or Charge Method of

Handling Code

R AN 2/2 „02‟ = Off invoice 13 127 Reference Number R AN 1/3 TRU Allowance Code 14 770 Option Number N

(25)

07/10/14 Page 25

CTT - Transaction Totals

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

Seq Elem Name Attribute Description

01 354 Number of Line Items M N0 1/6 Total number of line items in a transaction set.

02 347 Hash Total N 03 81 Weight N 04 355 Unit or Basis for Measurement

Code

N

05 183 Volume N 06 355 Unit or Basis for Measurement

Code

N

(26)

07/10/14 Page 26

SE - Transaction Set Trailer

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

Seq Elem Name Attribute Description 01 96 Number of Included Segments M N0 1/6

02 329 Transaction Set Control Number M N0 4/9 Sequentially assigned

(27)

07/10/14 Page 27

GE – Functional Set Trailer

This segment will occur once per GS segment.

Seq Elem Name Attribute Description

(28)

07/10/14 Page 28

IEA – Interchange Control Trailer

This segment will occur once per transmission.

Seq Elem Name Attribute Description

(29)

07/10/14 Page 29 Example: ISA*00* *00* *ZZ*VENDORISAID*12*4166602000*140324*1726*U*00400*000000006*1*P*\ GS*IN*VENDORGS*4166602000*20140324*1726*6*X*004010 ST*810*9580004~ BIG*20140507*0157845*20140307*58696~ CUR*VN*CAD~ N1*SE*ACME INC.*92*12345~ N3*70 RIVER RD.~ N4*MONTREAL*QC*H4R 2P2~ REF*GT*123456789AB~ N1*BY*TOYS R US*92*3500~ N3*2777 LANGSTAFF RD~ N4*CONCORD*ON*L4K 4M5*CAN~ N1*ST*TOYS R US*92*3501~ N3*901 CREDITSTONE ROAD~ N4*CONCORD*ON*L4K4M5~ ITD*01*3*2.05**30*20140621*30~ IT1*1*60*EA*300**UP*1234567891234*IT*123456*VA*22222W~ TXI*OH*.39*13~

References

Related documents

Whether you are looking for a tax solution for your sales and use, goods and services (GST), value-added tax (VAT), excise tax fees, IIBB, or other transaction taxes globally

plastic house when a virulent white rust inoculum was exited (Sugimura & Okayama, 2000). The lower disease intensity at the chry- santhemum plants derived from

When the recipient of goods and services creates the tax invoice on behalf of the supplier, this type of tax invoice is known as a recipient created tax invoice (RCTI). The

In this process of interaction, the group develops "a shared repertoire of resources: experiences, stories, tools, ways of addressing recurring problems—in short

If you provide related services to vehicles that your customer stores, keeps or retains for the sole purpose of resale or leasing, you may provide the related services, and any

• Modernize the sales tax by tax- ing selected services, eliminating sales tax exemptions, collecting tax on online sales and eliminat- ing the sales tax on groceries.. •

Formats Tax Invoice Credit Note Debit Notes in Excel Click wizard for Download Tax Invoice GST Invoice Format in Excel Export Invoice-GST Export Invoice.. The SAC code means

154 worm your way into/through etc something: to move through a small place or a crowd slowly, carefully, or with difficulty/ worm your way into somebody's