Rownnum

Identifies all rows with a number so that any load errors can be addressed and easily located

Action

Determines the database load action: ADD, UPDATE, DELETE

Entity

First line is prefilled, all others need filling with the same entity name, in this example it is Customer

Id

Relevant for Updates and Deletions, and determines the database record number

Name

Customer abbreviation – especially needed when the Id field value id unknown

FullName

This is the Customer’s full name – also a unique identifier