Web Service that request customer Material details based on Cust/Site/Serv

The following operations are supported. For a formal definition, please review the Service Description.

• CreateFacilityMaterialPricingByTable
  
  Update Material Rate for Facility, the table will have the following fields: Field NameDescription LM05_MATLMaterial Code [Max 2 characters] LM05_COSTMaterial Cost. [decimal(18,3)] LM05_CUOMMaterial Cost UOM. [Max 2 characters] LM05_BILLMaterial Billing Charge. [decimal(18,3)] LM05_BUOMMaterial Billing UOM. [Max 2 characters] LM05_EFFDEffective Date . [smalldatetime] LM05_DSTEFacility Code [Max 2 characters] LM05_MINQTY/term>Minimum Quantity [decimal(1823)] LM05_ACTIVEActive [bit] LM05_PRICETYPEMaterial Price Type [Max 1 characters] LM05_FMLAMaterial Price Formula [Max 80 characters] rateChangeReason2 digit code from CD12 Used in Logging Tables [2 characters] Returns Facility Material rate ID for the created rate
  Returns Facility
• CreateMaterialPricingByTable
  
  Update Material Rate for Service, the table will have the following fields: Field NameDescription CM09_CUSTCustomer Number. [int max 10 digit] CM09_SITESite Number. [int max 4 digit] CM09_SERVService Number. [int max 3 digit] CM09_MATLMaterial Code [Max 2 characters] CM09_RATEMaterial Rate. [decimal(18,2)] CM09_UOMMaterial Rate UOM. [Max 2 characters] CM09_INOTEInvoice Description. [Max 40 characters] CM09_EFFDEffective Date. [smalldatetime] CM09_DSTEDisposal Site CM09_TYPEMaterial Rate Type [Max 1 characters] CM09_CAPMaterial Rate Cap [decimal(18,2)] CM09_PRICETYPEMaterial Price Type [Max 1 characters] CM09_FMLAMaterial Price Formula [Max 80 characters] rateChangeReason2 digit code from CD12 Used in Logging Tables [2 characters] Returns Material rate ID for the created rate
• GetMaterials
  
  Get listing of Materials for specified Customer Account, using Authentication Key.
  Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded] Include History ['0' = Do Not Include History, '1' = Include History] Returns listing of Materials for specified Customer Account Field NameDescription MATERIALMaterial RATE TYPERate Type RATERate UNITRate Unit FACILITYFacility Name MIN/MAXWeight Cap Type CONSTRAINTConstraint EFFECTIVE DATEEffective Date MATERIAL CODEMaterial Code
• GetMaterialsForComp
  
  Get listing of Materials for specified Customer Account.
  Company Code [2 characters] User ID [10 characters unpadded] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded] Include History ['0' = Do Not Include History, '1' = Include History] Returns isting of Materials for specified Customer Account Field NameDescription MATERIALMaterial RATE TYPERate Type RATERate UNITRate Unit FACILITYFacility Name MIN/MAXWeight Cap Type CONSTRAINTConstraint EFFECTIVE DATEEffective Date MATERIAL CODEMaterial Code
• UpdateFacilityMaterialPricingByTable
  
  Update Material Rate for Facility, the table will have the following fields: Field NameDescription LM05_IDMaterial Rate ID. [int] LM05_MATLMaterial Code [Max 2 characters] LM05_COSTMaterial Cost. [decimal(18,3)] LM05_CUOMMaterial Cost UOM. [Max 2 characters] LM05_BILLMaterial Billing Charge. [decimal(18,3)] LM05_BUOMMaterial Billing UOM. [Max 2 characters] LM05_EFFDEffective Date . [smalldatetime] LM05_DSTEFacility Code [Max 2 characters] LM05_MINQTY/term>Minimum Quantity [decimal(18,2)] LM05_ACTIVEActive [bit] LM05_PRICETYPEMaterial Price Type [Max 1 characters] LM05_FMLAMaterial Price Formula [Max 80 characters] rateChangeReason2 digit code from CD12 Used in Logging Tables [2 characters]
• UpdateMaterialPricingByTable
  
  Update Material Rate for Service, the table will have the following fields: Field NameDescription CM09_CUSTCustomer Number. [int max 10 digit] CM09_SITESite Number. [int max 4 digit] CM09_SERVService Number. [int max 3 digit] CM09_IDMaterial Rate ID. [int] CM09_MATLMaterial Code [Max 2 characters] CM09_RATEMaterial Rate. [decimal(18,2)] CM09_UOMMaterial Rate UOM. [Max 2 characters] CM09_INOTEInvoice Description. [Max 40 characters] CM09_EFFDEffective Date . [smalldatetime] CM09_DSTEDisposal Site CM09_TYPEMaterial Rate Type [Max 1 characters] CM09_CAPMaterial Rate Cap [decimal(18,2)] CM09_PRICETYPEMaterial Price Type [Max 1 characters] CM09_FMLAMaterial Price Formula [Max 80 characters] rateChangeReason2 digit code from CD12 Used in Logging Tables [2 characters]