eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FV.FV_IPAC_TRX_ALL

Object Details

Object Name:	FV_IPAC_TRX_ALL
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_IPAC_TRX_ALL
Subobject Name:
Status:	VALID

FV_IPAC_TRAX_ALL is the IPAC transactions table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_IPAC_TRX_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID
FV_IPAC_TRX_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_NAME
FV_IPAC_TRX_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_NUMBER
FV_IPAC_TRX_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Customer transaction identifier
CUSTOMER_ID	NUMBER	(15)	Yes	Customer identifier
ADJUSTMENT_ID	NUMBER	(15)		Adjustment identifier
CUSTOMER_NAME	VARCHAR2	(360)		Customer name
TAXPAYER_NUMBER	VARCHAR2	(50)		Taxpayer reference
TRX_NUMBER	VARCHAR2	(20)	Yes	Transaction number
TRX_DATE	DATE		Yes	Transaction date
TRX_LINE_NO	NUMBER	(15)		Transaction detail line number
AMOUNT	NUMBER		Yes	Transaction amount
PO_NUMBER	VARCHAR2	(50)		Purchase order number
CONTRACT_NO	VARCHAR2	(17)		Contract number
CLIN	VARCHAR2	(17)		Contract line item number
SENDER_ALC	VARCHAR2	(12)		Sending agency Agency Location Code (ALC)
SENDER_DO_SYM	VARCHAR2	(560)		DO Symbol for sending ALC
TRN_SET_ID	NUMBER	(15)		Transaction set identifier
ORG_DCM_RFR	VARCHAR2	(20)		Original document reference number
ORG_DO_SYM	VARCHAR2	(560)		DO symbol of original transaction
ORG_ACC_DT	DATE			Original accomplished date
DPR_CD	VARCHAR2	(150)		Receiver department code
DSC	VARCHAR2	(240)		Description
OBL_DCM_NR	VARCHAR2	(20)		Obligating document number
PAY_FLG	VARCHAR2	(1)		Pay flag; constant F
QTY	NUMBER			Quantity
SND_APP_SYM	VARCHAR2	(35)		Sender Treasury Account Symbol
UNT_ISS	VARCHAR2	(3)		Unit of issue
UNT_PRC	NUMBER			Unit price
ORG_LN_ITM	NUMBER	(15)		Origina line number associated with adjustment
EXCLUDE_FLAG	VARCHAR2	(1)		Exclude flag
PROCESSED_FLAG	VARCHAR2	(1)		Processed flag
RUN_DATE	DATE			Run date
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
EXCEPTION_CATEGORY	VARCHAR2	(35)		Exception category
ORG_ID	NUMBER	(15)	Yes	Organization identifier
CNT_NM	VARCHAR2	(60)	Yes	Contact name
CNT_PHN_NR	VARCHAR2	(17)		Contact phone number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REPORT_FLAG	VARCHAR2	(1)		Report flag
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE21	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE22	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE23	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE24	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE25	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE26	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE27	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE28	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE29	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE30	VARCHAR2	(25)		Descriptive Flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
IPAC_BILLING_ID	NUMBER	(15)	Yes	IPAC transaction unique identifier
SGL_ACCT_NUM	VARCHAR2	(30)		USSGL account number
CR_DR_FLAG	VARCHAR2	(1)		Credit or Debit flag
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
CUST_DUNS_NUM	VARCHAR2	(30)		Customer DUNS number
ACCOUNT_CLASS	VARCHAR2	(30)		Account class
CASH_RECEIPT_ID	NUMBER	(15)		Unique receipt id for a receipt
RECEIPT_FLAG	VARCHAR2	(1)		Receipt created successfully flag
BULK_EXCEPTION	VARCHAR2	(30)		Bulk Exception
ACCOUNTED_FLAG	VARCHAR2	(1)		Accounting created successfully flag

Query Text

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


SELECT CUSTOMER_TRX_ID
,      CUSTOMER_ID
,      ADJUSTMENT_ID
,      CUSTOMER_NAME
,      TAXPAYER_NUMBER
,      TRX_NUMBER
,      TRX_DATE
,      TRX_LINE_NO
,      AMOUNT
,      PO_NUMBER
,      CONTRACT_NO
,      CLIN
,      SENDER_ALC
,      SENDER_DO_SYM
,      TRN_SET_ID
,      ORG_DCM_RFR
,      ORG_DO_SYM
,      ORG_ACC_DT
,      DPR_CD
,      DSC
,      OBL_DCM_NR
,      PAY_FLG
,      QTY
,      SND_APP_SYM
,      UNT_ISS
,      UNT_PRC
,      ORG_LN_ITM
,      EXCLUDE_FLAG
,      PROCESSED_FLAG
,      RUN_DATE
,      SET_OF_BOOKS_ID
,      EXCEPTION_CATEGORY
,      ORG_ID
,      CNT_NM
,      CNT_PHN_NR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REPORT_FLAG
,      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
,      IPAC_BILLING_ID
,      SGL_ACCT_NUM
,      CR_DR_FLAG
,      USSGL_TRANSACTION_CODE
,      CUST_DUNS_NUM
,      ACCOUNT_CLASS
,      CASH_RECEIPT_ID
,      RECEIPT_FLAG
,      BULK_EXCEPTION
,      ACCOUNTED_FLAG
FROM FV.FV_IPAC_TRX_ALL;

Dependencies

[top of page]

FV.FV_IPAC_TRX_ALL does not reference any database object

FV.FV_IPAC_TRX_ALL is referenced by following:

APPS: FV_IPAC_TRX; FV_IPAC_TRX_ALL