|
Colonne
|
Intitulé normal
|
Dim
|
Type
|
Long
|
Menu
|
Expression de lien
|
Annulation
|
Act
|
|
AUUID
|
Identifiant unique
|
|
AUUID
|
|
|
|
|
|
|
BASTAXLIN
|
Montant taxable
|
|
MD1
|
|
|
|
|
KUS
|
|
BPAADD
|
Adresse livraison
|
|
ADR
|
|
|
|
|
|
|
BPCORD
|
Client commande
|
|
BPC
|
|
|
[BPC]BPC0=[SQD]BPCORD
|
Autre
|
|
|
CLCAMT1
|
Base 1 calcul taxe
|
|
MD1
|
|
|
|
|
|
|
CLCAMT2
|
Base 2 calcul taxe
|
|
MD1
|
|
|
|
|
|
|
CNDNAM
|
Contact livraison
|
|
AIN
|
|
|
[AIN]AIN0=CNDNAM
|
Bloquant
|
|
|
CPRPRI
|
Prix revient
|
|
MD8
|
|
|
|
|
|
|
CPY
|
Société
|
|
CPY
|
|
|
[CPY]CPY0=[SQD]CPY
|
Bloquant
|
|
|
CREDAT
|
Date création
|
|
D
|
|
|
|
|
|
|
CREDATTIM
|
Date heure
|
|
ADATIM
|
|
|
|
|
|
|
CREUSR
|
Opérateur création
|
|
A
|
5
|
|
|
|
|
|
DAYLTI
|
Délai liv en jours
|
|
C
|
3
|
|
|
|
|
|
DDTANOT
|
Elt fact lig répart
|
|
MD1
|
|
|
|
|
SFL
|
|
DDTANUM
|
Elt fact lig répart
|
|
SFI
|
|
|
[SFI]SFI0=[SQD]DDTANUM
|
Bloquant
|
SFL
|
|
DISCRGREN1
|
Motif1 remise/frais
|
|
SPR
|
|
|
[SPR]SPR0=[SQD]DISCRGREN1
|
Bloquant
|
SP1
|
|
DISCRGREN2
|
Motif2 remise/frais
|
|
SPR
|
|
|
[SPR]SPR0=[SQD]DISCRGREN2
|
Bloquant
|
SP2
|
|
DISCRGREN3
|
Motif3 remise/frais
|
|
SPR
|
|
|
[SPR]SPR0=[SQD]DISCRGREN3
|
Bloquant
|
SP3
|
|
DISCRGREN4
|
Motif4 remise/frais
|
|
C
|
4
|
|
|
|
SP4
|
|
DISCRGREN5
|
Motif5 remise/frais
|
|
C
|
4
|
|
|
|
SP5
|
|
DISCRGREN6
|
Motif6 remise/frais
|
|
C
|
4
|
|
|
|
SP6
|
|
DISCRGREN7
|
Motif7 remise/frais
|
|
C
|
4
|
|
|
|
SP7
|
|
DISCRGREN8
|
Motif8 remise/frais
|
|
C
|
4
|
|
|
|
SP8
|
|
DISCRGREN9
|
Motif9 remise/frais
|
|
C
|
4
|
|
|
|
SP9
|
|
DISCRGVAL1
|
Valeur1 remise/frais
|
|
MD8
|
|
|
|
|
SP1
|
|
DISCRGVAL2
|
Valeur2 remise/frais
|
|
MD8
|
|
|
|
|
SP2
|
|
DISCRGVAL3
|
Valeur3 remise/frais
|
|
MD8
|
|
|
|
|
SP3
|
|
DISCRGVAL4
|
Valeur4 remise/frais
|
|
DCB
|
19.8
|
|
|
|
SP4
|
|
DISCRGVAL5
|
Valeur5 remise/frais
|
|
DCB
|
19.8
|
|
|
|
SP5
|
|
DISCRGVAL6
|
Valeur6 remise/frais
|
|
DCB
|
19.8
|
|
|
|
SP6
|
|
DISCRGVAL7
|
Valeur7 remise/frais
|
|
DCB
|
19.8
|
|
|
|
SP7
|
|
DISCRGVAL8
|
Valeur8 remise/frais
|
|
DCB
|
19.8
|
|
|
|
SP8
|
|
DISCRGVAL9
|
Valeur9 remise/frais
|
|
DCB
|
19.8
|
|
|
|
SP9
|
|
DSPLINFLG
|
Répartition
|
|
M
|
4
|
1
|
|
|
|
|
DSPLINVOL
|
Volume ligne
|
|
QTY
|
|
|
|
|
|
|
DSPLINWEI
|
Poids ligne
|
|
QTY
|
|
|
|
|
|
|
DSPVOU
|
Unité Volume
|
|
UOM
|
|
|
[TUN]TUN0=[SQD]DSPVOU
|
Bloquant
|
|
|
DSPWEU
|
Unité poids
|
|
UOM
|
|
|
[TUN]TUN0=[SQD]DSPWEU
|
Bloquant
|
|
|
ECCVALMAJ
|
Version majeure
|
|
ECS
|
|
|
|
|
ECC
|
|
ECCVALMIN
|
Version mineure
|
|
EVL
|
|
|
|
|
ECC
|
|
EXPNUM
|
Numéro export
|
|
L
|
8
|
|
|
|
|
|
FOCFLG
|
Gratuit
|
|
M
|
10
|
439
|
|
|
|
|
GEOCOD
|
Géo code
|
|
GEO
|
|
|
|
|
KUS
|
|
GROPRI
|
Prix brut
|
|
MD8
|
|
|
|
|
|
|
IMPNUMLIG
|
Ligne import
|
|
L
|
8
|
|
|
|
|
|
INSCTYFLG
|
Flag intér. ville
|
|
A
|
1
|
|
|
|
KUS
|
|
INVPRNBOM
|
Composant imp Fac
|
|
M
|
4
|
1
|
|
|
|
|
ITMDES
|
Désignation
|
|
DES
|
|
|
|
|
|
|
ITMDES1
|
Désignation
|
|
DES
|
|
|
|
|
|
|
ITMREF
|
Article
|
|
ITM
|
|
|
[ITM]ITM0=[SQD]ITMREF
|
Bloquant
|
|
|
LINTYP
|
Type ligne
|
|
M
|
15
|
423
|
|
|
|
|
NDEPRNBOM
|
Composant imp BL
|
|
M
|
4
|
1
|
|
|
|
|
NETPRI
|
Prix net
|
|
MD8
|
|
|
|
|
|
|
NETPRIATI
|
Prix net TTC
|
|
MD8
|
|
|
|
|
|
|
NETPRINOT
|
Prix net HT
|
|
MD8
|
|
|
|
|
|
|
OCNPRNBOM
|
Composant imp ARC
|
|
M
|
4
|
1
|
|
|
|
|
ORDFLG
|
Commandée
|
|
M
|
4
|
1
|
|
|
|
|
ORDQTY
|
Qté commandée
|
|
QTY
|
|
|
|
|
|
|
ORILIN
|
Ligne ori gratuit
|
|
L
|
8
|
|
|
|
|
|
PFM
|
Marge
|
|
MD1
|
|
|
|
|
|
|
PRIREN
|
Motif prix
|
|
SPR
|
|
|
[SPR]SPR0=[SQD]PRIREN
|
Bloquant
|
|
|
QTY
|
Quantité devis
|
|
QTY
|
|
|
|
|
|
|
QUODAT
|
Date devis
|
|
D
|
|
|
|
|
|
|
RATTAXLIN
|
Taux de taxe
|
|
RAT
|
|
|
|
|
KUS
|
|
REP1
|
Représentant 1
|
|
REP
|
|
|
[REP]REP0=[SQD]REP1
|
Bloquant
|
RE1
|
|
REP2
|
Représentant 2
|
|
REP
|
|
|
[REP]REP0=[SQD]REP2
|
Bloquant
|
RE2
|
|
REPCOE
|
Coef pondération
|
|
CCR
|
|
|
|
|
|
|
REPRAT1
|
Taux commission 1
|
|
RAT
|
|
|
|
|
RE1
|
|
REPRAT2
|
Taux commission 2
|
|
RAT
|
|
|
|
|
RE2
|
|
SALFCY
|
Site vente
|
|
FCY
|
|
|
[FCY]FCY0=[SQD]SALFCY
|
Bloquant
|
|
|
SAU
|
Unité vente
|
|
UOM
|
|
|
[TUN]TUN0=[SQD]SAU
|
Bloquant
|
|
|
SAUSTUCOE
|
Coef UV-US
|
|
COE
|
|
|
|
|
|
|
SOHNUM
|
No commande
|
|
VCR
|
|
|
|
|
|
|
SOPLIN
|
Ligne
|
|
L
|
8
|
|
|
|
|
|
SQDLIN
|
Ligne devis
|
|
L
|
8
|
|
|
|
|
|
SQDTEX
|
Texte ligne
|
|
TXC
|
|
|
|
|
|
|
SQHNUM
|
No devis
|
|
VCR
|
|
|
|
|
|
|
SSTCOD
|
Code taxe SST
|
|
ADI
|
|
|
[ADI]CODE=203;SSTCOD
|
Bloquant
|
LTA
|
|
STOFCY
|
Site expédition
|
|
FCY
|
|
|
[FCY]FCY0=[SQD]STOFCY
|
Bloquant
|
|
|
STU
|
Unité stock
|
|
UOM
|
|
|
[TUN]TUN0=[SQD]STU
|
Bloquant
|
|
|
TAXFLG
|
Flag taxable
|
|
M
|
4
|
1
|
|
|
KUS
|
|
TAXGEOFLG
|
Flag Geo taxed
|
|
A
|
1
|
|
|
|
KUS
|
|
TAXREGFLG
|
Flag taxe enregistré
|
|
M
|
4
|
1
|
|
|
KUS
|
|
UPDDAT
|
Date modification
|
|
D
|
|
|
|
|
|
|
UPDDATTIM
|
Date heure
|
|
ADATIM
|
|
|
|
|
|
|
UPDUSR
|
Opérateur modif
|
|
A
|
5
|
|
|
|
|
|
VACITM
|
Niveau taxe
|
3
|
TVI
|
|
|
[TVI]TVI0=VACITM(indice);[V]GSUPCLE
|
Bloquant
|
|
|
VAT
|
Taxe
|
3
|
VAT
|
|
|
[TVT]TVT0=VAT(indice);[V]GSUPCLE
|
Bloquant
|
|
|
VTC
|
Code transac. Vertex
|
|
A
|
1
|
|
|
|
KUS
|
|
VTS
|
Ss-type trans.Vertex
|
|
A
|
1
|
|
|
|
KUS
|
