[Home] [Help] [Dependency Information]
Object Name: | XTR_SWIFT_EFT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_SWIFT_EFT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
XTR_SWIFT_EFT_V is used to select information to generate Treasury payments in the provided X12 and SWIFT formats.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SETTLEMENT_NUMBER | NUMBER | Yes | Refer to base table or view | |
COMPANY | VARCHAR2 | (7) | Yes | Refer to base table or view |
CPARTY | VARCHAR2 | (7) | Yes | Refer to base table or view |
COMP_NAME | VARCHAR2 | (50) | Yes | Refer to base table or view |
CP_NAME | VARCHAR2 | (50) | Yes | Refer to base table or view |
CURRENCY | VARCHAR2 | (15) | Yes | Refer to base table or view |
SETTLEMENT_AMOUNT | NUMBER | Yes | Refer to base table or view | |
SETTLEMENT_DATE | DATE | Yes | Refer to base table or view | |
COMPANY_ACCT_NO | VARCHAR2 | (20) | Yes | Refer to base table or view |
CPARTY_ACCT_NO | VARCHAR2 | (20) | Refer to base table or view | |
COMP_SWIFT_ID | VARCHAR2 | (50) | Refer to base table or view | |
CP_SWIFT_ID | VARCHAR2 | (11) | Refer to base table or view | |
COMP_ADDRESS1 | VARCHAR2 | (50) | Refer to base table or view | |
COMP_ADDRESS2 | VARCHAR2 | (50) | Refer to base table or view | |
COMP_ADDRESS3 | VARCHAR2 | (50) | Refer to base table or view | |
CP_ADDRESS1 | VARCHAR2 | (50) | Refer to base table or view | |
CP_ADDRESS2 | VARCHAR2 | (50) | Refer to base table or view | |
CP_ADDRESS3 | VARCHAR2 | (50) | Refer to base table or view | |
COMP_BANK_CODE | VARCHAR2 | (7) | Refer to base table or view | |
CP_BANK_CODE | VARCHAR2 | (7) | Refer to base table or view | |
COMP_BANK_NAME | VARCHAR2 | (50) | Refer to base table or view | |
CP_BANK_NAME | VARCHAR2 | (50) | Refer to base table or view | |
COMP_BANK_LOCATION | VARCHAR2 | (35) | Yes | Refer to base table or view |
CP_BANK_LOCATION | VARCHAR2 | (35) | Yes | Refer to base table or view |
COMP_BANK_STREET | VARCHAR2 | (35) | Yes | Refer to base table or view |
CP_BANK_STREET | VARCHAR2 | (35) | Yes | Refer to base table or view |
CP_CORR_BANK_NAME | VARCHAR2 | (100) | Refer to base table or view | |
CP_CORR_BANK_NO | VARCHAR2 | (20) | Refer to base table or view | |
SETTLEMENT_SUMMARY_ID | NUMBER | Yes | Refer to base table of view |
Cut, paste (and edit) the following text to query this object:
SELECT SETTLEMENT_NUMBER
, COMPANY
, CPARTY
, COMP_NAME
, CP_NAME
, CURRENCY
, SETTLEMENT_AMOUNT
, SETTLEMENT_DATE
, COMPANY_ACCT_NO
, CPARTY_ACCT_NO
, COMP_SWIFT_ID
, CP_SWIFT_ID
, COMP_ADDRESS1
, COMP_ADDRESS2
, COMP_ADDRESS3
, CP_ADDRESS1
, CP_ADDRESS2
, CP_ADDRESS3
, COMP_BANK_CODE
, CP_BANK_CODE
, COMP_BANK_NAME
, CP_BANK_NAME
, COMP_BANK_LOCATION
, CP_BANK_LOCATION
, COMP_BANK_STREET
, CP_BANK_STREET
, CP_CORR_BANK_NAME
, CP_CORR_BANK_NO
, SETTLEMENT_SUMMARY_ID
FROM APPS.XTR_SWIFT_EFT_V;
|
|
|