[Home] [Help] [Dependency Information]
Object Name: | PO_RTRN_HDR |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.PO_RTRN_HDR |
Subobject Name: | |
Status: | VALID |
PO_RTRN_HDR holds the header information of all the returns. It has a record for every return created against a purchase order or for a stock receipt. RETURN_ID is the unique system generated id which is not visible to the user. RETURN_NO is the unique number which the user sees.
Information in this table is transferred to Oracle Purchasing so that detailed return information is available in that application, and specifically, for matching invoices entered in Oracle Payables (and generating automatic invoices). The table RCV_TRANSACTIONS is updated to reflect returns entered in OPM.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PO_RTRN_HDR_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | RETURN_ID |
PO_RTRN_HDRI1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGN_CODE
RETURN_NO |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RETURN_ID | NUMBER | (10) | Yes | Surrogate key for the return. |
ORGN_CODE | VARCHAR2 | (4) | Yes | Organization code. Fk to sy_orgn_mst. |
RETURN_NO | VARCHAR2 | (32) | Yes | Return number. |
RETURN_VENDOR_ID | NUMBER | (10) | Yes | Surrogate key for the vendor to which the return is made. Fk to po_vend_mst. |
RTRNADDR_ID | NUMBER | (10) | Surrogate key to the address at which the return vendor will accept the return. Fk to sy_addr_mst. | |
RETURN_DATE | DATE | Yes | Date on which the return was made. | |
SHIPPER_CODE | VARCHAR2 | (4) | Shipper carrying the return. Fk to op_ship_mst. | |
IN_USE | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT RETURN_ID
, ORGN_CODE
, RETURN_NO
, RETURN_VENDOR_ID
, RTRNADDR_ID
, RETURN_DATE
, SHIPPER_CODE
, IN_USE
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE_CATEGORY
FROM GML.PO_RTRN_HDR;
GML.PO_RTRN_HDR does not reference any database object
GML.PO_RTRN_HDR is referenced by following:
|
|
|