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: TableAR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_RECEIPT_METHODS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECEIPT_METHOD_ID
AR_RECEIPT_METHODS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
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
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
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:

SchemaAPPS
SynonymAR_RECEIPT_METHODS