Data Collection Transaction Log (SF010200)

azurecurveProductsManufacturing (346)3rd PartyData Collection Transaction Log (SF010200)

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

Product: Manufacturing (346)
Series:

Display Name: Data Collection Transaction Log
Physical Name: SF010200
Technical Name: Data_Collection_TRX_Log

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DATAENTRYTYPE_I SearchData Entry TypeIntegerDDL_Data_Entry_Type0
2EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
3LABORCODE_I SearchLabor CodeStringSTR1010
4MANUFACTUREORDER_I SearchManufacture OrderStringSTR30_UC30
5RTSEQNUM_I SearchrtseqnumStringSTR1010
6ACTUALSTARTDATE_I SearchActualStartDateDateDATE6
7ACTUALSTARTTIME_I SearchActualStartTimeTimeTM6
8DATE1 SearchDateDateDT66
9TIME1 SearchTimeTimeTM66
10ACTUALFINISHDATE_I SearchActualFinishDateDateDATE6
11ACTUALFINISHTIME_I SearchActualFinishTimeTimeTM6
12ELAPSEDTIME_I SearchElapsed TimeCurrencyhr10
13ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Data Collection Transaction Log'].ITEMNMBR AS 'Data Collection Transaction Log-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SF010200 AS ['Data Collection Transaction Log']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Data Collection Transaction Log'].ITEMNMBR = ['Item Master'].ITEMNMBR
14PIECES_I SearchPiecesCurrencyDLR_14_MRP14
15REJECTS_I SearchRejectsCurrencyDLR_14_MRP14
16PAYRCORD SearchPay RecordStringSTR6_Payroll_Code6
17LABCODEPAYCODESEL_I SearchLabor Code PayCode SelectIntegerGB0
18COMPTRNM SearchComputer TRX NumberLong IntegerLI8_U08
19UPRBCHOR SearchUPR Batch OriginIntegerDDL_UPR_Batch_Origin0
20BACHNUMB SearchBatch NumberStringSTR15_LBAU15
21SUCPAYROLLTRX_I SearchSuccessfulPayrollTrxBooleanCB0
22TRANSACTIONRESULT_I SearchTransaction ResultIntegerTransaction Result0
23COMMENTS1000_I SearchComments1000TextTXT10001000
azurecurveProductsManufacturing (346)3rd PartyData Collection Transaction Log (SF010200)

Leave a Reply

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