Radley\CARaS EDI Transactions - Flat-File Layout

The flat-file definitions for the Radley/CARaS extraction programs are shown below.

This table describes CARAS Customer Address Extraction File Definition:

Field Description Position Length Format Notes/ Field
Undefined 1 8 AN  
Mode (hard coded) 9 1 AN Hard Coded C
Undefined 10 10 AN  
Trading Partner Designator 20 7 AN

cust_tp.tp_code

You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports.

Type (hard coded) 27 1 N0 Hard Coded 3
Cust. Name 28 35 AN custaddr.name
Cust. Address 1 63 35 AN custaddr.addr##1
Cust. Address 2 98 35 AN custaddr.addr##2
Cust. City 133 30 AN custaddr.city
Cust. State 163 2 AN custaddr.state
Cust. Postal Code 165 15 AN custaddr.zip
Cust. Country 180 10 AN custaddr.country
Undefined 190 199 AN  
    ------    
    298   Total Record Length

This table describes CARAS Commodity Code Extraction:

Field Description Position Length Format Notes/ Field
Undefined 1 12 AN  
Commodity Code 13 16 AN

commodity.

comm_code

Commodity Desc. 29 30 AN commodity.description
Undefined 59 96 AN  
Transaction Mode (hard coded) 155 1 AN Hard Coded A
Undefined 156 400 AN  
    ------    
    555   Total Record Length

This table describes CARAS Ship Via Extraction:

Field Description Position Length Format Notes/ Field
Undefined 1 10 AN  
CARaS Tables Name (hard coded) 11 10 AN Hard Coded CARRIER
Carrier Code 21 4 AN shipcode.ship_code
Undefined 25 10 AN  
Table Code Description 35 35 AN

shipcode.

description

Mode (hard coded) 70 1 AN Hard Coded A
Undefined 71 20 AN  
    ------    
    90   Total Record Length

This table describes CARAS Part Master Extraction:

Field Description Position Length Format Notes/ Field
Undefined 1 8 AN  
Mode 9 1 AN A=add, C=chg, D=Del
Undefined 10 10 AN  
Trading Partner Designator 20 2 AN cust_tp.tp_code
Item 22 30 AN item.item
Undefined 52 10 AN  
Customer Item 62 30 AN itemcust.cust_item
Item Description 92 30 AN item.description
Undefined 122 60 AN  
Unit of Measure 182 2 AN itemcust.u_m
Weight 184 10 N0 item.unit_weight
Undefined 194 30 AN  
Commodity Code 224 16 AN item.comm_code
Price 240 10 N0 Calculated
Undefined 250 43 AN  
Pounds or Kilos 293 1 AN if item.weight_units = "KG" then "K" else "L"
Undefined 294 81 AN  
Lead Time 375 4 N0 parms.due_period
Undefined 379 208 AN  
    ------    
    586   Total Record Length