TXRPTTRANS – No description in the Lawson data dictionary

System: Tax (TX)
Prefix: TAS
Primary key: COMPANY, SYSTEM-CD, DOCUMENT, SUFFIX, TRANS-TYPE, VEND-CUST
Fields: 16
Updated by: 3 programs
Referenced by: 0 programs

TXRPTTRANS is a Lawson Tax table (prefix TAS); no description in the lawson data dictionary. It is indexed by COMPANY, SYSTEM-CD, DOCUMENT, SUFFIX, TRANS-TYPE, VEND-CUST (TASSET1); alternate indexes: TASSET2. It is related 1:M to TXRPTDIST. It is updated by TX101, TX226 and TX301. The table has 16 fields, 2 indexes and 1 documented relation.

About TXRPTTRANS

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the TAS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TAS-COMPANY` PK COMPANY	Numeric 4	The company number. The company must be already defined in the General Ledger system.	TX101
`TAS-PROC-LEVEL` PROC_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	TX101
`TAS-VEND-CUST` PK VEND_CUST	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` PK DOCUMENT	Alpha 27	The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered.	TX101
`TAS-SUFFIX` PK SUFFIX	Numeric 3	This is the suffix for the invoice.	TX101
`TAS-TRANS-TYPE` PK TRANS_TYPE	Alpha 1	Identifies the type of AR transaction: For non-AR systems, this field will be a space. `I` Invoice `C` Credit memo `D` Debit memo	TX101
`TAS-VOUCHER-NBR` VOUCHER_NBR	Alpha 10	—	TX101
`TAS-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	The journal book assigned to the transaction.	TX101
`TAS-JBK-SEQ-NBR` 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` TRAN_CURRENCY	Alpha 5	—	TX101
`TAS-POST-DATE` POST_DATE	Numeric 8 (yyyymmdd)	The date general ledger entries for the transaction will be posted to the general ledger.	TX101
`TAS-BASE-TAXABLE` BASE_TAXABLE	Signed 18.2	—	TX101
`TAS-BASE-TAX-AMT` BASE_TAX_AMT	Signed 18.2	—	TX101
`TAS-BASE-INV-AMT` BASE_INV_AMT	Signed 18.2	—	TX101
`TAS-SYSTEM-CD` PK SYSTEM_CD	Alpha 2	This field indicates on what system the transaction originated.	TX101
`TAS-SOURCE` 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

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`TASSET1`	`COMPANY`, `SYSTEM-CD`, `DOCUMENT`, `SUFFIX`, `TRANS-TYPE`, `VEND-CUST`	Primary		TX301
`TASSET2`	`COMPANY`, `VOUCHER-NBR`, `JRNL-BOOK-NBR`, `JBK-SEQ-NBR`, `DOCUMENT`, `SUFFIX`, `TRANS-TYPE`, `VEND-CUST`			TX226

Relations

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (3)

TX101 Journal File Create
TX226 Purchasing and Sales Journal
TX301 Journal Detail Purge