[Home] [Help] [Dependency Information]
Object Name: | FV_SYSTEM_PARAMETERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FV.FV_SYSTEM_PARAMETERS_V |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
FV_SYSTEM_PARAMETERS_V stores system information used by
processes such as Prompt Payment and FMS Form 224 Statement of
Transactions, and by disbursements in transit accounting. There is
one row for each Set of Books defined in the system.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
NAME | VARCHAR2 | (240) | Yes | Legal entity name |
ADDRESS_LINE_1 | VARCHAR2 | (240) | Legal entity address | |
ADDRESS_LINE_2 | VARCHAR2 | (240) | Legal entity address | |
ADDRESS_LINE_3 | VARCHAR2 | (240) | Legal entity address | |
TOWN_OR_CITY | VARCHAR2 | (30) | Legal entity city | |
REGION_1 | VARCHAR2 | (120) | ||
REGION_2 | VARCHAR2 | (120) | Legal entity state | |
REGION_3 | VARCHAR2 | (120) | ||
POSTAL_CODE | VARCHAR2 | (30) | Legal entity postal code | |
OU_ORG_ID | NUMBER | (15) | Yes | Operating unit organization identifier |
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
ALC_CODE | VARCHAR2 | (30) | Agency Location Code | |
RECEIVABLES_TRX_ID | NUMBER | (15) | Receivables Transaction ID | |
PAYABLES_IA_PAYGROUP | VARCHAR2 | (30) | Yes | Interagency Pay Group |
TELEPHONE_NUMBER_1 | VARCHAR2 | (60) | ||
TELEPHONE_NUMBER_2 | VARCHAR2 | (60) | ||
TELEPHONE_NUMBER_3 | VARCHAR2 | (60) | ||
FED_EMPLOYER_ID_NUMBER | VARCHAR2 | (20) | Federal Employer Identification Number enetered in Define Federal Options window. | |
DIT_CONFIRM_CASH_ACCOUNT | VARCHAR2 | (25) |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, NAME
, ADDRESS_LINE_1
, ADDRESS_LINE_2
, ADDRESS_LINE_3
, TOWN_OR_CITY
, REGION_1
, REGION_2
, REGION_3
, POSTAL_CODE
, OU_ORG_ID
, LEGAL_ENTITY_ID
, ALC_CODE
, RECEIVABLES_TRX_ID
, PAYABLES_IA_PAYGROUP
, TELEPHONE_NUMBER_1
, TELEPHONE_NUMBER_2
, TELEPHONE_NUMBER_3
, FED_EMPLOYER_ID_NUMBER
, DIT_CONFIRM_CASH_ACCOUNT
FROM APPS.FV_SYSTEM_PARAMETERS_V;
|
|
|