invantive documentation
Invantive Support ForumsLog In / Sign Up

TRN_HDR: AccountView Journal pages

read only per partition

  • Catalog: AccountView
  • Label: Journal pages

Can only retrieve data.

Table Columns

The columns of the table TRN_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
ACCT_NR varchar2(10) Account number
ACCT_OPP varchar2(10) Counter account
BLK_AMT int64 G-account amount
BV_AMT int64 UWV amount
CNG_DATE datetime Date last modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
COMMENT1 varchar2(4) Note
COST_CODE varchar2(10) Cost centre code
CRED_DAYS decimal Payment term in days
CUR_CODE varchar2(3) Currency code
DD_ACT char Direct debit
DISC_CODE varchar2(2) Payment term
DISC_DAYS decimal Discount term in days
DJ_CODE varchar2(3) Journal code
DOC_ID varchar2(32) Document code
DOC_TYPE int32 Document type
EXCH_RATE decimal Exchange rate
EXT_DESC varchar2(40) Payment reference
HDR_DESC varchar2(40) Page description
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
INV_NR varchar2(12) Document/invoice number
LB_AMT int64 Payroll tax amount
MAND_B2B char Direct debit type: business
MAND_DATE datetime Signature date
MAND_ID varchar2(35) Direct debit mandate reference
MAND_SEQ int32 Direct debit mandate
PAGE_AMT int64 Page balance
PAGE_NR varchar2(10) Page number
PAGE_VAT int64 VAT amount page
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PAY_ID varchar2(25) Payment code
PAYIN_ID varchar2(25) Pay-in ID
PD_AMT int64 Payment discount amount
PD_PCT decimal Payment discount percentage
PERIOD decimal Period
PROJ_CODE varchar2(10) Project code
REC_ID varchar2(10) Unique code
SUB_NR varchar2(10) Customer/Supplier
TRN_DATE datetime Change date
VOUCH_NR varchar2(15) Document number