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_IMPORT

Object Details

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

Table Used for IPAC Disbursements Import.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_IPAC_IMPORT_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	IPAC_IMPORT_ID
FV_IPAC_IMPORT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IPAC_IMPORT_ID	NUMBER		Yes	IPAC Import identifier
BATCH_NAME	VARCHAR2	(100)		Import batch name
TRANSACTION_ID	NUMBER	(16)		Transaction identifier
SUBMITTER_ALC	NUMBER	(8)		Agency location code of submitter
ORIGINATING_ALC	NUMBER	(8)		Originating agency location code
CUSTOMER_ALC	NUMBER	(8)		Customer agency location code
CONTACT_NAME	VARCHAR2	(60)		Contact name
CONTACT_EMAIL_ADDRESS	VARCHAR2	(80)		Contact email address
CONTACT_PHONE_NUMBER	VARCHAR2	(17)		Contact phone number
SUMMARY_AMOUNT	NUMBER	(14)		Summary amount
NUMER_OF_DETAIL_LINES	NUMBER	(6)		Number of detail lines
ACCOMPLISHED_DATE	DATE			Accomplished date
ACCOUNTING_DATE	DATE			Accounted date
DETAIL_LINE_NUMBER	NUMBER	(6)		Detail line number
CONTRACT_NUMBER	VARCHAR2	(17)		Contract number
PURCHASE_ORDER_NUMBER	VARCHAR2	(22)		Purchase order number
CLIN	VARCHAR2	(6)		Contract line item number
INVOICE_NUMBER	VARCHAR2	(22)		Invoice number
REQUISITION_NUMBER	VARCHAR2	(15)		Requisition number
QUANTITY	NUMBER	(12)		Quantity
UNIT_OF_ISSUE	VARCHAR2	(2)		Unit of issue
UNIT_PRICE	NUMBER	(19)		Unit price
DETAIL_AMOUNT	NUMBER	(14)		Detail amount
PAY_FLAG	VARCHAR2	(1)		Pay flag
FY_OBLIGATION_ID	VARCHAR2	(1)		Obligation identifier
RECEIVER_TRES_ACCT_SYMBOL	VARCHAR2	(27)		Receiver treasury account symbol
RECEIVER_BETC	VARCHAR2	(8)		Receiver business event type code
RECEIVER_DUNS	VARCHAR2	(9)		Receiver duns number
RECEIVER_DUNS_4	VARCHAR2	(4)		Receiver duns plus 4 number
SENDER_TRES_ACCT_SYMBOL	VARCHAR2	(27)		Sender treasury account symbol
SENDER_BETC	VARCHAR2	(8)		Sender business event type code
SENDER_DUNS	VARCHAR2	(9)		Sender duns number
SENDER_DUNS_4	VARCHAR2	(4)		Sender duns plus 4 number
RECEIVER_DEPARTMENT_CODE	VARCHAR2	(2)		Receiver department code
ACCOUNTING_CLASS_CODE	VARCHAR2	(16)		Accounting class code
ACRN	VARCHAR2	(12)		Account classification reference number
JOB_PROJECT_NUMBER	VARCHAR2	(20)		Job project number
JAS_NUMBER	VARCHAR2	(30)		JAS number (Combination of job order number, accounting classification record number and site-ID
FSN_AAA_ADSN	NUMBER	(8)		Fiscal station number
OBLIGATING_DOC_NUMBER	VARCHAR2	(17)		Obligating document number
ACT_TRACE_NUMBER	VARCHAR2	(15)		Accounting trace number
DESCRIPTION	VARCHAR2	(320)		Description
MISC_INFORMATION	VARCHAR2	(320)		Miscellaneous information
TRANSACTION_TYPE	VARCHAR2	(1)		Transaction type
IPAC_DOC_REF_NUMBER	VARCHAR2	(8)		IPAC document reference number
SENDER_DO_SYMBOL	VARCHAR2	(5)		Sender disbursing office symbol
DODACC	VARCHAR2	(15)		Department of defense activity address code
TRANSACTION_CONTACT	VARCHAR2	(60)		Transaction contact
TRANSCATION_CONTACT_PHONE	VARCHAR2	(17)		Transaction contact phone number
VOUCHER_NUMBER	VARCHAR2	(8)		Voucher number
ORIGINAL_DO_SYMBOL	VARCHAR2	(5)		Original disbursing office symbol
ORIG_ACCOMPLISHED_DATE	DATE			Original accomplished date
ORIG_ACCOUNTING_DATE	DATE			Original accounting date
ORIG_DOC_REF_NUMBER	VARCHAR2	(8)		Original document reference number
ORIG_TRANSACTION_TYPE	VARCHAR2	(1)		Original transaction type
SENDER_SGL_COMMENT	VARCHAR2	(255)		Sender SGL comment
RECEIVER_SGL_COMMENT	VARCHAR2	(255)		Receiver SGL comment
SGL_NUMBER1	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG1	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG1	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG1	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT1	NUMBER	(14)		SGL amount
SGL_NUMBER2	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG2	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG2	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG2	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT2	NUMBER	(14)		SGL amount
SGL_NUMBER3	NUMBER	(4)		SGL amount
SGL_SENDER_RECEIVER_FLAG3	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG3	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG3	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT3	NUMBER	(14)		SGL amount
SGL_NUMBER4	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG4	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG4	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG4	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT4	NUMBER	(14)		SGL amount
SGL_NUMBER5	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG5	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG5	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG5	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT5	NUMBER	(14)		SGL amount
SGL_NUMBER6	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG6	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG6	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG6	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT6	NUMBER	(14)		SGL amount
SGL_NUMBER7	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG7	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG7	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG7	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT7	NUMBER	(14)		SGL amount
SGL_NUMBER8	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG8	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG8	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG8	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT8	NUMBER	(14)		SGL amount
SGL_NUMBER9	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG9	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG9	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG9	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT9	NUMBER	(14)		SGL amount
SGL_NUMBER10	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG10	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG10	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG10	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT10	NUMBER	(14)		SGL amount
SGL_NUMBER11	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG11	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG11	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG11	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT11	NUMBER	(14)		SGL amount
SGL_NUMBER12	NUMBER			SGL account number
SGL_SENDER_RECEIVER_FLAG12	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG12	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG12	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT12	NUMBER	(14)		SGL amount
SGL_NUMBER13	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG13	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG13	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG13	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT13	NUMBER	(4)		SGL amount
SGL_NUMBER14	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG14	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG14	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG14	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT14	NUMBER	(14)		SGL amount
SGL_NUMBER15	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG15	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG15	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG15	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT15	NUMBER	(14)		SGL amount
SGL_NUMBER16	NUMBER	(4)		SGL account number
SGL_SENDER_RECEIVER_FLAG16	VARCHAR2	(1)		SGL sender or receiver flag
SGL_FEDERAL_FLAG16	VARCHAR2	(1)		SGL (F)ederal or (N)on-Federal flag
SGL_DEBIT_CREDIT_FLAG16	VARCHAR2	(1)		SGL (D)ebit or (C)redit flag
SGL_AMOUNT16	NUMBER	(14)		SGL amount
RECORD_STATUS	VARCHAR2	(20)		Record status
ORG_ID	NUMBER			Organization identifier
SET_OF_BOOKS_ID	NUMBER			Accounting books defining column
INVOICE_ID	NUMBER			Invoice identifier
INVOICE_LINE_ID	NUMBER			Invoice line identifier
ACTUAL_PO_NUMBER	VARCHAR2	(22)		Actual purchase order number
ACTUAL_PO_LINE_NUMBER	NUMBER			Actual purchase order line number
VENDOR_ID	NUMBER			Supplier identifier
VENDOR_SITE_ID	NUMBER			Supplier site identifier
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
GROUP_ID	NUMBER			Group identifier
DATA_FILE	VARCHAR2	(256)		Data file name
INT_INVOICE_ID	NUMBER			Interface invoice identifier
INT_INVOICE_LINE_ID	NUMBER			Interface invoice line identifier

Query Text

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


SELECT IPAC_IMPORT_ID
,      BATCH_NAME
,      TRANSACTION_ID
,      SUBMITTER_ALC
,      ORIGINATING_ALC
,      CUSTOMER_ALC
,      CONTACT_NAME
,      CONTACT_EMAIL_ADDRESS
,      CONTACT_PHONE_NUMBER
,      SUMMARY_AMOUNT
,      NUMER_OF_DETAIL_LINES
,      ACCOMPLISHED_DATE
,      ACCOUNTING_DATE
,      DETAIL_LINE_NUMBER
,      CONTRACT_NUMBER
,      PURCHASE_ORDER_NUMBER
,      CLIN
,      INVOICE_NUMBER
,      REQUISITION_NUMBER
,      QUANTITY
,      UNIT_OF_ISSUE
,      UNIT_PRICE
,      DETAIL_AMOUNT
,      PAY_FLAG
,      FY_OBLIGATION_ID
,      RECEIVER_TRES_ACCT_SYMBOL
,      RECEIVER_BETC
,      RECEIVER_DUNS
,      RECEIVER_DUNS_4
,      SENDER_TRES_ACCT_SYMBOL
,      SENDER_BETC
,      SENDER_DUNS
,      SENDER_DUNS_4
,      RECEIVER_DEPARTMENT_CODE
,      ACCOUNTING_CLASS_CODE
,      ACRN
,      JOB_PROJECT_NUMBER
,      JAS_NUMBER
,      FSN_AAA_ADSN
,      OBLIGATING_DOC_NUMBER
,      ACT_TRACE_NUMBER
,      DESCRIPTION
,      MISC_INFORMATION
,      TRANSACTION_TYPE
,      IPAC_DOC_REF_NUMBER
,      SENDER_DO_SYMBOL
,      DODACC
,      TRANSACTION_CONTACT
,      TRANSCATION_CONTACT_PHONE
,      VOUCHER_NUMBER
,      ORIGINAL_DO_SYMBOL
,      ORIG_ACCOMPLISHED_DATE
,      ORIG_ACCOUNTING_DATE
,      ORIG_DOC_REF_NUMBER
,      ORIG_TRANSACTION_TYPE
,      SENDER_SGL_COMMENT
,      RECEIVER_SGL_COMMENT
,      SGL_NUMBER1
,      SGL_SENDER_RECEIVER_FLAG1
,      SGL_FEDERAL_FLAG1
,      SGL_DEBIT_CREDIT_FLAG1
,      SGL_AMOUNT1
,      SGL_NUMBER2
,      SGL_SENDER_RECEIVER_FLAG2
,      SGL_FEDERAL_FLAG2
,      SGL_DEBIT_CREDIT_FLAG2
,      SGL_AMOUNT2
,      SGL_NUMBER3
,      SGL_SENDER_RECEIVER_FLAG3
,      SGL_FEDERAL_FLAG3
,      SGL_DEBIT_CREDIT_FLAG3
,      SGL_AMOUNT3
,      SGL_NUMBER4
,      SGL_SENDER_RECEIVER_FLAG4
,      SGL_FEDERAL_FLAG4
,      SGL_DEBIT_CREDIT_FLAG4
,      SGL_AMOUNT4
,      SGL_NUMBER5
,      SGL_SENDER_RECEIVER_FLAG5
,      SGL_FEDERAL_FLAG5
,      SGL_DEBIT_CREDIT_FLAG5
,      SGL_AMOUNT5
,      SGL_NUMBER6
,      SGL_SENDER_RECEIVER_FLAG6
,      SGL_FEDERAL_FLAG6
,      SGL_DEBIT_CREDIT_FLAG6
,      SGL_AMOUNT6
,      SGL_NUMBER7
,      SGL_SENDER_RECEIVER_FLAG7
,      SGL_FEDERAL_FLAG7
,      SGL_DEBIT_CREDIT_FLAG7
,      SGL_AMOUNT7
,      SGL_NUMBER8
,      SGL_SENDER_RECEIVER_FLAG8
,      SGL_FEDERAL_FLAG8
,      SGL_DEBIT_CREDIT_FLAG8
,      SGL_AMOUNT8
,      SGL_NUMBER9
,      SGL_SENDER_RECEIVER_FLAG9
,      SGL_FEDERAL_FLAG9
,      SGL_DEBIT_CREDIT_FLAG9
,      SGL_AMOUNT9
,      SGL_NUMBER10
,      SGL_SENDER_RECEIVER_FLAG10
,      SGL_FEDERAL_FLAG10
,      SGL_DEBIT_CREDIT_FLAG10
,      SGL_AMOUNT10
,      SGL_NUMBER11
,      SGL_SENDER_RECEIVER_FLAG11
,      SGL_FEDERAL_FLAG11
,      SGL_DEBIT_CREDIT_FLAG11
,      SGL_AMOUNT11
,      SGL_NUMBER12
,      SGL_SENDER_RECEIVER_FLAG12
,      SGL_FEDERAL_FLAG12
,      SGL_DEBIT_CREDIT_FLAG12
,      SGL_AMOUNT12
,      SGL_NUMBER13
,      SGL_SENDER_RECEIVER_FLAG13
,      SGL_FEDERAL_FLAG13
,      SGL_DEBIT_CREDIT_FLAG13
,      SGL_AMOUNT13
,      SGL_NUMBER14
,      SGL_SENDER_RECEIVER_FLAG14
,      SGL_FEDERAL_FLAG14
,      SGL_DEBIT_CREDIT_FLAG14
,      SGL_AMOUNT14
,      SGL_NUMBER15
,      SGL_SENDER_RECEIVER_FLAG15
,      SGL_FEDERAL_FLAG15
,      SGL_DEBIT_CREDIT_FLAG15
,      SGL_AMOUNT15
,      SGL_NUMBER16
,      SGL_SENDER_RECEIVER_FLAG16
,      SGL_FEDERAL_FLAG16
,      SGL_DEBIT_CREDIT_FLAG16
,      SGL_AMOUNT16
,      RECORD_STATUS
,      ORG_ID
,      SET_OF_BOOKS_ID
,      INVOICE_ID
,      INVOICE_LINE_ID
,      ACTUAL_PO_NUMBER
,      ACTUAL_PO_LINE_NUMBER
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      GROUP_ID
,      DATA_FILE
,      INT_INVOICE_ID
,      INT_INVOICE_LINE_ID
FROM FV.FV_IPAC_IMPORT;

Dependencies

[top of page]

FV.FV_IPAC_IMPORT does not reference any database object

FV.FV_IPAC_IMPORT is referenced by following:

FV: FV_IPAC_IMPORT#