| Line | Field Name | Data Type | Description |
|---|---|---|---|
| 1 | str:goodsReceivedData | Table | Goods received from supplier information per accounts payable 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:approvedByDateTime | Term (Date) | The DateTime 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:enteredBy | Term (Text/String) | User_ID (from User_Listing file) for person who created the record. |
| 9 | term:enteredDateTime | Term (Date) | The date the transaction 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. |
| 10 | term:goodsReceiptUniqueId | Term (Text/String) | |
| 11 | term:goodsReceivedAmount | Term (Decimal) | Customer purchasing the product. Must match a Customer_Account_ID in the Customer_Master_Listing_YYYYMMDD file. |
| 12 | term:goodsReceivedCurrencyAmount | Term (Decimal) | |
| 13 | term:goodsReceivedCurrencyCode | Term (Text/String) | |
| 14 | term:goodsReceivedExchangeRate | Term (Decimal) | The exchange rate used. CurrencyAmount x ExchangeRate = Amount |
| 15 | term:lastModifiedBy | Term (Text/String) | User_ID (from User_Listing file) for the last person modifying this entry. |
| 16 | term:lastModifiedDateTime | Term (Date) | The date and time the entry was last modified before posting. |
| 17 | term:lineAdjustmentAmount | Term (Decimal) | |
| 18 | term:lineAdjustmentDescription | Term (Text/String) | |
| 19 | term:lineAmount | Term (Decimal) | In the headers default currency. |
| 20 | term:lineCurrencyAmount | Term (Decimal) | Monetary amount for the line item in the receipt document related to the purchase order in local currency. |
| 21 | term:lineCurrencyCode | Term (Text/String) | The currency for local reporting requirements. See ISO 4217 coding. |
| 22 | term:lineExchangeRate | Term (Decimal) | The exchange rate used. CurrencyAmount x ExchangeRate = Amount |
| 23 | term:linePurchaseOrderAmount | Term (Decimal) | |
| 24 | term:linePurchaseOrderCurrencyAmount | Term (Decimal) | Monetary amount for the line item in the purchase order related to the receipt shipping document in local currency. If no purchase order, leave blank. |
| 25 | term:linePurchaseOrderCurrencyCode | Term (Text/String) | The currency for local reporting requirements. See ISO 4217 coding. If no purchase order, leave blank. |
| 26 | term:linePurchaseOrderExchangeRate | Term (Decimal) | |
| 27 | term:linePurchaseOrderLineId | Term (Text/String) | Identifier for purchase order line number. Must match Purchase_Order_Line_ID used in Purchase_Orders_Lines_YYYYMMDD_YYYYMMDD file. If no purchase order, leave blank. |
| 28 | term:linePurchaseOrderQuantity | Term (Text/String) | Purchase order line quantity. If no purchase order, leave blank. |
| 29 | term:linePurchaseOrderUnitofMeasure | Term (Text/String) | Purchase order line base unit of measure. If no purchase order, leave blank. |
| 30 | term:linePurchaseOrderUnitPrice | Term (Text/String) | Purchase order line price per unit. If no purchase order, leave blank. |
| 31 | term:lineReceiptDocumentLineId | Term (Text/String) | Reference line number on receipt document. |
| 32 | term:lineReceiptId | Term (Text/String) | Unique identifier for each shipment received. This ID may need to be created by concatenating fields (for example, document number, document type, and year) to uniquely identify each shipment. |
| 33 | term:lineReceiptProductBarCode | Term (Text/String) | UPC or other general identifier. |
| 34 | term:lineReceiptProductDescription | Term (Text/String) | Product description (plain English) to indicate the name or other identifying characteristics of the product. |
| 35 | term:lineReceiptProductGroup01 | Term (Text/String) | Product descriptor #1, for example, tires or accessories. |
| 36 | term:lineReceiptProductGroup02 | Term (Text/String) | Product descriptor #2, for example, brand. |
| 37 | term:lineReceiptProductId | Term (Text/String) | Identifier that is unique for each product. |
| 38 | term:lineReceiptQuantity | Term (Text/String) | Item quantity received. |
| 39 | term:lineReceiptUnitOfMeasure | Term (Text/String) | Base unit of measure. |
| 40 | term:lineReceiptUnitPrice | Term (Text/String) | Price per unit for item received. |
| 41 | term:postingStatus | Term (Text/String) | Status of the transactions posting to the GL (for example, Posted, Not Posted). |
| 42 | term:purchaseOrderAmount | Term (Decimal) | |
| 43 | term:purchaseOrderCurrencyAmount | Term (Decimal) | Transaction monetary amount in local currency. If no purchase order, leave blank. |
| 44 | term:purchaseOrderCurrencyCode | Term (Text/String) | The currency for local reporting requirements. See ISO 4217 coding. If no purchase order, leave blank. |
| 45 | term:purchaseOrderDate | Term (Date) | The date of the purchase order, regardless of the date the order is entered. If no purchase order leave blank. |
| 46 | term:purchaseOrderExchangeRate | Term (Decimal) | |
| 47 | term:purchaseOrderId | Term (Text/String) | Unique identifier for each purchase order. Must match Purchase_Order_ID in the Purchase_Orders_YYYYMMDD_YYYYMMDD file. If no purchase order, leave blank. |
| 48 | term:receiptDate | Term (Date) | Date of receipt (date received) |
| 49 | term:receiptDocumentId | Term (Text/String) | Reference number on receipt shipping document (company reference or logistics company identifier). |
| 50 | term:receiptFiscalYear | Term (Text/String) | Fiscal year in which the Receipt_Date occurred YYYY for delimited, CCYY-MM-DD fiscal year end (ISO 8601) for extensible business reporting language global ledger taxonomy framework (XBRL GL). |
| 51 | term:receiptId | Term (Text/String) | Unique identifier for each payment received. This ID may need to be created by concatenating fields (for example, customer and payment number) to uniquely identify each transaction. |
| 52 | term:receiptPeriod | Term (Text/String) | Fiscal period in which the Receipt_Date occurs. Examples include W1,W53 for weekly periods, M1,M12 for monthly periods, and Q1,Q4 for quarterly periods. |
| 53 | term:segment01 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 54 | term:segment02 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 55 | term:segment03 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 56 | term:segment04 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 57 | term:segment05 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 58 | 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. |