invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYS_EXPN: AccountView General expressions

read only per partition

  • Katalog: AccountView
  • Label: General expressions

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SYS_EXPN sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
ACCT_NAME varchar2(40) Administration company name
ADDRESS varchar2(80) Administration business postal address
ADDRESS2 varchar2(80) Administration business visiting address
COPIES decimal Total number of copies
CUR_AMT1 int64 Amount payment method 1
CUR_AMT2 int64 Amount payment method 2
CUR_AMT3 int64 Amount payment method 3
CUR_AMT4 int64 Amount payment method 4
DATE datetime Date
LOGIN_NAME varchar2(40) Full name of logged-in user
LONG_DATE varchar2(40) System date in full
PAGENUMBER decimal Page number
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PAY_AMT int64 Deposit amount
PAY_CUR1 varchar2(10) Currency payment method 1
PAY_CUR2 varchar2(10) Currency payment method 2
PAY_CUR3 varchar2(10) Currency payment method 3
PAY_CUR4 varchar2(10) Currency payment method 4
PAY_METH1 varchar2(30) Payment method 1
PAY_METH2 varchar2(30) Payment method 2
PAY_METH3 varchar2(30) Payment method 3
PAY_METH4 varchar2(30) Payment method 4
SI_ARTPX varchar2(20) Sales price per piece sales invoice lines
SI_TINVQTY varchar2(20) Quantity to invoice sales invoice lines
SOL_ARTPX varchar2(20) Sales price per piece sales order lines (layout)
SOL_ARTQTY varchar2(20) Quantity to deliver sales order lines (layout)
SOL_ORDQTY varchar2(20) Quantity ordered sales order lines (layout)
TIME varchar2(8) Time
TOT_PAY int64 Paid
TRIAL varchar2(20) Draft document
TXT_VISADD varchar2(20) Visiting address text
VAT_C_1 int64 VAT amt code 1 sales order lines (layout)
VAT_C_2 int64 VAT amt code 2 sales order lines (layout)
VAT_C_2_1 int64 VAT amt code 1 sales invoice lines
VAT_C_2_2 int64 VAT amt code 2 sales invoice lines
VAT_N_1 int64 Net amt VAT code 1 sales order lines (layout)
VAT_N_2 int64 Net amt VAT code 2 sales order lines (layout)
VAT_N_2_1 int64 Net amt VAT code 1 sales invoice lines
VAT_N_2_2 int64 Net amt VAT code 2 sales invoice lines
VAT_NR varchar2(14) Company fiscal VAT number