TXRPTTRANS

This file contains all invoices that have been released by AP, AR, BL, CB and BR. File is updated when Journal File(TX101) is ran. File is purged when Journal Detail Purge(TX301) is ran.
UPDATED BY
TX101 TX301 TX226

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAS-COMPANY
Element: Company
Numeric 4
The company number. The company must be already defined in the General Ledger system.
TX101
TAS-PROC-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
TX101
TAS-VEND-CUST
Element: Customer
Alpha 9 (Right Justified)
Vendor number if transaction is an AP invoice, CB invoice or Input ax transaction. Customer number if transaction is a BL invoice, AR invoice, CB output transaction or TX output transaction.
TX101
TAS-DOCUMENT
Element: Document Nbr
Alpha 27
The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered.
TX101
TAS-SUFFIX
Element: Suffix
Numeric 3
This is the suffix for the invoice.
TX101
TAS-TRANS-TYPE
Element: Trans Type
Alpha 1
Identifies the type of AR transaction: I=Invoice C=Credit memo D=Debit memo For non-AR systems, this field will be a space.
TX101
TAS-VOUCHER-NBR
Element: Voucher Nbr
Alpha 10
TX101
TAS-JRNL-BOOK-NBR
Element: Jrnl Book Nbr
Alpha 12
The journal book assigned to the transaction.
TX101
TAS-JBK-SEQ-NBR
Element: Jbk Seq Nbr
Numeric 10
The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).
TX101
TAS-TRAN-CURRENCY
Element: To Base Curr
Alpha 5
TX101
TAS-POST-DATE
Element: Post Date
Numeric 8 (yyyymmdd)
The date general ledger entries for the transaction will be posted to the general ledger.
TX101
TAS-BASE-TAXABLE
Element: Intl Amt
Signed 18.2
TX101
TAS-BASE-TAX-AMT
Element: Intl Amt
Signed 18.2
TX101
TAS-BASE-INV-AMT
Element: Intl Amt
Signed 18.2
TX101
TAS-SYSTEM-CD
Element: System Cd
Alpha 2
This field indicates on what system the transaction originated.
TX101
TAS-SOURCE
Element: Source
Alpha 1
The source of the transaction. Input or output. Input transactions are AP, CB input, TX input. Output transactions are AR, BL, TX output, CB Output.
TX101


TXRPTTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TASSET1 COMPANY
SYSTEM-CD
DOCUMENT
SUFFIX
TRANS-TYPE
VEND-CUST
TX301
TASSET2 COMPANY
VOUCHER-NBR
JRNL-BOOK-NBR
JBK-SEQ-NBR
DOCUMENT
SUFFIX
TRANS-TYPE
VEND-CUST
TX226


TXRPTTRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Txrptdist TXRPTDIST
TAS-COMPANY->TDT-COMPANY
TAS-SYSTEM-CD->TDT-SYSTEM-CD
TAS-DOCUMENT->TDT-DOCUMENT
TAS-SUFFIX->TDT-SUFFIX
TAS-TRANS-TYPE->TDT-TRANS-TYPE
  TDT-LINE-NBR
  TDT-SEQ-NBR
  TDT-DIST-SEQ-NBR


File created: Thu Jun 09 02:33:14 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.