Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents |
|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
| ArticleId | uniqueidentifier | 16 | null |
|
|
| Code | nvarchar | 20 | null |
|
|
| Type | varchar | 1 | null |
|
|
| LibelleCourt | nvarchar | 120 | null |
|
|
| LibelleLong | nvarchar | 2147483647 | null |
|
|
| FamilleCode | nvarchar | 20 | null |
|
|
| FamilleLibelle | nvarchar | 100 | null |
|
|
| SegmentationCode | nvarchar | 10 | null |
|
|
| SegmentationLibelle | nvarchar | 100 | null |
|
|
| NatureCode | nvarchar | 6 | null |
|
|
| NatureLibelle | nvarchar | 2147483647 | null |
|
|
| ModeUtilisation | nvarchar | 4 | null |
|
|
| Unite | nvarchar | 4 | null |
|
|
| UniteLibelle | nvarchar | 2147483647 | null |
|
|
| NiveauCode | nvarchar | 4 | null |
|
|
| NiveauLibelle | nvarchar | 2147483647 | null |
|
|
| NePlusUtiliser | varchar | 1 | null |
|
|
| Sup | int | 4 | null |
|
|
| DecoupeanalytiqueProduit | nvarchar | 60 | null |
|
|
| RepriseSurBaseDesRealisations | varchar | 1 | null |
|
|
| RepriseEnFactureSolde | varchar | 1 | null |
|
|
| RepriseEnFraisChancellerie | varchar | 1 | null |
|
|
| TauxFraisChancellerie | decimal | 7,2 | null |
|
|
| ChargesAutorise | nvarchar | 2 | null |
|
|
| ChargesLibelle | nvarchar | 4 | null |
|
|
| ChargesModeIntervention | nvarchar | 2 | null |
|
|
| ChargesPrixVente | nvarchar | 4 | null |
|
|
| ChargesPrixRevient | nvarchar | 4 | null |
|
|
| ArticleAFacturer | nvarchar | 20 | null |
|
|
| ARattacherClient | nvarchar | 2 | null |
|
|
| ARattacherPeriode | nvarchar | 2 | null |
|
|
| PeriodeTypeCode | nvarchar | 20 | null |
|
|
| PeriodeTypeLibelle | nvarchar | 100 | null |
|
|
| ARattacherMission | nvarchar | 2 | null |
|
|
| DoubleQuantite | nvarchar | 2 | null |
|
|
| TarifModeCode | int | 4 | null |
|
|
| TarifModeLibelle | nvarchar | 2147483647 | null |
|
|
| TarifDateApplication | int | 4 | null |
|
|
| TarifDateApplicationLibelle | nvarchar | 2147483647 | null |
|
|
| TypeDegressif | int | 4 | null |
|
|
| TypeDegressifLibelle | nvarchar | 2147483647 | null |
|
|
| TarifRAZCode | nvarchar | 4 | null |
|
|
| TarifRAZLibelle | nvarchar | 2147483647 | null |
|
|
| TarifRAZDate | datetime2 | 16,7 | null |
|
|
| TarifChargesCode | int | 4 | null |
|
|
| TarifChargesLibelle | nvarchar | 2147483647 | null |
|
|
| EcheanceDateBaseCode | nvarchar | 4 | null |
|
|
| EcheanceDateBaseLibelle | nvarchar | 2147483647 | null |
|
|
| EcheancePrecedente | nvarchar | 20 | null |
|
|
| EcheanceReport | nvarchar | 4 | null |
|
|
| EcheanceReportLibelle | nvarchar | 2147483647 | null |
|
|
| EcheanceNombre | int | 4 | null |
|
|
| EcheanceDelaiMois | int | 4 | null |
|
|
| EcheanceDelaiJour | int | 4 | null |
|
|
| EcheanceEcart | int | 4 | null |
|
|
| EcheanceVariable | nvarchar | 510 | null |
|
|
| BlocNotes | nvarchar | 2147483647 | null |
|
|
| FraisCompte | nvarchar | 24 | null |
|
|
| FraisTVA | nvarchar | 60 | null |
|
|
| FraisDecoupeAnalytique | nvarchar | 60 | null |
|
|
| NrDesignation | int | 4 | null |
|
|
| AutoriserRemise | bit | 1 | null |
|
|