PA Inventory Transfer Work Detail (PA10901)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Inventory Transfer Work Detail
Physical Name: PA10901
Technical Name: PA_IV_Transfer_WORK_LINE

Group Display Name: PA Inventory Transfer Transactions
Group Technical Name: PA Inventory Transfer Transactions

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PAIV_Document_No	PA IV Document No	STR17_LBAU	String	18	17
2	PAIV_Transfer_Type	PA IV Transfer Type	PA_DDL_IV_Transfer_Type	Integer	2	0
3	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
4	PALineItemSeq	PA Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
5	PAREFNO	PA Reference Document No.	STR17_LBAU	String	18	17
6	PAReference_Line_Seq_N	PA Reference Line Seq No	LI_Sequence_Number	Long Integer	4	10
7	PADT	PA Date	PA_Date	Date	4	8
8	PAPROJNUMBER	PA Project Number	STR15_LBAU	String	16	15
9	PACOSTCATID	PA Cost Category ID	STR15_Cost_Category_ID	String	16	15
10	ITEMNMBR	Item Number	STR30_Item_Number	String	32	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['PA Inventory Transfer Work Detail'].ITEMNMBR AS 'PA Inventory Transfer Work Detail-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM PA10901 AS ['PA Inventory Transfer Work Detail'] INNER JOIN IV00101 AS ['Item Master'] ON ['PA Inventory Transfer Work Detail'].ITEMNMBR = ['Item Master'].ITEMNMBR
11	PAIV_Item_Checkbox	PA IV Item Checkbox	PA_CB_IV_Item	Boolean	2	0
12	LOCNCODE	Location Code	STR10_Location_Code	String	12	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['PA Inventory Transfer Work Detail'].LOCNCODE AS 'PA Inventory Transfer Work Detail-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM PA10901 AS ['PA Inventory Transfer Work Detail'] INNER JOIN IV40700 AS ['Site Setup'] ON ['PA Inventory Transfer Work Detail'].LOCNCODE = ['Site Setup'].LOCNCODE
13	QUANTITY	QTY	DLR17_QTY_RBS0_STR	Currency	10	17
14	PABase_Qty	PA Base Qty	PA_DLR15_RBS0_STR	Currency	10	15
15	UOFM	U Of M	U_Of_M	String	10	8
16	PAUNITCOST	PA Unit Cost	PA_DLR17_RBS0_UTR$	Currency	10	17
17	PABase_Unit_Cost	PA Base Unit Cost	PA_DLR17_RBS0_STR$	Currency	10	17
18	PATOTCST	PA Total Cost	PA_DLR17_RBS0_STR$	Currency	10	17
19	PAOverhead_Amount	PA Overhead Amount	DLR15_RBU$2	Currency	10	15
20	PABaseOvhdCost	PA Base Overhead Cost	DLR17_RBS0_UTR$	Currency	10	17
21	PAOverheaPercentage	PA Overhead Percentage	DLR5_%2	Currency	10	8
22	PATOTALOVERH	PA Total Overhead	DLR17_RBS0_UTR$	Currency	10	17
23	PRICELVL	Price Level	STR15_LBAU	String	16	15
24	PABILRATE	PA Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
25	PA_Base_Billing_Rate	PA Base Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
26	PAMARKPERCENT	PA Markup Percentage	DLR5_%2	Currency	10	8
27	PAACREV	PA Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
28	PAbllngtype	PA Billing Type	PA_DDL_Billing_Type	Integer	2	0
29	PAbillnoteidx	PA Billing Note Index	DLR14	Currency	10	14
30	PACONTNUMBER	PA Contract Number	STR10_LBAU	String	12	10
31	PAexptdate	PA Export Date	PA_Date	Date	4	8
32	PASTD_Qty	PA STD Qty	PA_DLR15_RBS0_STR	Currency	10	15
33	PANC_Qty	PA NC Qty	PA_DLR15_RBS0_STR	Currency	10	15
34	PANB_Qty	PA NB Qty	PA_DLR15_RBS0_STR	Currency	10	15
35	PAProfitType	PA Profit Type	PA_DDL_Profit_Type	Integer	2	0
36	PAProfitPercent	PA Profit Percent	DLR5_%2	Currency	10	8
37	PAProfitAmount	PA Profit Amount	DLR17_RBS0_UTR$	Currency	10	17
38	PATotalProfit	PA Total Profit	DLR17_RBS0_UTR$	Currency	10	17
39	PAApproved_Quantity	PA Approved Quantity	PA_DLR15_RBS0_STR	Currency	10	15
40	PAAPPROVBILLRATE	PA Approved Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
41	PAAPPROVMKUPPCT	PA Approved Markup Percentage	DLR5_%2	Currency	10	8
42	PAApproved_Billing_Amou	PA Approved Billing Amount	DLR17_RBSO_STR$	Currency	10	17
43	PABilledProfitPercentage	PA Billed Profit Percentage Average	DLR5_%2	Currency	10	8
44	PA_Billed_Profit_Amount_	PA Billed Profit Amount Average	DLR17_RBS0_UTR$	Currency	10	17
45	PABilled_Amount	PA Billed Amount	DLR17_RBS0_UTR$	Currency	10	17
46	PABilledTax	PA Billed Tax	DLR17_RBS0_STR$	Currency	10	17
47	PABilled_Misc	PA Billed Misc	DLR17_RBS0_UTR$	Currency	10	17
48	PABilled_Freight	PA Billed Freight	DLR17_RBS0_UTR$	Currency	10	17
49	PABilled_Discount	PA Billed Discount	DLR17_RBS0_UTR$	Currency	10	17
50	PAWrite_UpDown_Amount	PA Write Up/Down Amount	PA_DLR17_RBS0_STR$	Currency	10	17
51	PAWrite_UpDown_Percenta	PA Write Up/Down Percentage	PA_LI5_%2S	Long Integer	4	5
52	PAApprover_ID	PA Approver ID	STR15	String	16	15
53	PABilled_QtyN	PA Billed Qty	PA_DLR15_RBS0_STR	Currency	10	15
54	PAApprover_Type	PA Approver Type	DDL_Approver_Type	Integer	2	0
55	PAPartial_Bill	PA Partial Bill	CB	Boolean	2	0
56	PABilling_StatusN	PA Billing Status	DDL_Billing_Status	Integer	2	0
57	PACGBWIPIDX	PA WIP IDX	LI_14	Long Integer	4	14
58	PAUnbilled_AR_Idx	PA Unbilled AR IDX	LI_14	Long Integer	4	14
59	PACogs_Idx	PA COGS IDX	LI_14	Long Integer	4	14
60	PAContra_Account_IDX	PA Contra Account IDX	LI_14	Long Integer	4	14
61	PAOverhead_IDX	PA Overhead IDX	LI_14	Long Integer	4	14
62	PAUnbilled_Proj_Rev_Idx	PA Unbilled Proj Rev IDX	LI_14	Long Integer	4	14
63	IVIVINDX	IV IV Index	LI_14	Long Integer	4	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['PA Inventory Transfer Work Detail'].IVIVINDX AS 'PA Inventory Transfer Work Detail-IV IV Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM PA10901 AS ['PA Inventory Transfer Work Detail'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['PA Inventory Transfer Work Detail'].IVIVINDX = ['Account Index Master'].ACTINDX
64	PAIV_Line_Errors	PA IV Line Errors	PA_ML_IVT_Line_Errors_1	Long Integer	4	0
65	PAIVLINERR2	PA IV Line Errors 2	PA_ML_IVT_Line_Errors_2	Long Integer	4	0
66	PAPurchase_Tax_Options	PA Purchase Tax Options	PA_DDL_Tax_Options_Purchase	Integer	2	0
67	ITMTSHID	Item Tax Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PA Inventory Transfer Work Detail'].ITMTSHID AS 'PA Inventory Transfer Work Detail-Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PA10901 AS ['PA Inventory Transfer Work Detail'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PA Inventory Transfer Work Detail'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
68	TAXAMNT	Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
69	BCKTXAMT	Backout Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
70	PAEXTCOST	PA Extended Cost	PA_DLR17_RBS0_STR$	Currency	10	17
71	UOMSCHDL	U Of M Schedule	STR10_Schedule	String	12	10
	Key to the Inventory U of M Schedule Setup (IV40201). Click to show/hide SELECT ['PA Inventory Transfer Work Detail'].UOMSCHDL AS 'PA Inventory Transfer Work Detail-U Of M Schedule' ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule' FROM PA10901 AS ['PA Inventory Transfer Work Detail'] INNER JOIN IV40201 AS ['Inventory U of M Schedule Setup'] ON ['PA Inventory Transfer Work Detail'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
72	PACHGORDNO	PA Change Order Number	STR17_LBAU	String	18	17
73	PACBADDFRMFLY	PA CB From Add On The Fly	CB	Boolean	2	0
74	TRNSTLOC	Transfer To Location	STR10_Location_Code	String	12	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['PA Inventory Transfer Work Detail'].TRNSTLOC AS 'PA Inventory Transfer Work Detail-Transfer To Location' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM PA10901 AS ['PA Inventory Transfer Work Detail'] INNER JOIN IV40700 AS ['Site Setup'] ON ['PA Inventory Transfer Work Detail'].TRNSTLOC = ['Site Setup'].LOCNCODE
75	PAMCCURNCYID	PA MC Currency ID	STR15_Currency_ID	String	16	15
76	PA_MC_Billing_Rate	PA MC Billing Rate	PA_DLR17_RBS0_UTR$	Currency	10	17
77	PA_MC_Base_Billing_Rate	PA MC Base Billing Rate	PA_DLR17_RBS0_UTR$	Currency	10	17
78	PA_MC_Accrued_Revenue	PA MC Accrued Revenue	PA_DLR17_RBS0_UTR$	Currency	10	17
79	CURRNIDX	Currency Index	INT3	Integer	2	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PA Inventory Transfer Work Detail'].CURRNIDX AS 'PA Inventory Transfer Work Detail-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM PA10901 AS ['PA Inventory Transfer Work Detail'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PA Inventory Transfer Work Detail'].CURRNIDX = ['Currency Setup'].CURRNIDX
80	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
81	EXCHDATE	Exchange Date	DT_Date	Date	4	6
82	EXGTBLID	Exchange Table ID	STR15_Exchange_Table_ID	String	16	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['PA Inventory Transfer Work Detail'].EXGTBLID AS 'PA Inventory Transfer Work Detail-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM PA10901 AS ['PA Inventory Transfer Work Detail'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['PA Inventory Transfer Work Detail'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
83	MCTRXSTT	MC Transaction State	INT1	Integer	2	1
84	RATECALC	Rate Calc Method	INT	Integer	2	0
85	RATETPID	Rate Type ID	STR15_Rate_Type_ID	String	16	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['PA Inventory Transfer Work Detail'].RATETPID AS 'PA Inventory Transfer Work Detail-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM PA10901 AS ['PA Inventory Transfer Work Detail'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['PA Inventory Transfer Work Detail'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
86	TIME1	Time	TM6	Time	4	6
87	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
88	DEX_ROW_ID		int	int	10	10
	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.

azurecurve Products Project Accounting (258)ProjectPA Inventory Transfer Work Detail (PA10901)

Leave a Reply Cancel reply