[Home] [Help] [Dependency Information]
Object Name: | GMF_RCV_ACCOUNTING_TXNS |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.GMF_RCV_ACCOUNTING_TXNS |
Subobject Name: | |
Status: | VALID |
This table stores information for receiving accounting for process organizations
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMF_RCV_ACCOUNTING_TXNS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ACCOUNTING_TXN_ID |
GMF_RCV_ACCOUNTING_TXNS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RCV_TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNTING_TXN_ID | NUMBER | (15) | Yes | Receiving Accounting Transaction identifier |
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 | |
REQUEST_ID | NUMBER | (15) | Concurrent Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Who Column | |
PROGRAM_ID | NUMBER | (15) | Concurrent Who Column | |
PROGRAM_UDPATE_DATE | DATE | Concurrent Who Column | ||
RCV_TRANSACTION_ID | NUMBER | (15) | Receiving Transaction Id | |
EVENT_TYPE | NUMBER | Yes | Receiving Event Type | |
EVENT_SOURCE | VARCHAR2 | (25) | Yes | Receiving Event Source |
EVENT_SOURCE_ID | NUMBER | (15) | Event Source identifier | |
LEDGER_ID | NUMBER | (15) | Ledger Identifier | |
ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
TRANSFER_ORG_ID | NUMBER | (15) | Transfer Operating Unit Identifier | |
ORGANIZATION_ID | NUMBER | (15) | Inv Organization Identifier | |
TRANSFER_ORGANIZATION_ID | NUMBER | (15) | Transfer Inv Organization Identifier | |
DEBIT_ACCOUNT_ID | NUMBER | (15) | Debit Account | |
CREDIT_ACCOUNT_ID | NUMBER | (15) | Credit Account | |
TRANSACTION_DATE | DATE | Transaction Date | ||
TRANSACTION_QUANTITY | NUMBER | Transaction Quantity | ||
TRANSACTION_UNIT_OF_MEASURE | VARCHAR2 | (25) | Transaction UOM | |
SOURCE_DOC_QUANTITY | NUMBER | Source Document Quantity | ||
SOURCE_DOC_UNIT_OF_MEASURE | VARCHAR2 | (25) | Source Document UOM | |
PRIMARY_QUANTITY | NUMBER | Item Primary Quantity | ||
PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Item Primary UOM | |
INVENTORY_ITEM_ID | NUMBER | (15) | Inventory Item Identifier | |
PO_HEADER_ID | NUMBER | (15) | PO Header Identifier | |
PO_RELEASE_ID | NUMBER | (15) | PO Release Identifier | |
PO_LINE_ID | NUMBER | (15) | PO Line Identifier | |
PO_LINE_LOCATION_ID | NUMBER | (15) | PO Shipment Identifier | |
PO_DISTRIBUTION_ID | NUMBER | (15) | PO Distribution Identifier | |
INTERCOMPANY_PRICING_OPTION | NUMBER | (15) | Inter-Company Pricing Flag: 1 = PO Price; 2 = Transfer Price | |
UNIT_PRICE | NUMBER | Unit Price, either PO Price or Transfer Price | ||
TRANSACTION_AMOUNT | NUMBER | Transaction amount | ||
PRIOR_UNIT_PRICE | NUMBER | Prior Unit Price | ||
NR_TAX | NUMBER | Not used currently | ||
REC_TAX | NUMBER | Not used currently | ||
NR_TAX_AMOUNT | NUMBER | Not used currently | ||
REC_TAX_AMOUNT | NUMBER | Not used currently | ||
PRIOR_NR_TAX | NUMBER | Not used currently | ||
PRIOR_REC_TAX | NUMBER | Not used currently | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
ACCOUNTED_FLAG | VARCHAR2 | (1) | Accounted Flag: N = Not Accounted, D = Draft Accounted; Null = Final Accounted | |
PROCUREMENT_ORG_FLAG | VARCHAR2 | (1) | Indicates if transaction is against Supplier facing Operating Unit | |
CROSS_OU_FLAG | VARCHAR2 | (1) | Indicates if PO is across Operating Units | |
TRX_FLOW_HEADER_ID | NUMBER | (15) | Inter-Company Transaction Flow identifier | |
INVOICED_FLAG | VARCHAR2 | (1) | Not used currently | |
UNIT_LANDED_COST | NUMBER | Unit landed cost, which includes Item price, charges, and taxes |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNTING_TXN_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UDPATE_DATE
, RCV_TRANSACTION_ID
, EVENT_TYPE
, EVENT_SOURCE
, EVENT_SOURCE_ID
, LEDGER_ID
, ORG_ID
, TRANSFER_ORG_ID
, ORGANIZATION_ID
, TRANSFER_ORGANIZATION_ID
, DEBIT_ACCOUNT_ID
, CREDIT_ACCOUNT_ID
, TRANSACTION_DATE
, TRANSACTION_QUANTITY
, TRANSACTION_UNIT_OF_MEASURE
, SOURCE_DOC_QUANTITY
, SOURCE_DOC_UNIT_OF_MEASURE
, PRIMARY_QUANTITY
, PRIMARY_UNIT_OF_MEASURE
, INVENTORY_ITEM_ID
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID
, INTERCOMPANY_PRICING_OPTION
, UNIT_PRICE
, TRANSACTION_AMOUNT
, PRIOR_UNIT_PRICE
, NR_TAX
, REC_TAX
, NR_TAX_AMOUNT
, REC_TAX_AMOUNT
, PRIOR_NR_TAX
, PRIOR_REC_TAX
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, ACCOUNTED_FLAG
, PROCUREMENT_ORG_FLAG
, CROSS_OU_FLAG
, TRX_FLOW_HEADER_ID
, INVOICED_FLAG
, UNIT_LANDED_COST
FROM GMF.GMF_RCV_ACCOUNTING_TXNS;
GMF.GMF_RCV_ACCOUNTING_TXNS does not reference any database object
GMF.GMF_RCV_ACCOUNTING_TXNS is referenced by following:
|
|
|