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_id, accountingbook, vendbill_lineid
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 |