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

TABLE: GML.PO_DIST_DTL

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


PO_DIST_DTL stores the General Ledger (GL) distribution for items and acquisition costs for both purchase orders and stock receipt transactions. The GL distribution is generated when PO's are transferred from Oracle Purchasing into OPM and when Stock Receipts in OPM are saved. In Stock Receipts, users can view and edit the GL distribution.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_DIST_DTL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_TYPE
ColumnDOC_ID
ColumnLINE_ID
ColumnRECV_SEQ_NO
ColumnSEQ_NO
Columns
Name Datatype Length Mandatory Comments
DOC_TYPE VARCHAR2 (4) Yes Determines the origin of the document: "pord" - purchase order; "recv" - stock receipts
DOC_ID NUMBER (10) Yes Fk to the document header: "pord" - op_ordr_hdr (purchase order); "recv" - op_recv_hdr (stock recipt)
LINE_ID NUMBER (10) Yes Fk to document line: "pord" - po_ordr_dtl (purchase order); "recv" - po_recv_dtl (stock receipt)
RECV_SEQ_NO NUMBER (5) Yes Additional counter.
SEQ_NO NUMBER (5) Yes Sequence number for the line.
AQUI_COST_ID NUMBER (10)
Fk to po_cost_mst
ITEM_ID NUMBER (10) Yes Fk to ic_item_mst
ACCTG_UNIT_ID NUMBER (10) Yes Fk to gl_accu_mst.
ACCT_ID NUMBER (10) Yes Fk to gl_acct_mst.
ACCT_DESC VARCHAR2 (70) Yes Description of the account
ACCT_TTL_TYPE NUMBER (5) Yes Fk to gl_acct_ttl.
AMOUNT_BASE NUMBER
Yes Monetary amount converted to base currency.
AMOUNT_TRANS NUMBER
Yes Monetary amount in the transaction currency.
QUANTITY NUMBER
Yes Quanity of the transaction.
QUANTITY_UM VARCHAR2 (4) Yes Fk to sy_uoms_mst.
PROJECT_NO VARCHAR2 (16)
Not currently supported
GL_POSTED_IND NUMBER (5) Yes Reserved for future use.
EXPORTED_DATE DATE
Yes Indicates whether the transaction has been posted to oracle financials. Defaults to sy$mindate.
CURRENCY_TRANS VARCHAR2 (4) Yes Curency of the transaction
CURRENCY_BASE VARCHAR2 (4) Yes Base currency.
CO_CODE VARCHAR2 (4) Yes Company code for gl posting purposes. Fk to sy_orgn_mst.
LEDGER_CODE VARCHAR2 (4) Yes Fk to gl_ldgr_mst
FISCAL_YEAR NUMBER (5) Yes Fiscal year of the transaction.
PERIOD NUMBER (5) Yes Fiscal period of the transaction.
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TRANS_CNT NUMBER (10)
Not currently used
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
Query Text

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


SELECT DOC_TYPE
,      DOC_ID
,      LINE_ID
,      RECV_SEQ_NO
,      SEQ_NO
,      AQUI_COST_ID
,      ITEM_ID
,      ACCTG_UNIT_ID
,      ACCT_ID
,      ACCT_DESC
,      ACCT_TTL_TYPE
,      AMOUNT_BASE
,      AMOUNT_TRANS
,      QUANTITY
,      QUANTITY_UM
,      PROJECT_NO
,      GL_POSTED_IND
,      EXPORTED_DATE
,      CURRENCY_TRANS
,      CURRENCY_BASE
,      CO_CODE
,      LEDGER_CODE
,      FISCAL_YEAR
,      PERIOD
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GML.PO_DIST_DTL;

Dependencies

[top of page]

GML.PO_DIST_DTL does not reference any database object

GML.PO_DIST_DTL is referenced by following:

SchemaGML
ViewPO_DIST_DTL#