WS_ARInquiry
Accounting Web Service
The following operations are supported. For a formal definition, please review the Service Description.
-
ApprovePendingAdjustments
Approve a list of pending adjustments Company Code [2 characters] Array of adjustment ids Approval NoteReturn Message ['TRUE - xxx' means the successful transaction , 'FALSE - xxx' means the failed transaction followed by reason] -
GetAccountAging
Get Customer Account Aging Buckets and their respective dollar amounts Company Code [2 characters] User ID [10 characters unpadded] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded, Use '0' if Customer is Consolidated]Returns the Aging Buckets and their respective dollar amounts as defined in the Company Settings. to30 Dollar amount outstanding between 0 to 30 days (or as defined) to60 Dollar amount outstanding between 31 to 60 days (or as defined) to90 Dollar amount outstanding between 61 to 90 days (or as defined) to120 Dollar amount outstanding between 91 to 120 days (or as defined) over120 Dollar amount outstanding over 120 days (or as defined) totals Total outstanding balance for the Customer Account
Field Name Description -
GetAccountBalance
Get total outstanding balance for a Customer Account Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded, Use '0' if Customer is Consolidated]Returns total outstanding balance -
GetAgingBuckets
Get Company Aging Categories as defined in Company Settings. Company Code [2 characters]Returns the Aging Categories as defined in the Company Settings and returns one row and ending value for each category. UserCode User ID [Max 10 characters] Parameter Internal TRUX Reference Value Ending value of Days Range CompCode Company Code [2 characters]
Field Name Description -
GetInvoiceDetails
Get Invoice details for provided invoice number. Company Code [2 characters] Invoice Number [10 digits]Returns Invoice details for provided invoice number. Info Info TransDate Transaction Date TransType Transaction Type Description Transaction Description Reference Transaction Reference Quantity Quantity Amount Amount
Field Name Description -
GetInvoiceList
Get listing of Invoice header information for a Customer Account. Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded, Use '0' if Customer is Consolidated]Returns listing of Invoice header information with the following fields. DM01_ID TRUX Internal Reference DM01_CUST Customer Number [Max 10 characters] DM01_SITE Site Number [Max 4 characters] DM01_INVC Invoice Number [Max 10 digits or 'OA'] DM01_DATE Invoice Date DM01_TRANTYPE TRUX Internal Reference DM01_AMNT Invoice Balance INVAMNT Invoice Total PAYMTS Payment Amount ADJMTS Adjustment Amount SORT TRUX Internal Reference DM01_SSIT TRUX Internal Reference DM01_CONTRACT Weigh-IT Contract ID DM01_PBLE Return 'X' for Payable Invoices (For Account Type equals 'Pay Rebate' and 'Net') INVADJ PENDADJ MEMO DM01_ORIGINVID ORIG_AMNT INFO Invoice Message (same as message printed on Customer Invoice)
Field Name Description -
GetInvoicePayments
Get invoice payments for the list of invoice ID's provided. Company Code [2 characters] Invoice IDsReturns listing of Invoice payments with the following fields. DM01_ID Invoice ID DM01_INVC Invoice Number DM01P_DATE Payment\Adjustment Date [smalldatetime] DM01P_TYPE Payment\Adjustment Type, A = Adjustment, P = Payment [char(1)] DM01P_AMNT Payment\Adjustment Amount [decimal(18,2)] DM01P_REFN Reference [nvarchar(50)] CD02_DESC Code Description [nvarchar(40)]
Field Name Description -
GetInvoicePeriod
Get's the invoice period number Company Code [2 characters] User ID [10 characters unpadded]Returns the invoice period -
GetLastPayment
Get Last Payment Date for a Customer Account Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded, Use '0' if Customer is Consolidated]Returns Last Payment Date -
GetOutstandingNonCreditInvoiceBalance
Get Total Outstanding Account Balance for a Customer Account. Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded, Use '0' if Customer is Consolidated]Returns Outstanding Account Balance -
GetPendingAdjustments
Get the pending adjustments for the given invoice Company Code [2 characters] Invoice Number [10 characters]Returns the list of pending adjustments AdjustmentId Adjustment ID Invoice# Invoice Number Inv.Date Invoice Date Info Customer Information Posting Date Posted Date Type Adjustment Type Description Adjustment Description Qty. Original Quantity Amount Original Amount Adjustment Adjustment Amount Adj. Reason Adjustment Reason Adj. Qty. Adjustment Quantity Adj. Note Adjustment Note BALANCE Balance Printed Printed Flag User User who created the adjustment G/L Account GL Account
Field Name Description -
HelloWorld
Hello World Test Method input string parameterReturns the input parameter with 'Hello World' attached on it.