PO_SYSTEM_PARAMETERS_ALL
PO_SYSTEM_PARAMETERS_ALL stores default, control, and option information you provide to customize Oracle Purchasing to your company's needs. PO_SYSTEM_PARAMETERS_ALL corresponds to the Purchasing Options window. This table has no primary key. The table should never have more than one row. . .
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PO_SYSTEM_PARAMETERS_ALL_PK |
PRC_BU_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| SOURCING_SUPP_ELIGIBILITY_FLAG | VARCHAR2 | 1 | Control to invite only sourcing eligible suppliers. | ||
| BYPASS_APPROVAL_FLAG | VARCHAR2 | 1 | A flag to indicate whether the approval process needs to be bypassed on submission | ||
| SYSTEM_CONFIGURED_FLAG | VARCHAR2 | 1 | A flag to indicate whether the procurement business unit was created using procurement setup simplification. | ||
| MAX_LINES_ON_PDF | NUMBER | 8 | Indicates the maximum number of document lines that will be printed on the PDF | ||
| NEG_APPROVAL_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Control to enable approval of a negotiation before it is published | |
| AWARD_APPROVAL_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Control to enable approval of award decision before it is completed | |
| MODE_OF_TRANSPORT | VARCHAR2 | 30 | Type of transportation used to ship the product, such as truck, air or boat. | ||
| SERVICE_LEVEL | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported | ||
| BUYER_MANAGED_TRANSPORT_FLAG | VARCHAR2 | 1 | Yes | A flag to indicate that the buying company is responsible for arranging the transportation, from picking up the requested goods to delivering to ship-to locations specified on the order. The value is Y/N. | |
| USE_SALES_ORDER_NUMBER_FLAG | VARCHAR2 | 1 | Indicates whether requisition lines should be grouped by Sales Order Number to create distinct purchase order headers. | ||
| AGING_PERIOD_DAYS | NUMBER | 5 | Indicates the maximum number of days the material may be on consignment. Only positive values are allowed. | ||
| AGING_ONSET_POINT | VARCHAR2 | 30 | Indicates the mutually agreed event point at which consigned material begins to age. The possible values are None / Receipt / Shipment. Values from Lookups | ||
| CONSUMPTION_ADVICE_FREQUENCY | VARCHAR2 | 30 | Indicates the frequency at which the 'Create Consumption Advice' program will be run for all consumption transactions for consigned inventory purchased under the agreements created in this BU. The possible values are Daily / Weekly / Monthly. Values from Lookups | ||
| CONSUMPTION_ADVICE_SUMMARY | VARCHAR2 | 30 | Indicates the granularity at which consumption advices will be generated. The possible values are Inventory Organization, Item and Transaction Date / Inventory Organization and Item / Inventory Organization / All Inventory Organizations. Values from Lookups | ||
| LANGUAGE_CODE | VARCHAR2 | 16 | Default user Language for the Procurement Business Unit | ||
| GROUP_REQUISITIONS | VARCHAR2 | 1 | check box for req grouping functionality | ||
| ALLOW_RETRO_PRICING | VARCHAR2 | 20 | Used to Store Allow Retro Active Pricing | ||
| DEFAULT_PROMISE_DATE | VARCHAR2 | 1 | Checkbox to check Default promise date from need-by date | ||
| GROUP_REQUISITION_LINES | VARCHAR2 | 1 | Check box to check Group Requisition Lines | ||
| USE_NEED_BY_DATE | VARCHAR2 | 1 | Checkbox to check Use need-by date | ||
| USE_SHIP_TO | VARCHAR2 | 1 | Checkbox to check Use ship-to organization and location | ||
| ENFORCE_BUYER_AUTHORITY_FLAG | VARCHAR2 | 1 | Determinies Buyer authority for the Procurement Business Unit | ||
| FOB_LOOKUP_CODE | VARCHAR2 | 30 | Default FOB for the Procurement Business Unit | ||
| FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | 30 | Default Freight Terms for the Procurement Business Unit | ||
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Yes | Default Inventory Organization for the Procurement Business Unit | |
| RFQ_ONLY_SITE_FLAG | VARCHAR2 | 1 | RFQ Only Site Flag | ||
| CARRIER_ID | NUMBER | 18 | Carrier ID | ||
| CURRENCY_CODE | VARCHAR2 | 215 | Yes | Default Currency for the Procurement Business Unit | |
| TERMS_ID | NUMBER | 18 | Default Terms for the Procurement Business Unit | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | 1 | Default value that indicates whether you require inspection for items you order | ||
| DEFAULT_RATE_TYPE | VARCHAR2 | 30 | Default currency rate type for your documents | ||
| TAXABLE_FLAG | VARCHAR2 | 1 | Default value that indicates whether your purchases are taxable | ||
| USER_DEFINED_RECEIPT_NUM_CODE | VARCHAR2 | 25 | Receipt numbering type | ||
| MANUAL_RECEIPT_NUM_TYPE | VARCHAR2 | 25 | Receipt number type | ||
| USER_DEFINED_REQ_NUM_CODE | VARCHAR2 | 25 | Requisition numbering type | ||
| MANUAL_REQ_NUM_TYPE | VARCHAR2 | 25 | Requisition number type | ||
| ENFORCE_VENDOR_HOLD_FLAG | VARCHAR2 | 1 | Indicates whether you enforce supplier holds during purchase order approval | ||
| LINE_TYPE_ID | NUMBER | 18 | Unique identifier of the line type you use on your documents | ||
| NEXT_APPROVER_LOOKUP_CODE | VARCHAR2 | 25 | Type of next approver logic | ||
| RECEIVING_FLAG | VARCHAR2 | 1 | Default value that indicates whether you require receipt for items you order or not | ||
| ALLOW_ITEM_DESC_UPDATE_FLAG | VARCHAR2 | 1 | Default value that indicates whether item descriptions can be updated on document lines | ||
| MIN_RELEASE_AMOUNT | NUMBER | Default minimum release amount for blanket and planned purchase orders in functional currency | |||
| PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | 25 | Default price break type for catalog quotations and blanket agreements | ||
| INVOICE_CLOSE_CODE | VARCHAR2 | 25 | Not currently used | ||
| RECEIVE_CLOSE_CODE | VARCHAR2 | 25 | Default receiving close point | ||
| INVOICE_CLOSE_TOLERANCE | NUMBER | Default invoice close tolerance percent | |||
| RECEIVE_CLOSE_TOLERANCE | NUMBER | Default receiving close tolerance percent | |||
| PRC_BU_ID | NUMBER | 18 | Yes | Procurement Business Unit Unique Identifier | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| TAX_FROM_SHIP_TO_LOC_FLAG | VARCHAR2 | 1 | Default tax code from ship-to location | ||
| TAX_FROM_ITEM_FLAG | VARCHAR2 | 1 | Default tax code from the inventory item | ||
| TAX_FROM_VENDOR_FLAG | VARCHAR2 | 1 | Default tax code from the supplier | ||
| TAX_FROM_VENDOR_SITE_FLAG | VARCHAR2 | 1 | Default tax code from supplier site | ||
| TAX_FROM_SYSTEM_FLAG | VARCHAR2 | 1 | Default tax code from Financial Options window | ||
| TAX_HIER_SHIP_TO_LOC | NUMBER | 18 | Ship-to location position in tax code defaulting hierarchy | ||
| TAX_HIER_ITEM | NUMBER | 18 | Item position in the tax code defaulting hierarchy | ||
| TAX_HIER_VENDOR | NUMBER | 18 | Supplier position in the tax code defaulting hierarchy | ||
| TAX_HIER_VENDOR_SITE | NUMBER | 18 | Supplier Site position in the tax code defaulting hierarchy | ||
| TAX_HIER_SYSTEM | NUMBER | 18 | Financial Options in the tax code defaulting hierarchy | ||
| CREATE_DEBIT_MEMO_FLAG | VARCHAR2 | 25 | Indicator of whether a debit memo should be created | ||
| PRICE_CHANGE_AMOUNT | NUMBER | Price difference amount you allow between requisition and purchase order price | |||
| MAX_ATTACHMENT_SIZE | NUMBER | Indicates maximum allowed size of ZIP attachment file | |||
| SUPPLIER_AUTHORING_ACCEPTANCE | VARCHAR2 | 30 | Supplier acceptance level for agreement change | ||
| CAT_ADMIN_AUTHORING_ACCEPTANCE | VARCHAR2 | 30 | Catalog Administrator acceptance level for agreement change | ||
| EMAIL_ATTACHMENT_FILENAME | VARCHAR2 | 30 | Email Attachment File name | ||
| MATCH_OPTION | VARCHAR2 | 25 | Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| BEST_PRICE_VISIBLE_BLIND | VARCHAR2 | 1 | Used by Sourcing | ||
| COLLAB_SECURITY_PROFILE_ID | NUMBER | 18 | Used by Sourcing | ||
| DOCTYPE_ID | NUMBER | 18 | Used by Sourcing | ||
| ENFORCE_MIN_BID_PRICE | VARCHAR2 | 1 | Used by Sourcing | ||
| HDR_ATTR_DEFAULT_MAX_SCORE | NUMBER | Used by Sourcing | |||
| HDR_ATTR_DISP_SCORE_CRITERIA | VARCHAR2 | 1 | Used by Sourcing | ||
| HDR_ATTR_ENABLE_WEIGHTS | VARCHAR2 | 1 | Used by Sourcing | ||
| NEXT_NEGOTIATION_NUMBER | NUMBER | Used by Sourcing | |||
| RANK_INDICATOR | VARCHAR2 | 30 | Used by Sourcing | ||
| RANK_VISIBLE_BLIND | VARCHAR2 | 1 | Used by Sourcing | ||
| STYLE_ID | NUMBER | 18 | Used by Sourcing | ||
| SUPPLIER_HISTORY_DURATION | NUMBER | Used by Sourcing | |||
| DEFAULT_BUYER_ID | NUMBER | 18 | Default Buyer unique identifier | ||
| PO_CREATION_PROCESS | VARCHAR2 | 30 | Yes | Indicates whether purchasing document will be created from Sourcing using web service or in Fusion Purchasing for the given procurement business unit. | |
| GEN_ORDER_FOR_NEG_REQS_FLAG | VARCHAR2 | 1 | Yes | Check box indicating whether negotiated requisition lines having valid supplier information should be automatically processed to purchase orders even without any purchase agreement reference. | |
| ALLOW_MANUL_PRICE_UPDATE_ORDER | VARCHAR2 | 1 | This attribute indicates if the price can be manually updated on fulfilled purchase orders. | ||
| USE_SHIP_TO_FOR_GROUP_REQS | VARCHAR2 | 1 | Yes | Checkbox to indicate whether to use ship-to organization and location when grouping requisitions | |
| COMMUNICATE_CO_FLAG | VARCHAR2 | 1 | Yes | A flag to indicate whether purchase order changes should be communicated and acknowledged. | |
| AUTO_SOURCING_FLAG | VARCHAR2 | 1 | Yes | Enable automatic sourcing flag | |
| PUNCHOUT_SOURCING_ONLY_FLAG | VARCHAR2 | 1 | Yes | Automatic Sourcing of Punchout Requests Only | |
| GENERATE_ORDERS_AUTOMATIC | VARCHAR2 | 1 | Yes | Automatically Generate Orders flag | |
| SUBMIT_APPROVAL_AUTOMATIC | VARCHAR2 | 1 | Yes | Automatically Submit for Approval flag | |
| COMMUNICATE_PA_FLAG | VARCHAR2 | 1 | Yes | A flag to indicate whether purchase agreements should be communicated and acknowledged. | |
| INITIATE_APPROVAL_ENABLED_FLAG | VARCHAR2 | 1 | A flag to default the initiate approval flag when creating the purchasing documents | ||
| ENFORCE_TEMPLATE_FLAG | VARCHAR2 | 1 | A flag to enforce the template selection in create negotiation. | ||
| DEFAULT_SUPP_RESP_FROM_SQM | VARCHAR2 | 1 | A flag to default the negotiation response from SQM repository. | ||
| UPDATE_SUPP_ITEM_IN_PIM_FLAG | VARCHAR2 | 1 | Control to update new supplier item relationship in PIM when capture supplier item optin is enabled in sourcing. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PO_SYSTEM_PARAMETERS_ALL | gl_daily_conversion_types | DEFAULT_RATE_TYPE |
| PO_SYSTEM_PARAMETERS_ALL | po_line_types_b | LINE_TYPE_ID |
| pon_neg_abstract_config | po_system_parameters_all | PRC_BU_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_SYSTEM_PARAMETERS_N1 | Non Unique | Default | CARRIER_ID |
| PO_SYSTEM_PARAMETERS_U1 | Unique | Default | PRC_BU_ID |