POS/2.30/Database Model/payments
Contents |
PAYMENTS
Description
Columns
This table contains the following columns:
| Name | PK | Nullable | Data Type | Default | Description |
| ID | Y | N | VARCHAR | ||
| RECEIPT | N | N | VARCHAR | ||
| PAYMENT | N | N | VARCHAR | ||
| TOTAL | N | N | DOUBLE | ||
| TRANSID | N | Y | VARCHAR | ||
| RETURNMSG | N | Y | BYTEA |
Foreign Keys
These are the foreign keys for this table:
| Name | Referencing column | Referenced table | Referenced column | Description |
| PAYMENTS_FK_RECEIPT | RECEIPT | RECEIPTS | ID |
Indexes
These are the indexes for this table (for each index there is a list of the columns included within it):
| Name | Unique | Reference | Description |
| PAYMENTS_INX_1 | N | PAYMENT - |
| Languages: |
POS/2.30/Database Model/locations | POS/2.30/Database Model/people