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