[Home] [Help] [Dependency Information]
Object Name: | PAY_ORG_PAYMENT_METHODS_F1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
EMPLOYER_CODE | VARCHAR2 | (150) | ||
BANK_CODE | VARCHAR2 | (150) | ||
HEADER_FORMULA | VARCHAR2 | (150) | ||
BODY_FORMULA | VARCHAR2 | (150) | ||
FOOTER_FORMULA | VARCHAR2 | (150) | ||
PAYMENT_CODE | VARCHAR2 | (150) | ||
PAYMENT_DESCRIPTION | VARCHAR2 | (150) | ||
BACS_USER_NUMBER | VARCHAR2 | (150) | ||
BACS_LIMIT | NUMBER | |||
BUREAU_NUMBER | VARCHAR2 | (150) | ||
BUREAU_NAME | VARCHAR2 | (150) | ||
SOURCE_BANK_CONTACT | VARCHAR2 | (150) | ||
SOURCE_CONTACT_TELEPHONE | VARCHAR2 | (150) | ||
TRANSACTION_LIMIT | NUMBER | |||
CONTRA_NARRATIVE | VARCHAR2 | (150) | ||
DIRECT_DEPOSIT_NUMBER | VARCHAR2 | (150) | ||
NARRATIVE | VARCHAR2 | (150) | ||
FINANCIAL_INSTITUTION | VARCHAR2 | (150) | ||
ORIGINATOR_ID | VARCHAR2 | (150) | ||
ORIGINATOR_NAME | VARCHAR2 | (150) | ||
ORIGINATOR_SHORT_NAME | VARCHAR2 | (150) | ||
RETURN_INSTITUTION_ID | VARCHAR2 | (150) | ||
RETURN_ACCOUNT_NUMBER | VARCHAR2 | (150) | ||
CPA_CODE | VARCHAR2 | (150) | ||
DES_DATA_CENTRE_DUMMY | VARCHAR2 | (150) | ||
DESTINATION_DATA_CENTRE_CODE | VARCHAR2 | (150) | ||
CASH_ANALYSIS | VARCHAR2 | (150) | ||
THIRD_PARTY_PAY_TYPE | VARCHAR2 | (150) | ||
COMPANY_ID | VARCHAR2 | (150) | ||
DE_BANK_CODE | VARCHAR2 | (150) | ||
DE_USER_NUMBER | VARCHAR2 | (150) | ||
DE_USER_NAME | VARCHAR2 | (150) | ||
DE_FILE_DESCRIPTION | VARCHAR2 | (150) | ||
DE_DEBIT_ITEM_AUTHORITY | VARCHAR2 | (150) | ||
DE_INCLUDE_LEADING_ZEROES | VARCHAR2 | (150) | ||
DE_INDICATOR | VARCHAR2 | (150) | ||
DE_TRANSACTION_CODE | VARCHAR2 | (150) | ||
DE_EFT_FILE_SUMMARY | VARCHAR2 | (150) | ||
ACCOUNT_TYPE | VARCHAR2 | (150) | ||
COMPANY_CODE | VARCHAR2 | (150) | ||
COMPANY_NAME | VARCHAR2 | (150) | ||
OVERRIDING_ZENGIN_FORMATTER | VARCHAR2 | (150) | ||
CREDITOR_CODE | VARCHAR2 | (150) | ||
CREDITOR_NAME | VARCHAR2 | (150) | ||
SITE_CODE | VARCHAR2 | (150) | ||
SITE_NAME | VARCHAR2 | (150) | ||
GIRO_COMPANY_NAME | VARCHAR2 | (150) | ||
GIRO_COMPANY_CODE | VARCHAR2 | (150) | ||
CUSTOMER_ID | VARCHAR2 | (150) | ||
NACHA_DESTINATION_CODE | VARCHAR2 | (150) | ||
NACHA_DESTINATION_NAME | VARCHAR2 | (150) | ||
NACHA_ORIGIN_CODE | VARCHAR2 | (150) | ||
NACHA_ORIGIN_NAME | VARCHAR2 | (150) | ||
REFERENCE_CODE | VARCHAR2 | (150) | ||
BALANCED_NACHA_FILE | VARCHAR2 | (150) | ||
HEADER_LINE_1 | VARCHAR2 | (150) | ||
HEADER_LINE_2 | VARCHAR2 | (150) | ||
SENDER_ID | VARCHAR2 | (150) | ||
BATCH_DESCRIPTION | VARCHAR2 | (150) | ||
INSTRUCTING_PARTY_NAME | VARCHAR2 | (150) | ||
PAYMENT_FILE_MEDIUM | VARCHAR2 | (150) | ||
SUPRESS_PAYEE_ADDRESS | VARCHAR2 | (150) | ||
IDENTIFY_POST_BANK_NUMBERS | VARCHAR2 | (150) | ||
NAW_CODE | VARCHAR2 | (150) | ||
ENTERPRISE_NUMBER | NUMBER | |||
DIVISION | VARCHAR2 | (150) | ||
AH_SEQUENCE_NUMBER | NUMBER | |||
SEQUENCE_CONTROL | NUMBER | |||
INVOICE_NUMBER | VARCHAR2 | (150) | ||
KID_NUMBER | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (1389) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, EMPLOYER_CODE
, BANK_CODE
, HEADER_FORMULA
, BODY_FORMULA
, FOOTER_FORMULA
, PAYMENT_CODE
, PAYMENT_DESCRIPTION
, BACS_USER_NUMBER
, BACS_LIMIT
, BUREAU_NUMBER
, BUREAU_NAME
, SOURCE_BANK_CONTACT
, SOURCE_CONTACT_TELEPHONE
, TRANSACTION_LIMIT
, CONTRA_NARRATIVE
, DIRECT_DEPOSIT_NUMBER
, NARRATIVE
, FINANCIAL_INSTITUTION
, ORIGINATOR_ID
, ORIGINATOR_NAME
, ORIGINATOR_SHORT_NAME
, RETURN_INSTITUTION_ID
, RETURN_ACCOUNT_NUMBER
, CPA_CODE
, DES_DATA_CENTRE_DUMMY
, DESTINATION_DATA_CENTRE_CODE
, CASH_ANALYSIS
, THIRD_PARTY_PAY_TYPE
, COMPANY_ID
, DE_BANK_CODE
, DE_USER_NUMBER
, DE_USER_NAME
, DE_FILE_DESCRIPTION
, DE_DEBIT_ITEM_AUTHORITY
, DE_INCLUDE_LEADING_ZEROES
, DE_INDICATOR
, DE_TRANSACTION_CODE
, DE_EFT_FILE_SUMMARY
, ACCOUNT_TYPE
, COMPANY_CODE
, COMPANY_NAME
, OVERRIDING_ZENGIN_FORMATTER
, CREDITOR_CODE
, CREDITOR_NAME
, SITE_CODE
, SITE_NAME
, GIRO_COMPANY_NAME
, GIRO_COMPANY_CODE
, CUSTOMER_ID
, NACHA_DESTINATION_CODE
, NACHA_DESTINATION_NAME
, NACHA_ORIGIN_CODE
, NACHA_ORIGIN_NAME
, REFERENCE_CODE
, BALANCED_NACHA_FILE
, HEADER_LINE_1
, HEADER_LINE_2
, SENDER_ID
, BATCH_DESCRIPTION
, INSTRUCTING_PARTY_NAME
, PAYMENT_FILE_MEDIUM
, SUPRESS_PAYEE_ADDRESS
, IDENTIFY_POST_BANK_NUMBERS
, NAW_CODE
, ENTERPRISE_NUMBER
, DIVISION
, AH_SEQUENCE_NUMBER
, SEQUENCE_CONTROL
, INVOICE_NUMBER
, KID_NUMBER
, CONCATENATED_SEGMENTS
FROM APPS.PAY_ORG_PAYMENT_METHODS_F1_DFV;
|
|
|