Table VSORDERC
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
VSORDERC | VOC | Cumulative sales order history | Sales |
Key | Description | Duplicates | Activity code |
---|---|---|---|
VOC0 | SOHNUM+ITMREVNUM+SOPLIN | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
BPAADD | Delivery address | ADR | ||||||
BPCORD | Sold-to | BPC | [BPC]BPC0=[VOC]BPCORD | Other | ||||
BPIEECNUM | EU identification | A | 20 | DEB | ||||
CPLAMT | Actual amount | MD1 | ||||||
CPY | Company | CPY | [CPY]CPY0=[VOC]CPY | Block | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
CUMDATEAR | Cumulative customer start date | D | ||||||
CUSORDREF | Customer order ref | A | 20 | |||||
DLVQTYCUM | Total delivered | QTY | ||||||
DSPPRC | Weekly quantity split | 7 | C | 3 | ||||
EARDAT | Calculated early / late date | D | ||||||
EARDATCUS | Customer early/late date | D | ||||||
EARHOU | Calculated early / late time | HM | ||||||
EARHOUCUS | Customer early/late time | HM | ||||||
EARQTY | Calculated early / late quanti | QTY | ||||||
EARQTYCUS | Customer early/late qty | QTY | ||||||
ECCVALMAJ | Major version | ECS | ECC | |||||
ECCVALMIN | Minor version | EVL | ECC | |||||
EECICT | Incoterm | ICT | [ICTH]ICT0=[VOC]EECICT | Block | ||||
EECLOC | Intrastat transport location | M | 15 | 236 | DEB | |||
EXTAMT | Expected amount | MD1 | ||||||
EXTQTY | Planned quantity | QTY | ||||||
FFWADD | Forwarding agent address | ADR | ||||||
FFWNUM | Freight agent | BPT | [BPT]BPT0=[VOC]FFWNUM | Block | ||||
FIMHOR | Firm horizon | C | 4 | |||||
ICTCTY | Incoterm town | CTY | ||||||
ITMDES | Description | DES | ||||||
ITMDES1 | Description | DES | ||||||
ITMDESBPC | Customer description | DES | ||||||
ITMREF | Product | ITM | [ITM]ITM0=[VOC]ITMREF | Block | ||||
ITMREFBPC | Customer product | A | 20 | |||||
ITMREVNUM | Revision no. | C | 4 | |||||
ORDQTYCUM | Total ordered | QTY | ||||||
PJT | Project | PJT | [PIM]PIM0=[VOC]PJT | Block | ||||
PLI | Price list code | SPC | [SPC]SPC0=[VOC]PLI | Other | ||||
REVCOD | Revision code | A | 1 | |||||
SALFCY | Sales site | FCY | [FCY]FCY0=[VOC]SALFCY | Block | ||||
SAU | Sales unit | UOM | [TUN]TUN0=[VOC]SAU | Block | ||||
SAUSTUCOE | SAL-STK conv. | COE | ||||||
SOCTEX | Product text | TXC | ||||||
SOHNUM | Order no. | VCR | ||||||
SOPLIN | Line | L | 8 | |||||
SSTCOD | SST tax code | ADI | [ADI]CODE=203;SSTCOD | Block | LTA | |||
STOFCY | Shipment site | FCY | [FCY]FCY0=[VOC]STOFCY | Block | ||||
STU | Stock unit | UOM | [TUN]TUN0=[VOC]STU | Block | ||||
TSICOD | Statistical group | ADI | [ADI]CODE=indice+20;TSICOD(indice) | Other | STI | |||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 | |||||
USEPLC | Location reference | A | 30 | |||||
VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Block | ||||
VACITM | Tax level | 3 | TVI | [TVI]TVI0=VACITM(indice);[V]GSUPCLE | Block | |||
VAT | Tax | 3 | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Block | |||
VLYDATITM | Validity date | D |