File

Select this option to browse for and select tables from a CSV or xml file. See the table below for the format of the CSV file.
Field in File

Field

Description

in File

LAWSON SAP Other
Table

Name

Name of

Table in

ERP/

application

Mandatory Mandatory Mandatory
Table

Friendly

Name

Friendly

name of

table in

ERP/

application

Mandatory Mandatory Mandatory
Column

Name

Column of

table in

ERP /

application

Mandatory Mandatory Mandatory
Column

Friendly

Name

Friendly

name of

column in

ERP /

application

Mandatory Mandatory Mandatory
Key Specifies

if the

column

is KEY

in the

ERP/

application

*Optional *Optional NA
Data

Type

Column

datatype

Mandatory Mandatory Mandatory
Data

Length

Length

of the

datatype

Mandatory Mandatory Mandatory
Scale Scale

for

number

datatype

Optional Optional Optional
Precision Precision

for

number

datatype

Optional Optional Optional
Domain

Name

Domain

for SAP

Boolean

datytype

NA **Optional NA
Has

Val

List

Applies to

Lawson.

Defines

whether

the

column has a

translation

value.

Mandatory NA NA
nOccurs Applies to

Lawson.

Defines

how many

times the

column

occurs in

a table.

Mandatory NA NA
Note: 
  • * This is the ISKEY. For non-SAP it gets populated as ‘N’ by default.
  • ** In SAP, Boolean and character(1) are saved as string datatype and they can be differentiated using this Domain Name.

The data types supported for Lawson are as in the table below:

Data Type Description
NUMERIC Stores numeric values
BCD Stores binary coded decimal values
CURRENCY Stores currency values
ALPHA Stores alphabetic characters that are left-justified
ALPHALC Stores alphabetic characters in lower case
ALPHARIGHT Stores alphabetic characters that are right-justified
MMDD Stores date in month and day format
PERCENT Stores percentage values.
TELE Stores telephone numbers
UNIQUEID Stores unique binary IDs
UNIQUEIDREF Stores unique binary IDs
YYYYMMDD Stores dates in a year, month and day format
TIME Stores the time