Project Distributions (PT10000)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Project Distributions
Physical Name: PT10000
Technical Name: ptProjectDistributions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PROJNAME SearchProject NameStringSTR20_LBU20
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Project Distributions'].ITEMNMBR AS 'Project Distributions-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       PT10000 AS ['Project Distributions']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Project Distributions'].ITEMNMBR = ['Item Master'].ITEMNMBR
3ITEMDESC SearchItem DescriptionStringSTR100100
4NONINVEN SearchNon IVIntegerINT11
Used to indicate whether an item is an inventory item or non-inventory item.

Click to show/hide PO Line Statuses

0	Inventory item
1	Non-inventory item
5ProjDistDocSource SearchProject Dist Doc SourceIntegerDDL_Project_Dist_Document_Source0
6DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
7LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
8CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
9DSTSQNUM SearchDistribution Sequence NumberLong IntegerLong Int8
10DOCDATE SearchDocument DateDateDT8
11Whom SearchWhomStringSTR3030
12ProjDistType SearchProject Distribution TypeIntegerDDL_Project_Dist_Type0
13ProDistCategory SearchProject Distribution CategoryIntegerDDL_Project_Dist_Category0
14INCORDEC SearchIncrease Or DecreaseIntegerGB0
15DISTAMNT SearchDistribution AmountCurrencyDLR17_RBSO_STR$17
16QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
17BillableType SearchBillable TypeIntegerDDL_Project_Billable_Type0
18DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
19DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
20POSTED SearchPostedBooleanTrue/False0
21ProjDistBillStatus SearchProject Distribution Billing StatusIntegerDDL_Project_Dist_BillingStatus0
22PayCode SearchPay CodeStringSTR6_Payroll_Code6
23PAYRATE SearchPay RateCurrencyDLR11_$S214
24SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17

Leave a Reply

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