Table PORDERP
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
PORDERP | POP | POs price | Purchasing |
Key | Description | Duplicates | Activity code |
---|---|---|---|
POP0 | POHNUM+POPLIN+POPSEQ | No | |
POP1 | POHNUM+POPLIN+POPDAT | No | |
POP2 | PRHFCY+POHNUM+POPLIN | Yes | |
POP3 | ITMREF+POHTYP | Yes | |
PJMPJT1 | PJT | Yes | PJM |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
CPY | Company | CPY | [CPY]CPY0=[POP]CPY | Block | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
DISCRGREN1 | Discount 1 reason | PPR | [PPR]PPR0=[POP]DISCRGREN1 | Block | PP1 | |||
DISCRGREN2 | Discount 2 reason | PPR | [PPR]PPR0=[POP]DISCRGREN2 | Block | PP2 | |||
DISCRGREN3 | Discount 3 reason | PPR | [PPR]PPR0=[POP]DISCRGREN3 | Block | PP3 | |||
DISCRGREN4 | Discount 4 reason | C | 4 | PP4 | ||||
DISCRGREN5 | Discount 5 reason | C | 4 | PP5 | ||||
DISCRGREN6 | Discount 6 reason | C | 4 | PP6 | ||||
DISCRGREN7 | Discount 7 reason | C | 4 | PP7 | ||||
DISCRGREN8 | Discount 8 reason | C | 4 | PP8 | ||||
DISCRGREN9 | Discount 9 reason | C | 4 | PP9 | ||||
DISCRGVAL1 | Discount/Charge 1 | MD8 | PP1 | |||||
DISCRGVAL2 | Discount/Charge 2 | MD8 | PP2 | |||||
DISCRGVAL3 | Discount/Charge 3 | MD8 | PP3 | |||||
DISCRGVAL4 | Discount/Charge 4 | DCB | 19.8 | PP4 | ||||
DISCRGVAL5 | Discount/Charge 5 | DCB | 19.8 | PP5 | ||||
DISCRGVAL6 | Discount/Charge 6 | DCB | 19.8 | PP6 | ||||
DISCRGVAL7 | Discount/Charge 7 | DCB | 19.8 | PP7 | ||||
DISCRGVAL8 | Discount/Charge 8 | DCB | 19.8 | PP8 | ||||
DISCRGVAL9 | Discount/Charge 9 | DCB | 19.8 | PP9 | ||||
EECINCRAT | Intrastat increase | RAT | DEB | |||||
EXPNUM | Export number | L | 8 | |||||
FCYADD | Receipt address | ADR | ||||||
GROPRI | Gross price | MD8 | ||||||
ITMDES | Description | DES | ||||||
ITMDES1 | Description | DES | ||||||
ITMREF | Product | ITM | [ITM]ITM0=[POP]ITMREF | Block | ||||
LINBUY | Buyer | AUS | [AUS]CODUSR=[POP]LINBUY | Block | ||||
LINREVNUM | Revision no. | C | 4 | |||||
MATTOL | Matching tolerance | MAT | [MAT]MAT0=[POP]MATTOL | Block | ||||
NETPRI | Net price | MD8 | ||||||
ORICRY | Country of origin | CRY | [TCY]TCY0=[POP]ORICRY | Block | ||||
PJT | Project | PJT | [PIM]PIM0=[POP]PJT | Block | ||||
POHNUM | Order no. | VCR | ||||||
POHTYP | Order type | M | 20 | 506 | ||||
POPCREFLG | Creation flag | M | 4 | 1 | ||||
POPDAT | Application end date | D | ||||||
POPLIN | Line | L | 8 | |||||
POPSEQ | Sequence | L | 8 | |||||
PRHFCY | Receiving site | FCY | [FCY]FCY0=[POP]PRHFCY | Block | ||||
PRIREN | Price reason | PPR | [PPR]PPR0=[POP]PRIREN | Block | ||||
QUAFLG | QC management | M | 4 | 1 | ||||
STRDAT | Price effectivity date | D | ||||||
TAXISS | Issue tax | VAT | [TVT]TVT0=TAXISS;[V]GSUPCLE | Block | PTX | |||
TAXOTH1 | Other tax 1 | VAT | [TVT]TVT0=TAXOTH1;[V]GSUPCLE | Block | PTX | |||
TAXOTH2 | Other tax 2 | VAT | [TVT]TVT0=TAXOTH2;[V]GSUPCLE | Block | PTX | |||
TAXRCP | Receipt tax | VAT | [TVT]TVT0=TAXRCP;[V]GSUPCLE | Block | PTX | |||
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 | |||||
VAT | Tax | 3 | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Block |