[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FV_IPAC_IMPORT_HISTORY |
|---|---|
| Object Type: | TABLE |
| Owner: | FV |
| FND Design Data: |  FV.FV_IPAC_IMPORT_HISTORY
|
| Subobject Name: | |
| Status: | VALID |
Table Used for IPAC Disbursements Import.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FV_IPAC_IMPORT_HISTORY_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 IPAC_IMPORT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| IPAC_IMPORT_ID | NUMBER | Yes | IPAC import identifier | |
| BATCH_NAME | VARCHAR2 | (100) | Batch name | |
| TRANSACTION_ID | NUMBER | (16) | Transaction identifier | |
| SUBMITTER_ALC | NUMBER | (8) | Submitter agency location code | |
| ORIGINATING_ALC | NUMBER | (8) | Origination 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 | Accounting 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) | Fiscal year 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 name | |
| 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 account number | |
| 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 | Set of books identifier | ||
| 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 | Vendor identifier | ||
| VENDOR_SITE_ID | NUMBER | Vendor 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 |
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_HISTORY;
FV.FV_IPAC_IMPORT_HISTORY does not reference any database object
FV.FV_IPAC_IMPORT_HISTORY is referenced by following:
APPS
FV_IPAC_IMPORT_HISTORY
|
|
|
|