Table UPORDER
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| UPORDER | UOH | PO history | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| POH0 | POHNUM+REVNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| APPFLG | Signed | M | 15 | 280 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BETCPY | Intercompany | M | 4 | 1 | ||||
| BETFCY | Intersites | M | 4 | 1 | ||||
| BPAADD | Address | ADR | ||||||
| BPAADDLIG | Address line | 3 | ADL | |||||
| BPAINV | Billing address | ADR | ||||||
| BPAPAY | Pay-to BP address | ADR | ||||||
| BPCORD | Sold-to | BPR | [BPR]BPR0=[UOH]BPCORD | Block | ||||
| BPOADD | Ship-from address | ADR | ||||||
| BPOADDLIG | Address line | 3 | ADL | |||||
| BPOCRY | Country | CRY | [TCY]TCY0=[UOH]BPOCRY | Block | ||||
| BPOCRYNAM | Country name | NCY | ||||||
| BPOCTY | City | CTY | ||||||
| BPONAM | Company name | 2 | NAM | |||||
| BPOPOSCOD | Postal code | POS | ||||||
| BPOSAT | County | SAT | ||||||
| BPRNAM | Company name | 2 | NAM | |||||
| BPRPAY | Pay-to | BPR | [BPR]BPR0=[UOH]BPRPAY | Block | ||||
| BPSINV | Supplier invoice | BPR | [BPR]BPR0=[UOH]BPSINV | Block | ||||
| BPSNUM | Supplier | BPR | [BPR]BPR0=[UOH]BPSNUM | Block | ||||
| BPTNUM | Carrier | BPT | [BPT]BPT0=[UOH]BPTNUM | Block | ||||
| BUY | Buyer | AUS | [AUS]CODUSR=[UOH]BUY | Block | ||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CHGCOE | Rate | DCB | 5.6 | |||||
| CHGTYP | Rate type | M | 15 | 202 | ||||
| CLEFLG | Closed | M | 4 | 1 | ||||
| CLELINNBR | No. closed lines | C | 4 | |||||
| COPNBR | No. copies order note | C | 1 | |||||
| CPY | Company | CPY | [CPY]CPY0=[UOH]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[UOH]CRY | Block | ||||
| CRYNAM | Country name | NCY | ||||||
| CTY | City | CTY | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[UOH]CUR | Block | ||||
| CURREVFLG | Current revision | M | 4 | 1 | ||||
| DEP | Settlement discount | TDA | [TDA]TDA0=DEP;[V]GSUPCLE | Block | ||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[UOH]DIE | Block | ANA | |||
| DISCRGTYP | Discount / charge type | M | 10 | 255 | PPR | |||
| DME | Partial delivery | M | 15 | 414 | ||||
| DSPVOU | Volume unit | UOM | [TUN]TUN0=[UOH]DSPVOU | Block | ||||
| DSPWEU | Weight unit | UOM | [TUN]TUN0=[UOH]DSPWEU | Block | ||||
| EECICT | Incoterm | ICT | [ICTH]ICT0=[UOH]EECICT | Block | ||||
| EECLOC | Intrastat transport location | M | 15 | 236 | DEB | |||
| EECNUM | EU identification | A | 20 | DEB | ||||
| ENDDAT | Validity end date | D | ||||||
| EXPNUM | Export number | L | 8 | |||||
| EXTRCPDAT1 | Exp. receipt date | D | ||||||
| FBULINNBR | No. lines > budg | C | 4 | |||||
| FFWADD | Forwarding agent address | ADR | ||||||
| FFWNUM | Freight agent | BPT | [BPT]BPT0=[UOH]FFWNUM | Block | ||||
| FUPFLG | Delivery reminders | M | 4 | 1 | ||||
| GPGCOD | Grouping code | A | 20 | |||||
| ICTCTY | Incoterm town | CTY | ||||||
| INVDTALIN1 | Invoice line element | PFI | [PFI]PFI0=[UOH]INVDTALIN1 | Block | PPR | |||
| INVDTALIN2 | Invoice line allocation elemen | 9 | PFI | [PFI]PFI0=[UOH]INVDTALIN2 | Block | |||
| INVDTAVAT1 | Price line tax | VAT | [TVT]TVT0=INVDTAVAT1(indice);[V]GSUPCLE | Block | PPR | |||
| INVDTAVAT2 | Distribution line tax | 9 | VAT | [TVT]TVT0=INVDTAVAT2(indice);[V]GSUPCLE | Block | |||
| INVFCY | Invoicing site | FCY | [FCY]FCY0=[UOH]INVFCY | Block | ||||
| INVFLG | Invoiced | M | 15 | 280 | ||||
| INVLINNBR | No. invoiced lines | C | 4 | |||||
| INVNBR | Number of invoices | L | 8 | |||||
| LAN | Language | LAN | [TLA]TLA0=[UOH]LAN | Block | ||||
| LINNBR | Number of lines | C | 4 | |||||
| MDL | Delivery mode | MDL | [TMD]TMD0=[UOH]MDL | Block | ||||
| OCNDAT | Ack. date | D | ||||||
| OCNFLG | Ack. reminder | M | 4 | 1 | ||||
| OCNNUM | Ack. ID | A | 20 | |||||
| OCNREM | Ack. notes | A | 150 | |||||
| ORDDAT | Order date | D | ||||||
| ORDMAXAMT | Maximum order | MD1 | ||||||
| ORDREF | Internal reference | A | 20 | |||||
| ORIFCY | Original site | FCY | [FCY]FCY0=[UOH]ORIFCY | Block | ||||
| PJTH | Project | PJT | [PIM]PIM0=[UOH]PJTH | Block | ||||
| POHFCY | Order site | FCY | [FCY]FCY0=[UOH]POHFCY | Block | ||||
| POHNUM | Order no. | VCR | ||||||
| POHTYP | Order type | M | 20 | 506 | ||||
| POSCOD | Postal code | POS | ||||||
| PRNFLG | Printed | M | 4 | 1 | ||||
| PTE | Payment term | PTE | [TPT]TPT0=PTE;[V]GCURLEG;1 | Block | ||||
| PURTYP | Purchase type | M | 15 | 507 | ||||
| RCPFCY | Receiving site | FCY | [FCY]FCY0=[UOH]RCPFCY | Block | ||||
| RCPFLG | Received | M | 15 | 280 | ||||
| RCPLINNBR | No. received lines | C | 4 | |||||
| RCPNBR | Number of receipts | L | 8 | |||||
| REVCOD | Revision code | A | 1 | |||||
| REVNUM | Revision no. | C | 4 | |||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[UOH]SALFCY | Block | ||||
| SAT | County | SAT | ||||||
| SINUM | Integrale part no. | A | 10 | SMI | ||||
| SOHCAT | Order category | M | 15 | 412 | ||||
| STOFCY | Shipment site | FCY | [FCY]FCY0=[UOH]STOFCY | Block | ||||
| STRDAT | Validity start date | D | ||||||
| TCTRNUM | Container | TCTR | [TCTR]TCTR0=[UOH]TCTRNUM | Block | ||||
| TCTRQTY | No. of containers | C | 4 | |||||
| TEX1 | Text | TXC | ||||||
| TEX2 | Text | TXC | ||||||
| TOTLINAMT | Invoice lines excluding tax | MD1 | ||||||
| TOTLINATI | Lines total incl-tax | MD1 | ||||||
| TOTLINQTY | Total quantity lines | DCB | 11.6 | |||||
| TOTLINVOU | Line volume total | QTY | ||||||
| TOTLINWEU | Line weight total | QTY | ||||||
| TOTORD | Total order -tax | MD1 | ||||||
| TOTORDL | Total excl. tax (co currency) | MD1 | ||||||
| TOTTAXAMT | Tax total | MD1 | ||||||
| TOTVLT | Expected total -tax | MD1 | ||||||
| TSSCOD | Statistical group | ADI | [ADI]CODE=indice+40;TSSCOD(indice) | Other | STS | |||
| TTVORD | Total order +tax | MD1 | ||||||
| TTVORDL | Tax incl. total cy currency | MD1 | ||||||
| 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 | |||||
| VOLCAP | Volume | QTY | ||||||
| WEICAP | Weight | QTY |