Automated Data Collection Records (SF010501)

azurecurveProductsManufacturing (346)3rd PartyAutomated Data Collection Records (SF010501)

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

Product: Manufacturing (346)
Series:

Display Name: Automated Data Collection Records
Physical Name: SF010501
Technical Name: ADC_Records

Group Display Name: Manufacturing WIP
Group Technical Name: Manufacturing WIP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DATAENTRYTYPEADC_I SearchData Entry Type ADCIntegerDDL_Data_Entry_Type_ADC0
2MANUFACTUREORDER_I SearchManufacture OrderStringSTR30_UC30
3RTSEQNUM_I SearchrtseqnumStringSTR1010
4DONECB_I Searchdone_cbBooleanCB_Done0
5EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
6MACHINEID_I SearchMachine ID ICStringSTR10_Location_Code10
7ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Automated Data Collection Records'].ITEMNMBR AS 'Automated Data Collection Records-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SF010501 AS ['Automated Data Collection Records']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Automated Data Collection Records'].ITEMNMBR = ['Item Master'].ITEMNMBR
8ADCDATE_I SearchADCDateDateDATE6
9ADCTIME_I SearchADCTimeTimeTM6
10TRXTYPE SearchTransaction TypeIntegerGB0
11LABORCODE_I SearchLabor CodeStringSTR1010
12PAYRCORD SearchPay RecordStringSTR6_Payroll_Code6
13PAYTYPE SearchPay TypeIntegerDDL_Pay_Types0
14LABCODEPAYCODESEL_I SearchLabor Code PayCode SelectIntegerGB0
15SETUPCB_I SearchSetup CBBooleanCB0
16NUMBERSCRAPPED_I SearchNumber ScrappedCurrencyDLR_14_MRP14
17PIECES_I SearchPiecesCurrencyDLR_14_MRP14
18REJECTS_I SearchRejectsCurrencyDLR_14_MRP14
19ADCDEVICEID_I SearchADC Device IDStringSTR15_User_ID15
20CHANGEBY_I SearchChange ByStringSTR15_User_ID15
21CHANGEDATE_I SearchChange DateDateDT8
22CHANGETIME_I SearchChange TimeTimeTM6
23ADCSTATUS_I SearchADCStatusIntegerDDL0
24Job_Number SearchIC Job NumberStringSTR3030
azurecurveProductsManufacturing (346)3rd PartyAutomated Data Collection Records (SF010501)

Leave a Reply

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