Get Project Log Jobs
Use this service to import Project Log Jobs information.
Method: GetPJJob
Assumptions and Dependencies
The Authorization ID controls the security and defaults the pCompany_Code field if left blank in the parameter fields.
All parameter fields have SuperSelect logic except the pSort_By
Parameter Fields
Use the table below for reference when using this service.Element Name | Description | Req | Type | Max | Field Information |
---|---|---|---|---|---|
Authorization_ID | Authorization ID to access the server | YES | Text | 20 | Data Exchange Installation Screen. |
GUID | Unique reference number created by programming | Text | 36 | ** See GUID definition | |
pCompany_Code | Company Code | YES | Text | 3 | Valid Company in Spectrum. Defaults from the Authorization ID if not populated. |
pJob_Number | Job Number | Text | 10 | ||
pStatus_Code | if left blank then active and inactive only | Text | 1 | (A)ctive, (I)nactive or (C )omplete | |
pCost_Center | if blank then all for company and operator or enter one only | Text | 50 | Project Log Discipline | |
pSort_By | Sort By Options | Text | 1 | Blank = Company Code or D= Log Class |
Return Fields
Use the table below for reference when using this service.Element Name | Description | Type | Max | Field Information |
---|---|---|---|---|
Company_Code | Company Code | Text | 3 | Valid Spectrum Company |
Job_Number | Job Number | Text | 10 | |
Job_Description | Job Name | Text | 25 | |
Status_Code | Status | Text | 1 | (A)ctive, (I)nactive or (C )omplete |
Category | Project Log Category | Text | 30 | |
PJ_Reference_Num | Last Project Log Reference Number per Category | Text | 10 | Display the Reference Number from the Project Log table per Category |
Cost_Center | Job Cost Center | Text | 10 | |
Error_Code | Error Code | Text | 1 | Used for Error information if needed |
Error_Description | Error Description | Text | 250 | Used for Error information if needed |
Error_Column | Error Column | Text | 100 | Used for Error information if needed |