goodsShippedData

11/20/2020 12:35:20 PM

Line Field Name Data Type Description
1 str:goodsShippedData Table Goods shipped to customer information per accounts receivable subsystem.
2 term:adjustmentAmount Term (Decimal) Reference number on shipping document (company reference or logistics company identifier).
3 term:adjustmentDescription Term (Text/String) If an adjustment to the receipt, a description of the reason for the adjustment.
4 term:adjustmentIndicator Term (Text/String) 0 if the transaction is the original shipment transaction, 1 if the transaction is a shipment adjustment.
5 term:approvedBy Term (Text/String) User ID (from User_Listing file) for person who approved the entry.
6 term:approvedDate Term (Date) Date the entry was approved.
7 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.
8 term:customerAccountId Term (Text/String) Identifier of the customer from whom payment is expected or to whom unused credits have been applied.
9 term:enteredBy Term (Text/String) User_ID (from User_Listing file) for person who created the record.
10 term:enteredDate Term (Date) Date the order was entered into the system. This is sometimes referred to as the creation date. This should be a system-generated date (rather than user-entered date), when possible. This date does not necessarily correspond with the date of the transaction itself.
11 term:goodsReceivedAmount Term (Decimal) Customer purchasing the product. Must match a Customer_Account_ID in the Customer_Master_Listing_YYYYMMDD file.
12 term:goodsReceivedExchangeRate Term (Decimal) The exchange rate used. CurrencyAmount x ExchangeRate = Amount
13 term:goodsShippedId Term (Text/String)
14 term:lastModifiedBy Term (Text/String) User_ID (from User_Listing file) for the last person modifying this entry.
15 term:lastModifiedDate Term (Date) The date the entry was last modified before posting.
16 term:lineAdjustmentAmount Term (Decimal)
17 term:lineAdjustmentDescription Term (Text/String)
18 term:lineAmount Term (Decimal) In the headers default currency.
19 term:lineExchangeRate Term (Decimal) The exchange rate used. CurrencyAmount x ExchangeRate = Amount
20 term:lineSalesOrderAmount Term (Decimal) In the headers default currency.
21 term:lineSalesOrderExchangeRate Term (Decimal) The exchange rate used. CurrencyAmount x ExchangeRate = Amount
22 term:lineSalesOrderLineAmountLocal Term (Text/String) Monetary amount for the line item in the sales order related to the shipping document line item. Recorded in the local currency. If no sales order, leave blank.
23 term:lineSalesOrderLineId Term (Text/String) Identifier for sales order line number. Must match Sales_Order_Line_ID used in Sales_Orders_Lines_YYYYMMDD_YYYYMMDD file. If no sales order, leave blank.
24 term:lineSalesOrderLocalCurrency Term (Text/String) The currency for local reporting requirements. See ISO 4217 coding. If no sales order, leave blank.
25 term:lineSalesOrderQuantity Term (Text/String) Sales order line original quantity. If no sales order, leave blank.
26 term:lineSalesOrderUnitOfMeasure Term (Decimal) Sales order line base unit of measure. If no sales order, leave blank.
27 term:lineSalesOrderUnitPrice Term (Decimal) Sales order line price per unit. If no sales order, leave blank.
28 term:lineShipmentId Term (Text/String) Unique identifier for each shipment. This ID may need to be created by concatenating fields (for example, document number, document type, and year) to uniquely identify each shipment. Must match the Shipment_ID field in the file Shipments_Made_YYYYMMDD_YYYYMMDD.
29 term:lineShippingDocumentLineId Term (Text/String) Reference line number on shipping document.
30 term:lineShippingLineAmountLocal Term (Decimal) Monetary amount for the line item in the shipping document related to the sales order. Recorded in the local currency.
31 term:lineShippingLineAmountLocalCurrency Term (Text/String) The currency for local reporting requirements. See ISO 4217 coding.
32 term:lineShippingProductBarCode Term (Text/String) UPC or other general identifier.
33 term:lineShippingProductCode Term (Text/String) Product code appearing on the trade document
34 term:lineShippingProductDescription Term (Text/String) Product description (plain English) to indicate the name or other identifying characteristics of the product.
35 term:lineShippingProductGroup01 Term (Text/String) Product descriptor #1, for example, tires or accessories.
36 term:lineShippingProductGroup02 Term (Text/String) Product descriptor #2, for example, brand.
37 term:lineShippingProductId Term (Text/String) Identifier that is unique for each product.
38 term:lineShippingQuantity Term (Text/String) Item quantity sent.
39 term:lineShippingUnitOfMeasure Term (Decimal) Base unit of measure.
40 term:lineShippingUnitPrice Term (Decimal) Price per unit for item sent.
41 term:postingStatus Term (Text/String) Status of the transactions posting to the GL (for example, Posted, Not Posted).
42 term:salesOrderAmount Term (Decimal) In the headers default currency.
43 term:salesOrderAmountLocal Term (Decimal) Sales monetary amount recorded in the local currency.
44 term:salesOrderDate Term (Date) Date of sales order for items shipped. If no sales order, leave blank.
45 term:salesOrderExchangeRate Term (Decimal) The exchange rate used. CurrencyAmount x ExchangeRate = Amount
46 term:salesOrderId Term (Text/String) Sales order ID for invoiced items. Must match Sales_Order_ID in the Sales_Orders_YYYYMMDD_YYYYMMDD file. If no sales order, leave blank.
47 term:salesOrderLocalCurrency Term (Text/String) The currency for local reporting requirements. See ISO 4217 coding.
48 term:segment01 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
49 term:segment02 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
50 term:segment03 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
51 term:segment04 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
52 term:segment05 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
53 term:shipmentDate Term (Date) Date of shipment (date shipped)
54 term:shipmentFiscalYear Term (Text/String) Fiscal year in which the Shipment_Date occurred YYYY for delimited, CCYY-MM-DD fiscal year end (ISO 8601) for extensible business reporting language global ledger taxonomy framework (XBRL GL).
55 term:shipmentId Term (Text/String) Unique identifier for each shipment. This ID may need to be created by concatenating fields (for example, document number, document type, and year) to uniquely identify each shipment.
56 term:shipmentPeriod Term (Text/String) Fiscal period in which the Shapment_Date occurs. Examples include W1‚W53 for weekly periods, M1‚M12 for monthly periods, and Q1‚Q4 for quarterly periods.
57 term:shippingAmountLocal Term (Decimal) Monetary amount for the items in the shipping document related to the sales order. Recorded in the local currency.
58 term:shippingAmountLocalCurrency Term (Text/String) The currency for local reporting requirements. See ISO 4217 coding.
59 term:shippingDocumentId Term (Text/String) Reference number on shipping document (company reference or logistics company identifier).