Skip to main content
Skip table of contents

wsiWSCreateUpdatePurchaseOrderIntegration

Tables: WS10101, SV00300, JC00102, JC00701, PM00200, IV00101, POP10100, POP10110

Description: Integrate Purchase Order Processing to Signature Job Cost or Service Management

Element NameData TypeLengthRequiredDefaultDescription

@I_vCost_Code_Number_1

char

7




@I_vCost_Code_Number_2

char

7




@I_vCost_Code_Number_3

char

7




@I_vCost_Code_Number_4

char

7




@I_vCost_Element

smallint

 




@I_vCOSTTYPE

smallint

 




@I_vEquipment_ID

char

31




@I_vJOBNUMBR

char

17




@I_vOnlyValidate

tinyint

 




@I_vORD

int

 




@I_vPONUMBER

char

17




@I_vProduct_Indicator

smallint

 




@I_vQTYRTRND

numeric

19,5




@I_vRetention_Amount_TTD

numeric

19,5




@I_vRetention_Pct

numeric

19,5




@I_vRetTotalCost

numeric

19,5




@I_vRetUnitCost

numeric

19,5




@I_vReturnErrorText

tinyint

 




@I_vTask_Code

char

11




@I_vTXTFIELD

varchar

8000




@I_vUpdateIfExists

tinyint

 




@I_vUSRDEFND1

char

50




@I_vUSRDEFND2

char

50




@I_vUSRDEFND3

char

50




@I_vUSRDEFND4

varchar

8000




@I_vUSRDEFND5

varchar

8000




@I_vWennSoftTablesOnly

tinyint

 




@I_vWSPOText

char

15




@O_iErrorState

int

 




@oErrString

varchar

305




Error Codes

Error CodeDescription

51013

 

51016

Service Call does not exist

51018

Cost code does not exist for the job

51052

Unable to insert into Signature PO Integration table.

51054

Retention percent cannot be greater than 100%.

51094

Job is inactive.

51095

Not Unbilled, Service or Job Cost.

51096

Cost code type cannot be labor

51097

The Account for this Cost Code is Inactive and cannot be using on Purchasing Transactions.

51098

Purchase Order does not exist in MBS

51099

Purchase Order Line does not exist in MBS

51104

Service Call has been posted

51430

Error updating table: WS10101.*/

52015

Option to update existing record is set to false.

52017

Job does not exist.

591

Line status is Closed, Canceled, or Received

591

PO Line Status must of type New, Released, Change Order or Cancelled

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.