Table SORDERC
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SORDERC | SOC | Sales orders - early / late | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SOC0 | SOHNUM+SOPLIN | No | |
| SOC1 | BPCORD+BPAADD+ITMREF | Yes | |
| SOC2 | CUSORDREF+BPCORD+BPAADD+ITMREFBPC | 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=[SOC]BPCORD | Other | ||||
| BPIEECNUM | EU identification | A | 20 | DEB | ||||
| CPLAMT | Actual amount | MD1 | ||||||
| CPY | Company | CPY | [CPY]CPY0=[SOC]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=[SOC]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=[SOC]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=[SOC]ITMREF | Block | ||||
| ITMREFBPC | Customer product | A | 20 | |||||
| ITMREVNUM | Revision no. | C | 4 | |||||
| ORDQTYCUM | Total ordered | QTY | ||||||
| PJT | Project | PJT | [PIM]PIM0=[SOC]PJT | Block | ||||
| PLI | Price list code | SPC | [SPC]SPC0=[SOC]PLI | Other | ||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[SOC]SALFCY | Block | ||||
| SAU | Sales unit | UOM | [TUN]TUN0=[SOC]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=[SOC]STOFCY | Block | ||||
| STU | Stock unit | UOM | [TUN]TUN0=[SOC]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 |