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

TABLE: FV.FV_SYSTEM_PARAMETERS

Object Details
Object Name: FV_SYSTEM_PARAMETERS
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_SYSTEM_PARAMETERS
Subobject Name:
Status: VALID


FV_SYSTEM_PARAMETERS stores the Federal System parameters.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
FACTSI_CUSTOMER_ATTRIBUTE VARCHAR2 (15) Yes Attribute column name for FACTS I Customer Eliminations department code
FACTSI_VENDOR_ATTRIBUTE VARCHAR2 (15) Yes Attribute column name for FACTS I Vendor Eliminations department code
REP_2209_ATTRIBUTE VARCHAR2 (15) Yes Attribute column name for 220-9 Adjustment Status Report
ETC_OPTION VARCHAR2 (1) Yes Enhanced Transaction Code option flag. Not currently used.
EBD_OPTION VARCHAR2 (1) Yes Economically Beneficial Discount option flag. Not currently used.
ARAP_OPTION VARCHAR2 (1) Yes AR/AP netting option flag. Not currently used.
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).
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).
FACTSI_JOURNAL_ATTRIBUTE VARCHAR2 (15)
Attribute column name for FACTS I Journal Trading Partner
SF224_ACCOMPLISH_DATE VARCHAR2 (15)
Attribute column name for Oracle Projects accomplished date
FACTSII_PUB_LAW_CODE_ATTRIBUTE VARCHAR2 (15)
Attribute column name for FACTS II Public Law Code
FACTSII_ADVANCE_TYPE_ATTRIBUTE VARCHAR2 (15)
Attribute column name for FACTS II Advance type
FACTSII_TR_MAIN_ACCT_ATTRIBUTE VARCHAR2 (15)
Attribute column name for FACTS II Transfer Main Account
FACTSII_TR_DEPT_ID_ATTRIBUTE VARCHAR2 (15)
Attribute column name for FACTS II Transfer Department ID
REQ_DATE_SEG VARCHAR2 (15)
Attribute column name for Requisition Date
PUR_ORDER_DATE_SEG VARCHAR2 (15)
Attribute column name for Purchase Order Date
REC_TRXN_DATE_SEG VARCHAR2 (15)
Attribute column name for Receiving Date
PYA_INVOICE_ATTRIBUTE VARCHAR2 (15)
Attribute column name for Adjustment to Invoice Paid in Prior Year
AR_RECLASS_ATTRIBUTE VARCHAR2 (15)
Attribute used in DFF in Receipt form to handle the reclassification transactions.
FACTSII_PUB_LAW_REC_ATTRIBUTE VARCHAR2 (15)
Attribute column name for FACTS II Public Law Rec
GTAS_CUSTOMER_ATTRIBUTE VARCHAR2 (15)
Attribute column name for GTAS Trading Partner Agency ID used in hz_cust_accounts for 12.0 and 12.1
Query Text

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


SELECT FACTSI_CUSTOMER_ATTRIBUTE
,      FACTSI_VENDOR_ATTRIBUTE
,      REP_2209_ATTRIBUTE
,      ETC_OPTION
,      EBD_OPTION
,      ARAP_OPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FACTSI_JOURNAL_ATTRIBUTE
,      SF224_ACCOMPLISH_DATE
,      FACTSII_PUB_LAW_CODE_ATTRIBUTE
,      FACTSII_ADVANCE_TYPE_ATTRIBUTE
,      FACTSII_TR_MAIN_ACCT_ATTRIBUTE
,      FACTSII_TR_DEPT_ID_ATTRIBUTE
,      REQ_DATE_SEG
,      PUR_ORDER_DATE_SEG
,      REC_TRXN_DATE_SEG
,      PYA_INVOICE_ATTRIBUTE
,      AR_RECLASS_ATTRIBUTE
,      FACTSII_PUB_LAW_REC_ATTRIBUTE
,      GTAS_CUSTOMER_ATTRIBUTE
FROM FV.FV_SYSTEM_PARAMETERS;

Dependencies

[top of page]

FV.FV_SYSTEM_PARAMETERS does not reference any database object

FV.FV_SYSTEM_PARAMETERS is referenced by following:

SchemaFV
ViewFV_SYSTEM_PARAMETERS#