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 |