Colonnes
Colonne | Type | Taille | Default | Enfants | Parents |
---|---|---|---|---|---|
DomaineId | int | 4 | null |
|
|
FactureId | uniqueidentifier | 16 | null |
|
|
FactureNumero | nvarchar | 22 | null |
|
|
DocumentTypeCode | int | 4 | null |
|
|
DocumentTypeLibelle | nvarchar | 2147483647 | null |
|
|
SocieteId | uniqueidentifier | 16 | null |
|
|
SocieteCode | nvarchar | 20 | null |
|
|
SocieteLibelle | nvarchar | 182 | null |
|
|
ClientTiersId | uniqueidentifier | 16 | null |
|
|
ClientCode | nvarchar | 20 | null |
|
|
ClientNomComplet | nvarchar | 240 | null |
|
|
NumeroEcheance | int | 4 | null |
|
|
Date | datetime2 | 16,7 | null |
|
|
Taux | decimal | 21,2 | null |
|
|
MontantTTC | decimal | 21,2 | null |
|
|
MontantRegle | decimal | 21,2 | null |
|
|
Solde | decimal | 21,2 | null |
|
|
TypeReglementCode | nvarchar | 4 | null |
|
|
TypeReglementLibelle | nvarchar | 2147483647 | null |
|
|
NiveauRelance | smallint | 2 | null |
|
|