inventoryList

11/20/2020 12:37:12 PM

Line Field Name Data Type Description
1 str:inventoryList Table Physical inventory list.
2 term:averageCost Term (Decimal)
3 term:binId Term (Text/String)
4 term:binLocation Term (Text/String)
5 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.
6 term:closingStockQuantity Term (Decimal)
7 term:closingStockValue Term (Decimal)
8 term:countedBy Term (Text/String)
9 term:currentValuation Term (Decimal)
10 term:defaultInventoryMethod Term (Text/String)
11 term:defaultStockingUnitOfMeasure Term (Decimal)
12 term:glAssetAccount Term (Text/String)
13 term:glCostAccount Term (Text/String)
14 term:inventoryABCCode Term (Text/String)
15 term:inventoryBarCode Term (Text/String)
16 term:inventoryClass Term (Text/String)
17 term:inventoryCost Term (Decimal)
18 term:inventoryCostMethod Term (Text/String)
19 term:inventoryDescription Term (Text/String)
20 term:inventoryHeldForCustomers Term (Text/String)
21 term:inventoryHeldForOthers Term (Text/String)
22 term:inventoryHeldForSuppliers Term (Text/String)
23 term:inventoryItemCode Term (Text/String)
24 term:inventoryListPrice Term (Decimal)
25 term:inventoryProductId Term (Text/String)
26 term:inventoryProductType Term (Text/String)
27 term:inventoryPurchaseYearToDate Term (Date)
28 term:inventoryPurchasingUOM Term (Text/String)
29 term:inventorySellingUOM Term (Text/String)
30 term:inventorySoldYearToDate Term (Date)
31 term:inventoryStockingUOM Term (Text/String)
32 term:lastCountDate Term (Date)
33 term:lastDespatchedDate Term (Date)
34 term:lastReceivedDate Term (Date)
35 term:locationActiveFlag Term (Text/String)
36 term:locationCity Term (Text/String)
37 term:locationCode Term (Text/String)
38 term:locationCountry Term (Text/String)
39 term:locationCurrency Term (Text/String)
40 term:locationDescription Term (Text/String)
41 term:locationId Term (Text/String)
42 term:locationLatitude Term (Text/String)
43 term:locationLongitude Term (Text/String)
44 term:locationParent Term (Text/String)
45 term:locationStateProvince Term (Text/String)
46 term:locationStreet Term (Text/String)
47 term:locationType Term (Text/String)
48 term:locationZipPostalCode Term (Text/String)
49 term:lotNumber Term (Text/String)
50 term:obsoleteorDamagedInventory Term (Text/String)
51 term:openingStockQuantity Term (Decimal)
52 term:openingStockValue Term (Decimal)
53 term:ownerId Term (Text/String)
54 term:preferredSupplier Term (Text/String)
55 term:primaryManufacturer Term (Text/String)
56 term:primaryManufacturerProductCode Term (Text/String)
57 term:primarySupplier Term (Text/String)
58 term:primarySupplierProductCode Term (Text/String)
59 term:productGroup01 Term (Text/String)
60 term:productGroup02 Term (Text/String)
61 term:quantity Term (Text/String)
62 term:quantityOnHandPhysicalCount Term (Text/String)
63 term:quantityOnHandSystem Term (Text/String)
64 term:segment01 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
65 term:segment02 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
66 term:segment03 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
67 term:segment04 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
68 term:segment05 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
69 term:serialNumber Term (Text/String)
70 term:specificCost Term (Decimal)
71 term:standardCost Term (Decimal)
72 term:stockAccountCommodityCode Term (Text/String)
73 term:stockCharacteristic Term (Text/String)
74 term:stockCharacteristicValue Term (Decimal)
75 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.
76 term:thirdPartyFacility Term (Text/String)
77 term:unitPrice Term (Decimal)
78 term:uomToUOMbaseConversionFactor Term (Text/String)
79 term:writeDownDescription Term (Text/String)
80 term:writeDownFactor Term (Text/String)