ReceivingReceiptRequestslines
ReceivingReceiptRequestslines
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslines |
| InterfaceTransactionId [KEY] | Long | Value that uniquely identifies the interfaced receipt line request. |
| HeaderInterfaceId | Long | Value that uniquely identifies the header request to which this line belongs to. |
| CreatedBy | String | CreatedBy of ReceivingReceiptRequestslines |
| CreationDate | Datetime | CreationDate of ReceivingReceiptRequestslines |
| LastUpdateDate | Datetime | LastUpdateDate of ReceivingReceiptRequestslines |
| LastUpdatedBy | String | LastUpdatedBy of ReceivingReceiptRequestslines |
| TransactionType | String | Type if transaction for the line request. Valid values include RECEIVE or SHIP. When creating an advanced shipment notice (ASN) line, transaction type should be set to SHIP. When creating a receipt line request, transaction type should be set to RECEIVE. |
| AutoTransactCode | String | Abbreviation that determines how to finish subsequent transactions automatically, if needed. Valid values include SHIP, RECEIVE, and DELIVER. If you receive a document line (transaction type is RECEIVE) where the document routing is direct delivery, then set auto-transact code to DELIVER. This will receive and also deliver the material or services automatically. If you receive a document with standard or inspection required routing, set auto-transact code to RECEIVE, so that only the receipt is created and the material resides in the receiving bay. When you create an advanced shipment notice (ASN) line (transaction type is SHIP) and set the auto-transact code to RECEIVE, then the advanced shipment notice (ASN) will be created and a receipt is automatically created. If you set auto-transact code to DELIVER, then along with creation of an advanced shipment notice (ASN), receive and deliver take place automatically. |
| TransactionDate | Datetime | Receipt date for the current line. This attribute is used for receipt accounting, invoicing, and other related processes. The default value is the current date and time. If the time zone is not provided, the value stored is the time zone of the database. This value cannot be a future date. |
| OrganizationCode | String | Abbreviation that identifies the receiving organization. This attribute is used to derive the organization identifier. For every receipt line request or advanced shipment notice (ASN) line request, either organization code or organization identifier must be populated. If the values are not provided, the request will fail. |
| OrganizationId | Long | Value that uniquely identifies the receiving organization. For every receipt line request or advanced shipment notice (ASN) line request, either organization code or organization identifier must be populated. If the values are not provided, the request will fail. |
| ItemDescription | String | Description of the item corresponding to the receipt line request or advanced shipment notice (ASN) line request. When you create an ASN or a receipt for a purchase order, it should match the item description of the corresponding purchase order line. For receipts against In-transit shipment, transfer order and return material authorization (RMA), this attribute should match the description of the inventory item. When creating an ASN or a receipt, one of the following must be provided: item identifier, item number, or item description. |
| ItemId | Long | Value that uniquely identifies the inventory item. When creating an advanced shipment notice (ASN) or a receipt, one of the following must be provided: item identifier, item number, or item description. |
| ItemNumber | String | Number that identifies the item. Used to derive the attribute ItemId. When creating an advanced shipment notice (ASN) or a receipt, one of the following must be provided: item identifier, item number, or item description. |
| ItemRevision | String | Number that identifies the revision of the item. This attribute is mandatory when creating receipt lines for an item that is revision controlled. |
| ReceiptSourceCode | String | Value that identifies the source of the advanced shipment notice (ASN) or the receipt. Valid values include VENDOR when creating an ASN, receiving a purchase order, or receiving an ASN, INVENTORY when receiving an in-transit shipment, TRANSFER ORDER when receiving a transfer order, CUSTOMER when receiving a return material authorization (RMA). This attribute is mandatory. |
| SourceDocumentCode | String | Abbreviation that identifies the type of source document. Valid values include PO to create an advanced shipment notice (ASN), receive a purchase order, or an ASN, INVENTORY to receive an in-transit shipment, TRANSFER ORDER to receive a transfer order, RMA to receive a transfer order. A list of accepted values is defined in the lookup type RCV_SOURCE_DOCUMENT_TYPE. This attribute is mandatory. |
| DocumentNumber | String | Number that identifies the document for the receipt line request or advanced shipment notice (ASN) line request. When the source document code is PO (create an ASN, receive a purchase order or an ASN), this attribute is the purchase order number. When the source document code is INVENTORY, this attribute is the in-transit shipment number. When the source document code is TRANSFER ORDER, this attribute is the transfer order shipment number. When the source document code is RMA, this attribute is the return material authorization (RMA) number. This attribute is mandatory. |
| DocumentLineNumber | Long | Number that identifies the document line number for the receipt line request or advanced shipment notice (ASN) line request. When the source document code is PO (create an ASN, receive a purchase order, or receive an ASN), this attribute is the purchase order line number. When the source document code is INVENTORY, this attribute is the in-transit shipment line number. When the source document code is TRANSFER ORDER, this attribute is the transfer order shipment line number. When the source document code is RMA, this attribute is the return material authorization (RMA) line number. This attribute is mandatory. |
| DocumentShipmentLineNumber | Long | Number that identifies the document schedule for the receiving transaction. When the source document code is PO (create an advanced shipment notice (ASN), receive a purchase order, or receive an ASN), this attribute is the purchase order schedule number. When receiving a purchase order or creating an ASN line, this attribute is mandatory. |
| DocumentDistributionNumber | Long | Number that identifies the document distribution for the receiving transaction. When receiving a purchase order that has multiple distributions, this attribute is the respective purchase order distribution number. When receiving a purchase order with multiple distributions, this attribute is mandatory. |
| PODistributionId | Long | Value that uniquely identifies the purchase order distribution. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN. |
| POHeaderId | Long | Value that uniquely identifies the purchase order header. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN. |
| POLineId | Long | Value that uniquely identifies the purchase order line. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN. |
| POLineLocationId | Long | Value that uniquely identifies the purchase order schedule. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN. |
| ShipmentHeaderId | Long | Value that uniquely identifies the receiving shipment or receipt header. This attribute is applicable when receiving an advanced shipment notice (ASN), a in-transit shipment, or a transfer order. |
| ShipmentLineId | Long | Value that uniquely identifies the shipment line. This attribute is applicable when receiving an advanced shipment notice (ASN), a in-transit shipment, or a transfer order. |
| ShipmentNumber | String | Number that indicates the shipment that the shipment source assigns. This number corresponds to the number that identifies one of the following objects: advance shipment notice, in-transit shipment, or transfer-order shipment. |
| ASNLineNumber | Long | Number that identifies the line on the advance shipment notice. Either this attribute or ShipmentLineId must be provided when receiving an advanced shipment notice (ASN). |
| TransferOrderHeaderId | Long | Value that uniquely identifies the transfer order header. This attribute is applicable when receiving a transfer order. |
| TransferOrderLineId | Long | Value that uniquely identifies the transfer order line. This attribute is applicable receiving a transfer order. |
| TransferOrderDistributionId | Long | Value that uniquely identifies the transfer order distribution. This attribute is applicable when receiving a transfer order with multiple distributions and direct routing. |
| SoldtoLegalEntity | String | Name of the sold-to legal entity. Populate this attribute with the sold-to legal entity associated to the purchase order. This is used to derive SoldtoLegalEntityId. |
| SoldtoLegalEntityId | Long | Value that uniquely identifies the sold-to legal entity. The combination of DocumentNumber and SoldtoLegalEntityId is needed to derive POHeaderId, which identifies the purchase order header for a purchase order-based transaction. |
| DestinationTypeCode | String | Abbreviation that identifies the destination type for the receiving transaction. Contains one of the following values: blank, RECEIVING, value stored in destination type, or INVENTORY. When you set to blank, the application will default the appropriate value based on the document type and auto-transact code. This is recommended. When set to RECEIVING, the document routing is standard or inspection required. Set to the value stored in destination type for the corresponding purchase order schedule or transfer order line. When set to INVENTORY, receive in-transit shipment or return material authorization (RMA) and the document routing is direct delivery. |
| Subinventory | String | Name of the destination subinventory for the receiving transaction. This attribute is mandatory when: the document routing is direct delivery or auto-transact code is DELIVER, destination type of the document schedule or document line is Inventory, subinventory is not specified on the document distribution or line (if provided in the document line, the default value is used), or no item transaction default exists (if item transaction default exists, it will be derived). |
| Locator | String | Name of the destination locator for the receiving transaction. This is used to derive LocatorId. This attribute or LocatorId is mandatory when: the document routing is direct delivery or auto-transact code is DELIVER, destination type of the document schedule or document line is Inventory, locator control is predefined or dynamic and item transaction defaults or not entered (if item transaction default exists, it will be derived). |
| LocatorId | Long | Value that uniquely identifies the destination locator for the receiving transaction. This attribute or Locator is mandatory when: the document routing is direct delivery or auto-transact code is DELIVER, destination type of the document schedule or document line is Inventory, locator control is predefined or dynamic and item transaction defaults or not entered (if item transaction default exists, it will be derived). |
| Quantity | Double | Transaction quantity in the unit of measure that the receipt line request or advanced shipment notice (ASN) request uses. |
| UnitOfMeasure | String | Unit of measure for the receipt line or ASN line request. This attribute is used to derive UOMCode. |
| UOMCode | String | Abbreviation that identifies the unit of measure that the receipt line or advanced shipment notice (ASN) line uses. |
| PrimaryQuantity | Double | Transaction quantity in the primary unit of measure that the item uses. |
| PrimaryUOMCode | String | Abbreviation that identifies the primary unit of measure that the item in the receiving organization uses. |
| PrimaryUnitOfMeasure | String | Primary unit of measure that the item in the receiving organization uses. This attribute is used to derive PrimaryUOMCode. |
| ProcessingStatusCode | String | Value that indicates the processing status for the line request. Valid values include PENDING, RUNNING, COMPLETED. The default value is PENDING. Only the interface records with value PENDING will be picked for processing. If there is an error in the derive, default, and validate cycle, the status moves to ERROR. This attribute should be blank during POST operation so that the default value of PENDING is picked. |
| SecondaryUOMCode | String | Abbreviation that identifies the secondary unit of measure that the item in the receiving organization uses. |
| SecondaryUnitOfMeasure | String | Secondary unit of measure that the item in the receiving organization uses. |
| SecondaryQuantity | Double | Transaction quantity in the secondary unit of measure that the item uses. |
| EmployeeId | Long | Value that uniquely identifies the employee who performed the receiving transaction. If this attribute is blank during POST or PATCH operation, the value from the header request is used. |
| EmployeeName | String | Name of the employee who performed the receiving transaction. This attribute is used to derive the EmployeeId. If this attribute is blank during POST or PATCH operation, the value from the header request is used. |
| ParentTransactionId | Long | Value that uniquely identifies the parent receiving transaction. This attribute should not be populated when creating an advanced shipment notice (ASN) or creating a receipt. Since this attribute is applicable only for post receipt transactions, leave this blank. |
| SourceTransactionNumber | String | Number that identifies the unique transaction identifier in the source system. This is not applicable when creating an advanced shipment notice (ASN). This attribute should be unique across the application. There can be only one record in receiving transactions for a source transaction number. |
| ParentSourceTransactionNumber | String | Number that identifies the source transaction of the parent receiving transaction. This attribute should not be populated when creating a receipt or creating an advanced shipment notice (ASN). |
| InterfaceSourceCode | String | Abbreviation that identifies the source that interfaced the receiving transaction. It can be populated with the source application name. |
| InterfaceSourceLineId | Long | Value that uniquely identifies the interfaced source line. This can be populated with the identifier of the line in the source application that initiated the receipt. |
| ShipToLocationCode | String | Abbreviation that identifies the receiving location. This is used to derive ShipTolocationId. When creating a receipt against in-transit shipment, either ShipToLocationCode or ShipToLocationId must be provided. |
| ShipToLocationId | Long | Value that uniquely identifies the receiving location. If this attribute is blank during a POST operation, this is derived from the ShipToLocationId of the source document. When creating a receipt against in-transit shipment, either ShipToLocationCode or ShipToLocationId must be provided. |
| DeliverToLocationCode | String | Abbreviation that identifies the deliver-to location. This is used to derive DeliverTolocationId. |
| DeliverToLocationId | Long | Value that uniquely identifies the deliver-to location. If this attribute is blank during a POST operation, this is derived from the DeliverToLocationId of the document distribution: purchase order distribution or transfer order distribution. DeliverToLocationId is mandatory when receiving a purchase order or transfer order with expense destination and the receipt routing is direct delivery. |
| DeliverToPersonId | Long | Value that uniquely identifies the deliver-to person or requester. If this attribute is blank, this will default to the requester specified on the purchase order distribution or transfer order distribution. |
| DeliverToPersonName | String | Name of the deliver-to person or requester. This attribute is used to derive DeliverToPersonId. |
| RoutingCode | String | Value that indicates the receiving routing. A list of accepted values is defined in the lookup type RCV_ROUTING_HEADERS. |
| RoutingHeaderId | Long | Value that uniquely identifies the receiving routing. Valid values include: 1 for standard receipt, 2 for inspection required, 3 for direct delivery. If this attribute is blank, the value is derived from the document line or schedule. |
| InspectionQualityCode | String | Abbreviation that identifies the inspection quality. This attribute is not applicable for a receipt line request or an advanced shipment notice (ASN) line request. |
| Exception | String | Value that indicates whether or not the receive transaction being created has an exception. If you want to flag the receiving transaction as an exception, populate this attribute with Y. Else, leave it blank. |
| RMAReference | String | Number that identifies the return material authorization that the supplier provides when returning goods to the supplier. This attribute is not currently used. |
| RMANumber | String | Number of the return material authorization (RMA) against which the receipt is being created. This attribute along with RMASourceSystemName of the header is used to derive ReceiptAdviceHeaderId. This attribute is mandatory when creating a receipt for RMA. |
| RMALineNumber | String | Line number of the return material authorization (RMA) against which the receipt is being created. This attribute is used to derive ReceiptAdviceLineId. This attribute is mandatory when creating a receipt for RMA. |
| RMAScheduleNumber | String | Schedule number of the return material authorization against which receipt is being created. |
| ReceiptAdviceHeaderId | Long | Value that uniquely identifies the receipt advice header. |
| ReceiptAdviceLineId | Long | Value that uniquely identifies the receipt advice line. |
| CustomerId | Long | Value that uniquely identifies the customer. This attribute can be blank and the value is derived from the header. |
| CustomerPartyName | String | Name of the customer. This attribute can be blank and the value is derived from the header. |
| CustomerPartyNumber | String | Number that uniquely identifies the customer. This attribute can be blank and the value is derived from the header. |
| CustomerItemNumber | String | Number that the customer uses to identify the item. |
| CustomerItemId | Long | Value that the customer uses to uniquely identify the item. |
| Amount | Double | Receipt amount in the purchase order currency. This attribute is mandatory when creating a receipt for a fixed price service purchase order line. |
| CountryOfOriginCode | String | Abbreviation that identifies the country of manufacture for this item. |
| CurrencyCode | String | Abbreviation that identifies the currency that the receiving transaction uses. If you leave this attribute blank, the value from the document is used. |
| CurrencyConversionDate | Date | Date when the currency conversion occurred for the receipt. Use this attribute only for a purchase order receipt where the option on the purchase order schedule is Receipt and the order currency is different from the ledger currency of the receiving organization. |
| CurrencyConversionRate | Double | Currency conversion rate for the receipt. Use this attribute only for a purchase order receipt where the option on the purchase order schedule is Receipt, the order currency is different from the ledger currency of the receiving organization, and the rate type on the purchase order is User. |
| FromOrganizationCode | String | Abbreviation that identifies the source organization for an interorganization transfer. This is applicable for receipts against in-transit shipment or transfer order shipment. |
| FromOrganizationId | Long | Value that uniquely identifies the source organization for an in-transit shipment. |
| ContainerNumber | String | Container number for the advanced shipment notice (ASN) line request. |
| SubstituteItemNumber | String | Substitute item number for the item on the receipt line. This attribute is used to derive SubstituteItemId. This is applicable for purchase order receipts. |
| SubstituteItemId | Long | Value that uniquely identifies the substitute item. This is applicable for purchase order receipts. |
| SubstituteUnorderedCode | String | Value that indicates whether the transaction is for a substitute item. Enter the value as SUBSTITUTE if you are creating a receipt for a substitute item. |
| VendorName | String | Name of the supplier. You can leave this attribute blank. |
| VendorId | Long | Value that uniquely identifies the supplier. You can leave this attribute blank. |
| VendorNumber | String | Number that identifies the supplier. You can leave this attribute blank. |
| VendorSiteCode | String | Abbreviation that identifies the supplier site for a business unit. This attribute is used to derive SupplierSiteId. It is applicable to creating an advanced shipment notice (ASN), receiving an ASN, or receiving a purchase order. You can leave this attribute blank. |
| VendorSiteId | Long | Value that uniquely identifies the supplier site. It is applicable to creating an advanced shipment notice (ASN), receiving an ASN, or receiving a purchase order. You can leave this attribute blank. |
| VendorItemNumber | String | Number that the supplier uses to identify the item. If a value is entered for this attribute, It must match the supplier item on the purchase order line. |
| BusinessUnit | String | Name of the business unit. For a purchase order receipt, this attribute references the procurement business unit of the supplier site. For a receipt that includes a return material authorization, this attribute references the business unit that the return material authorization contains. |
| BusinessUnitId | Long | Value that uniquely identifies the business unit. For a purchase order receipt, this attribute references the procurement business unit of the supplier site. For a receipt that includes a return material authorization, this attribute references the business unit that the return material authorization contains. You can leave this attribute blank. |
| ConsignedLine | String | Value that indicates whether or not the receiving transaction is for consigned material. If blank for a receipt line request, the value from the document is used. |
| ReasonId | Long | Value that uniquely identifies the inventory transaction reason for the receiving transaction. |
| ReasonName | String | Name of the inventory transaction reason for the receiving transaction. This attribute is used to derive ReasonId. |
| PackingSlip | String | Packing slip number for the container that contains this item. This attribute is applicable when creating an advanced shipment notice (ASN) line request. |
| Comments | String | Text that the used entered when receiving the item. |
| FromSubinventory | String | Name of the source subinventory for the receiving transaction. This attribute is not currently used. |
| FromLocator | String | Name of the source locator for the receiving transaction. This attribute is not currently used. |
| FromLocatorId | Long | Value that uniquely identifies the source locator for the receiving transaction. This attribute is not currently used. |
| TransactionStatusCode | String | Value that indicates the status of the advanced shipment notice (ASN) line request or receipt transaction request. Valid values include PENDING, RUNNING or ERROR. The default value is PENDING. Only the interface records with value PENDING are picked for processing. If there is an error in running the transaction, the status changes to ERROR. This attribute should be blank during POST operations so that the default value of PENDING is used. |
| GroupId | Long | Value that uniquely identifies the group of interface records submitted together for processing. |
| ExternalSystemPackingUnit | String | License plate number of the external warehouse management application. |
| DefaultTaxationCountry | String | Value that indicates the default taxation country. |
| DocumentFiscalClassification | String | Fiscal classification for the document. |
| FirstPartyRegistrationId | Long | Value that uniquely identifies the first party registration. |
| ThirdPartyRegistrationId | Long | Value that uniquely identifies the third party registration. |
| TransactionBusinessCategory | String | Business category of the transaction. |
| TaxInvoiceNumber | String | Number of the tax invoice. |
| TaxInvoiceDate | Date | Date when the tax invoice is created. |
| EwayBillNumber | Long | Number that identifies the electronic waybill provided by supplier for shipment of goods. This value is used to calculate the goods and services tax for India. |
| EwayBillDate | Date | Date when the electronic waybill was generated. This value is used to calculate the goods and services tax for India. |
| UserDefinedFiscalClassification | String | Value that indicates the fiscal classification defined by the user. |
| ProductFiscalClassificationId | Long | Value that uniquely identifies the product fiscal classification. |
| TaxClassificationCode | String | Value that indicates the tax classification. |
| IntendedUseClassificationId | Long | Value that uniquely identifies the intended use classification. |
| IntendedUse | String | Value that indicates the intended use. |
| ProductCategory | String | Value that indicates the product category. |
| AssessableValue | Double | Assessable value of the transaction for taxation purposes. |
| FinalDischargeLocationId | Long | Value that uniquely identifies the final discharge location. |
| ProductType | String | Value that indicates the product type for taxation purposes. |
| FirstPartyRegistrationNumber | String | Number that is used for the first party registration. This attribute is used to derive FirstPartyRegistrationId. |
| ThirdPartyRegistrationNumber | String | Number that is used for the third party registration. This attribute is used to derive ThirdPartyRegistrationId. |
| ProductFiscalClassName | String | Name used to indicate the product fiscal classification. This attribute is used to derive ProductFiscalClassificationId. |
| FinalDischargeLocationCode | String | Value that indicates the final discharge location. This attribute is used to derive FinalDischargeLocationId. |
| BarcodeLabel | String | Label of the barcode on the product. This attribute is applicable only for advanced shipment notice (ASN) line request. |
| TruckNumber | String | Number of the truck. This attribute is applicable only for advanced shipment notice (ASN) line request. |
| InsertAndProcessFlag | Bool | Contains one of the following values: true or false. If true, then the Manage Receiving Transactions API processes the posted interface data automatically and immediately returns the response. If false, then the records are created in interface tables but no processing is done. These interface records can subsequently processed by the Manage Receiving Transactions scheduled process. The default value is true. |
| ReturnStatus | String | Value that indicates the status of the application call that is sent to the client. Values include SUCCESS or ERROR. |
| LPNId | Long | Value that uniquely identifies the source license plate number. This attribute should be populated only for an advanced shipment notice (ASN) line request. |
| LicensePlateNumber | String | Source license plate number of the advanced shipment notice (ASN) request line. This attribute should be populated only for an advanced shipment notice (ASN) line request. |
| SaveAndSubmitFlag | Bool | Contains one of the following values: true or false. If true, then the Manage Receiving Transactions API resubmits the patched interface data automatically and immediately returns the response. If false, then the records are updated in interface tables but not resubmitted. The default value is false. |
| CreateDebitMemoFlag | Bool | Contains one of the following values: true or false. If true, then create the debit memo. If false, then do not create the debit memo. The default value is false. This attribute is not currently used. |
| PhysicalMaterialReturnRequiredFlag | Bool | Contains one of the following values: true or false. If true, then return against a transfer order requires a physical return of the item. If false, then return against a transfer order does not require a physical return of the item. The default value is false. This attribute is not currently used. |
| RecallHeaderId | Long | Value that uniquely identifies the recall notice number. This attribute should only be used for the RETURN TO VENDOR transaction type. |
| RecallLineId | Long | Value that uniquely identifies the line corresponding to the recall notice number. This attribute should only be used for the RETURN TO VENDOR transaction type. |
| RecallLineNumber | Long | Number that identifies the recall notice line. This attribute should only be used for the RETURN TO VENDOR transaction type. |
| RecallNoticeNumber | String | Number that identifies the recall notice. This attribute should only be used for the RETURN TO VENDOR transaction type. |
| ExternalSystemTransactionReference | String | Value that contains reference information for the corresponding transaction in external applications. Do not enter this value at line level for RECEIVE or SHIP transactions, the value given at header is copied to lines. This value is entered at line level for other receiving transactions like inspection, put away, correct, and return. |
| DefaultLotsAndSerialNumbersFromASNFlag | Bool | Contains one of the following values: true or false. If true, then the lots and serial numbers from an advance shipment notice (ASN) or an advance shipment billing notice (ASBN) will be are defaulted when executing a receipt or a put away transaction. If false, then the lots and serial numbers from an advance shipment notice (ASN) or an advance shipment billing notice (ASBN) will not be defaulted when executing a receipt or a put away transaction. The default value is false. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| FromDate | Datetime | FromDate |
| ToDate | Datetime | ToDate |
| Finder | String | finder |