Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA10603
Product: Project Accounting (258)
Series:
Display Name: PA Purchase Requisition
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 String STR17_POP_Number 17 2 ORD Ord Long Integer LI_Sequence_Number 10 3 ITEMNMBR Item Number String STR30_Item_Number 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 Currency DLR17_RBS0_UTR$ 17 6 ITMTSHID Item Tax Schedule ID String STR15_LBAU 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 Currency DLR17_RBS0_UTR$ 17 8 PABase_Qty PA Base Qty Currency PA_DLR15_RBS0_STR 15 9 PABase_Unit_Cost PA Base Unit Cost Currency PA_DLR17_RBS0_STR$ 17 10 PAbillnoteidx PA Billing Note Index Currency DLR14 14 11 PACBADDFRMFLY PA CB From Add On The Fly Boolean CB 0 12 PACHGORDNO PA Change Order Number String STR17_LBAU 17 13 PACogs_Idx PA COGS IDX Long Integer LI_14 14 14 PACOSTCATID PA Cost Category ID String STR15_Cost_Category_ID 15 15 PAIV_Item_Checkbox PA IV Item Checkbox Boolean PA_CB_IV_Item 0 16 PALineItemSeq PA Line Item Sequence Long Integer LI_Sequence_Number 10 17 PAORGBSUNITCST PA Originating Base Unit Cost Currency PA_DLR17_RBS0_STR$ 17 18 PAprojname PA Project Name String STR30_PTBS Description 1 30 19 PAPROJNUMBER PA Project Number String STR15_LBAU 15 20 PAProjectType PA Project Type Integer PA_DDL_Project_Type 0 21 PAPurchase_Tax_Options PA Purchase Tax Options Integer PA_DDL_Tax_Options_Purchase 0 22 PATU PA Transaction Usage Integer PA_DDL_Transaction_Usage 0 23 PACGBWIPIDX PA WIP IDX Long Integer LI_14 14 24 PostedSubtotal Posted Subtotal Currency DLR17_RBS0_STR$ 17 25 PRICELVL Price Level String STR15_LBAU 15 26 UOMSCHDL U Of M Schedule String STR10_Schedule 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'].UOMSCHDL