Order and Inventory Management Object Model Diagrams
G AP_Voucher_Credit__c AP Voucher Credit +!!AP Voucher Credit Name!!Name -!!AP Voucher!!AP_Voucher__c -!!Credit Date!!Credit_Date__c -!!Export Error!!Export_Error__c -!!Export Status!!Export_Status__c -!!External Tax Status!!External_Tax_Status__c -!!External Tax Status Last Updated!!External_Tax_Status_Last_Updated__c -!!External Tax Transaction ID!!External_Tax_Transaction_ID__c -!!Foreign Credit Number!!Foreign_Credit_Number__c -!!Original Invoice Date!!Original_Invoice_Date__c #!!Posting Tax to Avalara Optional!!Posting_Tax_to_Avalara_Optional__c -!!Purchase Order!!Purchase_Order__c -!!Registered Date!!Registered_Date__c -!!Status!!Status__c -!!Supplier Invoice Number!!Invoice_Number__c -!!Supplier Site!!Supplier_Site__c -!!Total Tax!!Total_Tax__c AP_Voucher__c AP Voucher +!!AP Voucher Name!!Name -!!Accounting Date!!Accounting_Date__c -!!Credit Status!!Credit_Status__c -!!Due Date!!Due_Date__c -!!Export Error!!Export_Error__c -!!Export Status!!Export_Status__c -!!External Tax Status!!External_Tax_Status__c -!!External Tax Status Last Updated!!External_Tax_Status_Last_Updated__c -!!External Tax Transaction ID!!External_Tax_Transaction_ID__c -!!Foreign Invoice Number!!Foreign_Invoice_Number__c -!!Invoice Date!!Invoice_Date__c -!!Invoice Total!!Invoice_Total__c -!!Number of Lines!!Number_of_Lines__c #!!Posting Tax to Avalara Optional!!Posting_Tax_to_Avalara_Optional__c -!!Purchase Order!!Purchase_Order__c -!!Purchase Order Type!!Purchase_Order_Type__c -!!Registered Date!!Registered_Date__c -!!Status!!Status__c -!!Supplier Invoice Number!!Invoice_Number__c -!!Supplier Site!!Supplier_Site__c -!!Terms!!Terms__c -!!Total Amount Credited!!Total_Amount_Credited__c -!!Total Tax!!Total_Tax__c -!!Total Voucher!!Total_Voucher__c #!!Total Voucher with Tax!!Total_Voucher_with_Tax__c + Matched() + Reverse_Receipt() + Credit_Voucher() + Void_Voucher() + Received() AP_Voucher_Credit__c->AP_Voucher__c Purchase_Order__c Purchase Order +!!Purchase Order  Number!!Name -!!Applied Rebate Amount!!Applied_Rebate_Amount__c -!!Approval Date!!Approval_Date__c -!!Award Code!!Award_Code__c -!!Batch!!Batch__c -!!Blanket Order Quantity Limit!!Blanket_Order_Quantity_Limit__c -!!Blanket Order Spend Limit!!Blanket_Order_Spend_Limit__c -!!Buyer!!Buyer_User__c -!!Buyer Instructions to Supplier!!Buyer_Instructions_to_Supplier__c -!!Buyer Notes!!Buyer_Notes__c -!!Confirm To!!Confirm_To__c -!!Currency!!Currency_Master__c -!!Delivery Options!!Delivery_Options__c -!!Delivery Status!!Delivery_Status__c -!!Drop Ship!!Drop_Ship__c -!!Drop Ship Address Validated!!Drop_Ship_Address_Validated__c -!!Drop Ship City!!Drop_Ship_City__c -!!Drop Ship Country!!Drop_Ship_Country__c -!!Drop Ship Line 1-2!!Drop_Ship_Line1__c -!!Drop Ship Name!!Drop_Ship_Name__c -!!Drop Ship State / Province!!Drop_Ship_State_Province__c -!!Drop Ship Zip / Postal Code!!Drop_Ship_Zip_Postal_Code__c -!!End Date!!End_Date__c -!!Engagement!!Engagement__c -!!Existing PO Number!!Existing_PO_Number__c -!!External Tax Status!!External_Tax_Status__c -!!Miscellaneous Charges!!Miscellaneous_Charges__c -!!Miscellaneous Charges 2!!Miscellaneous_Charges_2__c -!!Number of Cancelled Lines!!Number_of_Cancelled_Lines__c -!!Number of Closed Lines!!Number_of_Closed_Lines__c -!!Number of Item Lines!!Number_of_Item_Lines__c -!!Number of Lines!!Number_of_Lines__c -!!Number of Partially Received Lines!!Number_of_Partially_Received_Lines__c -!!Number of Recurrences!!Number_of_Recurrences__c -!!Number of Service Lines!!Number_of_Service_Lines__c -!!Number of Service Lines Shipped!!Number_of_Service_Lines_Shipped__c -!!Number of Service Lines to Allocate!!Number_of_Service_Lines_to_Allocate__c -!!Number Open Lines!!Number_Open_Lines__c #!!Order Type!!Order_Type__c -!!Override Ship to Address!!Override_Ship_to_Address__c -!!Ownership!!Ownership__c -!!Payment Terms!!Payment_Terms__c #!!Payment Terms Name!!Payment_Terms_Name__c -!!Procured for!!Procured_for__c -!!Purchase Agreement!!Purchase_Contract__c -!!Purchase Order Date!!Purchase_Order_Date__c -!!Purchase Order Name!!Purchase_Order_Name__c -!!Recurrence Interval!!Recurrence_Interval__c -!!Recurrence Period!!Recurrence_Period__c -!!Recurring Purchase Order?!!Recurring_Purchase_Order__c -!!Resale!!Resale__c -!!Revision!!Revision__c -!!Revision Date!!Revision_Date__c -!!Sales Order!!Sales_Order__c -!!Service Contract!!Service_Contract__c #!!Ship To Address!!Ship_To_Address__c -!!Ship to Warehouse!!Ship_To_Warehouse__c -!!Shipment Options!!Shipment_Options__c -!!Shipment Services!!Shipment_Services__c -!!Start Date!!Start_Date__c -!!Status!!Status__c -!!Status Change Date!!Status_Change_Date__c -!!Supplier Contact!!Supplier_Contact__c -!!Supplier Ship Via!!Supplier_Ship_Via__c -!!Supplier Site!!Supplier_Site__c -!!Total Amount Vouchered!!Total_Amount_Vouchered__c -!!Total Quantity Vouchered!!Total_Quantity_Vouchered__c -!!Total Tax!!Total_Tax__c -!!Total Value of PO!!Total_Value_of_PO__c + Create_Recurring_POs() + Print() + Send() + PO_Clone() + Price() + Reverse_Allocate_Service_Items() + Cancel_Purchase_Order() + Revise() AP_Voucher_Credit__c->Purchase_Order__c Supplier_Site__c Supplier_Site__c AP_Voucher_Credit__c->Supplier_Site__c AP_Voucher_Line_Credit__c AP Voucher Line Credit +!!AP Voucher Line Credit Name!!Name -!!Accounting Item!!Accounting_Item__c -!!Amount!!Amount__c -!!AP Voucher Credit!!AP_Voucher_Credit__c -!!AP Voucher Line!!AP_Voucher_Line__c #!!Description!!Description__c -!!Editable AP Voucher Line Credit Name!!Editable_Name__c #!!Extended Price!!Extended_Price__c #!!Extended Purchase Price Variance!!Extended_Purchase_Price_Variance__c #!!Item!!Item__c -!!Line Number!!Line_Number__c #!!Line Type!!Line_Type__c -!!Non-Receivable!!Non_Receivable__c -!!Purchase Order Line Item!!Purchase_Order_Line_Item__c #!!Quantity Ordered!!Quantity_Ordered__c #!!Quantity Received!!Quantity_Received__c -!!Quantity Vouchered!!Quantity__c #!!Sales Order!!Sales_Order__c -!!Serial Numbers!!Serial_Numbers__c -!!Tax!!Tax__c -!!Tax Name 1-3!!Tax_Name_1__c -!!Tax Rate!!Tax_Rate__c -!!Tax Rate 1-3!!Tax_Rate_1__c -!!Tax Value 1-3!!Tax_Value_1__c -!!Unit Price!!Unit_Price__c -!!Unit Purchase Price Variance!!Unit_Purchase_Price_Variance__c AP_Voucher_Line_Credit__c->AP_Voucher_Credit__c AP_Voucher_Line__c AP Voucher Line +!!AP Voucher Line Name!!Name -!!Accounting Item!!Accounting_Item__c -!!AP Voucher!!AP_Voucher__c -!!Capital Equipment!!Capital_Equipment__c -!!Delivery Method!!Delivery_Method__c #!!Description!!Description__c -!!Editable AP Voucher Line Name!!Editable_Name__c #!!Extended PPV!!Extended_Purchase_Price_Variance__c #!!Extended Price!!Extended_Price__c -!!Is Capital Equipment!!Is_Capital_Equipment__c #!!Item!!Item__c -!!Line Number!!Line_Number__c #!!Line Type!!Line_Type__c -!!Non-Receivable!!Non_Receivable__c -!!Override Avalara Tax Code!!Override_Avalara_Tax_Code__c -!!Purchase Order Line Item!!Purchase_Order_Line_Item__c #!!Quantity Ordered!!Quantity_Ordered__c #!!Quantity Received!!Quantity_Received__c -!!Quantity Vouchered!!Quantity__c -!!Received Date!!Received_Date__c #!!Sales Order!!Sales_Order__c -!!Serial Numbers!!Serial_Numbers__c -!!Tax!!Tax__c -!!Tax Code!!Tax_Code__c -!!Tax Name 1-3!!Tax_Name_1__c -!!Tax Rate!!Tax_Rate__c -!!Tax Rate 1-3!!Tax_Rate_1__c -!!Tax Value 1-3!!Tax_Value_1__c -!!Unit PPV!!Unit_Purchase_Price_Variance__c -!!Unit Price!!Unit_Price__c -!!Use Code!!Use_Code__c AP_Voucher_Line_Credit__c->AP_Voucher_Line__c Purchase_Order_Line_Item__c Purchase Order Line Item +!!System PO Line Number!!Name -!!Amount Received!!Amount_Received__c -!!Amount Vouchered!!Amount_Vouchered__c -!!Applied Rebate Amount!!Applied_Rebate_Amount__c -!!Budget!!Budget__c -!!Category!!Product_Group__c -!!Charge Number!!Charge_Number__c -!!Condition!!Condition_Code__c -!!Delivery Method!!Delivery_Method__c -!!Description!!Description__c -!!DPAS Rating!!DPAS_Rating__c -!!Drop Ship!!Drop_Ship__c -!!Drop Ship City!!Drop_Ship_City__c -!!Drop Ship Country!!Drop_Ship_Country__c -!!Drop Ship Line 1-2!!Drop_Ship_Line1__c -!!Drop Ship Name!!Drop_Ship_Name__c -!!Drop Ship State / Province!!Drop_Ship_State_Province__c -!!Drop Ship Zip / Postal Code!!Drop_Ship_Zip_Postal_Code__c -!!Editable Purchase Order Line Item Name!!Editable_Name__c -!!End Date!!End_Date__c -!!Government Contract Number!!Government_Contract_Number__c #!!Inspection Required!!Inspection_Required__c -!!Item Being Procured!!Item_Master__c #!!Item Description!!Item_Description__c #!!Item Type!!Item_Type__c #!!Line Type!!Line_Type__c -!!Logistics Cost!!Logistics_Cost__c -!!Option Cost Per Unit!!Option_Cost_Per_Unit__c -!!Outbound Parts Status!!Outbound_Parts_Status__c -!!Override Avalara Tax Code!!Override_Avalara_Tax_Code__c #!!Ownership!!Ownership__c #!!Pending Voucher!!Pending_Quantity_To_Voucher__c #!!PO Line Number!!Line_Formula__c -!!PO Line Number!!Line_Number__c -!!Production Order Line!!Production_Order_Line__c -!!Purchase Agreement Line!!Purchase_Contract_Line__c -!!Purchase Order!!Purchase_Order__c -!!Purchase Price Variance!!Purchase_Price_Variance__c -!!Quantity!!Quantity__c -!!Quantity Received!!Quantity_Received__c -!!Quantity Vouchered!!Quantity_Vouchered__c -!!Receive by Amount!!Receive_by_Amount__c #!!Remaining to Voucher!!Remaining_to_Voucher__c -!!Requested Delivery Date!!Requested_Date__c -!!Requisition Line Item!!Requisition_Line_Item__c -!!Sales Order Line Item!!Sales_Order_Line_Item__c -!!Service Being Procured!!Service_Being_Procured__c -!!Service Contact Line Type!!Service_Contact_Line_Type__c -!!Service Contract Line!!Service_Contract_Line__c -!!Service Term!!Service_Term__c -!!Ship to Warehouse!!Warehouse__c -!!Status!!Status__c -!!Status Change Date!!Status_Change_Date__c #!!Stocking Unit of Measure!!Stocking_Unit_of_Measure__c #!!Supplier Awarded!!Supplier_Awarded__c -!!Supplier Commitment Date!!Supplier_Commitment_Date__c -!!Supplier Current Promise Date!!Supplier_Current_Promise_Date__c #!!Supplier Unit of Measure!!Supplier_Unit_of_Measure__c -!!Tax!!Tax__c -!!Tax Code!!Use_Tax_Code__c -!!Tax Name 1-3!!Tax_Name_1__c -!!Tax Rate!!Tax_Rate__c -!!Tax Rate 1-3!!Tax_Rate_1__c -!!Tax Value 1-3!!Tax_Value_1__c -!!Taxable?!!Taxable__c #!!Total Cost!!Total_Cost__c -!!Total Service Terms!!Total_Service_Terms__c #!!Total Vouchered!!Total_Vouchered__c -!!Unit Cost!!Unit_Cost__c #!!Unit Cost With Options!!Unit_Cost_With_Options__c -!!Use Code!!Use_Code__c + Apply() + Cancel_Purchase_Order_Line() + Allocate_Parts_for_Service() + Reverse_Allocate_Items_for_Service() + Associate_Inv() AP_Voucher_Line_Credit__c->Purchase_Order_Line_Item__c AP_Voucher_Line__c->AP_Voucher__c AP_Voucher_Line__c->Purchase_Order_Line_Item__c AP_Voucher__c->Purchase_Order__c AP_Voucher__c->Supplier_Site__c AttachmentType__c Attachment Type +!!Attachment Type!!Name -!!Description!!Description__c Attachment_Set_Association__c Attachment Sets +!!Attachment Set Association Name!!Name -!!Attachment!!Attachment__c -!!Buyer Attachment Set!!Buyer_Attachment_Set__c -!!Customer Quotation!!Customer_Quotation__c -!!Customer Quotation Line!!Customer_Quotation_Line__c -!!PO Attachment!!PO_Attachment__c -!!Purchase Order!!Purchase_Order__c -!!Purchase Order Line Item!!Purchase_Order_Line_Item__c -!!Sales Order!!Sales_Order__c -!!Sales Order Line Item!!Sales_Order_Line_Item__c Buyer_Attachment_Set__c Buyer Attachment Set +!!Buyer Attachment Set Name!!Name -!!Description!!Description__c Attachment_Set_Association__c->Buyer_Attachment_Set__c PO_Attachment__c PO Attachment +!!PO Attachment Name!!Name -!!Attachment Type!!Attachment_Type__c -!!PO Attachment Description!!PO_Attachment_Description__c -!!Version!!Version__c Attachment_Set_Association__c->PO_Attachment__c Attachment_Set_Association__c->Purchase_Order_Line_Item__c Attachment_Set_Association__c->Purchase_Order__c Award_Code__c Award Code +!!Award Code!!Name -!!Award Description!!Award_Description__c -!!Default for Autobuild!!Default_for_Autobuild__c Commodity_Code_Buyer_Association__c Commodity Code Buyer Association +!!Commodity Code Buyer Association Name!!Name -!!Buyer!!Buyer__c -!!Commodity Code!!Commodity_Code__c Commodity_Code__c Commodity Code +!!Commodity Code Name!!Name -!!Description!!Description__c -!!Number!!Number__c -!!Purchase Tax Code!!Tax_Code__c -!!Supplier Lead Time!!Supplier_Lead_Time__c + State_of_Tennessee_Commodity_Codes() Commodity_Code_Buyer_Association__c->Commodity_Code__c Tax_Code__c Tax Code +!!Tax Code Name!!Name -!!Description!!Description__c -!!Effective From!!Effective_From__c -!!Inactive!!Inactive__c -!!Purchase Tax Account!!Purchase_Tax_Account__c -!!Rate!!Tax_Rate__c -!!Rate Obsolete!!Rate__c -!!Sale Tax Account!!Sale_Tax_Account__c -!!Split Tax!!Split_Tax__c -!!Tax Agency!!Tax_Agency__c -!!Tax Type!!Tax_Type__c -!!Valid Until!!Valid_Until__c Commodity_Code__c->Tax_Code__c Credit_Invoice_Line__c Credit Invoice Line +!!Credit Invoice Line Name!!Name -!!Amount!!Amount__c -!!Credit Invoice!!Credit_Invoice__c -!!Customer Return Line!!Customer_Return_Line__c -!!Editable Credit Invoice Line Name!!Editable_Name__c -!!Invoice Line Item!!Invoice_Line_Item__c #!!Item!!Item__c -!!Quantity!!Quantity__c -!!Tax!!Tax__c -!!Tax Name 1-3!!Tax_Name_1__c -!!Tax Rate!!Tax_Rate__c -!!Tax Rate 1-3!!Tax_Rate_1__c -!!Tax Value 1-3!!Tax_Value_1__c Credit_Invoice__c Credit Invoice +!!Credit Invoice Name!!Name -!!Credit Invoice Date!!Credit_Invoice_Date__c -!!Customer Return!!Customer_Return__c -!!Export Error!!Export_Error__c -!!Export Status!!Export_Status__c -!!External Tax Status!!External_Tax_Status__c -!!External Tax Status Last Updated!!External_Tax_Status_Last_Updated__c -!!External Tax Transaction ID!!External_Tax_Transaction_ID__c -!!Foreign Credit Invoice!!Foreign_Credit_Invoice__c -!!Invoicing!!Invoicing__c -!!Total Tax!!Total_Tax__c Credit_Invoice_Line__c->Credit_Invoice__c Exchange_Order__c Exchange Order +!!Exchange Order Number!!Name -!!Advance Core Receipt?!!Advance_Core_Receipt__c -!!Core Return Date!!Core_Return_Date__c -!!Core Return Warehouse!!Core_Return_Warehouse__c -!!Core Valuation!!Core_Valuation__c -!!Incoming Item Number!!Incoming_Item_Number__c -!!Outgoing Item Number!!Outgoing_Item_Number__c -!!Purchase Order Line Item!!Purchase_Order_Line_Item__c -!!Quantity Received!!Quantity_Received__c -!!Received Item Number!!Received_Item_Number__c -!!Sales Order Line Item!!Sales_Order_Line_Item__c -!!Status!!Status__c -!!Status Change Date!!Status_Change_Date__c Exchange_Order__c->Purchase_Order_Line_Item__c Experience__c Experience__c Supplier_Service__c Supplier_Service__c Experience__c->Supplier_Service__c Experience__c->Supplier_Site__c Freight_Code__c Freight Code +!!Freight Code!!Name -!!Freight Code!!Freight_Code__c -!!Freight Description!!Freight_Description__c Ownership_Code__c Ownership Code +!!Ownership Code Name!!Name -!!Ownership Code Description!!Ownership_Code_Description__c Receipt_Line__c Receipt Line +!!Receipt Line Id!!Name -!!Amount!!Amount__c -!!Customer Return Line!!Customer_Return_Line__c #!!Item Description!!Item_Description__c -!!Item Number!!Item_Number__c -!!Lot Number!!Lot_Number__c -!!Purchase Order Line Item!!Purchase_Order_Line_Item__c -!!Quantity!!Quantity__c -!!Receiver!!Receiver__c -!!Serial Number!!Serial_Number__c -!!Shelf Life!!Shelf_Life__c -!!Status!!Status__c #!!Stocking Unit of Measure!!Stocking_Unit_of_Measure__c -!!Supplier Quantity!!Supplier_Quantity__c #!!Supplier Unit of Measure!!Supplier_Unit_of_Measure__c + Reverse_Line() Receipt__c Receipt +!!Receipt Id!!Name -!!Customer Return!!Customer_Return__c -!!Exchange Order!!Exchange_Order__c -!!Purchase Order!!Purchase_Order__c -!!Receipt Type!!Receipt_Type__c -!!Return Material Authorization!!Return_Material_Authorization__c #!!Supplier!!Supplier__c + Add_Documents() + Print() Receipt_Line__c->Receipt__c Receipt_Line__c->Purchase_Order_Line_Item__c Receipt__c->Exchange_Order__c Receipt__c->Purchase_Order__c Receiving_Inspection__c Receiving Inspection +!!Receiving Inspection Number!!Name -!!Acceptance APIS!!Acceptance_APIS__c -!!Acceptance Bilateral Agreement!!Acceptance_Bilateral_Agreement__c -!!Acceptance PC!!Acceptance_PC__c -!!Acceptance PMA!!Acceptance_PMA__c -!!Acceptance Standard Parts!!Acceptance_Standard_Parts__c -!!Acceptance STC!!Acceptance_STC__c -!!Bench Test!!Bench_Test__c -!!CAGE Code!!CAGE_Code__c -!!Condition!!Condition_Code__c -!!CSN!!CSN__c -!!CSO!!CSO__c -!!CSR!!CSR__c -!!Documentation!!Documentation__c -!!Functional Test!!Functional_Test__c -!!Incoming Core!!Incoming_Core__c #!!Inspection Type!!Inspection_Type__c -!!Inspector Notes!!Inspector_Notes__c #!!Item Description!!Item_Description__c -!!Item Number!!Item_Number__c -!!Lot Number!!Lot_Number__c -!!Measurement/Test Equipment Utilized!!Measurement_Test_Equipment_Utilized__c -!!Misc Received Quantity!!Misc_Received_Quantity__c -!!Ownership Code!!Ownership_Code__c -!!Preservation!!Preservation__c -!!Production Order!!Production_Order__c -!!Quantity to Accept!!Quantity_to_Accept__c -!!Receipt Line!!Receipt_Line__c #!!Received Quantity!!Received_Quantity__c #!!Remaining Quantity to Inspect!!Remaining_Quantity_to_Inspect__c -!!Sample Size Taken!!Sample_Size_Taken__c -!!Serial Number!!Serial_Number__c -!!Shelf Life Limit!!Shelf_Life_Limit__c -!!Stamp Number!!Stamp_Number__c -!!Status!!Status__c #!!Supplier!!Supplier__c #!!Supplier Purchase Order!!Supplier_Purchase_Order__c #!!Supplier Purchase Order Line!!Supplier_Purchase_Order_Line__c #!!Supplier Purchase Order Line!!Supplier_Purchase_Order_Line_c__c -!!Supporting Documentation!!Supporting_Documentation__c -!!Technical Data Utilized!!Technical_Data_Utilized__c -!!Technical Document Control Number!!Technical_Document_Control_Number__c -!!Tool / Equipment Calibration Date!!Tool_Equipment_Calibration_Date__c -!!Total Quantity Accepted!!Total_Quantity_Accepted__c -!!Total Quantity Rejected!!Total_Quantity_Rejected__c -!!Total Quantity Scrapped!!Total_Quantity_Scrapped__c -!!TSN!!TSN__c -!!TSO!!TSO__c -!!TSR!!TSR__c -!!Visual!!Visual__c + Add_Documents() + Confirm_Serial_Number() + Complete() Receiving_Inspection__c->Ownership_Code__c Receiving_Inspection__c->Receipt_Line__c Production_Order__c Production Order +!!Production Order Name!!Name -!!Actual Completion Date!!Completion_Date__c -!!Actual Yield!!Actual_Yield__c -!!Approval Date!!Approval_Date__c -!!Assembly Cell!!Assembly_Cell__c -!!Completion Warehouse!!Completion_Warehouse__c -!!Condition!!Condition_Code__c -!!Item Master!!Item_Master__c -!!Material Warehouse!!Material_Warehouse__c -!!Ownership!!Ownership__c -!!Planned Completion Date!!Planned_Completion_Date__c -!!Production Status!!Production_Status__c -!!Progress Status!!Progress_Status__c -!!Quantity!!Quantity__c -!!Revision!!Revision__c -!!Sales Order Line Item!!Sales_Order_Line_Item__c -!!Start Date!!Start_Date__c -!!Status!!Status__c -!!Total Cost!!Total_Cost__c + Allocate() + Assign_Serial_Numbers() + Reverse_Allocate() + Cancel_Order() + Create_Requisition() + Complete() + Test_Allocate() Receiving_Inspection__c->Production_Order__c Requisition_Line_Item__c Requisition Line Item +!!Reference Number!!Name -!!Autobuilt?!!Autobuilt__c -!!Budget!!Budget__c -!!Buyer!!Buyer_User__c -!!Category!!Product_Group__c -!!Charge Number!!Charge_Number__c -!!Condition!!Condition_Code__c -!!Description!!Description__c -!!DPAS Rating!!DPAS_Rating__c -!!Drop Ship!!Drop_Ship__c -!!Drop Ship City!!Drop_Ship_City__c -!!Drop Ship Country!!Drop_Ship_Country__c -!!Drop Ship Line 1-2!!Drop_Ship_Line1__c -!!Drop Ship Name!!Drop_Ship_Name__c -!!Drop Ship State / Province!!Drop_Ship_State_Province__c -!!Drop Ship Zip / Postal Code!!Drop_Ship_Zip_Postal_Code__c -!!Government Contract Number!!Government_Contract_Number__c #!!Item Description!!Item_Description__c -!!Item Description - New!!Item_Description_New__c -!!Item Master!!Item_Master__c -!!Item Number - New!!Item_Number_New__c -!!Line Status!!Line_Status__c #!!Line Type!!Line_Type__c -!!Production Order Line!!Production_Order_Line__c #!!Providing Supplier!!Providing_Suppiler__c -!!Purchase Agreement Line!!Purchase_Contract_Line_Award__c -!!Purchase Order Award!!Purchase_Order_Award__c -!!Quantity!!Quantity__c #!!Req Line #!!Line_Number_Formula__c -!!Req Line #!!Line_Number__c -!!Requested Delivery Date!!Requested_Date__c -!!Requisition!!Requisition__c -!!Sales Order Association!!Sales_Order_Association__c -!!Service Being Requested!!Service_Being_Requested__c -!!Ship to Warehouse!!Warehouse__c -!!Sourcing Request Line!!Sourcing_Request_Line__c -!!Status Change Date!!Status_Change_Date__c -!!Suggested Supplier!!Suggested_Supplier__c -!!Supplier Catalogue Item!!Supplier_Catalogue_Item__c #!!Supplier Promise Date!!Supplier_Promise_Date__c -!!Taxable?!!Taxable__c + Create_Sourcing_Request() + Create_Purchase_Order() + Cancel_Requisition_Line() Requisition__c Requisition +!!Requisition Number!!Name -!!Approval Status!!Approval_Status__c -!!Buyer!!Buyer__c -!!Complete?!!Complete__c -!!Drop Ship!!Drop_Ship__c -!!Drop Ship City!!Drop_Ship_City__c -!!Drop Ship Country!!Drop_Ship_Country__c -!!Drop Ship Line 1-2!!Drop_Ship_Line_1__c -!!Drop Ship Name!!Drop_Ship_Name__c -!!Drop Ship State / Province!!Drop_Ship_State_Province__c -!!Drop Ship Zip / Postal Code!!Drop_Ship_Zip_Postal_Code__c -!!Follow With Chatter!!Follow_With_Chatter__c -!!Instructions to Supplier!!Instructions_to_Supplier__c -!!Lines Cancelled!!Number_Cancelled__c -!!Lines Closed!!Number_not_Open__c -!!Number of Lines!!Number_of_Lines__c -!!Override Ship to Address!!Override_Ship_to_Address__c -!!Ownership!!Ownership__c -!!Procured for!!Procured_for__c -!!Requestor Department!!Requestor_Department__c -!!Requestor Notes to Buyer!!Requestor_Notes_to_Buyer__c -!!Requisition Name!!Requisition_Name__c -!!Ship to Warehouse!!Warehouse__c #!!Status!!Status__c -!!Supplier Site!!Supplier_Site__c + Create_PO() + Cancel_Requisition() Requisition_Line_Item__c->Requisition__c Sourcing_Request_Line__c Sourcing Request Line +!!Sourcing Request Line Number!!Name -!!Budget!!Budget__c -!!Charge Number!!Charge_Number__c -!!Condition!!Condition_Code__c #!!Deliver to Address!!Deliver_to_Address__c -!!Deliver to Warehouse!!Deliver_to_Warehouse__c -!!DPAS Rating!!DPAS_Rating__c -!!Drop Ship City!!Drop_Ship_City__c -!!Drop Ship Country!!Drop_Ship_Country__c -!!Drop Ship Line 1-2!!Drop_Ship_Line1__c -!!Drop Ship Name!!Drop_Ship_Name__c -!!Drop Ship State / Province!!Drop_Ship_State_Province__c -!!Drop Ship Zip / Postal Code!!Drop_Ship_Zip_Postal_Code__c -!!Drop Ship?!!Drop_Ship__c -!!Government Contract Number!!Government_Contract_Number__c #!!Item Description!!Item_Description__c -!!Item Description - New!!Item_Description_New__c -!!Item Exists in Item Master!!Item_Exists_in_Item_Master__c -!!Item Master!!Item_Master__c -!!Item Number - New!!Item_Number_New__c -!!Line Number!!Line_Number__c #!!Line Type!!Line_Type__c -!!Quantity Required!!Quantity_Required__c -!!Requested Delivery Date!!Requested_Date__c -!!Requisition Line Item!!Requisition_Line_Item__c -!!Sourcing!!Sourcing__c #!!Sourcing Item!!Sourcing_Item__c #!!Sourcing Item Description!!Sourcing_Item_Description__c + Part_Statistics() Requisition_Line_Item__c->Sourcing_Request_Line__c Production_Order_Line__c Production Order Line +!!Production Order Line Name!!Name -!!Condition Code!!Condition_Code__c -!!Item Master!!Item_Master__c -!!Line Cost!!Line_Cost__c -!!Production Order!!Production_Order__c -!!Purchase Order Line Item!!Purchase_Order_Line_Item__c -!!Quantity!!Quantity__c -!!Quantity Allocated!!Quantity_Allocated__c -!!Quantity Backordered!!Quantity_Backordered__c -!!Status!!Status__c + Reverse_Allocate() Requisition_Line_Item__c->Production_Order_Line__c Supplier_Catalogue_Item__c Supplier Catalogue Item +!!Catalogue Reference Number!!Name -!!Active!!Active__c -!!Currency!!Currency__c -!!Delivery ARO!!Delivery_ARO__c -!!Is Preferred Catalogue Item!!Is_Preferred_Catalogue_Item__c #!!Item Description!!Item_Description__c -!!Item Master!!Item_Master__c -!!Item Type!!Item_Type__c -!!List Price!!List_Price__c -!!Manufacturer!!Manufacturer__c -!!Model Applicability!!Model_Applicability__c -!!New Item Description!!New_Item_Description__c -!!New Item Number!!New_Item_Number__c -!!Product Group!!Product_Group__c #!!Supplier!!Supplier__c -!!Supplier Catalogue!!Supplier_Catalogue__c #!!Supplier Unit of Measure!!Supplier_Unit_of_Measure__c Requisition_Line_Item__c->Supplier_Catalogue_Item__c Requisition__c->Ownership_Code__c Requisition__c->Supplier_Site__c Sourcing__c Sourcing Request +!!Sourcing Request Number!!Name -!!Budget!!Budget__c -!!Buyer!!Buyer_User__c -!!Considered Taxable?!!Considered_Taxable__c -!!Currency Master!!Currency_Master__c -!!Deliver to Warehouse!!Deliver_to_Warehouse__c -!!DEPRECATED: ILSMart.com RFQ!!ILSMart_com_RFQ__c -!!Drop Ship City!!Drop_Ship_City__c -!!Drop Ship Country!!Drop_Ship_Country__c -!!Drop Ship Line 1-2!!Drop_Ship_Line1__c -!!Drop Ship Name!!Drop_Ship_Name__c -!!Drop Ship State / Province!!Drop_Ship_State_Province__c -!!Drop Ship Zip / Postal Code!!Drop_Ship_Zip_Postal_Code__c -!!Drop Ship?!!Drop_Ship__c -!!Expired Quotes!!Expired_Quotes__c -!!FOB!!FOB__c -!!Freight Terms!!Freight_Terms__c -!!Open Quotes!!Open_Quotes__c -!!Payment Terms!!Payment_Terms__c -!!Purchase History!!Purchase_History__c -!!Quote Valid Until Date!!Quote_Vaild_Until_Date__c -!!Request Type!!Request_Type__c -!!Response Due By!!ResponseDueBy__c -!!Ship Via Method!!Ship_Via_Method__c -!!Solicitation Type!!Solicitation_Type__c -!!Status!!Status__c -!!Supplier Agreements!!Supplier_Agreements__c -!!Supplier Five!!Supplier_Five__c -!!Supplier Four!!Supplier_Four__c -!!Supplier Name!!Supplier_Name__c + Get_Sourcing() + Create_PO() + Deliver_All() Sourcing_Request_Line__c->Sourcing__c Sourcing_Response__c Sourcing Response +!!Response!!Name -!!Comments Exist?!!Comments_Exist__c -!!Condition!!Condition_Code__c -!!Customer Quotation Line!!Customer_Quotation_Line__c -!!Delivery Days ARO!!Delivery_Days_ARO__c -!!DEPRECATED: ILS ItemSupplierPartId!!ILS_ItemSupplierPartId__c -!!DEPRECATED: ILS RFQId!!ILS_RFQId__c -!!External Condition Code!!External_Condition_Code__c -!!First Price Break Amount!!First_Price_Break_Amount__c -!!FOB!!FOB__c -!!Freight Terms!!Freight_Terms__c -!!Item Alternatives!!Item_Alternatives__c -!!Item Bid!!Item_Bid__c -!!Item Bid Description!!Item_Bid_Description__c -!!Lead Time!!Lead_Time__c -!!Line Comments!!Line_Comments__c -!!Minimum Order Quantity!!Minimum_Order_Quantity__c -!!Minimum Order Value!!Minimum_Order_Value__c -!!Price!!Price__c -!!Price Break Level One!!Price_Break_Level_One__c -!!Price Break Level Three!!Price_Break_Level_Three__c -!!Price Break Level Two!!Price_Break_Level_Two__c -!!Quantity!!Quantity__c -!!Quote Date!!Quote_Date__c -!!Request for Quotation!!Request_for_Quotation__c -!!Requested Condition!!Requested_Condition__c -!!Requested Item!!Requested_Item__c -!!Requested Item Description!!Requested_Item_Description__c -!!Requested Quantity!!Requested_Quantity__c #!!Response Due Date!!Response_Due_Date__c -!!Second Price Break Amount!!Second_Price_Break_Amount__c -!!Ship Via Method!!Ship_Via_Method__c -!!Sourcing Request Line!!Sourcing_Request_Line__c -!!Sourcing to Supplier Association!!Sourcing_to_Supplier_Association__c -!!Status!!Status__c -!!Supplier Comments!!Supplier_Comments__c -!!Supplier Contact!!Supplier_Contact__c -!!Supplier Site!!Supplier_Site__c -!!Tag Information!!Tag_Information__c -!!Terms!!Terms__c -!!Third Price Break Amount!!Third_Price_Break_Amount__c #!!Total Price!!Total_Price__c -!!Traceability!!Traceability__c -!!Unit of Measure!!Unit_of_Measure__c -!!Valid Until!!Valid_Until__c Sourcing_Response__c->Sourcing_Request_Line__c Sourcing_Response__c->Sourcing__c Supplier_Contact__c Supplier Contact +!!Supplier Contact Last Name!!Name -!!Active!!Active__c -!!Assistant!!Assistant__c -!!Asst. Phone!!Asst_Phone__c -!!Birth Date!!Birth_Date__c -!!Building Information!!Building_Information__c -!!Department!!Department__c -!!Description!!Description__c -!!E-Mail!!E_Mail__c -!!FAX!!FAX__c -!!First Name!!First_Name__c -!!Home Phone!!Home_Phone__c -!!Language!!Language__c -!!Mailing City!!Mailing_City__c -!!Mailing Country!!Mailing_Country__c -!!Mailing State / Province!!Mailing_State_Province__c -!!Mailing Street!!Mailing_Street__c -!!Mailing Street Additional Information!!Mailing_Street_Additional_Information__c -!!Mailing Zip / Postal Code!!Mailing_Zip_Postal_Code__c -!!Mobile Phone!!Mobile_Phone__c -!!Office Phone!!Office_Phone__c -!!Office Phone Extension!!Office_Phone_Extension__c -!!Other Phone!!Other_Phone__c -!!Preferred Communication - Purchase Order!!Preferred_Communication_Purchase_Order__c -!!Preferred Communication - Sourcing!!Preferred_Communication_Sourcing__c -!!Prefix!!Prefix__c -!!Previous Companies!!Previous_Companies__c -!!Reports To!!Reports_To__c -!!Suffix!!Suffix__c -!!Supplier Site!!Supplier_Site__c -!!Title!!Title__c Sourcing_Response__c->Supplier_Contact__c Sourcing_Response__c->Supplier_Site__c PO_Payment_Terms__c PO Payment Terms +!!PO Payment Terms Name!!Name -!!Basis for Due!!Basis_for_Due__c -!!Date Due!!Date_Due__c -!!Description!!Description__c -!!Discount Days!!Discount_Days__c -!!Discount Determined by!!Discount_Determined_by__c -!!Discount Number!!Discount_Number__c -!!Discount Percentage!!Discount_Percentage__c -!!Number of Days!!Number_of_Days__c -!!Terms Description!!Terms_Description__c -!!Terms Name!!Terms_Name__c PO_to_Attachment_Association__c PO to Attachment Association Number +!!PO to Attachment Association Number!!Name -!!Buyer Attachment Set!!Buyer_Attachment_Set__c -!!PO Attachment!!PO_Attachment__c PO_to_Attachment_Association__c->Buyer_Attachment_Set__c PO_to_Attachment_Association__c->PO_Attachment__c Production_Order_Line__c->Production_Order__c Production_Order_Line__c->Purchase_Order_Line_Item__c Production_Order__c->Ownership_Code__c Purchase_Order_Line_Item__c->Requisition_Line_Item__c Purchase_Order_Line_Item__c->Purchase_Order__c Purchase_Contract_Line__c Purchase Agreement Line +!!Purchase Agreement Line Number!!Name -!!Amount Matched!!Amount_Matched__c -!!Amount on Order!!Amount_On_Order__c -!!Amount Received!!Amount_Received__c -!!Buyer!!Buyer__c -!!Category!!Product_Group__c -!!Condition!!Condition_Code__c #!!Days until Expiration!!Days_Until_Expiration__c -!!Description!!Description__c -!!End Date!!End_Date__c -!!Item Being Procured!!Item_Master__c #!!Line Type!!Line_Type__c -!!Maximum Amount to Order!!Maximum_Amount_To_Order__c -!!Maximum Quantity to Order!!Maximum_Quantity_To_Order__c -!!Original Agreement Line!!Original_Contract_Line__c #!!Percentage of Amount Matched!!Percentage_Of_Amount_Matched__c #!!Percentage of Quantity Matched!!Percentage_Of_Quantity_Matched__c -!!Previous Agreement Line!!Previous_Contract_Line__c -!!Purchase Agreement!!Purchase_Contract__c -!!Quantity!!Quantity__c -!!Quantity Matched!!Quantity_Matched__c -!!Quantity on Order!!Quantity_On_Order__c -!!Quantity Received!!Quantity_Received__c #!!Remaining Amount to Order!!Remaining_Amount_to_Order__c #!!Remaining Quantity to Order!!Remaining_Quantity_to_Order__c -!!Requisition Line!!Requisition_Line__c -!!Ship to Warehouse!!Ship_To_Warehouse__c -!!Start Date!!Start_Date__c -!!Status!!Status__c -!!Supplier Contact!!Supplier_Contact__c -!!Unit Cost!!Unit_Cost__c Purchase_Order_Line_Item__c->Purchase_Contract_Line__c Purchase_Order__c->Award_Code__c Purchase_Order__c->Ownership_Code__c Purchase_Order__c->PO_Payment_Terms__c Purchase_Order__c->Supplier_Contact__c Purchase_Order__c->Supplier_Site__c Purchase_Contract__c Purchase Agreement +!!Purchase Agreement Number!!Name -!!Amount Matched!!Amount_Matched__c -!!Amount on Order!!Amount_On_Order__c -!!Amount Received!!Amount_Received__c -!!Buyer!!Buyer__c -!!Currency!!Currency_Master__c #!!Days until Expiration!!Days_Until_Expiration__c -!!Effective Date of Cancellation!!Effective_Cancel_Date__c -!!End Date!!End_Date__c -!!End of Agreement Notes!!End_of_Contract_Notes__c -!!Maximum Amount to Order!!Maximum_Amount_To_Order__c -!!Maximum Quantity to Order!!Maximum_Quantity_To_Order__c -!!Original Purchase Agreement!!Original_Purchase_Contract__c #!!Percentage of Amount Matched!!Percentage_Of_Amount_Matched__c #!!Percentage of Quantity Matched!!Percentage_Of_Quantity_Matched__c -!!Previous Agreement!!Previous_Contract__c -!!Quantity Matched!!Quantity_Matched__c -!!Quantity on Order!!Quantity_On_Order__c -!!Quantity Received!!Quantity_Received__c -!!Reason for Agreement Cancellation!!Reason_for_Cancelling_Contract__c #!!Remaining Amount to Order!!Remaining_Amount_on_Order__c #!!Remaining Quantity to Order!!Remaining_Quantity_On_Order__c -!!Renewal Reminder!!Renewal_Reminder__c -!!Ship to Warehouse!!Ship_To_Warehouse__c -!!Start Date!!Start_Date__c -!!Status!!Status__c -!!Supplier Contact!!Supplier_Contact__c -!!Supplier Site!!Supplier_Site__c + Activate_Purchase_Contract() + Cancel_Purchase_Contract() Purchase_Order__c->Purchase_Contract__c Supplier_Action__c Supplier Action +!!Supplier Action Name!!Name -!!Action Description!!Action_Description__c -!!Action Type!!Action_Type__c -!!Arbitration!!Arbitration__c -!!Bankruptcy!!Bankruptcy__c -!!Claims!!Claims__c -!!Date Resolved!!Date_Resolved__c -!!Judgments!!Judgments__c -!!Lawsuits!!Lawsuits__c -!!Liens!!Liens__c -!!Supplier Site!!Supplier_Site__c -!!Termination for Cause!!Termination_for_Cause__c Supplier_Action__c->Supplier_Site__c Supplier_Catalogue__c Supplier Catalogue +!!Catalogue Number!!Name -!!Available for Use!!Available_for_Use__c -!!Buyer!!Buyer_User__c -!!Buyer Notes!!Buyer_Notes__c -!!Catalogue Name!!Catalogue_Name__c -!!Currency!!Currency__c -!!End Date!!End_Date__c -!!Order Quantity Limit!!Order_Quantity_Limit__c -!!Order Spend Limit!!Order_Spend_Limit__c -!!Start Date!!Start_Date__c -!!Supplier Catalogue Type!!Supplier_Catalogue_Type__c -!!Supplier Site!!Supplier_Site__c Supplier_Catalogue_Item__c->Supplier_Catalogue__c Supplier_Catalogue_Price_Break__c Supplier Catalogue Price Break +!!Price Break Number!!Name -!!Condition!!Condition_Code__c #!!Condition Description!!Condition_Code_Description__c -!!Currency!!Currency__c -!!Price!!Price__c -!!RC Fee!!RC_Fee__c -!!Supplier Catalogue Item!!Supplier_Catalogue_Item__c -!!Valid Until Date!!Valid_Until_Date__c -!!Valid Until Quantity!!Valid_Until_Quantity__c Supplier_Catalogue_Price_Break__c->Supplier_Catalogue_Item__c Supplier_Catalogue__c->Supplier_Site__c Supplier_Certifications__c Supplier Certification +!!Supplier Certifications Name!!Name -!!Certification Type!!Certification_Type__c -!!Certified Since!!Certified_Since__c -!!CPR Certification!!CPR_Certification__c -!!First Aid Certification!!First_Aid_Certification__c -!!Last Certification Date!!Last_Certification_Date__c -!!OSHA-10/30!!OSHA_10_30__c -!!Rescue Certification!!Rescue_Certification__c -!!RF Certification!!RF_Certification__c -!!Supplier Site!!Supplier_Site__c Supplier_Certifications__c->Supplier_Site__c Supplier_Contact__c->Supplier_Site__c Supplier_Crew__c Supplier Crew +!!Supplier Crew Name!!Name -!!Supplier Site!!Supplier_Site__c Supplier_Crew__c->Supplier_Site__c Supplier_Reference__c Supplier Reference +!!Supplier Reference Name!!Name -!!Address!!Address__c -!!Average Balance!!Average_Balance__c -!!City, State, Zip!!City_State_Zip__c -!!Contact!!Contact__c -!!Credit Line Amount!!Credit_Line_Amount__c -!!Email!!Email__c -!!Institution!!Institution__c -!!Product Line!!Product_Line__c -!!Supplier Site!!Supplier_Site__c -!!Telephone!!Telephone__c Supplier_Reference__c->Supplier_Site__c Supplier_Safety__c Supplier Safety +!!Supplier Safety Name!!Name -!!Description!!Description__c -!!EMR Rating!!EMR_Rating__c -!!OSHA Incident Rating!!OSHA_Incident_Rating__c -!!Safety Logging!!Safety_Logging__c -!!Supplier Site!!Supplier_Site__c -!!Year!!Year__c Supplier_Safety__c->Supplier_Site__c Supplier_Service__c->Supplier_Site__c Supplier_Site__c->PO_Payment_Terms__c Supplier_Special_Status__c Supplier Special Status +!!Special Status Name!!Name -!!Certification Date!!Certification_Date__c -!!Certification Number!!Certification_Number__c -!!Special Status Type!!Special_Status_Type__c -!!Supplier Site!!Supplier_Site__c Supplier_Special_Status__c->Supplier_Site__c Tax_Split__c Tax Split +!!Tax Split Name!!Name -!!Description!!Description__c -!!Tax Code!!Tax_Code__c -!!Tax Rate!!Tax_Rate__c Tax_Split__c->Tax_Code__c Purchase_Contract__c->Supplier_Contact__c Purchase_Contract__c->Supplier_Site__c Purchase_Contract_Line__c->Requisition_Line_Item__c Purchase_Contract_Line__c->Supplier_Contact__c Purchase_Contract_Line__c->Purchase_Contract__c
© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.