Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA10603
Product: Project Accounting (258)
Series: Project
Display Name: PA Purchase Requisition DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: PA10603
Technical Name: PA_REQ_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 POPRequisitionNumber 
POP Requisition Number STR17_POP_Number String 17 2 ORD Ord LI_Sequence_Number Long Integer 10 3 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['PA Purchase Requisition'].ITEMNMBR AS 'PA Purchase Requisition-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
PA10603 AS ['PA Purchase Requisition']
INNER JOIN
IV00101 AS ['Item Master']
ON
['PA Purchase Requisition'].ITEMNMBR = ['Item Master'].ITEMNMBR4 DATEVAL DateValue DATE Date 6 5 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 6 ITMTSHID Item Tax Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['PA Purchase Requisition'].ITMTSHID AS 'PA Purchase Requisition-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA10603 AS ['PA Purchase Requisition']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Purchase Requisition'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID7 ORFRTAMT Originating Freight Amount DLR17_RBS0_UTR$ Currency 17 8 PABase_Qty PA Base Qty PA_DLR15_RBS0_STR Currency 15 9 PABase_Unit_Cost PA Base Unit Cost PA_DLR17_RBS0_STR$ Currency 17 10 PAbillnoteidx PA Billing Note Index DLR14 Currency 14 11 PACBADDFRMFLY PA CB From Add On The Fly CB Boolean 0 12 PACHGORDNO PA Change Order Number STR17_LBAU String 17 13 PACogs_Idx PA COGS IDX LI_14 Long Integer 14 14 PACOSTCATID PA Cost Category ID STR15_Cost_Category_ID String 15 15 PAIV_Item_Checkbox PA IV Item Checkbox PA_CB_IV_Item Boolean 0 16 PALineItemSeq PA Line Item Sequence LI_Sequence_Number Long Integer 10 17 PAORGBSUNITCST PA Originating Base Unit Cost PA_DLR17_RBS0_STR$ Currency 17 18 PAprojname PA Project Name STR30_PTBS Description 1 String 30 19 PAPROJNUMBER PA Project Number STR15_LBAU String 15 20 PAProjectType PA Project Type PA_DDL_Project_Type Integer 0 21 PAPurchase_Tax_Options PA Purchase Tax Options PA_DDL_Tax_Options_Purchase Integer 0 22 PATU PA Transaction Usage PA_DDL_Transaction_Usage Integer 0 23 PACGBWIPIDX PA WIP IDX LI_14 Long Integer 14 24 PostedSubtotal Posted Subtotal DLR17_RBS0_STR$ Currency 17 25 PRICELVL Price Level STR15_LBAU String 15 26 UOMSCHDL U Of M Schedule STR10_Schedule String 10 Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hide
SELECT
['PA Purchase Requisition'].UOMSCHDL AS 'PA Purchase Requisition-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PA10603 AS ['PA Purchase Requisition']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PA Purchase Requisition'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL27 DEX_ROW_ID int int 10