POS/2.30/Database Model/thirdparties
Contents |
THIRDPARTIES
Description
Columns
This table contains the following columns:
| Name | PK | Nullable | Data Type | Default | Description |
| ID | Y | N | VARCHAR | ||
| CIF | N | N | VARCHAR | ||
| NAME | N | N | VARCHAR | ||
| ADDRESS | N | Y | VARCHAR | ||
| CONTACTCOMM | N | Y | VARCHAR | ||
| CONTACTFACT | N | Y | VARCHAR | ||
| PAYRULE | N | Y | VARCHAR | ||
| FAXNUMBER | N | Y | VARCHAR | ||
| PHONENUMBER | N | Y | VARCHAR | ||
| MOBILENUMBER | N | Y | VARCHAR | ||
| N | Y | VARCHAR | |||
| WEBPAGE | N | Y | VARCHAR | ||
| NOTES | N | Y | VARCHAR |
Foreign Keys
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 |
| THIRDPARTIES_CIF_INX | Y | CIF - | |
| THIRDPARTIES_NAME_INX | Y | NAME - |
| Languages: |
POS/2.30/Database Model/taxlines | POS/2.30/Database Model/ticketlines