# DW_NS_PROCUREMENT_SPEND_CF (Preview)

This table requires activation of Procurement Spend Analysis functional area. This fact contains details on procurement spending items, accompanied by derived flags designed to simplifying, streamline and enhance spend analysis.

## Details

Module:

## Key Columns

vendbill_lineid, vendbill_id, accountingbook

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
vendbill_id | NUMBER | 38 | 0 | True |  | DW_NS_VENDOR_BILL_LINES_F | transaction
vendbill_lineid | NUMBER | 38 | 0 | True |  | DW_NS_VENDOR_BILL_LINES_F | id
accountingbook | NUMBER | 38 | 0 | True |  | DW_NS_VENDOR_BILL_LINES_F | accountingbook
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | This column is for Oracle Internal use only. |  |
creditforeignamount | NUMBER |  |  |  |  |  |
item | NUMBER | 38 | 0 |  |  | DW_NS_item_D | id
quantity | NUMBER |  |  |  |  |  |
subsidiary | NUMBER | 38 | 0 |  |  | DW_NS_subsidiary_D | id
transactiondiscount | VARCHAR2 | 16 |  |  |  |  |
foreignamount | NUMBER |  |  |  |  |  |
mainline | VARCHAR2 | 16 |  |  |  |  |
landedcostcategory | NUMBER | 38 | 0 |  |  | DW_NS_costCategory_D | id
landedcostperline | VARCHAR2 | 16 |  |  |  |  |
entity | NUMBER | 38 | 0 |  |  | DW_NS_entity_D | id
itemtype | VARCHAR2 | 32 |  |  |  | DW_NS_ITEMTYPE_D | id
class | NUMBER | 38 | 0 |  |  | DW_NS_classification_D | id
location | NUMBER | 38 | 0 |  |  | DW_NS_location_D | id
debitforeignamount | NUMBER |  |  |  |  |  |
department | NUMBER | 38 | 0 |  |  | DW_NS_department_D | id
taxline | VARCHAR2 | 16 |  |  |  |  |
isinventoryaffecting | VARCHAR2 | 16 |  |  |  |  |
terms | NUMBER | 38 | 0 |  |  | DW_NS_term_D | id
status | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | code
currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
postingperiod | NUMBER | 38 | 0 |  |  | DW_NS_accountingPeriod_D | id
type | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | key
billingaddress | NUMBER | 38 | 0 |  |  | DW_NS_transactionBillingAddress_D | nkey
trandate | TIMESTAMP |  |  |  |  |  |
posting | VARCHAR2 | 16 |  |  |  |  |
trandisplayname | VARCHAR2 | 999 |  |  |  |  |
duedate | TIMESTAMP |  |  |  |  |  |
closedate | TIMESTAMP |  |  |  |  |  |
typebaseddocumentnumber | VARCHAR2 | 512 |  |  |  |  |
vendor | NUMBER | 38 | 0 |  |  | DW_NS_vendor_D | id
account | NUMBER | 38 | 0 |  |  | DW_NS_account_D | id
accountingbook_credit | NUMBER |  |  |  |  |  |
accountingbook_debit | NUMBER |  |  |  |  |  |
base_currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
base_creditamount | NUMBER |  |  |  |  |  |
base_amount | NUMBER |  |  |  |  |  |
base_debitamount | NUMBER |  |  |  |  |  |
accountingbook_currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
accountingbook_amount | NUMBER |  |  |  |  |  |
purchord_id | NUMBER | 38 | 0 |  |  | DW_NS_PURCHASE_ORDER_LINES_F | transaction
purchord_lineid | NUMBER | 38 | 0 |  |  | DW_NS_PURCHASE_ORDER_LINES_F | id
purchord_trandate | TIMESTAMP |  |  |  |  |  |
purchord_trandisplayname | VARCHAR2 | 999 |  |  |  |  |
purchord_typebaseddocumentnumber | VARCHAR2 | 512 |  |  |  |  |
purchord_type | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | key
purchord_status | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | code
purchreq_id | NUMBER | 38 | 0 |  |  | DW_NS_PURCHASE_REQUISITION_LINES_F | transaction
purchreq_lineid | NUMBER | 38 | 0 |  |  | DW_NS_PURCHASE_REQUISITION_LINES_F | id
purchreq_trandate | TIMESTAMP |  |  |  |  |  |
purchreq_trandisplayname | VARCHAR2 | 999 |  |  |  |  |
purchreq_typebaseddocumentnumber | VARCHAR2 | 512 |  |  |  |  |
purchreq_type | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | key
purchreq_status | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | code
purchcon_id | NUMBER | 38 | 0 |  |  | DW_NS_PURCHASE_CONTRACT_LINES_F | transaction
purchcon_lineid | NUMBER | 38 | 0 |  |  | DW_NS_PURCHASE_CONTRACT_LINES_F | id
purchcon_trandate | TIMESTAMP |  |  |  |  |  |
purchcon_trandisplayname | VARCHAR2 | 999 |  |  |  |  |
purchcon_typebaseddocumentnumber | VARCHAR2 | 512 |  |  |  |  |
purchcon_type | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | key
purchcon_status | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | code
IS_ADDRESSABLE_SPEND_FLAG | VARCHAR2 | 16 |  |  |  |  |
IS_DIRECT_SPEND_FLAG | VARCHAR2 | 16 |  |  |  |  |
IS_PURCHASE_ORDER_BASED_FLAG | VARCHAR2 | 16 |  |  |  |  |
IS_PURCHASE_CONTRACT_BASED_FLAG | VARCHAR2 | 16 |  |  |  |  |
IS_PURCHASE_CONTRACT_LEAKAGE_FLAG | VARCHAR2 | 16 |  |  |  |  |
IS_PURCHASE_REQUISITION_BASED_FLAG | VARCHAR2 | 16 |  |  |  |  |

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