JC_Inv_TRX_Level_Batch_VIEW (JC90700)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Inv_TRX_Level_Batch_VIEW (JC90700)

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

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

Display Name: JC_Inv_TRX_Level_Batch_VIEW
Physical Name: JC90700
Technical Name: JC_Inv_TRX_Level_Batch_VIEW

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BACHNUMB SearchBatch NumberSTR15_LBAUString15
2RMDNUMWK SearchRM Document Number-WORKSTR17_LBAUString17
3Document_Source SearchDocument SourceSTR3String3
4Job_TRX_Number SearchJob TRX NumberSTR20String20
5Cost_Element SearchCost ElementINT3_RB0_UInteger3
6Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString6
7Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString6
8Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString6
9Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString6
10LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
11WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
12Project_Number SearchWS Project NumberSTR170String17
13Cost_Element_Desc SearchCost Element DescriptionSTR15String15
14Cost_Code_Description SearchCost Code DescriptionSTR30String30
15TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency17
16Current_Bill SearchCurrent BillDLR14_TSCurrency14
17Apply_Transaction SearchApply TransactionCBBoolean0
18BCHSOURC SearchBatch SourceSTR15String15
19GLPOSTDT SearchGL Posting DateDTDate8
20Profit_Type_Number SearchProfit Type NumberINT2Integer2
21Profit_Amount SearchProfit AmountDLR14_TSCurrency14
22EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
23VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

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

Click to show/hide

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

Leave a Reply

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