This table contains payment terms information for Payables.
Module: Payables
PAYMENT_TERMS_ID
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 | Source record identifier for payment term. | |||
ACTIVE_FLAG | VARCHAR2 | 16 | Indicates an active payment term. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_LKP_TL | 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. |
Copyright © 2019, 2022, Oracle and/or its affiliates.