Table ORGANISME
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| ORGANISME | ORG | Organizations | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| ORG0 | COD | No | |
| ORG1 | TYP+COD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD | Address | 3 | ADL | |||||
| AUUID | Single identifier | AUUID | ||||||
| BANFCY | Bank | 2 | BAN | [BAN]BAN0=[ORG]BANFCY | Block | |||
| BID | Bank ID number | BID | ||||||
| CMTORG | Comments | AC0 | 2 | |||||
| CNT | Contact | A | 30 | |||||
| COD | Code | ORG | [ORG]ORG0=[ORG]COD | Delete | ||||
| CODSSC | Secu code | A | 4 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRN | Site tax ID no. | CRT | ||||||
| CRY | Country | CRY | [TCY]TCY0=[ORG]CRY | Block | ||||
| CRYNAM | Country name | NCY | ||||||
| CTY | Distributor office | CTY | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[ORG]CUR | Block | ||||
| DEP | Department | A | 3 | |||||
| DES | Description | DES | ||||||
| DUECOD | DUE code | ADI | [ADI]CODE=561;DUECOD | Block | ||||
| ENAFLG | Active | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| FAX | Fax | TEL | ||||||
| FLGORGCMP | Complementary organization | M | 4 | 1 | ||||
| FORNUM | Training org. no. | A | 15 | |||||
| GRPORG | Organization | 10 | ORG | [ORG]ORG0=[ORG]GRPORG | Block | |||
| KEYORG | Identification | M | 15 | 371 | ||||
| LIBKEYORG | Other | A | 35 | |||||
| MEW | Occupational health | MEW | [MEW]MEW0=DEP;MEW | Block | ||||
| MOB | Mobile phone | TEL | ||||||
| MODPAY | Payment mode | M | 15 | 362 | ||||
| NBRLIG | Number of lines | C | 2 | |||||
| NSSCOD | Insurance code | A | 10 | KPOAO | ||||
| NUMASS | ASSEDIC no. | A | 2 | |||||
| NUMDCS | Organization | ADI | [ADI]CODE=340;NUMDCS | Block | ||||
| NUMORG | Membership no. | A | 35 | FRT | ||||
| OFIEMP | Employer | M | 4 | 1 | FRT | |||
| ORFWEB | Web site | A | 250 | FRT | ||||
| POS | Postal code | POS | ||||||
| SPEORG | Speciality | 10 | ADI | [ADI]CODE=392;SPEORG | Block | FRT | ||
| TEL | Telephone | TEL | ||||||
| TYP | Organization type | M | 15 | 337 | ||||
| TYPASS | Assedic type | M | 15 | 325 | ||||
| TYPFRM0 | URSSAF statement | ADI | [ADI]CODE=374;TYPFRM0 | Block | ||||
| TYPFRM1 | ASSEDIC statement | ADI | [ADI]CODE=375;TYPFRM1 | Block | ||||
| TYPFRM2 | IRC statement | ADI | [ADI]CODE=376;TYPFRM2 | Block | ||||
| TYPIRC | IRC type | M | 15 | 386 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| WEB | MAI |