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) |
|