If you use the DataAssist Wizard to create the page, it will match the form fields with the correct database column.
If you are adding the Insert record Behavior to the page manually, then you will need to manually bind the database columns to the form fields.
To bind the database column, select it in the list and click the Lightning bolt next to value. Expand the Form Collection in the Dynamic Data binding window and select the corresponding form element.