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:

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

Leave a Reply

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