Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

[ Image Removed |../../index.htm#lansa/ugub_30030.htm]
You are here:

...

These examples apply to specifying the fields in a file definition.
Define the fields in a name and address file

Seq

Field

Description

Primary Key Order

1

NADCD

Name and address code

1

2

NAME

Name of person / organization

 


3

ADDR1

Address line 1

 


4

ADDR2

Address line 2

 


5

ADDR3

Address line 3

 


6

POSTCD

Post code


 

...

 |
Define the fields in an order header file

Seq

Field

Description

Primary Key Order

10

ORDNUM

Order number

1

20

NADCOD

Customer name & address code

 


30

DATDUE

Date order is due

 


40

COMPFL

Order completion flag

 


50

USERID

User who entered order details

 


 |
Define the fields in an order lines file

Seq

Field

Description

Primary Key Order

10

ORDNUM

Order number

1

20

PRODNO

Product number

 


30

QUANTY

Quantity ordered

 


15

ORDLIN

Order line number

2

40

DISCNT

Discount percentage

 

...