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: ptProjectDistributionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PROJNAME 
Project Name String STR20_LBU 20 2 ITEMNMBR Item Number String STR30_Item_Number 30 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'].ITEMNMBR3 ITEMDESC Item Description String STR100 100 4 NONINVEN Non IV Integer INT1 1 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 item5 ProjDistDocSource Project Dist Doc Source Integer DDL_Project_Dist_Document_Source 0 6 DOCNUMBR Document Number String STR20_Document_Number 20 7 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 8 CMPNTSEQ Component Sequence Long Integer LI_Sequence_Number 10 9 DSTSQNUM Distribution Sequence Number Long Integer Long Int 8 10 DOCDATE Document Date Date DT 8 11 Whom Whom String STR30 30 12 ProjDistType Project Distribution Type Integer DDL_Project_Dist_Type 0 13 ProDistCategory Project Distribution Category Integer DDL_Project_Dist_Category 0 14 INCORDEC Increase Or Decrease Integer GB 0 15 DISTAMNT Distribution Amount Currency DLR17_RBSO_STR$ 17 16 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 17 BillableType Billable Type Integer DDL_Project_Billable_Type 0 18 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 19 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 20 POSTED Posted Boolean True/False 0 21 ProjDistBillStatus Project Distribution Billing Status Integer DDL_Project_Dist_BillingStatus 0 22 PayCode Pay Code String STR6_Payroll_Code 6 23 PAYRATE Pay Rate Currency DLR11_$S2 14 24 SOPNUMBE SOP Number String STR20_SOP_Number 17