eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_RECEIPT_METHODS

Object Details

Object Name:	AR_RECEIPT_METHODS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_RECEIPT_METHODS
Subobject Name:
Status:	VALID

The AR_RECEIPT_METHODS table stores information about payment methods, which are receipt attributes that you define and assign to receipt classes to account for receipts and their applications.
.
For automatically created receipts, a payment method defines the rules for creating these receipts. For manually created receipts, a payment method defines a user-definable receipt type.
.
Each payment method is associated with a set of bank accounts, which forms the set of bank accounts that can be assigned to a receipt. For example, if you normally receive Lockbox transmissions from bank ABC and bank DEF, you might create a Lockbox payment method and assign bank accounts from bank ABC and bank DEF to this payment method.
.
The primary key for this table is RECEIPT_METHOD_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_RECEIPT_METHODS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECEIPT_METHOD_ID ZD_EDITION_NAME
AR_RECEIPT_METHODS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
RECEIPT_METHOD_ID	NUMBER	(15)	Yes	Identifier of the receipt method
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
NAME	VARCHAR2	(30)	Yes	Name of the receipt method
RECEIPT_CLASS_ID	NUMBER	(15)	Yes	Identifier of the receipt class that is associated with this receipt method
START_DATE	DATE		Yes	Date when this receipt method is active
AUTO_PRINT_PROGRAM_ID	NUMBER	(15)		Identifier of the program that prints the automatic receipts that this receipt method creates
AUTO_TRANS_PROGRAM_ID	NUMBER	(15)		Identifier of the program that transmits the automatic receipts that this receipt method creates
END_DATE	DATE			Date when this receipt method is inactive
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LEAD_DAYS	NUMBER	(5)		Number of days before the invoice due date that an invoice becomes eligible to be selected for receipt application of the automatic receipts that this payment method creates
MATURITY_DATE_RULE_CODE	VARCHAR2	(30)		Determines the maturity date of an automatic receipt that is used to pay invoices that have different due dates
RECEIPT_CREATION_RULE_CODE	VARCHAR2	(30)		Indicates the rule that is used to group automatic receipts that this receipt method creates. For example, one per customer or one per site.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
PRINTED_NAME	VARCHAR2	(30)		String that is printed on statements when referring to this receipt method
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
PAYMENT_TYPE_CODE	VARCHAR2	(30)		Payment type for this payment method, values include CASH, CHECK, and CREDIT CARD
MERCHANT_ID	NUMBER	(15)		Merchant's identifier for the Credit Card Processor, usually provided by the bank or credit card issuer
RECEIPT_INHERIT_INV_NUM_FLAG	VARCHAR2	(1)		Indicates if a receipt that the Automatic Receipts program creates is assigned the same document number as the transaction that the receipt pays
DM_INHERIT_RECEIPT_NUM_FLAG	VARCHAR2	(1)		Indicates if the debit memo that a debit memo reversal creates is assigned the same document number as the reversed receipt
BR_CUST_TRX_TYPE_ID	NUMBER	(15)		Identifier of the bills receivable transaction type, used in a bills receivable transaction creation batch
BR_MIN_ACCTD_AMOUNT	NUMBER			Minimum functional amount that a bill receivable can be created for
BR_MAX_ACCTD_AMOUNT	NUMBER			Maximum functional amount that a bill receivable can be created for
BR_INHERIT_INV_NUM_FLAG	VARCHAR2	(1)		Indicates if a standard transaction number is used for the bill receivable number
MERCHANT_REF	VARCHAR2	(80)		Merchant's identifier for the Credit Card Processor, usually provided by the bank or credit card issuer
PAYMENT_CHANNEL_CODE	VARCHAR2	(30)		Identifies payment channel
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RECEIPT_METHOD_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      NAME
,      RECEIPT_CLASS_ID
,      START_DATE
,      AUTO_PRINT_PROGRAM_ID
,      AUTO_TRANS_PROGRAM_ID
,      END_DATE
,      LAST_UPDATE_LOGIN
,      LEAD_DAYS
,      MATURITY_DATE_RULE_CODE
,      RECEIPT_CREATION_RULE_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRINTED_NAME
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      PAYMENT_TYPE_CODE
,      MERCHANT_ID
,      RECEIPT_INHERIT_INV_NUM_FLAG
,      DM_INHERIT_RECEIPT_NUM_FLAG
,      BR_CUST_TRX_TYPE_ID
,      BR_MIN_ACCTD_AMOUNT
,      BR_MAX_ACCTD_AMOUNT
,      BR_INHERIT_INV_NUM_FLAG
,      MERCHANT_REF
,      PAYMENT_CHANNEL_CODE
,      ZD_EDITION_NAME
FROM AR.AR_RECEIPT_METHODS;

Dependencies

[top of page]

AR.AR_RECEIPT_METHODS does not reference any database object

AR.AR_RECEIPT_METHODS is referenced by following:

AR: AR_RECEIPT_METHODS#