DW_AP_TERMS_D
This table contains payment terms information for Payables.
Details
Module: Payables
Key Columns
PAYMENT_TERMS_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PAYMENT_TERMS_ID | NUMBER | 38 | 0 | True | Payment terms identifier. | DW_AP_TERMS_D_TL | PAYMENT_TERMS_ID |
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. Source record identifier for payment term. | |||
| ACTIVE_FLAG | VARCHAR2 | 16 | Indicates an active payment term. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_CODE | ||
| CONDITION_TEXT1 | VARCHAR2 | 256 | Payment term condition description 1. | ||||
| CONDITION_TEXT2 | VARCHAR2 | 256 | Payment term condition description 2. | ||||
| CONDITION_TEXT3 | VARCHAR2 | 256 | Payment term condition description 3. | ||||
| CONDITION_TEXT4 | VARCHAR2 | 256 | Payment term condition description 4. | ||||
| CONDITION_TEXT5 | VARCHAR2 | 256 | Payment term condition description 5. |