Table FACILITY
| Table | Abbreviation | Title | 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 | CAC | [CAC]CAC0=[V]GCACFCY;ACCCOD;[V]GSUPCLE | Block | CPT | |||
| AUUID | Single identifier | AUUID | ||||||
| BIDNUM | Bank ID number | BID | ||||||
| BPAADD | Default address | ADR | ||||||
| BPTNUM | Carrier | A | 10 | |||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CNTNAM | Contact | AIN | [AIN]AIN0=[FCY]CNTNAM | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[FCY]CREUSR | Other | ||||
| CRN | Site registration nb | CRT | ||||||
| CRY | Country | CRY | [TCY]TCY0=[FCY]CRY | Block | ||||
| DADFCY | DAS2 site | A | 10 | KFR | ||||
| DADFLG | DAS2 | C | 4 | KFR | ||||
| DIE | Dim type code | DIE | [DIE]DIE0=[FCY]DIE | Block | ANA | |||
| FCY | Site | FCY | [FCY]FCY0=[FCY]FCY | Delete | ||||
| FCYNAM | Name | NAM | ||||||
| FCYSHO | Short title | 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 | NAF code | NAF | ||||||
| PAYBAN | Payment bank | BAN | [BAN]BAN0=[FCY]PAYBAN | Block | ||||
| 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 |