[Home] [Help] [Dependency Information]
Object Name: | OP_TERM_MST |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.OP_TERM_MST |
Subobject Name: | |
Status: | VALID |
Payment terms are maintained in this table. Payment terms are entered in Oracle Payables and the information is transferred to this OPM table via a database trigger. Payment terms must be entered in Oracle Payables to be transferred, but the same terms must be entered in Oracle Receivables to be used in Order Fulfillment and then allow invoicing of the order/shipment.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OP_TERM_MST01 | NORMAL | UNIQUE | APPS_TS_SEED | OF_TERMS_CODE |
OP_TERM_MST_PK | NORMAL | UNIQUE | APPS_TS_SEED | TERMS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERMS_CODE | VARCHAR2 | (4) | Yes | Code to uniquely identify payment terms |
TERMS_DESC | VARCHAR2 | (40) | Yes | Description of the payment terms. |
DISCOUNT_RATE | NUMBER | Yes | The percent discount given to the customer if payment is made within a certain number of days. Valid values are 0 <= x <= 1. | |
DISCOUNT_DAYS | NUMBER | (5) | Yes | The number of days in which a discount will be given. For example, if the payment terms are 2 10 net 30, then the discount days would be 10. |
NET_DAYS | NUMBER | (5) | Yes | Number of days by which full payment is expected. |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
OF_TERMS_CODE | VARCHAR2 | (50) | Yes | If payment terms originate in Oracle Applications, this is the corresponding code from that application. |
REQUEST_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
RA_TERMS_CODE | VARCHAR2 | (15) | Corresponding Oracle Receivables Terms Code |
Cut, paste (and edit) the following text to query this object:
SELECT TERMS_CODE
, TERMS_DESC
, DISCOUNT_RATE
, DISCOUNT_DAYS
, NET_DAYS
, DELETE_MARK
, TEXT_CODE
, TRANS_CNT
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OF_TERMS_CODE
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, RA_TERMS_CODE
FROM GML.OP_TERM_MST;
GML.OP_TERM_MST does not reference any database object
GML.OP_TERM_MST is referenced by following:
|
|
|