Manufacturing Series Purchase Receipts (IC10200)

azurecurveProductsManufacturing (346)3rd PartyManufacturing Series Purchase Receipts (IC10200)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: Manufacturing Series Purchase Receipts
Physical Name: IC10200
Technical Name: IC_IV_Purchase_Receipts

Group Display Name: Manufacturing Inventory
Group Technical Name: Manufacturing Inventory

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['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
2TRXLOCTN SearchTRX LocationSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['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
3QTYTYPE SearchQTY TypeDDL_QTY_TypeInteger20
4DATERECD SearchDate ReceivedDATEDate46
5RCTSEQNM SearchReceipt SEQ NumberlongLong Integer48
6LABCOSTI_1 SearchLab Cost[1]DLR17_RBS0_UTR$Currency1017
7LABCOSTI SearchLab CostDLR17_RBS0_UTR$Currency1017
8LABFIXOHDCOSTI SearchLab Fix Ohd CostDLR17_RBS0_UTR$Currency1017
9LABCOSTI_2 SearchLab Cost[2]DLR17_RBS0_UTR$Currency1017
10LABCOSTI_3 SearchLab Cost[3]DLR17_RBS0_UTR$Currency1017
11LABVAROHDCOSTI SearchLab Var Ohd CostDLR17_RBS0_UTR$Currency1017
12MACHCOSTI SearchMach CostDLR17_RBS0_UTR$Currency1017
13LABCOSTI_4 SearchLab Cost[4]DLR17_RBS0_UTR$Currency1017
14MACHFIXOHDCOSTI SearchMach Fix Ohd CostDLR17_RBS0_UTR$Currency1017
15LABCOSTI_5 SearchLab Cost[5]DLR17_RBS0_UTR$Currency1017
16MACHVAROHDCOSTI SearchMach Var Ohd CostDLR17_RBS0_UTR$Currency1017
17LABCOSTI_6 SearchLab Cost[6]DLR17_RBS0_UTR$Currency1017
18LABCOSTI_7 SearchLab Cost[7]DLR17_RBS0_UTR$Currency1017
19MATCOSTI SearchMat CostDLR17_RBS0_UTR$Currency1017
20LABCOSTI_8 SearchLab Cost[8]DLR17_RBS0_UTR$Currency1017
21MATFIXOHDCOSTI SearchMat Fix Ohd CostDLR17_RBS0_UTR$Currency1017
22MATVAROHDCOSTI SearchMat Var Ohd CostDLR17_RBS0_UTR$Currency1017
23LABFIXOHDCOSTI_1 SearchLab Fix Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
24LABFIXOHDCOSTI_2 SearchLab Fix Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
25LABFIXOHDCOSTI_3 SearchLab Fix Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
26LABFIXOHDCOSTI_4 SearchLab Fix Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
27LABFIXOHDCOSTI_5 SearchLab Fix Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
28LABFIXOHDCOSTI_6 SearchLab Fix Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
29LABFIXOHDCOSTI_7 SearchLab Fix Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
30LABFIXOHDCOSTI_8 SearchLab Fix Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
31LABVAROHDCOSTI_1 SearchLab Var Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
32LABVAROHDCOSTI_2 SearchLab Var Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
33LABVAROHDCOSTI_3 SearchLab Var Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
34LABVAROHDCOSTI_4 SearchLab Var Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
35LABVAROHDCOSTI_5 SearchLab Var Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
36LABVAROHDCOSTI_6 SearchLab Var Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
37LABVAROHDCOSTI_7 SearchLab Var Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
38LABVAROHDCOSTI_8 SearchLab Var Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
39MACHCOSTI_1 SearchMach Cost[1]DLR17_RBS0_UTR$Currency1017
40MACHCOSTI_2 SearchMach Cost[2]DLR17_RBS0_UTR$Currency1017
41MACHCOSTI_3 SearchMach Cost[3]DLR17_RBS0_UTR$Currency1017
42MACHCOSTI_4 SearchMach Cost[4]DLR17_RBS0_UTR$Currency1017
43MACHCOSTI_5 SearchMach Cost[5]DLR17_RBS0_UTR$Currency1017
44MACHCOSTI_6 SearchMach Cost[6]DLR17_RBS0_UTR$Currency1017
45MACHCOSTI_7 SearchMach Cost[7]DLR17_RBS0_UTR$Currency1017
46MACHCOSTI_8 SearchMach Cost[8]DLR17_RBS0_UTR$Currency1017
47MACHFIXOHDCOSTI_1 SearchMach Fix Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
48MACHFIXOHDCOSTI_2 SearchMach Fix Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
49MACHFIXOHDCOSTI_3 SearchMach Fix Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
50MACHFIXOHDCOSTI_4 SearchMach Fix Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
51MACHFIXOHDCOSTI_5 SearchMach Fix Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
52MACHFIXOHDCOSTI_6 SearchMach Fix Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
53MACHFIXOHDCOSTI_7 SearchMach Fix Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
54MACHFIXOHDCOSTI_8 SearchMach Fix Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
55MACHVAROHDCOSTI_1 SearchMach Var Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
56MACHVAROHDCOSTI_2 SearchMach Var Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
57MACHVAROHDCOSTI_3 SearchMach Var Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
58MACHVAROHDCOSTI_4 SearchMach Var Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
59MACHVAROHDCOSTI_5 SearchMach Var Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
60MACHVAROHDCOSTI_6 SearchMach Var Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
61MACHVAROHDCOSTI_7 SearchMach Var Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
62MACHVAROHDCOSTI_8 SearchMach Var Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
63MATCOSTI_1 SearchMat Cost[1]DLR17_RBS0_UTR$Currency1017
64MATCOSTI_2 SearchMat Cost[2]DLR17_RBS0_UTR$Currency1017
65MATCOSTI_3 SearchMat Cost[3]DLR17_RBS0_UTR$Currency1017
66MATCOSTI_4 SearchMat Cost[4]DLR17_RBS0_UTR$Currency1017
67MATCOSTI_5 SearchMat Cost[5]DLR17_RBS0_UTR$Currency1017
68MATCOSTI_6 SearchMat Cost[6]DLR17_RBS0_UTR$Currency1017
69MATCOSTI_7 SearchMat Cost[7]DLR17_RBS0_UTR$Currency1017
70MATCOSTI_8 SearchMat Cost[8]DLR17_RBS0_UTR$Currency1017
71MATFIXOHDCOSTI_1 SearchMat Fix Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
72MATFIXOHDCOSTI_2 SearchMat Fix Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
73MATFIXOHDCOSTI_3 SearchMat Fix Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
74MATFIXOHDCOSTI_4 SearchMat Fix Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
75MATFIXOHDCOSTI_5 SearchMat Fix Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
76MATFIXOHDCOSTI_6 SearchMat Fix Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
77MATFIXOHDCOSTI_7 SearchMat Fix Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
78MATFIXOHDCOSTI_8 SearchMat Fix Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
79MATVAROHDCOSTI_1 SearchMat Var Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
80MATVAROHDCOSTI_2 SearchMat Var Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
81MATVAROHDCOSTI_3 SearchMat Var Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
82MATVAROHDCOSTI_4 SearchMat Var Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
83MATVAROHDCOSTI_5 SearchMat Var Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
84MATVAROHDCOSTI_6 SearchMat Var Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
85MATVAROHDCOSTI_7 SearchMat Var Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
86MATVAROHDCOSTI_8 SearchMat Var Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
87DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsManufacturing (346)3rd PartyManufacturing Series Purchase Receipts (IC10200)

Leave a Reply

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