[Home] [Help] [Dependency Information]
Object Name: | FV_TP_BULK_FMT_DATA# |
---|---|
Object Type: | VIEW |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHECKRUN_NAME | VARCHAR2 | (50) | Yes | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
ORG_ID | NUMBER | (15) | Yes | |
PAYMENT_FORMAT_NAME | VARCHAR2 | (30) | Yes | |
FORMAT_PAYMENTS_FRIENDLY_NAME | VARCHAR2 | (50) | Yes | |
PAY_GROUP_CODE | VARCHAR2 | (30) | ||
RFC_IDENTIFIER | VARCHAR2 | (15) | ||
FED_EMPLOYER_ID_NUMBER | VARCHAR2 | (20) | ||
AGENCY_ID | VARCHAR2 | (15) | ||
AGENCY_ALC_CODE | VARCHAR2 | (8) | ||
AGENCY_NAME | VARCHAR2 | (25) | ||
AGENCY_ADDRESS_LINE_1 | VARCHAR2 | (25) | ||
AGENCY_ADDRESS_LINE_2 | VARCHAR2 | (25) | ||
AGENCY_CITY_STATE_ZIP | VARCHAR2 | (25) | ||
AGENCY_TELEPHONE_NUMBER1 | VARCHAR2 | (15) | ||
CHECK_DATE | DATE | |||
EMP_ECS_PAY_TYPE_CODE | VARCHAR2 | (30) | ||
SCHEDULE_RECORD_COUNT | NUMBER | (8) | ||
TOTAL_SCHEDULE_AMOUNT | NUMBER | (17) |
Cut, paste (and edit) the following text to query this object:
SELECT CHECKRUN_NAME
, SET_OF_BOOKS_ID
, ORG_ID
, PAYMENT_FORMAT_NAME
, FORMAT_PAYMENTS_FRIENDLY_NAME
, PAY_GROUP_CODE
, RFC_IDENTIFIER
, FED_EMPLOYER_ID_NUMBER
, AGENCY_ID
, AGENCY_ALC_CODE
, AGENCY_NAME
, AGENCY_ADDRESS_LINE_1
, AGENCY_ADDRESS_LINE_2
, AGENCY_CITY_STATE_ZIP
, AGENCY_TELEPHONE_NUMBER1
, CHECK_DATE
, EMP_ECS_PAY_TYPE_CODE
, SCHEDULE_RECORD_COUNT
, TOTAL_SCHEDULE_AMOUNT
FROM FV.FV_TP_BULK_FMT_DATA#;
|
|
|