Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC05004
Product: FieldService (949)
Series:
Display Name: SVC_Vendor_Item_Reimbursement Group Display Name: Service Table Group
Physical Name: SVC05004
Technical Name: SVC_Vendor_Item_Reimbursement
Group Technical Name: Service
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | VENDORID  | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['SVC_Vendor_Item_Reimbursement'].VENDORID AS 'SVC_Vendor_Item_Reimbursement-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SVC05004 AS ['SVC_Vendor_Item_Reimbursement']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SVC_Vendor_Item_Reimbursement'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 2 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['SVC_Vendor_Item_Reimbursement'].ITEMNMBR AS 'SVC_Vendor_Item_Reimbursement-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SVC05004 AS ['SVC_Vendor_Item_Reimbursement']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SVC_Vendor_Item_Reimbursement'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 3 | RTV_Type | RTV Type | String | STR10_LBAU | 10 | |
| 4 | Dollar_Or_Percent_Reimbu | Dollar Or Percent Reimbursement | STR1 | String | 1 | |
| 5 | Dollar_Or_Percent_Reimbu_1 | Dollar Or Percent Reimbursement[1] | String | STR1 | 1 | |
| 6 | Dollar_Or_Percent_Reimbu_2 | Dollar Or Percent Reimbursement[2] | String | STR1 | 1 | |
| 7 | Dollar_Or_Percent_Reimbu_3 | Dollar Or Percent Reimbursement[3] | String | STR1 | 1 | |
| 8 | Dollar_Or_Percent_Reimbu_4 | Dollar Or Percent Reimbursement[4] | String | STR1 | 1 | |
| 9 | Reimbursement_Amount_1 | Reimbursement Amount[1] | Currency | DLR17_RBS0_STR | 17 | |
| 10 | Reimbursement_Amount_2 | Reimbursement Amount[2] | Currency | DLR17_RBS0_STR | 17 | |
| 11 | Reimbursement_Amount | Reimbursement Amount | DLR17_RBS0_STR | Currency | 17 | |
| 12 | Reimbursement_Amount_3 | Reimbursement Amount[3] | Currency | DLR17_RBS0_STR | 17 | |
| 13 | Reimbursement_Amount_4 | Reimbursement Amount[4] | Currency | DLR17_RBS0_STR | 17 | |
| 14 | Reimbursement_NTE_1 | Reimbursement NTE[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
| 15 | Reimbursement_NTE_2 | Reimbursement NTE[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
| 16 | Reimbursement_NTE | Reimbursement NTE | DLR17_RBS0_UTR$ | Currency | 17 | |
| 17 | Reimbursement_NTE_3 | Reimbursement NTE[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
| 18 | Reimbursement_NTE_4 | Reimbursement NTE[4] | Currency | DLR17_RBS0_UTR$ | 17 | |