Asset Transaction Conversion
UPDATED BY
AM500 | AM93.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
TNC-CONVERSION-NBR Element: Conversion Nbr | Alpha 22 This number associates the transaction with the asset. This number can also be the Lawson-assigned asset number for use when doing just transaction conversion. If using the conversion by asset number option on AM500, be sure to zerofill and right-justify this field. |
|
||
TNC-SEQ-NUMBER Element: Seq Number | Numeric 6 A unique number assigned to each transaction to be transferred into the Lawson system. This number will not be the same as the number assigned to the AMTRANS record. |
|
||
TNC-COMPANY Element: Company | Numeric 4 This is the asset company number. |
|
||
TNC-BOOK Element: Book | Alpha 10 The book to which the transaction is posted. |
|
||
TNC-LEASE-COMPANY Element: Company | Numeric 4 The lease company number. |
|
||
TNC-LEASE Element: Lease | Alpha 19 The name of the lease to which the asset is assigned. |
|
||
TNC-ASSET-GROUP Element: Asset Group | Alpha 10 The asset group to which the asset belongs. |
|
||
TNC-TRANS-DATE Element: Trans Date | Numeric 8 (yyyymmdd) The date the transaction was posted. |
|
||
TNC-TRANS-AMOUNT Element: Intl Amt | Signed 18.2 The signed associated with this transaction in the currency of the posting book. |
|
||
TNC-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field contains the transaction description. |
|
||
TNC-ACCT-GRP Element: Acct Grp Am | Alpha 10 The account group identifying the general ledger accounts that are used to create journal entries when the asset is processed. |
|
||
TNC-ASSET-TYPE Element: Asset Type | Alpha 10 The asset type assigned to the asset, identifying the general ledger accounts used to store the asset, depreciation expense, and accumulated depreciation amounts. |
|
||
TNC-SUB-TYPE Element: Sub Type | Alpha 10 The asset type associated with the asset. Must be unique within the asset type. |
|
||
TNC-ACCT-TYPE Element: Acct Type | Alpha 3 This field contains the type of account to which the transaction is posted. Valid values are: AST = Asset ACM = Accumulated Depreciation EXP = Depreciation Expense PRO = Proceeds GAN = Gain LOS = Loss CLR = Clearing COS = Disposal Expense DGN = Deferred Gain DLS = Deferred Loss |
|
||
TNC-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit used to post the transaction to the General Ledger. |
|
||
TNC-ACCOUNT Element: Account | Numeric 6 The account used to post the transaction to the General Ledger. |
|
||
TNC-SUB-ACCT Element: Sub Acct | Numeric 4 The subaccount used to post the transaction to the General Ledger. |
|
||
TNC-ASSET-PROCESS Element: Asset Process | Alpha 3 The asset process that caused the transaction to be created. Valid values are: ADD = Addition ADJ = Adjustment DPR = Depreciation DSP = Disposal TRF = Transfer |
|
||
TNC-ACTIVITY Element: Activity | Alpha 15 The activity assigned to the transaction. |
|
||
TNC-ACCT-CATEGORY Element: Acct Category | Alpha 5 The account category assigned to the transaction. The account category assigned to the transaction. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
TNCSET1 |
CONVERSION-NBR SEQ-NUMBER |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Amassetcnv | AMASSETCNV |
Not Required
| |||
Amcnvasset | AMCNVASSET |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Amastbkcnv | AMASTBKCNV |
| ||||||
Amastitcnv | AMASTITCNV |
| ||||||
Amastmxcnv | AMASTMXCNV |
|
All trademarks and registered trademarks are the property of their
respective owners.