inventoryTransactions

11/20/2020 12:37:25 PM

Line Field Name Data Type Description
1 str:inventoryTransactions Table Inventory transactions
2 term:bookValue Term (Decimal)
3 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.
4 term:customerId Term (Text/String) Unique code for the customer
5 term:inventoryFromLocation Term (Text/String)
6 term:inventoryglLineCreditAccountNumber Term (Text/String)
7 term:inventoryglLineDebitAccountNumber Term (Text/String)
8 term:inventoryId Term (Text/String)
9 term:inventoryProductId Term (Text/String)
10 term:inventorySystemOrExternalSource Term (Text/String)
11 term:inventoryToLocation Term (Text/String)
12 term:inventoryTransactionApprovedBy Term (Text/String)
13 term:inventoryTransactionApprovedByDate Term (Date)
14 term:inventoryTransactionEnteredBy Term (Text/String)
15 term:inventoryTransactionEnteredDate Term (Date)
16 term:inventoryTransactionId Term (Text/String)
17 term:inventoryTransactionLastModifiedBy Term (Text/String)
18 term:inventoryTransactionLastModifiedDate Term (Date)
19 term:lotNumber Term (Text/String)
20 term:movementDocumentType Term (Text/String)
21 term:movementLineNumber Term (Text/String)
22 term:movementReference Term (Text/String)
23 term:movementTaxPointDate Term (Date)
24 term:segment01 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
25 term:segment02 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
26 term:segment03 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
27 term:segment04 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
28 term:segment05 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
29 term:serialNumber Term (Text/String)
30 term:sourceLedgerTransactionAssociatedOrderId Term (Text/String)
31 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.
32 term:taxAmount Term (Decimal)
33 term:taxAmountCurrencyAmount Term (Decimal)
34 term:taxAmountCurrencyCode Term (Text/String)
35 term:taxAmountExchangeRate Term (Decimal)
36 term:taxBase Term (Text/String)
37 term:taxBaseDescription Term (Text/String)
38 term:taxCode Term (Text/String)
39 term:taxDeclarationPeriod Term (Text/String)
40 term:taxExemptionReason Term (Text/String)
41 term:taxPercentage Term (Decimal)
42 term:taxType Term (Text/String) Tax type for look-up in tables
43 term:transactionAssociatedDocumentId Term (Text/String)
44 term:transactionAssociatedDocumentLineId Term (Text/String)
45 term:transactionAssociatedOrderId Term (Text/String)
46 term:transactionAssociatedOrderLineId Term (Text/String)
47 term:transactionCostAdjust Term (Text/String)
48 term:transactionDateTime Term (Date) The date and time the payment was made or credit was applied.
49 term:transactionDescription Term (Text/String)
50 term:transactionQuantityIssued Term (Decimal)
51 term:transactionQuantityReceived Term (Decimal)
52 term:transactionType Term (Text/String)
53 term:transactionTypeSystem Term (Text/String)
54 term:unitOfMeasure Term (Text/String)
55 term:unitPrice Term (Decimal)
56 term:uomToUOMPhysicalStockConversionFactor Term (Text/String)