Please enable JavaScript to view this site.

Navigation: Schema:  > Tables

TransactionLines: XAF 3.2 Transaction Lines

Contents Previous Home Next More

Catalog: XAF

Label: Transaction Lines

The data in this table is partitioned per value of the COMPANY_NAME column.

Retrieve: true

Topic: auditfile

Base XPath: /xaf:auditfile/xaf:company/xaf:transactions/xaf:journal/xaf:transaction

XPath: /xaf:trLine

Table Columns

The columns of the table TransactionLines are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

ACCID

string(240)

Account ID

 

 

AMNT

decimal

Amount

 

 

AMNTTP

string(240)

Amount Type

 

 

ARTGRPID

string(240)

Article Group ID

 

 

AUDIT_FILE_VERSION

string(240)

Audit File Version

 

BALANCE

decimal

Balance

 

BANKACCNR

string(240)

Bank Account Number

 

 

BANKIDCD

string(240)

Bank ID Code

 

 

COMPANY_ADDRESS

string(240)

Company Address

 

COMPANY_CITY

string(240)

Company City

 

COMPANY_ID

string(240)

Company ID

 

COMPANY_NAME

string(1000)

Company Name

 

COMPANY_POSTAL_CODE

string(240)

Company Postal Code

 

COMPANY_TAX_REG_IDENT

string(240)

Tax Registration Identification

 

COSTID

string(240)

Cost ID

 

 

CURRENCY_CURAMNT

decimal

Currency Amount

 

 

CURRENCY_CURCODE

string(240)

Currency Currency Code

 

 

CUSTSUPID

string(240)

ID

 

 

DESCRIPTION

string

Description

 

 

DOCREF

string(999)

Document Reference

 

 

EFFDATE

datetime

Effective Date

 

 

FILE_CURRENCY_CODE

string(240)

File Currency Code

 

FILE_DATE_CREATED

string(240)

File Creation Date

 

FISCAL_YEAR_END_DATE

datetime

Fiscal Year End Date

 

FISCAL_YEAR_NUMBER

string(240)

Fiscal Year Number

 

FISCAL_YEAR_START_DATE

datetime

Fiscal Year Start Date

 

INTERFACE_URL

string(4000)

Interface URL

 

INVREF

string(999)

Invoice Reference

 

 

MATCHKEYID

string(240)

Match Key ID

 

 

NR

string(240)

Number

 

 

ORDERREF

string(999)

Order Reference

 

 

PRODID

string(240)

Product ID

 

 

PRODUCT_ID

string(240)

Product ID

 

PRODUCT_VERSION

string(240)

Product Version

 

PROJID

string(240)

Project ID

 

 

QNTITY

int64

Quantity

 

 

QNTITYID

string(240)

Quantity ID

 

 

RECEIVINGDOCREF

string(999)

Receiving Document Reference

 

 

RECREF

string(999)

Record Reference

 

 

SHIPDOCREF

string(999)

Shipping Document Reference

 

 

TRANSACTION_AMNT

decimal

Transaction Amount

 

 

TRANSACTION_AMNTTP

string(240)

Transaction Amount Type

 

 

TRANSACTION_DESC

string

Transaction Description

 

 

TRANSACTION_NR

string(240)

Transaction Number

 

 

TRANSACTION_PERIODNUMBER

int64

Transaction Period Number

 

 

TRANSACTION_SOURCEID

string(240)

Transaction Source ID

 

 

TRANSACTION_TRDT

datetime

Transaction Date

 

 

TRANSACTION_USERID

string(240)

Transaction User ID

 

 

WORKCOSTARRREF

string(999)

Work Cost Arrangement Reference

 

 

 

27-12-2021 11:01 Version 20.2.169-PROD+3633