Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WC010931
Product: Manufacturing (346)
Series:
Display Name: Work Center Header File Group Display Name: Manufacturing Work Centers
Physical Name: WC010931
Technical Name: WC_HDR
Group Technical Name: Manufacturing WC
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | WCID_I | WC ID | String | STR10_Location_Code | 10 | |
2 | WCDESC_I | WC Desc | String | STR30 | 30 | |
3 | CMPNYNAM | Company Name | String | STR64_Company_Name | 64 | |
4 | DEPRTMNT | Department | String | STR6_Payroll_Code | 6 | |
5 | OUTSOURCED_I | Outsourced | Integer | DDL_YesNo | 0 | |
6 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['Work Center Header File'].VENDORID AS 'Work Center Header File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
WC010931 AS ['Work Center Header File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Work Center Header File'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
7 | SERVITEMNUM | Service Item Number | String | STR30_LBAU | 30 | |
8 | POOFFSETDAYS | POOffsetDays | Integer | INT3_U0 | 3 |