DW_AP_TERMS_D

This table contains payment terms information for Payables.

Details

Module: Payables

Key Columns

PAYMENT_TERMS_ID

Columns

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   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, 2023, Oracle and/or its affiliates.