DBA Data[Home] [Help] [Dependency Information]

TABLE: GML.PO_RECV_HDR

Object Details
Object Name: PO_RECV_HDR
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.PO_RECV_HDR
Subobject Name:
Status: VALID


PO_RECV_HDR stores the header information for the receipts made against a purchase order. This table has one entry for every receipt that is created. RECV_ID is the unique system generated key which is not visible to the user. ORGN_NO and RECV_NO is the unique key seen by the user. RECV_TYPE indicates the type of receipt, either from a Purchase Order or a Stock Receipt.
Information in this table is transferred to Oracle Purchasing so that detailed receiving information is available in that application, and specifically, for matching invoices entered in Oracle Payables (and generating automatic invoices). The Receiving Open Interface in Oracle Purchasing is used to create receiving transactions in Oracle Purchasing when receipts are saved in OPM. Receipt numbers in OPM and Oracle Purchasing are the same since the same source is used for document numbering. Stock receipts are maintained only in OPM, so they have a different document numbering sequence.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_RECV_HDR_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECV_ID
PO_RECV_HDR_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGN_CODE
ColumnRECV_NO
Columns
Name Datatype Length Mandatory Comments
RECV_ID NUMBER (10) Yes Physical key.
RECV_LOCT VARCHAR2 (16)
Default actual receiving location.
RECV_NO VARCHAR2 (32) Yes Document number.
RECV_TYPE NUMBER (5) Yes Indicates document type which created the receipt: 1 - po receipt; 2 - stock receipt
PAYVEND_ID NUMBER (10)
Remit to vendor. Fk to po_vend_mst.
SHIPVEND_ID NUMBER (10)
Vendor shipping the order. Fk to po_vend_mst.
SHIPPER_CODE VARCHAR2 (4)
Default actual shipper (op_ship_mst).
SHIP_MTHD VARCHAR2 (4)
Default actual ship method (op_ship_mth).
TO_WHSE VARCHAR2 (4)
Default actual receiveing warehouse.
ORGN_CODE VARCHAR2 (4) Yes Fk to sy_orgn_mst.
RECV_DATE DATE
Yes Receipt date and default for po_ordr_dtl.
REASON_CODE VARCHAR2 (4)
Fk to sy_reas_cds.
TRAILER_NO VARCHAR2 (40)
Number of trailer making delivery.
WAYBILL_NO VARCHAR2 (32)
Shippers shipment identification number.
RECEIVED_BY NUMBER (15)
Fk to sy_oper_mst.
APPROVED_BY NUMBER (15)
Fk to sy_oper_mst.
PRINT_COUNT NUMBER (5) Yes Number of times printed.
DEBARKATION_PORT VARCHAR2 (8)
Fk to op_port_mst.
EMBARKATION_PORT VARCHAR2 (8)
Fk to op_port_mst.
ARRIVAL_DATE DATE

Date & time trucker arrived.
DEPARTURE_DATE DATE

Date & time trucker departed.
REGISTERED_IND NUMBER (5) Yes 0 - not registered; 1=registered.
DEMURRAGE_AMT NUMBER

Actual demurrage penalty.
DEMURRAGE_CURRENCY VARCHAR2 (4)
Fk to gl_curr_cds.
RECEIPT_COMMENT VARCHAR2 (70)
Prints on receipt ticket.
GROSS_WT NUMBER

Weight of truck/rail car before unload.
NET_WT NUMBER

Net weight of entire receipt.
TARE_WT NUMBER

Weight of truck/rail car after unload.
BOL_UM VARCHAR2 (4)
Fk to sy_uoms_mst.
DATE_PRINTED DATE

Date receipt ticket printed.
VOID_IND NUMBER (5) Yes 0=no void; 1=void.
IN_USE NUMBER (10)
Not currently used
RECEIPT_EXCHANGE_RATE NUMBER
Yes Exchange rate used to convert the amount into base currency.
MUL_DIV_SIGN NUMBER (5) Yes 0 - multiply; 1 - divide
BILLING_CURRENCY VARCHAR2 (4) Yes Fk to gl_curr_mst.
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
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
CREATED_BY NUMBER (15) Yes Standard who column
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RECV_ID
,      RECV_LOCT
,      RECV_NO
,      RECV_TYPE
,      PAYVEND_ID
,      SHIPVEND_ID
,      SHIPPER_CODE
,      SHIP_MTHD
,      TO_WHSE
,      ORGN_CODE
,      RECV_DATE
,      REASON_CODE
,      TRAILER_NO
,      WAYBILL_NO
,      RECEIVED_BY
,      APPROVED_BY
,      PRINT_COUNT
,      DEBARKATION_PORT
,      EMBARKATION_PORT
,      ARRIVAL_DATE
,      DEPARTURE_DATE
,      REGISTERED_IND
,      DEMURRAGE_AMT
,      DEMURRAGE_CURRENCY
,      RECEIPT_COMMENT
,      GROSS_WT
,      NET_WT
,      TARE_WT
,      BOL_UM
,      DATE_PRINTED
,      VOID_IND
,      IN_USE
,      RECEIPT_EXCHANGE_RATE
,      MUL_DIV_SIGN
,      BILLING_CURRENCY
,      TEXT_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      DELETE_MARK
,      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_RECV_HDR;

Dependencies

[top of page]

GML.PO_RECV_HDR does not reference any database object

GML.PO_RECV_HDR is referenced by following:

SchemaAPPS
SynonymPO_RECV_HDR