RCV_PARAMETERS
RCV_PARAMETERS stores receiving options for each organization in which you want to be able to receive items. The table contains one row for each organization.
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
RCV_PARAMETERS_PK |
ORGANIZATION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ORGANIZATION_ID | NUMBER | 18 | Yes | Organization unique identifier for the receiving parameter record. | |
INTF_RETURNS_TO_SHIPPING | VARCHAR2 | 1 | Interface with Shipping during Returns to Suppliers. | ||
INTF_DROPSHIPS_TO_SHIPPING | VARCHAR2 | 1 | Flag that indicates whether or not shipping documents will be printed for Drop Ship transactions. | ||
INTF_RMAS_TO_SHIPPING | VARCHAR2 | 1 | Flag that indicates whether or not shipping documents will be printed for RMA transactions. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
QTY_RCV_TOLERANCE | NUMBER | Over-receipt tolerance value percentage. | |||
QTY_RCV_EXCEPTION_CODE | VARCHAR2 | 25 | Receiving quantity over receipt exception level. Values - REJECT, WARNING, NONE | ||
ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | 25 | Ship-to location control exception level. Values - REJECT, WARNING, NONE. | ||
ALLOW_EXPRESS_DELIVERY_FLAG | VARCHAR2 | 1 | Not populated currently and hence not in use. | ||
DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Number of days allowed for an early receipt. | |||
DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Number of days allowed for a late receipt. | |||
RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | 25 | Indicator of action to take when receipt date is outside of tolerances defined on the document. | ||
RECEIVING_ROUTING_ID | NUMBER | 18 | Receipt Routing indicator to be used while receiving documents. Values: 1 (Standard receipt), 2 (Inspection required) and 3 (Direct delivery). | ||
ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | 1 | Flag to control whether receipt of substitute items is allowed against a purchase order. | ||
ALLOW_UNORDERED_RECEIPTS_FLAG | VARCHAR2 | 1 | Flag to control whether unordered receipts can be created in the inventory organization. | ||
BLIND_RECEIVING_FLAG | VARCHAR2 | 1 | Flag that indicates if blind receiving is to be enforced for this organization. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
ALLOW_CASCADE_TRANSACTIONS | VARCHAR2 | 1 | Not populated currently and hence not in use. | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
RECEIPT_ASN_EXISTS_CODE | VARCHAR2 | 30 | This field holds the action to be taken when the user receives against a purchase order shipment even though an Advance Shipment Notice (ASN) exists. | ||
USER_DEFINED_RECEIPT_NUM_CODE | VARCHAR2 | 25 | Code for receipt number generation. Values - MANUAL, AUTOMATIC. | ||
MANUAL_RECEIPT_NUM_TYPE | VARCHAR2 | 25 | Type of numbers being generated for manual setting - Numeric or Alphanumeric. | ||
NEXT_RECEIPT_NUM | NUMBER | 18 | Number for the next receipt that is to be generated as a sequence. | ||
ENFORCE_RMA_SERIAL_NUM | VARCHAR2 | 1 | Enforce Serial Numbers as on RMA. | ||
RMA_RECEIPT_ROUTING_ID | NUMBER | 18 | Receipt Routing identifier for Return Material Authorization document. | ||
ENFORCE_RMA_LOT_NUM | VARCHAR2 | 1 | Options to enforce the lot number received against the lot number in the RMA line. | ||
MAINTAIN_STANDARD_PACK | VARCHAR2 | 1 | Flag that indicates if the integrity of standard packs are to be retained. | ||
PRINT_RECEIPT_TRAVELER | VARCHAR2 | 1 | Flag that indicates if the print receipt traveler report is automatically invoked on creation of a receipt. | ||
INCLUDE_CLOSED_PO_RECEIPT | VARCHAR2 | 1 | Flag that indicates if the organization will allow receipt against closed purchase orders. | ||
ALLOW_ROUTING_OVERRIDE | VARCHAR2 | 1 | Flag that indicates if the routing on the document can be overridden while executing receiving transactions. | ||
PROCESS_ASN_LINES_TOGETHER | VARCHAR2 | 1 | Flag that indicates if all lines in the ASN will be marked error fail if one line fails in processing. | ||
ADVANCED_PRICING | VARCHAR2 | 1 | Flag to identify if Advanced Pricing is used to capture Charges. | ||
TRANSPORTATION_EXECUTION | VARCHAR2 | 1 | Flag to identify if Transportation Execution is used to estimate charges. | ||
MAINTAIN_SP_QUANTITY | VARCHAR2 | 1 | Flag to maintain the integrity of a standard pack that has been received for all subsequent transactions. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
SEND_CHGRA_ESS_LAST_RUN_DATE | DATE | For internal use only. Indicates last run date for generate changed receipt advice ESS job. | |||
PUBLISH_TXN_EVENTS | VARCHAR2 | 1 | Flag that controls whether receiving transactional business events will be published or not. | ||
INSPECTION_METHOD | VARCHAR2 | 30 | This column indicates whether inspections will be recorded using the standard Receiving inspection UIs or the Quality inspection UIs. | ||
ALLOW_DEFAULT_LOTSER_FROM_ASN | VARCHAR2 | 1 | Check box option allowing to enable functionality whether to default lot and serial numbers from an ASN or ASBN when executing a receipt or putaway transaction, without having to go to the record lot and serial numbers page. | ||
ALLOW_DEFAULT_LOTSER_FROM_TO | VARCHAR2 | 1 | Check box option allowing to enable functionality whether to default lot and serial numbers from a transfer order shipment when executing a receipt or putaway transaction, without having to go to the record lot and serial numbers page. | ||
EXPENSE_DEST_DELIVERY_REQD | VARCHAR2 | 1 | This column indicates if a delivery is required for expense destination receipts created in the current inventory organizations. Valid values are Y, N and NULL. | ||
PAR_LOCATION_DELIVERY_REQD | VARCHAR2 | 1 | This column indicates if a delivery is required for receipts that are put away to PAR locations in the current inventory organizations. Valid values are Y, N and NULL. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
RCV_PARAMETERS_U1 | Unique | Default | ORGANIZATION_ID |