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 |
- * 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 |