[Home] [Help] [Dependency Information]
Object Name: | PAY_ZA_BANK_ADDRESS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_ZA_BANK_ADDRESS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PAY_ZA_BANK_ADDRESS_V is a view based on Bank / Branch details and CDV weighting factors.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BANK_NAME | VARCHAR2 | (40) | Bank Name | |
BRANCH_CODE | VARCHAR2 | (6) | Yes | Branch Code |
ACCOUNT_TYPE | NUMBER | (1) | Yes | Type of Account |
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 | |
MODULUS | NUMBER | (2) | Modulus factor | |
FUDGE_FACTOR | NUMBER | (2) | Factor added to check sum calculation | |
CDV_WEIGHTING1 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING2 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING3 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING4 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING5 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING6 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING7 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING8 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING9 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING10 | NUMBER | (2) | Validation Weighting | |
CDV_WEIGHTING11 | NUMBER | (2) | Validation Weighting | |
EXCEPTION_CODE | VARCHAR2 | (2) | Additional Validation | |
ACCOUNT_INDICATOR | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT BANK_NAME
, BRANCH_CODE
, ACCOUNT_TYPE
, STREAM_CODE
, BRANCH_NAME
, STREET_ADDRESS_LINE_1
, STREET_ADDRESS_LINE_2
, PO_BOX_NUMBER
, PO_BOX_POST_OFFICE
, POSTAL_CODE
, MODULUS
, FUDGE_FACTOR
, CDV_WEIGHTING1
, CDV_WEIGHTING2
, CDV_WEIGHTING3
, CDV_WEIGHTING4
, CDV_WEIGHTING5
, CDV_WEIGHTING6
, CDV_WEIGHTING7
, CDV_WEIGHTING8
, CDV_WEIGHTING9
, CDV_WEIGHTING10
, CDV_WEIGHTING11
, EXCEPTION_CODE
, ACCOUNT_INDICATOR
, TELEPHONE_NUMBER
, DIALING_CODE
, TELEX1
, TELEX2
FROM APPS.PAY_ZA_BANK_ADDRESS_V;
|
|
|