DW_AP_HOLDS_CF

This table contains details about Payables invoice holds.

Details

Module: Payables

Key Columns

INVOICE_ID, HOLD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVOICE_ID NUMBER 38 0 True Invoice identifier.    
HOLD_ID NUMBER 38 0 True Hold identifier.    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of invoice identifier and hold identifier.    
INVOICE_NUMBER VARCHAR2 64     Invoice number.    
INVOICE_LINE_NUMBER NUMBER       Invoice line number of the applied hold.    
INVOICE_GROUP VARCHAR2 64     Invoice Group or Invoice batch name    
HOLD_REASON_ID VARCHAR2 32     Hold reason code. DW_AP_HOLD_RELEASE_REASON_D HOLD_OR_RELEASE_CODE
RELEASE_REASON_ID VARCHAR2 32     Release reason code. DW_AP_HOLD_RELEASE_REASON_D HOLD_OR_RELEASE_CODE
HELD_BY_USER_ID VARCHAR2 128     User who applied the hold. DW_USER_D USERNAME
RELEASED_BY_USER_ID VARCHAR2 128     User who released the hold. DW_USER_D USERNAME
SUPPLIER_PARTY_ID NUMBER 38 0   Supplier identifier. DW_PARTY_D PARTY_ID
SUPPLIER_SITE_ID NUMBER 38 0   Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
THIRD_PARTY_ID NUMBER 38 0   Third party payee identifier. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0   Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0   Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
INVOICED_ON_DATE DATE       Date when invoice is created.    
HOLD_DATE TIMESTAMP       Date when hold is applied.    
RELEASED_DATE TIMESTAMP       Date when hold is released.    
HOLD_STATUS_FLAG VARCHAR2 16     Indicates that the invoice is on hold. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
PAYMENT_TERMS_ID NUMBER 38 0   Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
PAYMENT_METHOD_CODE VARCHAR2 32     Payment method. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING,WIRE, and so on. DW_CODE_VALUES_LKP_TL CODE
INVOICE_SOURCE_CODE VARCHAR2 32     Invoice source. Values are from For the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SOURCE. Possible values are INVOICE GATEWAY, Recurring Invoice, SelfService, Confirm PaymentBatch, LOANS, Manual Invoice Entry, QuickCheck, and so on. DW_CODE_VALUES_LKP_TL CODE
INVOICE_CURRENCY_CODE VARCHAR2 16     Invoice currency code.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency code.    
INVOICE_AMOUNT NUMBER       Invoice amount in invoice currency.    
LEDGER_AMOUNT NUMBER       Invoice amount in ledger currency.    
INVOICE_LINE_AMOUNT NUMBER       Invoice line amount in invoice currency.    
INVOICE_LINE_LEDGER_AMOUNT NUMBER       Invoice line amount in ledger currency.    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global currency conversion rate.    
GLOBAL_AMOUNT NUMBER       Invoice amount in global currency.    
GLOBAL_INVOICE_LINE_AMOUNT NUMBER       Invoice line amount in global currency.    
CREATED_BY_USER_ID VARCHAR2 128     User who created the record. DW_USER_D USERNAME
UPDATED_BY_USER_ID VARCHAR2 128     User who updated the record. DW_USER_D USERNAME
HEADER_CREATED_BY_USER_ID VARCHAR2 128     User who created the invoice. DW_USER_D USERNAME
HEADER_UPDATED_BY_USER_ID VARCHAR2 128     User who updated the invoice. DW_USER_D USERNAME
INVOICE_CREATION_DATE TIMESTAMP       Date when invoice row was created in the table.    
INVOICE_CREATION_DATE_1 DATE       Date when invoice row was created in the table.    
INVOICE_VALIDATION_STATUS_CODE VARCHAR2 16     Invoice validation status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE.    
HOLD_DATE_1 DATE       Date when hold is applied.    
RELEASED_DATE_1 DATE       Date when hold is released.    
MIN_SCHEDULE_DUE_DATE DATE       Minimum date when the invoice is due for payment.    
MIN_FIRST_DISCOUNT_DUE_DATE DATE       Minimum date when first discount is available.    
MIN_SECOND_DISCOUNT_DUE_DATE DATE       Minimum date when second discount is available.    
MIN_THIRD_DISCOUNT_DUE_DATE DATE       Minimum date when third discount is available.    
INVOICE_ACCOUNTING_DATE DATE       Date when invoice was accounted    
INVOICE_RECEIVED_DATE DATE       Date when the invoice was received. This is used to calculate when the invoice is due.    
INVOICE_TYPE_CODE VARCHAR2 32     Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE TYPE. Possible values are STANDARD, CREDIT, DEBIT, PAYMENT REQUEST, PREPAYMENT, INTEREST, INVOICE REQUEST, AWT, CREDIT MEMO REQUEST, EXPENSE REPORT, MIXED, and so on.    
INVOICE_APPROVAL_STATUS_CODE VARCHAR2 64     Invoice approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_WFAPPROVAL_STATUS. Possible values are INITIATED, MANUALLY APPROVED, NOT REQUIRED, REJECTED, REMOVED FROM APPROVAL, REQUIRED, WFAPPROVED, and so on.    
INVOICE_PO_NUMBER VARCHAR2 32     PO number the invoice is matched to.    
INVOICE_PAYMENT_STATUS_CODE VARCHAR2 16     Invoice payment status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS.    
FISCAL_PERIOD_NAME VARCHAR2 64     Accounting period name.    
HOLD_CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
HOLD_DATE_PERIOD_END_DATE_ID NUMBER 38 0   Hold creation date identifier.    
RELEASED_DATE_PERIOD_END_DATE_ID NUMBER 38 0   Hold release date identifier.    

Copyright © 2019, 2024, Oracle and/or its affiliates.