[Home] [Help] [Dependency Information]
Object Name: | JAI_CMN_MATCH_RECEIPTS |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_CMN_MATCH_RECEIPTS |
Subobject Name: | |
Status: | VALID |
Records the matching details of Issues against the Receipt in a trading organization
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_CMN_MATCH_RECEIPTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RECEIPT_ID
REF_LINE_ID ORDER_INVOICE |
JAI_CMN_MATCH_RECEIPTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REF_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECEIPT_ID | NUMBER | Yes | Indicates the Receipt, basically a receipt transaction in RG23D register. foreign key to JA_IN_RG23_D.register_id. | |
REF_LINE_ID | NUMBER | Yes | Indicates Delivery_detail_id or customer_trx_line_id based on whether the transaction is done in Order Management or Receivables. | |
SUBINVENTORY | VARCHAR2 | (20) | Indicates the subinventory from where the matching is done. | |
QUANTITY_APPLIED | NUMBER | Yes | Indicates delivery detail quantity applied on receipt in Delivery detail UOM. | |
ISSUE_UOM | VARCHAR2 | (3) | Indicates delivery detail UOM of the quantity. | |
ORDER_INVOICE | VARCHAR2 | (2) | Yes | Indicates whether the matching is done for Sales Order or AR Invoice. possible values `O` for Order, `I` for Invoice. |
SHIP_STATUS | VARCHAR2 | (8) | Indicates the status of delivery detail or customer trx line. possible values are NULL or `CLOSED`. | |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
RECEIPT_QUANTITY_APPLIED | NUMBER | Indicates Quantity applied in receipt UOM. | ||
RECEIPT_QUANTITY_UOM | VARCHAR2 | (4) | Indicates Receipt Quantity UOM. | |
REF_LINE_NO | NUMBER | (4) | Reference Line num | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT RECEIPT_ID
, REF_LINE_ID
, SUBINVENTORY
, QUANTITY_APPLIED
, ISSUE_UOM
, ORDER_INVOICE
, SHIP_STATUS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, RECEIPT_QUANTITY_APPLIED
, RECEIPT_QUANTITY_UOM
, REF_LINE_NO
, OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_MATCH_RECEIPTS;
JA.JAI_CMN_MATCH_RECEIPTS does not reference any database object
JA.JAI_CMN_MATCH_RECEIPTS is referenced by following:
|
|
|