[Home] [Help] [Dependency Information]
Object Name: | PAY_ZA_TEMP_BRANCH_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_ZA_TEMP_BRANCH_DETAILS |
Subobject Name: | |
Status: | VALID |
PAY_ZA_TEMP_BRANCH_DETAILS is a temporary table that holds Bank and Branch information used to verify Bank account numbers, used in the population of PAY_ZA_BRANCH_CDV_DETAILS.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_ZA_TEMP_BRANCH_DETAI_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | BRANCH_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_IND | NUMBER | (2) | Type of record | |
BRANCH_CODE | VARCHAR2 | (6) | Yes | Branch Code |
SSV_ALLOWED | NUMBER | (1) | Yes | Sub-service allowed indicator |
ONE_DAY_SS | NUMBER | (1) | One day sub-service | |
TWO_DAY_SS | NUMBER | (1) | Two day sub-service | |
FIVE_DAY_SS | NUMBER | (1) | Five day sub-service | |
STREAM_CODE | NUMBER | (2) | Yes | Stream Code |
BRANCH_NAME | VARCHAR2 | (30) | Yes | Branch Name |
STREET_ADDRESS_LINE_1 | VARCHAR2 | (48) | Address Details | |
STREET_ADDRESS_LINE_2 | VARCHAR2 | (48) | Address Details | |
PO_BOX_NUMBER | VARCHAR2 | (35) | Address Details | |
PO_BOX_POST_OFFICE | VARCHAR2 | (20) | Address Details | |
POSTAL_CODE | NUMBER | (6) | Address Details | |
ACCOUNT_TYPE_1 | NUMBER | (1) | Type of account | |
MODULUS_1 | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR_1 | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTINGS_1 | VARCHAR2 | (22) | Validation weighting | |
EXCEPTION_CODE_1 | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_IND_1 | VARCHAR2 | (1) | Account Indicator | |
ACCOUNT_TYPE_2 | NUMBER | (1) | Type of account | |
MODULUS_2 | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR_2 | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTINGS_2 | VARCHAR2 | (22) | Validation weighting | |
EXCEPTION_CODE_2 | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_IND_2 | VARCHAR2 | (1) | Account Indicator | |
ACCOUNT_TYPE_3 | NUMBER | (1) | Type of account | |
MODULUS_3 | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR_3 | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTINGS_3 | VARCHAR2 | (22) | Validation weighting | |
EXCEPTION_CODE_3 | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_IND_3 | VARCHAR2 | (1) | Account Indicator | |
ACCOUNT_TYPE_4 | NUMBER | (1) | Type of account | |
MODULUS_4 | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR_4 | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTINGS_4 | VARCHAR2 | (22) | Validation weighting | |
EXCEPTION_CODE_4 | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_IND_4 | VARCHAR2 | (1) | Account Indicator | |
ACCOUNT_TYPE_5 | NUMBER | (1) | Type of account | |
MODULUS_5 | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR_5 | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTINGS_5 | VARCHAR2 | (22) | Validation weighting | |
EXCEPTION_CODE_5 | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_IND_5 | VARCHAR2 | (1) | Account Indicator | |
ACCOUNT_TYPE_6 | NUMBER | (1) | Type of account | |
MODULUS_6 | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR_6 | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTINGS_6 | VARCHAR2 | (22) | Validation weighting | |
EXCEPTION_CODE_6 | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_IND_6 | VARCHAR2 | (1) | Account Indicator | |
ACCOUNT_TYPE_7 | NUMBER | (1) | Type of account | |
MODULUS_7 | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR_7 | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTINGS_7 | VARCHAR2 | (22) | Validation weighting | |
EXCEPTION_CODE_7 | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_IND_7 | VARCHAR2 | (1) | Account Indicator | |
ACCOUNT_TYPE_8 | NUMBER | (1) | Type of account | |
MODULUS_8 | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR_8 | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTINGS_8 | VARCHAR2 | (22) | Validation weighting | |
EXCEPTION_CODE_8 | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_IND_8 | VARCHAR2 | (1) | Account Indicator | |
ACCOUNT_TYPE_9 | NUMBER | (1) | Type of account | |
MODULUS_9 | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR_9 | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTINGS_9 | VARCHAR2 | (22) | Validation weighting | |
EXCEPTION_CODE_9 | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_IND_9 | VARCHAR2 | (1) | Account Indicator | |
TELEPHONE_NUMBER | VARCHAR2 | (14) | Contact Details | |
DIALING_CODE | VARCHAR2 | (20) | Contact Details | |
TELEX1 | VARCHAR2 | (20) | Contact Details | |
TELEX2 | VARCHAR2 | (20) | Contact Details | |
DELETION_DATE | NUMBER | (6) | Deletion Date of Information |
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;
HR.PAY_ZA_TEMP_BRANCH_DETAILS does not reference any database object
HR.PAY_ZA_TEMP_BRANCH_DETAILS is referenced by following:
|
|
|