21R0202 - Attachment A9 SEA Card File Layouts and Directions.pdf

Element Qualifier

Description Name Value Length Req Data Example

IDoc Control Record Data

HEADER Level Data

Invoice Date BIG01 8 Required 20110907 Date Invoice is submitted

Invoice Number BIG02 7 Required 1108120 Merchant's Invoice Number

Date Received BIG03 8 Required 20110907 Date Invoice is submitted

Delivery Order Number BIG04 4 Required 0425 SEA Card Delivery Order Number

Shipment Number BIG05 7 Required BNK0001 Always BNK0001

Debit/Credit Indicator BIG07 2 Required DI DI = Debit | CI = Credit

Batch Identifier REF02 REF01 = BT

Contract Number REF02 REF01 = CT 7 Required 09D0354 DLA Contract Number

Batch Ticket Count REF02 REF01 = 2H Blank

Point of Sale Code REF02 REF01 = S2 Blank

ReIssue Number REF02 REF01 = RX Blank

Program Identifier REF02 REF01 = IT Blank

SEA Card Requisition Number REF02 REF01 = RQ Blank

Contract Indicator REF02 REF01 = ZZ Blank

Product Code REF02 REF01 = P7 Blank

Discount Pay Ind (Type) ITD01 2 Optional 05

Discount Pay Days ITD05 3 Optional

Discount Pay Value ITD08 6 Optional

Batch Date DTM02 DTM01 = "007" Blank

SEA Card Order Date DTM02 DTM01 = "002" Blank SEA Card Delivery Date DTM02 DTM01 = "035" Blank

DETAIL Level Data

Quantity Billed IT102 9 Required 0000001380 Max length 10 (8.2) | Implied Decimal

Unit of Measure IT103 2 Required MP US Gallons = GA | Metric Tons = MP

Unit Price IT104 10 Required 00001229.23 Max Length 11 including decimal (4.6) zero filled

Buyer's Item Number IT106 PI Qualifier

CLIN IT107 6 Required 20061A DLA contract line item number

Commodity Name IT110 CN Qualifier

Tax Code TX101 2 Optional

Tax Amount TX102 12 Conditional

Clin Invoice Amount REF02 REF01=ZZ 10 Required 0016963.37 Max length 10 including decimal (7.2) zero filled NSN 13 Required 9130014850982 List of NSNs will be provided by DLA

Summary Level Data

Average Product Price TDS01 1696337 Max length 10 decimal implied

EDI Standard (X12)

Formating Instructions|Details F

Element Record Field

Description Name Position Length Requirement Data Example

DETAIL Level Data

Program Indicator Program Indicator 1 1 Required B Always 'B'

Transaction Type Transaction Type 2 1 Required 1 1 = Debit | 2 = Credit

Shipment (Lift Date) Shipment (Lift Date) 3-8 6 Required 130111 Date Format = DDMMYY

Requisition Number Requisition Number 9-24 16 Required Z133341012SE00

Vendor Name Vendor Name 25-54 30 Optional Port Consolidated

Vendor Address Line 1 Vendor Address Line 1 55-84 30 Optional P.O. Box 350430

Vendor Address Line 2 Vendor Address Line 2 85-114 30 Optional

City City 115 -133 19 Optional Ft. Lauderdale

State State 134 - 135 2 Optional FL

Zip Zip 136 - 144 9 Optional 333350430

Contract Number Contract Number 145 - 151 7 Required 06D0353

Order Number Order Number 152 - 155 4 Required 0275

Line Item Num Line Item Num 156 - 161 6 Required 147751

Shipment Num Shipment Num 162 - 168 7 Optional BNK0001

Quantity Quantity 169 - 178 10 Required 0000112500 Decimal implied

Unit of Issue Unit of Issue 179 - 180 2 Required G US Gallons = 'G ' | Metric Tons = 'T ' Left justified

Unit Price Unit Price 181 - 190 10 Required 0002834115 Decimal implied

Extended Total Extended Total 191 - 200 10 Required 0000318838 Decimal implied

Tax Type Tax Type 201 1 Blank

Tax Quantity Tax Quantity 202 - 211 10 Blank

Tax Unit Price Tax Unit Price 212 - 221 10 Blank

Extended Tax Extended Tax 222 - 231 10 Blank

Tax Type Tax Type 232 1 Blank

Tax Quantity Tax Quantity 233 - 242 10 Blank

Tax Unit Price Tax Unit Price 243 - 252 10 Blank

Extended Tax Extended Tax 253 - 262 10 Blank

Tax Type Tax Type 263 1 Blank

Tax Quantity Tax Quantity 264 - 273 10 Blank

Tax Unit Price Tax Unit Price 274 - 283 10 Blank

Extended Tax Extended Tax 284 - 293 10 Blank

Discount Discount 294 1 Blank

Discount Type Discount Type 295 1 Blank

Discount Percentage Discount Percentage 296 - 302 7 Blank

Discount Days Discount Days 303 - 304 2 Blank

Customer ID Customer ID 305 - 307 3 Optional

Card Number Card Number 308 - 313 6 Optional 653076 Last 6 of virtual card or account number

Supplementary Address Supplementary Address 314 - 319 6 Conditional Z51800 Required if Signal Code is other than 'A'

Signal Code Signal Code 320 1 Required B

Fund Code Fund Code 321 - 322 2 Required SQ

Major Force Program Major Force Program 323 1 Blank

Mission Design Series Mission Design Series 324 - 326 3 Blank

Vessel/Tail Number Vessel/Tail Number 327 - 330 4 Blank

DoDAAC of Requisitioner DoDAAC of Requisitioner 331 - 336 6 Required Z13334

Order Date Order Date 337 - 342 6 Required 120111 Format = DDMMYY

Transaction Transmittal Date Transaction Transmittal Date 343 - 348 6 Optional 180111 Format = DDMMYY

National Stock Number National Stock Number 349 - 361 13 Required List of NSNs will be provided by DLA

UDF Data

Formating Instructions|Details