Table: Sage Fixed Assets Integration Assets

Table: FAASSET
View: FA0100
Record Length: 353

Flags: A R 

Keys: 2

Title Flags Fields
Sequence SEQUENCE
Status/Sequence D M  STATUS, SEQUENCE

Fields: 30

Field Type Title Presentation
SEQUENCE Long Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
STATUS Integer Status List:3 entries
0 = Pending
1 = Created
99 = Error
ERRORS Long Errors
ORGID String*6 Database ID
DRILLAPP String*2 Drilldown Application Source Mask: %-2A
DRILLTYPE Integer Drilldown Type
DRILLDWNLK BCD*10.0 Drilldown Link Number
FASDB String*32 Sage Fixed Assets Database
FASCMP String*32 Sage Fixed Assets Company/Org.
FASTMPL String*25 Sage Fixed Assets Template
ASSETDESC String*80 Asset Description
DATE Date Acquisition Date
QTY BCD*10.5 Quantity
UOM String*10 Unit of Measure
VENDOR String*12 Vendor Number Mask: %-12C
DOCUMENTNO String*22 Document Number Mask: %-22C
PONUMBER String*22 Purchase Order Number Mask: %-22C
CURRENCY String*3 Currency Code Mask: %-3N
RATETYPE String*2 Rate Type Mask: %-2N
RATEDATE Date Rate Date
RATEOP Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
RATE BCD*8.7 Exchange Rate
VALUETC BCD*10.3 Source Currency Asset Value
VALUEHC BCD*10.3 Functional Currency Asset Value
ASSETID Long Sys No
CREATEDATE Date Date Asset Created

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).