invantive documentation
Invantive Support ForumsLog In / Sign Up

ICL_HDR: AccountView ICP returns

read only per partition

  • Catalog: AccountView
  • Label: ICP returns

Can only retrieve data.

Table Columns

The columns of the table ICL_HDR 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
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
FIAT_DATE datetime Approval date
ICL_DESC varchar2(80) Return description
ICL_NOTE varchar2(4) Return note
ICL_PER varchar2(1) Return period
ICL_STAT int32 Return status
ICL_YEAR int32 Return year
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
INT_ADDR1 varchar2(41) Intermediary address
INT_ASS varchar2(20) Name of umbrella organisation of tax service providers
INT_BECON varchar2(17) BECON number
INT_CITY varchar2(24) Intermediary city
INT_CNAME varchar2(35) Intermediary contact person
INT_NAME varchar2(35) Intermediary name
INT_PCODE varchar2(6) Intermediary postcode
INT_PHONE varchar2(25) Intermediary telephone number
INT_USE char Prepared by intermediary
MSG_ID varchar2(8) Characteristic
MSG_IDNR varchar2(10) Unique return message number
PA_CODE varchar2(10) Partner
partition_code varchar2 Partition code
partition_name varchar2 Partition name
REC_ID varchar2(10) Unique code
RNG_CODE varchar2(10) Partner administration
RPT_DATE1 datetime Date from
RPT_DATE2 datetime Date to
RPT_PER1 int32 Period from
RPT_PER2 int32 Period to
RPT_QTR int32 Quarter
RPT_RNG int32 Time frame
ST_EXTRA varchar2(10) Address addition
ST_NR varchar2(10) House number
ST_STREET varchar2(60) Street Name
TAX_CITY varchar2(24) Company city
TAX_CNAME varchar2(35) Company contact person
TAX_NAME varchar2(35) Company name
TAX_PCODE varchar2(6) Company postcode
TAX_PHONE varchar2(25) Company telephone number
VAT_IC_NR varchar2(14) ICP number
VAT_NR varchar2(14) VAT number