Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IC10200
Product: Manufacturing (346)
Series:
Display Name: Manufacturing Series Purchase Receipts Group Display Name: Manufacturing Inventory
Physical Name: IC10200
Technical Name: IC_IV_Purchase_Receipts
Group Technical Name: Manufacturing Inventory
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Manufacturing Series Purchase Receipts'].ITEMNMBR AS 'Manufacturing Series Purchase Receipts-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IC10200 AS ['Manufacturing Series Purchase Receipts']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Manufacturing Series Purchase Receipts'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
2 | TRXLOCTN | TRX Location | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Manufacturing Series Purchase Receipts'].TRXLOCTN AS 'Manufacturing Series Purchase Receipts-TRX Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IC10200 AS ['Manufacturing Series Purchase Receipts']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Manufacturing Series Purchase Receipts'].TRXLOCTN = ['Site Setup'].LOCNCODE | ||||||
3 | QTYTYPE | QTY Type | Integer | DDL_QTY_Type | 0 | |
4 | DATERECD | Date Received | Date | DATE | 6 | |
5 | RCTSEQNM | Receipt SEQ Number | Long Integer | long | 8 | |
6 | LABCOSTI_1 | Lab Cost[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
7 | LABCOSTI | Lab Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
8 | LABCOSTI_2 | Lab Cost[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
9 | LABFIXOHDCOSTI | Lab Fix Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
10 | LABCOSTI_3 | Lab Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
11 | LABVAROHDCOSTI | Lab Var Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
12 | MACHCOSTI | Mach Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
13 | LABCOSTI_4 | Lab Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
14 | LABCOSTI_5 | Lab Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
15 | MACHFIXOHDCOSTI | Mach Fix Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
16 | LABCOSTI_6 | Lab Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
17 | MACHVAROHDCOSTI | Mach Var Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
18 | LABCOSTI_7 | Lab Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
19 | MATCOSTI | Mat Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
20 | MATFIXOHDCOSTI | Mat Fix Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
21 | LABCOSTI_8 | Lab Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
22 | LABFIXOHDCOSTI_1 | Lab Fix Ohd Cost[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
23 | MATVAROHDCOSTI | Mat Var Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
24 | LABFIXOHDCOSTI_2 | Lab Fix Ohd Cost[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
25 | LABFIXOHDCOSTI_3 | Lab Fix Ohd Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
26 | LABFIXOHDCOSTI_4 | Lab Fix Ohd Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
27 | LABFIXOHDCOSTI_5 | Lab Fix Ohd Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
28 | LABFIXOHDCOSTI_6 | Lab Fix Ohd Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
29 | LABFIXOHDCOSTI_7 | Lab Fix Ohd Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
30 | LABFIXOHDCOSTI_8 | Lab Fix Ohd Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
31 | LABVAROHDCOSTI_1 | Lab Var Ohd Cost[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
32 | LABVAROHDCOSTI_2 | Lab Var Ohd Cost[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
33 | LABVAROHDCOSTI_3 | Lab Var Ohd Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
34 | LABVAROHDCOSTI_4 | Lab Var Ohd Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
35 | LABVAROHDCOSTI_5 | Lab Var Ohd Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
36 | LABVAROHDCOSTI_6 | Lab Var Ohd Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
37 | LABVAROHDCOSTI_7 | Lab Var Ohd Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
38 | LABVAROHDCOSTI_8 | Lab Var Ohd Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
39 | MACHCOSTI_1 | Mach Cost[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
40 | MACHCOSTI_2 | Mach Cost[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
41 | MACHCOSTI_3 | Mach Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
42 | MACHCOSTI_4 | Mach Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
43 | MACHCOSTI_5 | Mach Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
44 | MACHCOSTI_6 | Mach Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
45 | MACHCOSTI_7 | Mach Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
46 | MACHCOSTI_8 | Mach Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
47 | MACHFIXOHDCOSTI_1 | Mach Fix Ohd Cost[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
48 | MACHFIXOHDCOSTI_2 | Mach Fix Ohd Cost[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
49 | MACHFIXOHDCOSTI_3 | Mach Fix Ohd Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
50 | MACHFIXOHDCOSTI_4 | Mach Fix Ohd Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
51 | MACHFIXOHDCOSTI_5 | Mach Fix Ohd Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
52 | MACHFIXOHDCOSTI_6 | Mach Fix Ohd Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
53 | MACHFIXOHDCOSTI_7 | Mach Fix Ohd Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
54 | MACHFIXOHDCOSTI_8 | Mach Fix Ohd Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
55 | MACHVAROHDCOSTI_1 | Mach Var Ohd Cost[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
56 | MACHVAROHDCOSTI_2 | Mach Var Ohd Cost[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
57 | MACHVAROHDCOSTI_3 | Mach Var Ohd Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
58 | MACHVAROHDCOSTI_4 | Mach Var Ohd Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
59 | MACHVAROHDCOSTI_5 | Mach Var Ohd Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
60 | MACHVAROHDCOSTI_6 | Mach Var Ohd Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
61 | MACHVAROHDCOSTI_7 | Mach Var Ohd Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
62 | MACHVAROHDCOSTI_8 | Mach Var Ohd Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
63 | MATCOSTI_1 | Mat Cost[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
64 | MATCOSTI_2 | Mat Cost[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
65 | MATCOSTI_3 | Mat Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
66 | MATCOSTI_4 | Mat Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
67 | MATCOSTI_5 | Mat Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
68 | MATCOSTI_6 | Mat Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
69 | MATCOSTI_7 | Mat Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
70 | MATCOSTI_8 | Mat Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
71 | MATFIXOHDCOSTI_1 | Mat Fix Ohd Cost[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
72 | MATFIXOHDCOSTI_2 | Mat Fix Ohd Cost[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
73 | MATFIXOHDCOSTI_3 | Mat Fix Ohd Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
74 | MATFIXOHDCOSTI_4 | Mat Fix Ohd Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
75 | MATFIXOHDCOSTI_5 | Mat Fix Ohd Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
76 | MATFIXOHDCOSTI_6 | Mat Fix Ohd Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
77 | MATFIXOHDCOSTI_7 | Mat Fix Ohd Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
78 | MATFIXOHDCOSTI_8 | Mat Fix Ohd Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
79 | MATVAROHDCOSTI_1 | Mat Var Ohd Cost[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
80 | MATVAROHDCOSTI_2 | Mat Var Ohd Cost[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
81 | MATVAROHDCOSTI_3 | Mat Var Ohd Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
82 | MATVAROHDCOSTI_4 | Mat Var Ohd Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
83 | MATVAROHDCOSTI_5 | Mat Var Ohd Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
84 | MATVAROHDCOSTI_6 | Mat Var Ohd Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
85 | MATVAROHDCOSTI_7 | Mat Var Ohd Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
86 | MATVAROHDCOSTI_8 | Mat Var Ohd Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 |