Table VSQUOTE
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| VSQUOTE | VQH | Sales quote history - header | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SQH0 | SQHNUM+REVNUM | No | |
| SQH1 | BPCORD+CUSQUOREF | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADRVAL | Validated | M | 4 | 1 | LTA | |||
| AMTTAX | Tax amount | MD1 | KUS | |||||
| APPFLG | Signed | M | 15 | 280 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BASTAX | Tax basis | MD1 | KUS | |||||
| BPAADD | Delivery address | ADR | ||||||
| BPAORD | Order addr code | ADR | ||||||
| BPCADDLIG | Address | 3 | ADL | |||||
| BPCCRY | Country | CRY | [TCY]TCY0=[VQH]BPCCRY | Block | ||||
| BPCCRYNAM | Country name | NCY | ||||||
| BPCCTY | City | CTY | ||||||
| BPCNAM | Customer name | 2 | NAM | |||||
| BPCORD | Customer | BPR | [BPR]BPR0=[VQH]BPCORD | Block | ||||
| BPCPOSCOD | Postal code | POS | ||||||
| BPCSAT | Order state | SAT | ||||||
| BPDADDLIG | Delivery address | 3 | ADL | |||||
| BPDCRY | Delivery country | CRY | [TCY]TCY0=[VQH]BPDCRY | Block | ||||
| BPDCRYNAM | Delivery country name | NCY | ||||||
| BPDCTY | Delivery city | CTY | ||||||
| BPDNAM | Ship-to customer name | 2 | NAM | |||||
| BPDPOSCOD | Deliv postal code | POS | ||||||
| BPDSAT | Delivery country | SAT | ||||||
| BPIEECNUM | EU identification | A | 20 | DEB | ||||
| CCE | Dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CFMLINNBR | Number of validated lines | C | 4 | |||||
| CHGRAT | Currency rate | DCB | 5.6 | |||||
| CHGTYP | Rate type | M | 15 | 202 | ||||
| CNCNAM | Order contact | AIN | [AIN]AIN0=CNCNAM | Block | ||||
| CNDNAM | Delivery contact | AIN | [AIN]AIN0=CNDNAM | Block | ||||
| COPNBR | No. copies quote | C | 1 | |||||
| CPY | Company | CPY | [CPY]CPY0=[VQH]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[VQH]CUR | Block | ||||
| CURREVFLG | Current revision | M | 4 | 1 | ||||
| CUSQUOREF | Quote reference | A | 20 | |||||
| DAYLTI | Delivery LT in days | C | 3 | |||||
| DEP | Settlement discount | TDA | [TDA]TDA0=DEP;[V]GSUPCLE | Block | ||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[VQH]DIE | Block | ANA | |||
| DISCRGTYP | Discount / charge type | M | 10 | 255 | SPR | |||
| DSPTOTQTY | Quantity total | DCB | 9.6 | |||||
| DSPTOTVOL | Volume aggregation | QTY | ||||||
| DSPTOTWEI | Weight aggregation | QTY | ||||||
| DSPVOU | Volume unit | UOM | [TUN]TUN0=[VQH]DSPVOU | Block | ||||
| DSPWEU | Weight unit | UOM | [TUN]TUN0=[VQH]DSPWEU | Block | ||||
| EECICT | Incoterm | ICT | [ICTH]ICT0=[VQH]EECICT | Block | ||||
| EECLOC | Intrastat transport location | M | 15 | 236 | DEB | |||
| EXPNUM | Export number | L | 8 | |||||
| FFWADD | Forwarding agent address | ADR | ||||||
| FFWNUM | Freight agent | BPT | [BPT]BPT0=[VQH]FFWNUM | Block | ||||
| GEOCOD | Geographic code | GEO | KUS | |||||
| ICTCTY | Incoterm town | CTY | ||||||
| INSCTYFLG | City interior flag | A | 1 | KUS | ||||
| INVDTA | Invoicing element | SFI | [SFI]SFI0=[VQH]INVDTA | Other | SFI | |||
| INVDTAAMT | % or amt inv el | DCB | 11.4 | SFI | ||||
| INVDTADSP | Distrib key | DSP | [DSP]DSP0=INVDTADSP;1 | Other | SFI | |||
| INVDTALIN | Invoice line element | C | 2 | SPR | ||||
| INVDTATYP | Value type | M | 6 | 2227 | SFI | |||
| LAN | Language | LAN | [TLA]TLA0=[VQH]LAN | Block | ||||
| LINNBR | Number of lines | C | 4 | |||||
| ORDDAT | Order date | D | ||||||
| ORDNBR | Number of orders | C | 2 | |||||
| PBYPRC | Probability % | C | 3 | |||||
| PFMTOT | Total margin | MD1 | ||||||
| PJT | Project | PJT | [PIM]PIM0=[VQH]PJT | Block | ||||
| PLISTC | Structure code | PRS | [PRS]PRS0=1;PLISTC | Other | ||||
| PRFNUM | Proforma invoice no. | VCR | ||||||
| PRITYP | Price - / +tax | M | 6 | 243 | ||||
| PTE | Payment term | PTE | [TPT]TPT0=PTE;[V]GCURLEG;1 | Block | ||||
| QUOATI | Line amt. + tax | MD1 | ||||||
| QUOATIL | Line amt. + tax (company) | MD1 | ||||||
| QUODAT | Quote date | D | ||||||
| QUOINVATI | Valuation + tax | MD1 | ||||||
| QUOINVATIL | Costing tax incl. cy | MD1 | ||||||
| QUOINVNOT | Valuation - tax | MD1 | ||||||
| QUOINVNOTL | Costing tax excl. cy | MD1 | ||||||
| QUONOT | Line amt. - tax | MD1 | ||||||
| QUONOTL | Line amt. - tax (company) | MD1 | ||||||
| QUOPRN | Printed quote | M | 4 | 1 | ||||
| QUOSTA | Quote status | M | 15 | 430 | ||||
| REP | Sales rep | REP | [REP]REP0=[VQH]REP | Block | REP | |||
| REVCOD | Revision code | A | 1 | |||||
| REVNUM | Revision no. | C | 4 | |||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[VQH]SALFCY | Block | ||||
| SFISSTCOD | SST tax code | ADI | [ADI]CODE=203;SFISSTCOD | Block | SFI | |||
| SINUM | Integrale part no. | A | 10 | SMI | ||||
| SOHNUM | Order no. | VCR | ||||||
| SOHTYP | Order type | TSO | [TSO]TSO0=SOHTYP;[V]GSUPCLE | Block | ||||
| SQHCFMFLG | Electronic signature | M | 4 | 1 | KPO | |||
| SQHNUM | Quote no. | VCR | ||||||
| SQHNUMEND | Final number | VCR | KPO | |||||
| SQHTEX1 | Quote header text | TXC | ||||||
| SQHTEX2 | Quote footer text | TXC | ||||||
| SQHTYP | Quote type | TSQ | [TSQ]TSQ0=SQHTYP;[V]GSUPCLE | Block | ||||
| SQHVALDAT | Validation date | D | KPO | |||||
| SSTENTCOD | Entity/Use | ADI | [ADI]CODE=202;SSTENTCOD | Block | LTA | |||
| STOFCY | Shipment site | FCY | [FCY]FCY0=[VQH]STOFCY | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Block | ||||
| VLYDAT | Validity date | D | ||||||
| VTT | Vertex transaction type | A | 1 | KUS |