JC_Inv_TRX_Level_Labor_Batch_VIEW (JC90701)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Inv_TRX_Level_Labor_Batch_VIEW (JC90701)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC_Inv_TRX_Level_Labor_Batch_VIEW
Physical Name: JC90701
Technical Name: JC_Inv_TRX_Level_Labor_Batch_VIEW

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BACHNUMB SearchBatch NumberSTR15_LBAUString1615
2RMDNUMWK SearchRM Document Number-WORKSTR17_LBAUString1817
3Document_Source SearchDocument SourceSTR3String43
4Job_TRX_Number SearchJob TRX NumberSTR20String2220
5Cost_Element SearchCost ElementINT3_RB0_UInteger23
6Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString86
7Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString86
8Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString86
9Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString86
10LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
11WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
12Project_Number SearchWS Project NumberSTR170String1817
13Cost_Element_Desc SearchCost Element DescriptionSTR15String1615
14Cost_Code_Description SearchCost Code DescriptionSTR30String3230
15TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency1017
16Current_Bill SearchCurrent BillDLR14_TSCurrency1014
17Apply_Transaction SearchApply TransactionCBBoolean20
18BCHSOURC SearchBatch SourceSTR15String1615
19GLPOSTDT SearchGL Posting DateDTDate48
20Profit_Type_Number SearchProfit Type NumberINT2Integer22
21Profit_Amount SearchProfit AmountDLR14_TSCurrency1014
22EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
23VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['JC_Inv_TRX_Level_Labor_Batch_VIEW'].VENDORID AS 'JC_Inv_TRX_Level_Labor_Batch_VIEW-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       JC90701 AS ['JC_Inv_TRX_Level_Labor_Batch_VIEW']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['JC_Inv_TRX_Level_Labor_Batch_VIEW'].VENDORID = ['PM Vendor Master File'].VENDORID
24ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['JC_Inv_TRX_Level_Labor_Batch_VIEW'].ITEMNMBR AS 'JC_Inv_TRX_Level_Labor_Batch_VIEW-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       JC90701 AS ['JC_Inv_TRX_Level_Labor_Batch_VIEW']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['JC_Inv_TRX_Level_Labor_Batch_VIEW'].ITEMNMBR = ['Item Master'].ITEMNMBR
azurecurveProductsWennSoft Products (131)3rd PartyJC_Inv_TRX_Level_Labor_Batch_VIEW (JC90701)

Leave a Reply

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