Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ICJC2006
Product: Manufacturing (346)
Series:
Display Name: ICJC_Applied_Purchases_Work Group Display Name: Manufacturing Job Costing
Physical Name: ICJC2006
Technical Name: ICJC_Applied_Purchases_Work
Group Technical Name: Manufacturing Job Costing
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | CITEMNUMBERI  | Citem Number | Integer | INT5_NoFormat | 5 | |
| 2 | JOBNUMBER_I | Job Num | String | STR30 | 30 | |
| 3 | SEQ_I | Seq | Long Integer | LINT_10 | 10 | |
| 4 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
| 5 | Split | Split | Long Integer | LONG_INT | 10 | |
| 6 | RECEIVINGNUMBER_I | Receiving Number | String | STR20_Document_Number | 20 | |
| 7 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['ICJC_Applied_Purchases_Work'].VENDORID AS 'ICJC_Applied_Purchases_Work-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ICJC2006 AS ['ICJC_Applied_Purchases_Work']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ICJC_Applied_Purchases_Work'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 8 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 | |
| 9 | DOCDATE | Document Date | Date | DT | 8 | |
| 10 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 11 | RECTRANSNUMBER_I | Receiving Transaction Number | Integer | INT4 | 4 | |
| 12 | AMT_I | AMT | Currency | DLR19_$S2 | 19 | |
| 13 | VENDNAME | Vendor Name | String | STR64_Vendor_Name | 64 | |