fixedAssetMasterData

11/20/2020 12:36:33 PM

Line Field Name Data Type Description
1 str:fixedAssetMasterData Table Fixed asset master data by fixed asset record.
2 term:businessUnitCode Term (Text/String) Used to identify the business unit, region, branch, and so on at the level that financial statements are being audited and for which the trial balance is generated. For example, you may use a code aligned with the concept of a reportable segment as defined in FASB Accounting Standards Codification (ASC) 280, Segment Reporting.
3 term:currencyId Term (Text/String)
4 term:depreciationRate Term (Decimal)
5 term:fixedAssetAccumulatedDepreciation Term (Decimal)
6 term:fixedAssetAccumulatedDepreciationAccount Term (Text/String)
7 term:fixedAssetAcquisitionDate Term (Date)
8 term:fixedAssetAssetAccount Term (Text/String)
9 term:fixedAssetAvailableforSaleDate Term (Date)
10 term:fixedAssetBarCode Term (Text/String)
11 term:fixedAssetCIPAccount Term (Text/String)
12 term:fixedAssetCIPFlag Term (Text/String)
13 term:fixedAssetClass Term (Text/String)
14 term:fixedAssetCode Term (Text/String)
15 term:fixedAssetDepreciableBasis Term (Text/String)
16 term:fixedAssetDepreciationAccount Term (Text/String)
17 term:fixedAssetDescription Term (Text/String)
18 term:fixedAssetDisposalDate Term (Date)
19 term:fixedAssetFairValue Term (Decimal)
20 term:fixedAssetGroup01 Term (Text/String)
21 term:fixedAssetGroup02 Term (Text/String)
22 term:fixedAssetId Term (Text/String)
23 term:fixedAssetInactiveFlag Term (Text/String)
24 term:fixedAssetInServiceDate Term (Date)
25 term:fixedAssetNetBookValue Term (Decimal)
26 term:fixedAssetOriginalCost Term (Decimal)
27 term:fixedAssetQuantityOnHand Term (Text/String)
28 term:fixedAssetRealisedGainLossAccount Term (Text/String)
29 term:fixedAssetReplacementCost Term (Decimal)
30 term:fixedAssetRetirementDate Term (Date)
31 term:fixedAssetSalvageValue Term (Decimal)
32 term:fixedAssetToBeAbandonedOrDisposedOfOtherThanByForSaleDate Term (Date)
33 term:fixedAssetType Term (Text/String)
34 term:fixedAssetUnrealizedGainLossAccount Term (Text/String)
35 term:fixedAssetUsefulLife Term (Text/String)
36 term:fixedAssetUsefulLifeRemaining Term (Text/String)
37 term:locationCode Term (Text/String)
38 term:locationDescription Term (Text/String)
39 term:locationId Term (Text/String)
40 term:lotNumber Term (Text/String)
41 term:manufacturerId Term (Text/String)
42 term:projectId Term (Text/String)
43 term:segment01 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
44 term:segment02 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
45 term:segment03 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
46 term:segment04 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
47 term:segment05 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
48 term:serialNumber Term (Text/String)
49 term:supplierId Term (Text/String) Identifier of the supplier to whom payment is due or from whom unused credits have been applied. Must match the Supplier_Account_ID in the Supplier_Listing_YYYYMMDD file.
50 term:supplierName Term (Text/String) Name of the supplier