RA_TERMS_B
The RA_TERMS_B table stores standard payment term information. Oracle Receivables creates one row for each payment term that you define. Receivables uses this information to calculate when a payment is due and any discounts that are given for early payment. Receivables stores payment schedules in the AR_PAYMENT_SCHEDULES_ALL table. . The primary key for this table is TERM_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
RA_TERMS_B_PK |
TERM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| TERM_ID | NUMBER | 18 | Yes | Payment term identifier | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| NAME | VARCHAR2 | 15 | Payment term name. | |||
| CREDIT_CHECK_FLAG | VARCHAR2 | 1 | Indicates whether the customer account is included in credit checking. | |||
| DUE_CUTOFF_DAY | NUMBER | Cutoff day with proxima terms when due date is extended one month | ||||
| PRINTING_LEAD_DAYS | NUMBER | This is the number of days between the print date and the due date. If this column is null, the invoice is printed on the invoice date. If this column is filled in, the invoice is printed this number of days before the due date. | ||||
| DESCRIPTION | VARCHAR2 | 240 | Payment term description. | |||
| START_DATE_ACTIVE | DATE | Yes | Date when the payment term becomes active. | |||
| END_DATE_ACTIVE | DATE | Date when the payment term becomes inactive. | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| BASE_AMOUNT | NUMBER | Yes | Sum of the relative amount for the installments | |||
| CALC_DISCOUNT_ON_LINES_FLAG | VARCHAR2 | 1 | Yes | Flag to calculate discounts on line amounts only or on the entire invoice amount | ||
| DISCOUNT_BASIS_DATE_TYPE | VARCHAR2 | 20 | Date type used to calculate discounts on payments received. | |||
| FIRST_INSTALLMENT_CODE | VARCHAR2 | 12 | Yes | Flag to put freight, tax on the first installment or to allocate it over all installments | ||
| IN_USE | VARCHAR2 | 1 | Yes | Flag to indicate whether this payment term was referenced in a transaction | ||
| PARTIAL_DISCOUNT_FLAG | VARCHAR2 | 1 | Yes | Flag to allow discounts on partial payments | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Terms (RA_TERMS) | ||
| PREPAYMENT_FLAG | VARCHAR2 | 1 | Indicates whether this payment term is enabled for prepayment | |||
| BILLING_CYCLE_ID | NUMBER | 18 | Billing cycle identifier | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| SET_ID | NUMBER | 18 | Yes | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RA_TERMS_B | ar_cons_bill_cycles_b | BILLING_CYCLE_ID |
| ra_terms_lines_discounts | ra_terms_b | TERM_ID |
| ra_customer_trx_all | ra_terms_b | TERM_ID |
| hes_fee_attributes_b | ra_terms_b | TERM_ID |
| hes_transaction_post_all | ra_terms_b | TERM_ID |
| ar_cons_inv_all | ra_terms_b | TERM_ID |
| hz_customer_profiles_f | ra_terms_b | LATE_CHARGE_TERM_ID |
| hz_customer_profiles_f | ra_terms_b | STANDARD_TERMS |
| ra_terms_tl | ra_terms_b | TERM_ID |
| ar_interest_headers_all | ra_terms_b | LATE_CHARGE_TERM_ID |
| okc_k_headers_all_b_h | ra_terms_b | PAYMENT_TERM_ID |
| ar_customer_alt_names | ra_terms_b | TERM_ID |
| ra_terms_lines | ra_terms_b | TERM_ID |
| ra_interface_lines_all | ra_terms_b | TERM_ID |
| okc_k_headers_all_b | ra_terms_b | PAYMENT_TERM_ID |
| ar_payment_schedules_all | ra_terms_b | TERM_ID |
| hz_cust_profile_classes | ra_terms_b | LATE_CHARGE_TERM_ID |
| hz_cust_profile_classes | ra_terms_b | STANDARD_TERMS |
| hes_org_defaults_all_b | ra_terms_b | TERM_ID |
| ar_late_charge_trx_t | ra_terms_b | LATE_CHARGE_TERM_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_TERMS_B_N1 | Non Unique | Default | LAST_UPDATE_DATE |
| RA_TERMS_B_U1 | Unique | Default | TERM_ID, ORA_SEED_SET1 |
| RA_TERMS_B_U11 | Unique | Default | TERM_ID, ORA_SEED_SET2 |