invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

PO_HDR: AccountView Purchase orders

read only per partition

  • Catalogus: AccountView
  • Label: Purchase orders

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel PO_HDR worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
ACCT_NAME varchar2(40) Bedrijfsnaam
ADDRESS1 varchar2(80) Address
APX_LIST varchar2(5) Prijzen per artikel in de prijslijst
AUTH_HIST varchar2(4) Goedkeuringsgeschiedenis
AVG_VAT int64 Average VAT percentage purchase order
BCC_EMAIL varchar2(4) Bcc
BLK_AMT int64 Saldo G-rekening
BV_AMT int64 UWV-bedrag
CC_EMAIL varchar2(4) Cc
CITY varchar2(35) City
CNG_DATE datetime Datum van wijziging
CNG_NR int32 Nummer wijzigen
CNG_USR varchar2(20) Employee last modified
CNT_CODE varchar2(2) ISO country code supplier
CNT_CODE2 varchar2(2) ISO-landcode
COMMENT1 varchar2(40) Purchase order description
COMMENT2 varchar2(4) Externe opmerking
COMMENT3 varchar2(4) Interne opmerking
COST_CODE varchar2(10) Cost centre code
COUNTRY varchar2(30) Country
CPY_PRN varchar2(100) File name copy purchase order
CPY_PRTYPE varchar2(40) Printer type copy purchase order
CRED_DAYS decimal Betalingstermijn in dagen
CRED_LIM_P decimal Credit limitation percentage purchase order
CUR_CODE varchar2(3) Currency code
CUR_UNIT int64 Currency unit purchase order
DEL_ADDR varchar2(4) Afleveradres
DEL_CODE varchar2(10) Delivery address code
DEL_CP varchar2(40) Delivery customer contact
DEL_DATE datetime Leveringsdatum
DEL_PP varchar2(10) Contactpersoonscode
DEL_WEEK int32 Leveringsdatum (week)
DISC_CODE varchar2(2) Code voor betalingstermijn
DISC_DAYS decimal Kortingsperiode in dagen
DISC_DESC varchar2(40) Payment term description
EMP_NR varchar2(10) Buyer
EXCH_RATE decimal Wisselkoers
EXT_DESC varchar2(40) Payment reference
EXT_INV varchar2(10) External document/invoice number
GROSS_FLG char Show base amount incl. VAT
INP_DATE datetime Datum van inschrijving
INP_USR varchar2(20) Entered by employee
INV_ADDR varchar2(4) Invoice address in country-specific layout
INV_CP varchar2(40) Supplier contact
INV_DATE datetime Factuurdatum
INV_NR varchar2(10) Document-/factuurnummer
INV_PP varchar2(10) Contactpersoonscode
INV_WEEK int32 Factuurdatum (week)
INVTP_PROJ char Project purchase order
LB_AMT int64 Bedrag aan loonbelasting
LNG_CODE varchar2(5) Taalcode
ORD_COLL char Order picked
ORD_COMPL char Purchase order fully received
ORD_COST int64 Bestelkosten
ORD_DATE datetime Purch. order date
ORD_KEEP char Recurring order
ORD_NR varchar2(10) Order number
ORD_PROC char Goods partially received
ORD_RECD char Receipts to be processed
ORD_SENT char Op bestelling
ORD_STAT decimal Approval stage
ORD_TOT int64 Order total
ORD_WEEK int32 Purch. order date (week)
PAC_NR varchar2(10) Delivery note number (purchasing)
PAGE_BLK char Purchase order blocked
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PAY_AMT int64 Deposit amount
PAY_TOT int64 Total purchase order amount
PAY_VAT int64 Vooruitbetaling van de btw
PAY_VATC varchar2(2) Vooruitbetaling van de btw-code
PCT_LIST varchar2(5) Prijslijst met kortingspercentages
PD_AMT int64 Bedrag van de betalingskorting
PD_PCT decimal Kortingspercentage bij betaling
PD_VAT int64 BTW op betalingskorting
PO_BOX varchar2(80) Postadres
PO_CITY varchar2(35) Postal address city
PO_CODE varchar2(10) Postadres, postcode
POST_CODE varchar2(10) Postcode
PREF_DATE datetime Beloofde leverdatum
PREF_WEEK int32 Beloofde leveringsdatum (week)
PROJ_CODE varchar2(10) Projectcode
RPL_DEL varchar2(10) Delivery customer
RPL_INV varchar2(10) Supplier
RPL_NAME varchar2(40) Supplier name
SEL_CODE varchar2(5) Selectiecode
SHIP_COST int64 Vervoerskosten
SHIP_MTH varchar2(10) Vervoerswijze
ST_EXTRA varchar2(10) Adres toevoegen
ST_NR varchar2(10) Huisnummer
ST_PROP varchar2(40) Building
ST_REGION varchar2(40) Adresregio
ST_STREET varchar2(60) Street
STAT_DESC varchar2(30) Purchase order status
SUB_TOT int64 Total excl. VAT and payment discount
SUB_TOT_EU int64 Total excl. VAT and payment discount in euros
SUBT_M_DIS int64 Subtotal purchase order (excl. payment discount)
SUBT_P_DIS int64 Subtotal purchase order (incl. payment discount)
SUBT_P_VAT int64 Subtotal purchase order (incl.VAT)
TO_EMAIL varchar2(4) To
TOT_ADM int64 Order total in administration currency
TOT_EUR int64 Order total in euros
TOT_HOME int64 Order total in country currency
VAT_ORD int64 BTW-bedrag op bestelkosten
VAT_SHIP int64 BTW-bedrag over transportkosten
VAT_TOT int64 VAT total
VAT_TOT_EU int64 VAT total in euros
VC_ORD varchar2(2) BTW-code voor bestelkosten
VC_SHIP varchar2(2) BTW-code transportkosten