[Home] [Help] [Dependency Information]
Object Name: | PAY_ZA_TEMP_BRANCH_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_IND | NUMBER | (2) | ||
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 | |
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) | ||
ACCOUNT_TYPE_1 | NUMBER | (1) | ||
MODULUS_1 | NUMBER | (2) | ||
FUDGE_FACTOR_1 | NUMBER | (2) | ||
CDV_WEIGHTINGS_1 | VARCHAR2 | (22) | ||
EXCEPTION_CODE_1 | VARCHAR2 | (2) | ||
ACCOUNT_IND_1 | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_2 | NUMBER | (1) | ||
MODULUS_2 | NUMBER | (2) | ||
FUDGE_FACTOR_2 | NUMBER | (2) | ||
CDV_WEIGHTINGS_2 | VARCHAR2 | (22) | ||
EXCEPTION_CODE_2 | VARCHAR2 | (2) | ||
ACCOUNT_IND_2 | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_3 | NUMBER | (1) | ||
MODULUS_3 | NUMBER | (2) | ||
FUDGE_FACTOR_3 | NUMBER | (2) | ||
CDV_WEIGHTINGS_3 | VARCHAR2 | (22) | ||
EXCEPTION_CODE_3 | VARCHAR2 | (2) | ||
ACCOUNT_IND_3 | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_4 | NUMBER | (1) | ||
MODULUS_4 | NUMBER | (2) | ||
FUDGE_FACTOR_4 | NUMBER | (2) | ||
CDV_WEIGHTINGS_4 | VARCHAR2 | (22) | ||
EXCEPTION_CODE_4 | VARCHAR2 | (2) | ||
ACCOUNT_IND_4 | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_5 | NUMBER | (1) | ||
MODULUS_5 | NUMBER | (2) | ||
FUDGE_FACTOR_5 | NUMBER | (2) | ||
CDV_WEIGHTINGS_5 | VARCHAR2 | (22) | ||
EXCEPTION_CODE_5 | VARCHAR2 | (2) | ||
ACCOUNT_IND_5 | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_6 | NUMBER | (1) | ||
MODULUS_6 | NUMBER | (2) | ||
FUDGE_FACTOR_6 | NUMBER | (2) | ||
CDV_WEIGHTINGS_6 | VARCHAR2 | (22) | ||
EXCEPTION_CODE_6 | VARCHAR2 | (2) | ||
ACCOUNT_IND_6 | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_7 | NUMBER | (1) | ||
MODULUS_7 | NUMBER | (2) | ||
FUDGE_FACTOR_7 | NUMBER | (2) | ||
CDV_WEIGHTINGS_7 | VARCHAR2 | (22) | ||
EXCEPTION_CODE_7 | VARCHAR2 | (2) | ||
ACCOUNT_IND_7 | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_8 | NUMBER | (1) | ||
MODULUS_8 | NUMBER | (2) | ||
FUDGE_FACTOR_8 | NUMBER | (2) | ||
CDV_WEIGHTINGS_8 | VARCHAR2 | (22) | ||
EXCEPTION_CODE_8 | VARCHAR2 | (2) | ||
ACCOUNT_IND_8 | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_9 | NUMBER | (1) | ||
MODULUS_9 | NUMBER | (2) | ||
FUDGE_FACTOR_9 | NUMBER | (2) | ||
CDV_WEIGHTINGS_9 | VARCHAR2 | (22) | ||
EXCEPTION_CODE_9 | VARCHAR2 | (2) | ||
ACCOUNT_IND_9 | VARCHAR2 | (1) | ||
TELEPHONE_NUMBER | VARCHAR2 | (14) | ||
DIALING_CODE | VARCHAR2 | (20) | ||
TELEX1 | VARCHAR2 | (20) | ||
TELEX2 | VARCHAR2 | (20) | ||
DELETION_DATE | NUMBER | (6) |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_IND
, BRANCH_CODE
, SSV_ALLOWED
, ONE_DAY_SS
, TWO_DAY_SS
, FIVE_DAY_SS
, STREAM_CODE
, BRANCH_NAME
, STREET_ADDRESS_LINE_1
, STREET_ADDRESS_LINE_2
, PO_BOX_NUMBER
, PO_BOX_POST_OFFICE
, POSTAL_CODE
, ACCOUNT_TYPE_1
, MODULUS_1
, FUDGE_FACTOR_1
, CDV_WEIGHTINGS_1
, EXCEPTION_CODE_1
, ACCOUNT_IND_1
, ACCOUNT_TYPE_2
, MODULUS_2
, FUDGE_FACTOR_2
, CDV_WEIGHTINGS_2
, EXCEPTION_CODE_2
, ACCOUNT_IND_2
, ACCOUNT_TYPE_3
, MODULUS_3
, FUDGE_FACTOR_3
, CDV_WEIGHTINGS_3
, EXCEPTION_CODE_3
, ACCOUNT_IND_3
, ACCOUNT_TYPE_4
, MODULUS_4
, FUDGE_FACTOR_4
, CDV_WEIGHTINGS_4
, EXCEPTION_CODE_4
, ACCOUNT_IND_4
, ACCOUNT_TYPE_5
, MODULUS_5
, FUDGE_FACTOR_5
, CDV_WEIGHTINGS_5
, EXCEPTION_CODE_5
, ACCOUNT_IND_5
, ACCOUNT_TYPE_6
, MODULUS_6
, FUDGE_FACTOR_6
, CDV_WEIGHTINGS_6
, EXCEPTION_CODE_6
, ACCOUNT_IND_6
, ACCOUNT_TYPE_7
, MODULUS_7
, FUDGE_FACTOR_7
, CDV_WEIGHTINGS_7
, EXCEPTION_CODE_7
, ACCOUNT_IND_7
, ACCOUNT_TYPE_8
, MODULUS_8
, FUDGE_FACTOR_8
, CDV_WEIGHTINGS_8
, EXCEPTION_CODE_8
, ACCOUNT_IND_8
, ACCOUNT_TYPE_9
, MODULUS_9
, FUDGE_FACTOR_9
, CDV_WEIGHTINGS_9
, EXCEPTION_CODE_9
, ACCOUNT_IND_9
, TELEPHONE_NUMBER
, DIALING_CODE
, TELEX1
, TELEX2
, DELETION_DATE
FROM HR.PAY_ZA_TEMP_BRANCH_DETAILS#;
|
|
|