Table SQUOTED
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SQUOTED | SQD | Quote detail | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SQD0 | SQHNUM+SQDLIN | No | |
| SQD1 | ORDFLG+SALFCY+BPCORD | Yes | |
| PJMPJT1 | PJT | Yes | PJM |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BASTAXLIN | Taxable amount | MD1 | KUS | |||||
| BPAADD | Delivery address | ADR | ||||||
| BPCORD | Sold-to | BPC | [BPC]BPC0=[SQD]BPCORD | Other | ||||
| CLCAMT1 | Tax calculation basis 1 | MD1 | ||||||
| CLCAMT2 | Tax calculation basis 2 | MD1 | ||||||
| CNDNAM | Delivery contact | AIN | [AIN]AIN0=CNDNAM | Block | ||||
| CPRPRI | Cost price | MD8 | ||||||
| CPY | Company | CPY | [CPY]CPY0=[SQD]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DAYLTI | Delivery LT in days | C | 3 | |||||
| DDTANOT | Invoice line allocation elemen | MD1 | SFL | |||||
| DDTANUM | Invoice line allocation elemen | SFI | [SFI]SFI0=[SQD]DDTANUM | Block | SFL | |||
| DISCRGREN1 | Discount 1 reason | SPR | [SPR]SPR0=[SQD]DISCRGREN1 | Block | SP1 | |||
| DISCRGREN2 | Discount 2 reason | SPR | [SPR]SPR0=[SQD]DISCRGREN2 | Block | SP2 | |||
| DISCRGREN3 | Discount 3 reason | SPR | [SPR]SPR0=[SQD]DISCRGREN3 | Block | SP3 | |||
| DISCRGREN4 | Discount 4 reason | C | 4 | SP4 | ||||
| DISCRGREN5 | Discount 5 reason | C | 4 | SP5 | ||||
| DISCRGREN6 | Discount 6 reason | C | 4 | SP6 | ||||
| DISCRGREN7 | Discount 7 reason | C | 4 | SP7 | ||||
| DISCRGREN8 | Discount 8 reason | C | 4 | SP8 | ||||
| DISCRGREN9 | Discount 9 reason | C | 4 | SP9 | ||||
| DISCRGVAL1 | Discount/Charge 1 | MD8 | SP1 | |||||
| DISCRGVAL2 | Discount/Charge 2 | MD8 | SP2 | |||||
| DISCRGVAL3 | Discount/Charge 3 | MD8 | SP3 | |||||
| DISCRGVAL4 | Discount/Charge 4 | DCB | 19.8 | SP4 | ||||
| DISCRGVAL5 | Discount/Charge 5 | DCB | 19.8 | SP5 | ||||
| DISCRGVAL6 | Discount/Charge 6 | DCB | 19.8 | SP6 | ||||
| DISCRGVAL7 | Discount/Charge 7 | DCB | 19.8 | SP7 | ||||
| DISCRGVAL8 | Discount/Charge 8 | DCB | 19.8 | SP8 | ||||
| DISCRGVAL9 | Discount/Charge 9 | DCB | 19.8 | SP9 | ||||
| DLVFLG | Deliverable | M | 4 | 1 | ||||
| DSPLINFLG | Distribution | M | 4 | 1 | ||||
| DSPLINVOL | Line volume | QTY | ||||||
| DSPLINWEI | Line weight | QTY | ||||||
| DSPVOU | Volume unit | UOM | [TUN]TUN0=[SQD]DSPVOU | Block | ||||
| DSPWEU | Weight unit | UOM | [TUN]TUN0=[SQD]DSPWEU | Block | ||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| EXPNUM | Export number | L | 8 | |||||
| FOCFLG | Free | M | 10 | 439 | ||||
| GEOCOD | Geographic code | GEO | KUS | |||||
| GROPRI | Gross price | MD8 | ||||||
| IMPNUMLIG | Import line | L | 8 | |||||
| INSCTYFLG | City interior flag | A | 1 | KUS | ||||
| INVPRNBOM | Print component on invoice | M | 4 | 1 | ||||
| ITMDES | Description | DES | ||||||
| ITMDES1 | Description | DES | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[SQD]ITMREF | Block | ||||
| LINREVNUM | Revision no. | C | 4 | |||||
| LINTYP | Line type | M | 15 | 423 | ||||
| NDEPRNBOM | PS print component | M | 4 | 1 | ||||
| NETPRI | Net price | MD8 | ||||||
| NETPRIATI | Net price + tax | MD8 | ||||||
| NETPRINOT | Net price - tax | MD8 | ||||||
| OCNPRNBOM | Print component on acknowledgement | M | 4 | 1 | ||||
| ORDFLG | Ordered | M | 4 | 1 | ||||
| ORDQTY | Ordered qty. | QTY | ||||||
| ORILIN | Free line source | L | 8 | |||||
| PFM | Margin | MD1 | ||||||
| PJT | Project | PJT | [PIM]PIM0=[SQD]PJT | Block | ||||
| PRIREN | Price reason | SPR | [SPR]SPR0=[SQD]PRIREN | Block | ||||
| QTY | Quote quantity | QTY | ||||||
| QUODAT | Quote date | D | ||||||
| RATTAXLIN | Tax rates | RAT | KUS | |||||
| REP1 | Sales rep 1 | REP | [REP]REP0=[SQD]REP1 | Block | RE1 | |||
| REP2 | Sales rep 2 | REP | [REP]REP0=[SQD]REP2 | Block | RE2 | |||
| REPCOE | Commission factor | CCR | ||||||
| REPRAT1 | Commission rate 1 | RAT | RE1 | |||||
| REPRAT2 | Commission rate 2 | RAT | RE2 | |||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[SQD]SALFCY | Block | ||||
| SAU | Sales unit | UOM | [TUN]TUN0=[SQD]SAU | Block | ||||
| SAUSTUCOE | SAL-STK conv. | COE | ||||||
| SOHNUM | Order no. | VCR | ||||||
| SOPLIN | Line | L | 8 | |||||
| SQDLIN | Quote line | L | 8 | |||||
| SQDPSONUM | Project doc number | PSO | [PSOH]PSOH0=[SQD]SQDPSONUM | Block | PJM | |||
| SQDSEQNUM | Line | L | 8 | PJM | ||||
| SQDTEX | Line text | TXC | ||||||
| SQHNUM | Quote no. | VCR | ||||||
| SSTCOD | SST tax code | ADI | [ADI]CODE=203;SSTCOD | Block | LTA | |||
| STOFCY | Shipment site | FCY | [FCY]FCY0=[SQD]STOFCY | Block | ||||
| STU | Stock unit | UOM | [TUN]TUN0=[SQD]STU | Block | ||||
| TAXFLG | Taxable flag | M | 4 | 1 | KUS | |||
| TAXGEOFLG | Taxed geo flag | A | 1 | KUS | ||||
| TAXREGFLG | Recorded tax flag | M | 4 | 1 | KUS | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VACITM | Tax level | 3 | TVI | [TVI]TVI0=VACITM(indice);[V]GSUPCLE | Block | |||
| VAT | Tax | 3 | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Block | |||
| VTC | Vertex transaction code | A | 1 | KUS | ||||
| VTS | Vertex transaction sub-type | A | 1 | KUS |