Table FACILITY
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| FACILITY | FCY | Sites | Supervisor |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| FCY0 | FCY | No | |
| FCY1 | LEGCPY+FCY | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCOD | Accounting code | A | 10 | CPT | ||||
| AUUID | Single identifier | AUUID | ||||||
| BIDNUM | Bank ID number | BID | ||||||
| BPAADD | Default address | ADR | ||||||
| BPTNUM | Carrier | A | 10 | |||||
| CCE | Analytical dimension | A | 10 | |||||
| CNTNAM | Contact | A | 10 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[FCY]CREUSR | Other | ||||
| CRN | Site registration number | CRT | ||||||
| CRY | Country | CRY | [TCY]TCY0=[FCY]CRY | Block | ||||
| DADFCY | DAS2 site | FCY | [FCY]FCY0=[FCY]DADFCY | Other | ||||
| DADFLG | DAS2 | M | 4 | 1 | ||||
| EORINUM | EORI number | A | 35 | EORI | ||||
| FCY | Site | FCY | [FCY]FCY0=[FCY]FCY | Delete | ||||
| FCYNAM | Name | NAM | ||||||
| FCYSHO | Short description | SHO | ||||||
| FINFLG | Accounting | M | 4 | 1 | ||||
| FINRSPFCY | Financial site | FCY | [FCY]FCY0=[FCY]FINRSPFCY | Other | ||||
| GEOCOD | Geographic code | A | 10 | KUS | ||||
| INSCTYFLG | City interior flag | A | 10 | KUS | ||||
| LEG | Legislation | ADI | [ADI]CODE=909;LEG | Block | ||||
| LEGCPY | Legal company | CPY | [CPY]CPY0=[FCY]LEGCPY | Block | ||||
| MFGFLG | Manufacturing | M | 4 | 1 | ||||
| NAF | SIC code | NAF | ||||||
| PAYBAN | Payment bank | A | 10 | |||||
| PURFLG | Purchase | M | 4 | 1 | ||||
| SALFLG | Sales | M | 4 | 1 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[FCY]UPDUSR | Other | ||||
| UVYCOD | Unavailable | UVY | ||||||
| UVYDAY | Unavail. (everyday) | 7 | M | 4 | 1 | |||
| WRHFLG | Warehouse | M | 4 | 1 |