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 |