Item Master Extensions (SVC00951)

azurecurveProductsFieldService (949)ProjectItem Master Extensions (SVC00951)

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

Product: FieldService (949)
Series:

Display Name: Item Master Extensions
Physical Name: SVC00951
Technical Name: SVC_Item_MSTR_Ext

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['Item Master Extensions'].UOMSCHDL AS 'Item Master Extensions-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       SVC00951 AS ['Item Master Extensions']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['Item Master Extensions'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Item Master Extensions'].ITEMNMBR AS 'Item Master Extensions-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC00951 AS ['Item Master Extensions']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Item Master Extensions'].ITEMNMBR = ['Item Master'].ITEMNMBR
3METERED SearchMeteredBooleanCB0
4RTRNABLE SearchReturnableBooleanCB0
5PRDLINE SearchProduct LineStringSTR2020
6WARRCDE SearchWarranty CodeStringSTR10_LBAU10
7MTBF SearchMTBFCurrencyCURR_MTTR10
8MTBI SearchMTBICurrencyCURR_MTTR10
9MTTR SearchMTTRCurrencyCURR_MTTR10
10RETCOST SearchReturn CostCurrencyDLR17_$S217
11SVC_PM_Allowed SearchSVC PM AllowedBooleanCB0
12SVC_Contractible SearchSVC ContractibleBooleanCB0
13SLRWARR SearchSeller Warranty CodeStringSTR10_LBAU10
14VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Item Master Extensions'].VENDORID AS 'Item Master Extensions-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SVC00951 AS ['Item Master Extensions']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Item Master Extensions'].VENDORID = ['PM Vendor Master File'].VENDORID
15SVC_Use_CurrentCost SearchSVC Use CurrentCostBooleanCB0
azurecurveProductsFieldService (949)ProjectItem Master Extensions (SVC00951)

Leave a Reply

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