PA Purchase Requisition History (PA30701)

azurecurveProductsProject Accounting (258)ProjectPA Purchase Requisition History (PA30701)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Purchase Requisition History
Physical Name: PA30701
Technical Name: PA_REQ_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1POPRequisitionNumber SearchPOP Requisition NumberSTR17_POP_NumberString1817
2ORD SearchOrdLI_Sequence_NumberLong Integer410
3ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['PA Purchase Requisition History'].ITEMNMBR AS 'PA Purchase Requisition History-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       PA30701 AS ['PA Purchase Requisition History']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['PA Purchase Requisition History'].ITEMNMBR = ['Item Master'].ITEMNMBR
4DATEVAL SearchDateValueDATEDate46
5FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
6ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Purchase Requisition History'].ITMTSHID AS 'PA Purchase Requisition History-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA30701 AS ['PA Purchase Requisition History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Purchase Requisition History'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
7ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
8PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency1015
9PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency1017
10PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
11PACBADDFRMFLY SearchPA CB From Add On The FlyCBBoolean20
12PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString1817
13PACogs_Idx SearchPA COGS IDXLI_14Long Integer414
14PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString1615
15PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean20
16PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer410
17PAORGBSUNITCST SearchPA Originating Base Unit CostPA_DLR17_RBS0_STR$Currency1017
18PAprojname SearchPA Project NameSTR30_PTBS Description 1String3230
19PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
20PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
21PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
22PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
23PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer414
24PostedSubtotal SearchPosted SubtotalDLR17_RBS0_STR$Currency1017
25PRICELVL SearchPrice LevelSTR15_LBAUString1615
26UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Purchase Requisition History'].UOMSCHDL AS 'PA Purchase Requisition History-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA30701 AS ['PA Purchase Requisition History']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Purchase Requisition History'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
27DEX_ROW_ID Searchintint1010

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.

azurecurveProductsProject Accounting (258)ProjectPA Purchase Requisition History (PA30701)

Leave a Reply

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