Order and Inventory Management Data Dictionary

Requisition_Line_Item__c

Label: Requisition Line Item

This Object describes a Requisition Line Item. A Requisition may have multiple line items. Line items facilitate procurement of multiple items or services on one purchase order and the requestor's information for pricing and delivery of goods (i.e., parts, facility supplies (MRO)) or services and is subject to a formal process of approval. This information is used in Procurement, Quality, and Finance processes

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Autobuilt__c Autobuilt? Pre-Spring 2018 Checkbox false
Budget__c Budget Pre-Spring 2018 Requestor's budget established for the Buyer to use when placing the Purchase Order Line

Currency(12,2)
Buyer_User__c Buyer Pre-Spring 2018 Looks up to: User

Lookup
Charge_Number__c Charge Number Pre-Spring 2018 Enter the authorized charge number used for this purchase

Text(15)
Condition_Code__c Condition Pre-Spring 2018 Enter the condition of the Item you would like purchased

Looks up to: Condition_Code__c
Lookup
DPAS_Rating__c DPAS Rating Pre-Spring 2018 Defense Priorities and Allocations System Rating for Government Contract

Text(5)
Description__c Description Pre-Spring 2018 This description is used for capital equipment, description, and contractor line item types.

TextArea
Drop_Ship_City__c Drop Ship City Pre-Spring 2018 Text(100)
Drop_Ship_Country__c Drop Ship Country Pre-Spring 2018 Text(100)
Drop_Ship_Line1__c Drop Ship Line 1 Pre-Spring 2018 Text(100)
Drop_Ship_Line2__c Drop Ship Line 2 Pre-Spring 2018 Text(100)
Drop_Ship_Name__c Drop Ship Name Pre-Spring 2018 The Name for a drop shipment

Text(100)
Drop_Ship_State_Province__c Drop Ship State / Province Pre-Spring 2018 Text(100)
Drop_Ship_Zip_Postal_Code__c Drop Ship Zip / Postal Code Pre-Spring 2018 Text(15)
Drop_Ship__c Drop Ship Pre-Spring 2018 Indicate whether this line item is drop shipped.

Checkbox false
Government_Contract_Number__c Government Contract Number Pre-Spring 2018 Enter the government contract number this Requisition supports

Text(24)
Item_Description_New__c Item Description - New Pre-Spring 2018 Enter as much information as possible to help procurement find the correct item

TextArea
Item_Description__c Item Description Pre-Spring 2018 Item Description Defined in the Item Master

Formula:
Item_Master__r.Item_Description__c
Text
Item_Master__c Item Master Pre-Spring 2018 Looks up to: Item__c
Lookup
Item_Number_New__c Item Number - New Pre-Spring 2018 Use this Item Number field for Items not currently in the system

Text(32)
Line_Number_Formula__c Req Line # Pre-Spring 2018 Covert requisition line item number to a number

Formula:
VALUE(Line_Number__c)
Number(18,0)
Line_Number__c Req Line # Pre-Spring 2018 The number of the requisition line within a specific requisition. This field is automatically set.

Text(3)
Line_Status__c Line Status Pre-Spring 2018 Picklist:
Approved
Cancelled
Disapproved
Open
Place on a Sourcing Request Line
Placed on a Purchase Contract
Placed on a Purchase Order
Revised
Submitted for Approval
Line_Type__c Line Type Pre-Spring 2018 Formula:
$RecordType.DeveloperName
Text
Product_Group__c Category Spring 2022 The category of the goods or services for which the requisition line is created. The category corresponds to a product group that has been set as a category. This field is used for requisition lines of type Category.

Looks up to: Product_Group__c
Lookup
Production_Order_Line__c Production Order Line Pre-Spring 2018 Production order line that generated this requisition line

Looks up to: Production_Order_Line__c
Lookup
Providing_Suppiler__c Providing Supplier Pre-Spring 2018 Formula:
Purchase_Order_Award__r.Supplier_Awarded__c
Text
Purchase_Contract_Line_Award__c Purchase Contract Line Winter 2023 The purchase contract line that relates to the requisition line item.

Looks up to: Purchase_Contract_Line__c
Lookup
Purchase_Order_Award__c Purchase Order Award Pre-Spring 2018 This is the Purchase Order line that was placed against this Requisition

Looks up to: Purchase_Order_Line_Item__c
Lookup
Quantity__c Quantity Pre-Spring 2018 Number of units being Requisitioned

Number(18,4)
Requested_Date__c Requested Delivery Date Pre-Spring 2018 Date the item is required to be delivered

Date
Requisition__c Requisition Pre-Spring 2018 The requisition this line item is related to. All requisition order line items must have a Requisition header.

Looks up to: Requisition__c
MasterDetail
Sales_Order_Association__c Sales Order Association Pre-Spring 2018 This Requisition was generated by sales referencing this Sales Order Information

Looks up to: Sales_Order_Line_Item__c
Lookup
Service_Being_Requested__c Service Being Requested Pre-Spring 2018 The service being requested.

LongTextArea(32000)
Sourcing_Request_Line__c Sourcing Request Line Pre-Spring 2018 Looks up to: Sourcing_Request_Line__c
Lookup
Status_Change_Date__c Status Change Date Pre-Spring 2018 The date the status on the requisition line was last changed.

DateTime
Suggested_Supplier__c Suggested Supplier Pre-Spring 2018 Enter a suggested supplier for sourcing of this Requisition. This is optional.

Text(100)
Supplier_Catalogue_Item__c Supplier Catalogue Item Pre-Spring 2018 Enter the item being requested from a supplier catalogue

Looks up to: Supplier_Catalogue_Item__c
Lookup
Supplier_Promise_Date__c Supplier Promise Date Pre-Spring 2018 Formula:
Purchase_Order_Award__r.Supplier_Current_Promise_Date__c
Date
Taxable__c Taxable? Pre-Spring 2018 Select this box if taxes are applicable to this Requisition

Checkbox false
Warehouse__c Ship to Warehouse Pre-Spring 2018 Choose the warehouse this line item is to be delivered to

Looks up to: Warehouse__c
Lookup


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.