[Home] [Help] [Dependency Information]
Object Name: | PAY_ZA_BRANCH_CDV_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BRANCH_CODE | VARCHAR2 | (6) | Yes | |
SSV_ALLOWED | NUMBER | (1) | Yes | |
ONE_DAY_SS | NUMBER | (1) | ||
TWO_DAY_SS | NUMBER | (1) | ||
FIVE_DAY_SS | NUMBER | (1) | ||
STREAM_CODE | NUMBER | (2) | Yes | |
BANK_NAME | VARCHAR2 | (40) | ||
BRANCH_NAME | VARCHAR2 | (30) | Yes | |
STREET_ADDRESS_LINE_1 | VARCHAR2 | (48) | ||
STREET_ADDRESS_LINE_2 | VARCHAR2 | (48) | ||
PO_BOX_NUMBER | VARCHAR2 | (35) | ||
PO_BOX_POST_OFFICE | VARCHAR2 | (20) | ||
POSTAL_CODE | NUMBER | (6) | ||
TELEPHONE_NUMBER | VARCHAR2 | (14) | ||
DIALING_CODE | VARCHAR2 | (20) | ||
TELEX1 | VARCHAR2 | (20) | ||
TELEX2 | VARCHAR2 | (20) | ||
DELETION_DATE | NUMBER | (6) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT BRANCH_CODE
, SSV_ALLOWED
, ONE_DAY_SS
, TWO_DAY_SS
, FIVE_DAY_SS
, STREAM_CODE
, BANK_NAME
, BRANCH_NAME
, STREET_ADDRESS_LINE_1
, STREET_ADDRESS_LINE_2
, PO_BOX_NUMBER
, PO_BOX_POST_OFFICE
, POSTAL_CODE
, TELEPHONE_NUMBER
, DIALING_CODE
, TELEX1
, TELEX2
, DELETION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PAY_ZA_BRANCH_CDV_DETAILS#;
|
|
|