invantive documentation
Invantive Support ForumsLog In / Sign Up

SYS_EXPN: AccountView General expressions

read only per partition

  • Catalog: AccountView
  • Label: General expressions

Can only retrieve data.

Table Columns

The columns of the table SYS_EXPN are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type 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