Receiving Inbound Shipment Lines
The Receiving Inbound Shipment Lines view object contains information for receipt, advance shipment notice (ASN), and advance shipment billing notice (ASBN) line.
Data Store Key : FscmTopModelAM.ScmExtractAM.RcvBiccExtractAM.ReceivingInboundShipmentLineExtractPVO
Primary Keys : ShipmentLineId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
Amount | Amount for designated transaction or receipt. |
AmountReceived | Amount received for a fixed price service receipt line in purchase order currency. |
AmountShipped | Amount shipped for a fixed price service receipt line in purchase order currency. |
AsnLineFlag | Contains one of the following values: true or false. If true, then the item is on an advance shipment notice (ASN). If false, then the item isn't on an ASN. This attribute doesn't have a default value, but a value of null translates to false. This attribute is used by the missing ASN items processor to determine whether shipped items were received. |
AsnLpnId | Value that uniquely identifies the license plate number used for this advanced shipment notice line. |
AssessableValue | Price at which a product is valued by a tax authority for tax. |
Attribute1 | Segment for the Receipt Line descriptive flexfield. |
Attribute10 | Segment for the Receipt Line descriptive flexfield. |
Attribute11 | Segment for the Receipt Line descriptive flexfield. |
Attribute12 | Segment for the Receipt Line descriptive flexfield. |
Attribute13 | Segment for the Receipt Line descriptive flexfield. |
Attribute14 | Segment for the Receipt Line descriptive flexfield. |
Attribute15 | Segment for the Receipt Line descriptive flexfield. |
Attribute16 | Segment for the Receipt Line descriptive flexfield. |
Attribute17 | Segment for the Receipt Line descriptive flexfield. |
Attribute18 | Segment for the Receipt Line descriptive flexfield. |
Attribute19 | Segment for the Receipt Line descriptive flexfield. |
Attribute2 | Segment for the Receipt Line descriptive flexfield. |
Attribute20 | Segment for the Receipt Line descriptive flexfield. |
Attribute3 | Segment for the Receipt Line descriptive flexfield. |
Attribute4 | Segment for the Receipt Line descriptive flexfield. |
Attribute5 | Segment for the Receipt Line descriptive flexfield. |
Attribute6 | Segment for the Receipt Line descriptive flexfield. |
Attribute7 | Segment for the Receipt Line descriptive flexfield. |
Attribute8 | Segment for the Receipt Line descriptive flexfield. |
Attribute9 | Segment for the Receipt Line descriptive flexfield. |
AttributeCategory | Context name for the Receipt Line descriptive flexfield. |
AttributeDate1 | Date segment for the Receipt Line descriptive flexfield. |
AttributeDate2 | Date segment for the Receipt Line descriptive flexfield. |
AttributeDate3 | Date segment for the Receipt Line descriptive flexfield. |
AttributeDate4 | Date segment for the Receipt Line descriptive flexfield. |
AttributeDate5 | Date segment for the Receipt Line descriptive flexfield. |
AttributeNumber1 | Number segment for the Receipt Line descriptive flexfield. |
AttributeNumber10 | Number segment for the Receipt Line descriptive flexfield. |
AttributeNumber2 | Number segment for the Receipt Line descriptive flexfield. |
AttributeNumber3 | Number segment for the Receipt Line descriptive flexfield. |
AttributeNumber4 | Number segment for the Receipt Line descriptive flexfield. |
AttributeNumber5 | Number segment for the Receipt Line descriptive flexfield. |
AttributeNumber6 | Number segment for the Receipt Line descriptive flexfield. |
AttributeNumber7 | Number segment for the Receipt Line descriptive flexfield. |
AttributeNumber8 | Number segment for the Receipt Line descriptive flexfield. |
AttributeNumber9 | Number segment for the Receipt Line descriptive flexfield. |
AttributeTimestamp1 | Date and time segment for the Receipt Line descriptive flexfield. |
AttributeTimestamp2 | Date and time segment for the Receipt Line descriptive flexfield. |
AttributeTimestamp3 | Date and time segment for the Receipt Line descriptive flexfield. |
AttributeTimestamp4 | Date and time segment for the Receipt Line descriptive flexfield. |
AttributeTimestamp5 | Date and time segment for the Receipt Line descriptive flexfield. |
BackToBackFlag | Contains one of the following values: true or false. If true, then the supply source for a reservation is a back-to-back purchase order. If false, then the supply source for a reservation is a transfer order. This attribute doesn't have a default value, but a value of null translates to false. |
BarCodeLabel | Bar code label for the material on the shipment line. |
CategoryId | Value that uniquely identifies the item category. |
Comments | Comments entered by the user. |
ConsignedFlag | Contains one of the following values: true or false. If true, then the receipt line is created for consigned material. If false, then the receipt line isn't created for consigned material. This attribute doesn't have a default value, but a value of null translates to false. |
ConsumedQuantity | Quantity consumed by the supplier consigned inventory. |
ContainerNum | Reference number assigned to the freight container. This attribute is used for documentation purposes. |
CountryOfOriginCode | Code that identifies the country of manufacture of this item. |
CreatedBy | User who created the inbound shipment line record. |
CreationDate | Date and time when the inbound shipment line record was created. |
CustomerId | Value that uniquely identifies the customer. This attribute is used for return material authorization (RMA) transactions. |
CustomerItemId | Value that uniquely identifies the customer item. |
CustomerItemNum | Number that identifies the customer's item. |
CustomerSiteId | Value that uniquely identifies the customer site. This attribute is used for return material authorization (RMA) transactions. |
DefaultTaxationCountry | Code that identifies the default taxation country for the shipment line. |
DeliverToLocationId | Value that uniquely identifies the deliver-to location. |
DeliverToPersonId | Value that uniquely identifies the deliver-to person. |
DestinationContext | Destination descriptive flexfield context for the Receiving Inbound Shipment Line descriptive flexfield. |
DestinationTypeCode | Code that identifies the destination type of the receiving transaction. A list of accepted values is defined in the lookup type RCV_DESTINATION_TYPE. |
DocumentFiscalClassification | Value that identifies the document fiscal classification. This value is also known as Tax Document Subtype. |
EmployeeId | Value that uniquely identifies the person who created the receiving transaction. |
EwayBillDate | Date when the user generated the electronic way bill number. This attribute is used for goods and services tax in India. |
EwayBillNumber | Number that identifies the electronic way bill. This attribute is used for goods and services tax in India. |
ExcessTransportReason | Reason for the excess transportation. |
ExternalSysIntfStatus | Indicates whether the receipt advice for this shipment has been interfaced to the external system or has been confirmed as received. |
FinalDischargeLocationId | Value that uniquely identifies the final destination for the purchase, if it's different from the ship-to location. |
FirstPtyRegId | Value that uniquely identifies the first party tax registration for the shipment line. |
FromOrganizationId | Value that uniquely identifies the originating organization of the in-transit shipment or transfer order shipment. |
GovernmentContext | Context name for United States Standard General Ledger (USSGL). |
IntendedUse | Purpose for which the product is used. |
IntendedUseClassifId | Value that uniquely identifies the intended use of the transaction line. This attribute identifies the purpose for which the product is used. |
InterfaceTransactionId | Value that uniquely identifies the transaction interface record. |
InvReservedAttribute1 | Reserved for future inventory striping related functionality. |
InvReservedAttribute2 | Reserved for future inventory striping related functionality. |
InvStripingCategory | Context name for inventory striping attributes. |
InvUserDefAttribute1 | Reserved for user-definable inventory striping information. |
InvUserDefAttribute10 | Reserved for user-definable inventory striping information. |
InvUserDefAttribute2 | Reserved for user-definable inventory striping information. |
InvUserDefAttribute3 | Reserved for user-definable inventory striping information. |
InvUserDefAttribute4 | Reserved for user-definable inventory striping information. |
InvUserDefAttribute5 | Reserved for user-definable inventory striping information. |
InvUserDefAttribute6 | Reserved for user-definable inventory striping information. |
InvUserDefAttribute7 | Reserved for user-definable inventory striping information. |
InvUserDefAttribute8 | Reserved for user-definable inventory striping information. |
InvUserDefAttribute9 | Reserved for user-definable inventory striping information. |
InvoiceStatusCode | Code that identifies the advance shipment notice (ASN) with billing information (ASBN) only. This attribute indicates when the line items were rejected. |
ItemDescription | Description of the item being shipped. |
ItemId | Value that uniquely identifies the item. |
ItemRevision | Value that identifies an incremental change to the item. |
JobDefinitionName | Name of the scheduled process that created or last updated the record. |
JobDefinitionPackage | Package name of the scheduled process that created or most recently updated the record. |
LastUpdateDate | Date and time when the user most recently updated the inbound shipment line record. |
LastUpdateLogin | Session login associated with the user who most recently updated the inbound shipment line record. |
LastUpdatedBy | User who most recently updated the inbound shipment line record. |
LineNum | Number that identifies the line in a document. |
LocatorId | Value that uniquely identifies the locator. |
MmtTransactionId | Value that uniquely identifies the inventory transaction that created the in-transit shipment line. This attribute maps to INV_MATERIAL_TXNS.TRANSACTION_ID. |
NoticeUnitPrice | Electronic data interchange (EDI) transaction 857 unit price for the item in the shipment line. |
ObjectVersionNumber | Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
OrigToInvShipTxnId | Value that uniquely identifies the inventory transaction of the original transfer order shipment for a return transfer order. |
PackingSlip | Document that itemizes in detail the contents of a particular package, carton, pallet, or container for shipment to a customer. |
PoDistributionId | Value that uniquely identifies the purchase order distribution. |
PoHeaderId | Value that uniquely identifies the purchase order header. |
PoLineId | Value that uniquely identifies the purchase order line. |
PoLineLocationId | Value that uniquely identifies the purchase order schedule. |
PrimaryUomCode | Code that identifies the primary unit of measure of the item in the receiving organization. |
ProductCategory | Category of the product in the shipment line. |
ProductFiscClassId | Value that uniquely identifies the product fiscal classification for the inventory item. |
ProductType | Code that identifies the product type of the inventory item. Valid values are GOODS and SERVICES. |
ProjectId | Value that uniquely identifies the project. |
QuantityAccepted | Net accepted quantity for this inbound shipment line. |
QuantityDelivered | Net quantity delivered for this inbound shipment line. |
QuantityReceived | Net quantity received for the inbound shipment line. |
QuantityRejected | Net quantity rejected for this inbound shipment line. |
QuantityReturned | Net quantity returned for this inbound shipment line. |
QuantityShipped | Total quantity of goods shipped for this inbound shipment line. |
RaAllowSubstituteReceipt | Value that indicates whether to allow receipt of substitute items control for receipt advice line. This attribute is used for flexible supply source documents |
RaDaysEarlyReceiptAllowed | Number of days allowed for an early receipt against receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaDaysLateReceiptAllowed | Number of days allowed for a late receipt against receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaDocLineCreationDate | Date when the user created the source document line for receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaDocLineLastUpdateDate | Date when the user most recently updated the source document line for receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaDocScheduleNumber | Number that identifies source document schedule for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaDocumentLineNumber | Number that identifies the source document line for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaDooFulfillmentLineNumber | Number that identifies the fulfillment line reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RaDooHeaderNumber | Number that identifies the header reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RaDooLineNumber | Number that identifies the line reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RaEnforceShipToLocCode | Code that identifies the ship-to location exception control for receipt advice line. This attribute is used for flexible supply source documents. |
RaExpectedReceiptDate | Date when the receipt advice line is expected to arrive. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaLastActionCode | Code that identifies the last action performed on the receipt advice line. Valid values include CREATE, UPDATE, and CANCEL. |
RaMessageNumber | Number that identifies the message when the user most recently processed the receipt advice. |
RaNoteToReceiver | Note to receiver specified in the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaOrigDooFulfilLineNum | Number that identifies the original fulfillment line reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RaOrigDooHeaderNumber | Number that identifies the original order reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RaOrigDooLineNumber | Number that identifies the original order line reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RaOrigOcHeaderNumber | Number that identifies the original sales order reference corresponding to the return material authorization (RMA). |
RaOrigOcLineNumber | Number that identifies the original sales order line reference corresponding to the return material authorization (RMA). |
RaQtyRcvExceptionCode | Code that identifies the overreceipt quantity tolerance exception level for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaQtyRcvTolerance | Overreceipt quantity tolerance for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaQuantityExpected | Expected quantity to be received for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaReceiptDaysExceptionCode | Code that identifies the receipt days exception level for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaSecondaryQuantityExpected | Expected quantity to be received for the receipt advice line in item's secondary UOM. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RaUnitPrice | Unit price of the inventory item for the receipt advice line. This attribute is used for flexible supply source documents. |
ReasonId | Value that uniquely identifies the reason. |
ReceiptAdviceHeaderId | Value that uniquely identifies the receipt advice header. |
ReceiptAdviceLineId | Value that uniquely identifies the receipt advice line. |
ReceiptAdviceLineNumber | Number that identifies the line for the receipt advice. |
ReqDistributionId | Value that uniquely identifies the requisition distribution. |
RequestId | Value that uniquely identifies the request of the scheduled process that created or most recently updated the row. |
RequisitionLineId | Value that uniquely identifies the requisition line. |
RoutingHeaderId | Value that uniquely identifies the receipt routing. Values include 1, 2, and 3. A list of accepted values is defined in the lookup type RCV_ROUTING_HEADERS. |
SecondaryQtyAccepted | Quantity accepted in the secondary unit of measure. |
SecondaryQtyDelivered | Quantity delivered in the secondary unit of measure. |
SecondaryQtyRejected | Quantity rejected in the secondary unit of measure. |
SecondaryQtyReturned | Quantity returned in the secondary unit of measure. |
SecondaryQuantityReceived | Quantity received in the secondary unit of measure. |
SecondaryQuantityShipped | Quantity shipped in the secondary unit of measure. |
SecondaryUomCode | Code that identifies the unit of measure for the secondary quantity. |
ShipFromLocationId | Value that uniquely identifies the ship from location of the supplier site. |
ShipToLocationId | Value that uniquely identifies the receiving location. |
ShipmentHeaderId | Value that uniquely identifies the shipment header. |
ShipmentLineId | Value that uniquely identifies the shipment line. |
ShipmentLineStatusCode | Code that identifies the state of the inbound shipment line. Valid values include EXPECTED, PARTIALLY RECEIVED, FULLY RECEIVED, and CANCELLED. |
ShipmentUnitPrice | Unit price for shipping the item. |
SourceDocumentCode | Code that identifies the document classification based on the originating source such as purchase order or transfer order. A list of accepted values is defined in the lookup type RCV_SOURCE_DOCUMENT_TYPE. |
SpGroupId | Value that uniquely identifies the grouping standard pack receipts. |
SpQuantity | Transaction quantity represented in terms of standard pack unit of measure. |
SpUomCode | Code that identifies the standard pack unit of measure. |
TaskId | Value that uniquely identifies the task. |
TaxAmount | Value of a tax for a given tax jurisdiction for a given tax event. Each tax amount that's calculated for a tax may also have a tax recovery amount and nontax recoverable amount. For purposes of reconciliation to general ledger, these amounts will each have their own tax line. The tax amount is represented in three currencies: transactional currency, functional currency, and tax currency. |
TaxClassificationCode | Code that identifies the tax classification for the shipment line. |
TaxInvoiceDate | Date when the user generated the fiscal document. |
TaxInvoiceNumber | Number that identifies the fiscal document. |
TaxName | Name of the tax associated with the shipment or billing notice (advanced shipment notice (ASN) with billing information). |
ThirdPtyRegId | Value that uniquely identifies the third party tax registration for the shipment line. |
ToOrganizationId | Value that uniquely identifies the receiving organization. |
ToSubinventory | Default destination subinventory in the receiving organization. |
TransferCost | Cost of transfer for the interorganizational shipments. |
TransferOrderHeaderId | Value that uniquely identifies the transfer order header. |
TransferOrderLineId | Value that uniquely identifies the transfer order line. |
TransferPercentage | Percent of transfer for costing. |
TransportationCost | Base cost of transportation that's incurred by a merchant in moving goods, by whatever means, from one place to another under the terms of the contract of carriage. |
TruckNum | Number of the truck used for shipment. |
TrxBusinessCategory | Business category of the transaction for the shipment line. |
UomCode | Code that identifies the unit of measure in which the lot was shipped. |
UserDefinedFiscClass | User defined fiscal classification code for the shipment line. |
VendorCumShippedQuantity | Quantity shipped by the supplier specified on the advanced shipment notice (ASN). This attribute is populated for parent lines only. |
VendorItemNum | Number that identifies the supplier's item. This attribute maps to PO_LINES_ALL.VENDOR_PRODUCT_NUM. |
VendorLotNum | Number that identifies the lot given by the supplier for the purchase order receipts. |
WorkConfirmationId | Value that uniquely identifies the work confirmation. |
WorkConfirmationLineId | Value that uniquely identifies the work confirmation line. |