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: TableFV.FV_IPAC_TRX_ALL
Subobject Name:
Status: VALID


FV_IPAC_TRAX_ALL is the IPAC transactions table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FV_IPAC_TRX_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
FV_IPAC_TRX_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_NAME
FV_IPAC_TRX_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_NUMBER
FV_IPAC_TRX_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_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:

SchemaFV
ViewFV_IPAC_TRX_ALL#