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.
REFERENCED BY
TX226 |
TX101 | TX301 |
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. |
|
||
TAS-PROC-LEVEL Element: Process Level | Alpha 5 This field contains the process level, which is the reporting hierarchy below company. |
|
||
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. |
|
||
TAS-DOCUMENT Element: Document Nbr | Alpha 27 The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered. |
|
||
TAS-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||
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. |
|
||
TAS-VOUCHER-NBR Element: Voucher Nbr | Alpha 10 |
|
||
TAS-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|
||
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). |
|
||
TAS-TRAN-CURRENCY Element: To Base Curr | Alpha 5 |
|
||
TAS-POST-DATE Element: Post Date | Numeric 8 (yyyymmdd) The date general ledger entries for the transaction will be posted to the general ledger. |
|
||
TAS-BASE-TAXABLE Element: Intl Amt | Signed 18.2 |
|
||
TAS-BASE-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||
TAS-BASE-INV-AMT Element: Intl Amt | Signed 18.2 |
|
||
TAS-SYSTEM-CD Element: System Cd | Alpha 2 This field indicates on what system the transaction originated. |
|
||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
TASSET1 |
COMPANY SYSTEM-CD DOCUMENT SUFFIX TRANS-TYPE VEND-CUST |
|
| ||||||||
TASSET2 |
COMPANY VOUCHER-NBR JRNL-BOOK-NBR JBK-SEQ-NBR DOCUMENT SUFFIX TRANS-TYPE VEND-CUST |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Txrptdist | TXRPTDIST |
|
All trademarks and registered trademarks are the property of their
respective owners.