Table PRETURN
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PRETURN | PNH | Returns | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PNH0 | PNHNUM | No | |
| PNH1 | BPSNUM+RTNDAT | Yes | |
| PNH2 | RTNDAT+PNHNUM | No | |
| PNH3 | CPY+EECNUMDEB+RTNDAT | Yes | DEB |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ARVDATR | Arrival date | D | ||||||
| ATDTCODR | AT code | A | 100 | KPO | ||||
| AUUID | Single identifier | AUUID | ||||||
| AUZNUM | Authorization number | A | 15 | |||||
| BETCPY | Intercompany | M | 4 | 1 | ||||
| BETFCY | Intersites | M | 4 | 1 | ||||
| BOLNUM | BOL number | VCR | ||||||
| BPAADD | Address | ADR | ||||||
| BPAADDLIG | Address line | 3 | ADL | |||||
| BPAINV | Billing address | ADR | ||||||
| BPAPAY | Pay-to BP address | ADR | ||||||
| BPRNAM | Company name | 2 | NAM | |||||
| BPRPAY | Pay-to | BPR | [BPR]BPR0=[PNH]BPRPAY | Block | ||||
| BPSINV | Bill-by BP | BPR | [BPR]BPR0=[PNH]BPSINV | Block | ||||
| BPSNUM | Supplier | BPR | [BPR]BPR0=[PNH]BPSNUM | Block | ||||
| BPTNUM | Carrier | BPT | [BPT]BPT0=[PNH]BPTNUM | Block | ||||
| BUY | Buyer | AUS | [AUS]CODUSR=[PNH]BUY | Block | ||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CFMFLG | Posted | M | 4 | 1 | ||||
| COPNBR | No. copies return note | C | 1 | |||||
| CPY | Company | CPY | [CPY]CPY0=[PNH]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[PNH]CRY | Block | ||||
| CRYNAM | Country name | NCY | ||||||
| CTY | City | CTY | ||||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[PNH]DIE | Block | ANA | |||
| DPEDATR | Departure date | D | ||||||
| EECICT | Incoterm | ICT | [ICTH]ICT0=[PNH]EECICT | Block | ||||
| EECLOC | Intrastat transport location | M | 15 | 236 | DEB | |||
| EECNAT | Transaction nature | TEC | [TEC]TEC0=EECNAT;[V]GSUPCLE | Block | DEB | |||
| EECNUM | EU identification | A | 20 | DEB | ||||
| EECNUMDEB | EU Intrastat | C | 4 | DEB | ||||
| EECSCH | Intrastat rule | TSC | [TSC]TSC0=EECSCH;[V]GSUPCLE | Block | DEB | |||
| EECTRN | Intrastat transp. mode | M | 15 | 237 | DEB | |||
| ENTCOD | Stock auto journal | GAU | [GAU]GAU0=[PNH]ENTCOD | Block | ||||
| ETAR | Arrival time | HM | ||||||
| ETDR | Departure time | HM | ||||||
| EXPNUM | Export number | L | 8 | |||||
| FFWADD | Forwarding agent address | ADR | ||||||
| FFWNUM | Freight agent | BPT | [BPT]BPT0=[PNH]FFWNUM | Block | ||||
| ICTCTY | Incoterm town | CTY | ||||||
| INVFLG | Invoiced | M | 15 | 280 | ||||
| INVLINNBR | No. invoiced lines | C | 4 | |||||
| LICPLATER | Registration | REGLIC | ||||||
| LINNBR | Number of lines | C | 4 | |||||
| MANDOCR | Manual document | DOC | KPO | |||||
| MDL | Delivery mode | MDL | [TMD]TMD0=[PNH]MDL | Block | ||||
| PJTH | Project | PJT | [PIM]PIM0=[PNH]PJTH | Block | ||||
| PNHFCY | Return site | FCY | [FCY]FCY0=[PNH]PNHFCY | Block | ||||
| PNHNUM | Return no. | VCR | ||||||
| PNHTYP | Return type | TPN | [TPN]TPN0=PNHTYP;[V]GSUPCLE | Block | TRSNE | |||
| POSCOD | Postal code | POS | ||||||
| PRNFLG | Printed | M | 4 | 1 | ||||
| PSTDAT | Reversal date | D | ||||||
| PSTFLG | Posted | M | 4 | 1 | ||||
| PSTLINNBR | No. of posted lines | C | 4 | |||||
| PURTYP | Purchase type | M | 15 | 507 | ||||
| REM | Notes | A | 250 | |||||
| RTNDAT | Return date | D | ||||||
| SAT | County | SAT | ||||||
| TEX1 | Text | TXC | ||||||
| TEX2 | Text | TXC | ||||||
| TMPPNHNUM | Return no. | VCR | ||||||
| TOTGROWEI | Gross weight | DCB | 11.4 | |||||
| TOTNETWEI | Net weight | DCB | 11.4 | |||||
| TOTVOL | Volume | DCB | 11.4 | |||||
| TRLLICPLATER | Trailer license plate | REGLIC | ||||||
| TRSCOD | Movement code | ADI | [ADI]CODE=14;TRSCOD | Other | ||||
| TSSCOD | Statistical group | ADI | [ADI]CODE=indice+40;TSSCOD(indice) | Block | STS | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Block | ||||
| VACTYP | Tax rule type | C | 1 | |||||
| VOU | Volume unit | UOM | [TUN]TUN0=[PNH]VOU | Block | ||||
| WEU | Weight unit | UOM | [TUN]TUN0=[PNH]WEU | Block | ||||
| WRHE | Warehouse | WRH | [WRH]WRH0=WRH | Other | WRH |