System Configuration (SVC00401)

azurecurveProductsFieldService (949)ProjectSystem Configuration (SVC00401)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00401

Product: FieldService (949)
Series:

Display Name: System Configuration
Physical Name: SVC00401
Technical Name: SVC_Configuration_System

Group Display Name: Service Table Group
Group Technical Name: Service

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CONFGREF SearchConfig ReferenceStringSTR20_LBAU20
2CNFGLVL SearchConfig LevelIntegerINT44
3CNFGSEQ SearchConfig SequenceIntegerINT44
4EQUIPID SearchEquipment IDLong IntegerLong Int8
5QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
6ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['System Configuration'].ITEMNMBR AS 'System Configuration-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC00401 AS ['System Configuration']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['System Configuration'].ITEMNMBR = ['Item Master'].ITEMNMBR
7PARLEVEL SearchParent LevelIntegerINT44
8PARSEQ SearchParent SequenceIntegerINT44
9INSTDTE SearchInstall DateDateDT_Date6
10DSCRIPTN SearchDescriptionStringSTR3030
azurecurveProductsFieldService (949)ProjectSystem Configuration (SVC00401)

Leave a Reply

Your email address will not be published. Required fields are marked *