Table SDELIVERYD
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SDELIVERYD | SDD | Delivery detail | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SDD0 | SDHNUM+SDDLIN | No | |
| SDD1 | SOHNUM+SOPLIN+SOQSEQ | Yes | |
| SDD2 | ITMREF+SHIDAT+SDHNUM | Yes | |
| SDD3 | BPCORD+BPAADD+ITMREF | Yes | |
| SDD4 | SDHNUM-SDDLIN | 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 | BPD | [BPD]BPD0=BPCORD;BPAADD | Other | ||||
| BPCORD | Sold-to | BPC | [BPC]BPC0=[SDD]BPCORD | Other | ||||
| CLCAMT1 | Tax calculation basis 1 | MD1 | ||||||
| CLCAMT2 | Tax calculation basis 2 | MD1 | ||||||
| CPRPRI | Cost price | MD8 | ||||||
| CPY | Company | CPY | [CPY]CPY0=[SDD]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DDTANOT | Invoice line allocation elemen | MD1 | SFL | |||||
| DDTANUM | Invoice line allocation elemen | SFI | [SFI]SFI0=[SDD]DDTANUM | Block | SFL | |||
| DISCRGREN1 | Discount 1 reason | SPR | [SPR]SPR0=[SDD]DISCRGREN1 | Block | SP1 | |||
| DISCRGREN2 | Discount 2 reason | SPR | [SPR]SPR0=[SDD]DISCRGREN2 | Block | SP2 | |||
| DISCRGREN3 | Discount 3 reason | SPR | [SPR]SPR0=[SDD]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 | ||||
| DSPLINFLG | Distribution | M | 4 | 1 | ||||
| DSPLINVOL | Line volume | QTY | ||||||
| DSPLINWEI | Line weight | QTY | ||||||
| DSPVOU | Volume unit | UOM | [TUN]TUN0=[SDD]DSPVOU | Block | ||||
| DSPWEU | Weight unit | UOM | [TUN]TUN0=[SDD]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=[SDD]ITMREF | Block | ||||
| LINCFMFLG | Validated line | M | 4 | 1 | ||||
| LINTYP | Line type | M | 15 | 423 | ||||
| LOC | Location filter | LOC | [STC]STC0=STOFCY;LOC | Other | ||||
| LOT | Filter lot | LOT | ||||||
| NDEPRNBOM | PS print component | M | 4 | 1 | ||||
| NETPRI | Net price | MD8 | ||||||
| NETPRIATI | Net price + tax | MD8 | ||||||
| NETPRINOT | Net price - tax | MD8 | ||||||
| OALQTYSTU | Order qty alloc. STU | QTY | ||||||
| ORILIN | Free line source | L | 8 | |||||
| PACQTYSTU | Qty packed SAL | QTY | ||||||
| PCK | Packaging | PCK | [TPA]TPA0=[SDD]PCK | Block | ||||
| PCKCAP | Packaging capacity | COE | ||||||
| PCKFLG | Packing | M | 4 | 1 | ||||
| PFM | Margin | MD1 | ||||||
| PJT | Project | PJT | [PIM]PIM0=[SDD]PJT | Block | ||||
| PRELIN | Preparation line | L | 8 | |||||
| PRHNUM | Pick ticket | VCR | ||||||
| PRIREN | Price reason | SPR | [SPR]SPR0=[SDD]PRIREN | Block | ||||
| PRPTEX | Picking ticket line text | TXC | ||||||
| QTY | Delivered quantity | QTY | ||||||
| QTYSTU | Delivered quantity STU | QTY | ||||||
| RATTAXLIN | Tax rates | RAT | KUS | |||||
| RCPFLG | Shipment inquiry | C | 1 | |||||
| RCPQTYSTU | Received STK | QTY | ||||||
| REP1 | Sales rep 1 | REP | [REP]REP0=[SDD]REP1 | Block | RE1 | |||
| REP2 | Sales rep 2 | REP | [REP]REP0=[SDD]REP2 | Block | RE2 | |||
| REPCOE | Commission factor | CCR | ||||||
| REPRAT1 | Commission rate 1 | RAT | RE1 | |||||
| REPRAT2 | Commission rate 2 | RAT | RE2 | |||||
| RTNQTY | Return quantity | QTY | ||||||
| RTNQTYSTU | Return quantity STK | QTY | ||||||
| SAU | Sales unit | UOM | [TUN]TUN0=[SDD]SAU | Block | ||||
| SAUSTUCOE | SAL-STK conv. | COE | ||||||
| SDDLIN | Delivery line | L | 8 | |||||
| SDDTEX | Packing slip line text | TXC | ||||||
| SDHCAT | Delivery category | M | 20 | 490 | ||||
| SDHNUM | Delivery no. | VCR | ||||||
| SHIDAT | Shipment date | D | ||||||
| SOHCAT | Order category | M | 15 | 412 | ||||
| SOHNUM | Order no. | VCR | ||||||
| SOPLIN | Order line | L | 8 | |||||
| SOQSEQ | Sequence number | L | 8 | |||||
| SSTCOD | SST tax code | ADI | [ADI]CODE=203;SSTCOD | Block | LTA | |||
| STA | Filter status | A | 12 | |||||
| STOFCY | Shipment site | FCY | [FCY]FCY0=[SDD]STOFCY | Block | ||||
| STOMGTCOD | Stock management | M | 15 | 215 | ||||
| STU | Stock unit | UOM | [TUN]TUN0=[SDD]STU | Block | ||||
| TAXFLG | Taxable flag | M | 4 | 1 | KUS | |||
| TAXGEOFLG | Taxed geo flag | A | 1 | KUS | ||||
| TAXREGFLG | Recorded tax flag | M | 4 | 1 | KUS | |||
| TSICOD | Statistical group | ADI | [ADI]CODE=indice+20;TSICOD(indice) | Other | STI | |||
| UNTWEI | Unit weight | WEI | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| USEPLC | Location reference | A | 30 | |||||
| VACITM | Tax level | 3 | TVI | [TVI]TVI0=VACITM(indice);[V]GSUPCLE | Block | |||
| VAT | Tax | 3 | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Block | |||
| VCRLINORI | Source document line | L | 8 | |||||
| VCRNUMORI | Original document | VCR | ||||||
| VCRSEQORI | Source document sequence no. | L | 8 | |||||
| VCRTYPORI | Source document type | M | 15 | 701 | ||||
| VTC | Vertex transaction code | A | 1 | KUS | ||||
| VTS | Vertex transaction sub-type | A | 1 | KUS | ||||
| WEU | Weight unit | UOM | [TUN]TUN0=[SDD]WEU | Block | ||||
| WRH | Warehouse | WRH | [WRH]WRH0=WRH | Other | WRH | |||
| WRTQTY | Qty waiting return | QTY | ||||||
| WRTQTYSTU | Qty wtg ret STK | QTY |