[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 | settlement number | |
COMPANY | VARCHAR2 | (7) | Yes | company |
CPARTY | VARCHAR2 | (7) | Yes | counterparty |
COMP_NAME | VARCHAR2 | (50) | Yes | company name |
CP_NAME | VARCHAR2 | (50) | Yes | counterparty name |
CURRENCY | VARCHAR2 | (15) | Yes | currency |
SETTLEMENT_AMOUNT | NUMBER | Yes | settlement amount | |
SETTLEMENT_DATE | DATE | Yes | settlement date | |
COMPANY_ACCT_NO | VARCHAR2 | (20) | Yes | company account number |
CPARTY_ACCT_NO | VARCHAR2 | (20) | counterparty account number | |
COMP_SWIFT_ID | VARCHAR2 | (50) | company swift id | |
CP_SWIFT_ID | VARCHAR2 | (11) | counterarty swift id | |
COMP_ADDRESS1 | VARCHAR2 | (50) | company address line 1 | |
COMP_ADDRESS2 | VARCHAR2 | (50) | company address line 2 | |
COMP_ADDRESS3 | VARCHAR2 | (50) | company address line 3 | |
CP_ADDRESS1 | VARCHAR2 | (50) | counterparty address line 1 | |
CP_ADDRESS2 | VARCHAR2 | (50) | counterparty address line 2 | |
CP_ADDRESS3 | VARCHAR2 | (50) | counterparty address line 3 | |
COMP_BANK_CODE | VARCHAR2 | (7) | company bank code | |
CP_BANK_CODE | VARCHAR2 | (7) | counterparty bank code | |
COMP_BANK_NAME | VARCHAR2 | (50) | company bank name | |
CP_BANK_NAME | VARCHAR2 | (50) | counterparty bank name | |
COMP_BANK_LOCATION | VARCHAR2 | (35) | Yes | company bank location |
CP_BANK_LOCATION | VARCHAR2 | (35) | Yes | counterparty bank location |
COMP_BANK_STREET | VARCHAR2 | (35) | Yes | company bank street |
CP_BANK_STREET | VARCHAR2 | (35) | Yes | counterarty bank street |
CP_CORR_BANK_NAME | VARCHAR2 | (100) | counterparty bank name | |
CP_CORR_BANK_NO | VARCHAR2 | (20) | counterpary bank number | |
CP_IBAN | VARCHAR2 | (50) | counterparty iban number | |
SETTLEMENT_SUMMARY_ID | NUMBER | Yes | settlement summary id |
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
, CP_IBAN
, SETTLEMENT_SUMMARY_ID
FROM APPS.XTR_SWIFT_EFT_V;
|
|
|