Purchasing Requisition Line (POP10210)

SELECT
       ['Purchasing Requisition Line'].ITEMNMBR AS 'Purchasing Requisition Line-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Purchasing Requisition Line'].ITEMNMBR = ['Item Master'].ITEMNMBR

SELECT
       ['Purchasing Requisition Line'].VENDORID AS 'Purchasing Requisition Line-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Purchasing Requisition Line'].VENDORID = ['PM Vendor Master File'].VENDORID

0	Inventory item
1	Non-inventory item

SELECT
       ['Purchasing Requisition Line'].LOCNCODE AS 'Purchasing Requisition Line-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Purchasing Requisition Line'].LOCNCODE = ['Site Setup'].LOCNCODE

SELECT
       ['Purchasing Requisition Line'].REQSTDBY AS 'Purchasing Requisition Line-Requested By'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Purchasing Requisition Line'].REQSTDBY = ['Users Master'].USERID

SELECT
       ['Purchasing Requisition Line'].INVINDX AS 'Purchasing Requisition Line-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Purchasing Requisition Line'].INVINDX = ['Account Index Master'].ACTINDX

SELECT
       ['Purchasing Requisition Line'].CURNCYID AS 'Purchasing Requisition Line-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchasing Requisition Line'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['Purchasing Requisition Line'].CURRNIDX AS 'Purchasing Requisition Line-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchasing Requisition Line'].CURRNIDX = ['Currency Setup'].CURRNIDX

SELECT
       ['Purchasing Requisition Line'].RATETPID AS 'Purchasing Requisition Line-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Purchasing Requisition Line'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID

SELECT
       ['Purchasing Requisition Line'].EXGTBLID AS 'Purchasing Requisition Line-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Purchasing Requisition Line'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID

0	Multiply
1	Divide

0	Euro currency is not created or no denomination currencies are enabled.
		1	Originating is not a denomination; Functional is not a denomination
		2	Originating is not a denomination; Functional is the Euro currency.
		3	Originating is not a denomination; Functional is a denomination.
		4	Originating is a denomination; Functional is not a denomination.
		5	Originating is a denomination; Functional is a denomination.
		6	Originating is a denomination; Functional is the Euro currency.
		7	Originating is the Euro currency; Functional is a denomination.
		8	Originating is the Euro currency; Functional is not a denomination.

7	0 decimals
8	1
9	2
10	3
11	4
12	5

1	0 decimals
2	1
3	2
4	3
5	4
6	5

1	0 decimals
2	1
3	2
4	3
5	4
6	5

1	FIFO Perpetual
2	LIFO Perpetual
3	Average Perpetual
4	FIFO Periodic
5	LIFO Periodic

SELECT
       ['Purchasing Requisition Line'].CCode AS 'Purchasing Requisition Line-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Purchasing Requisition Line'].CCode = ['VAT Country Code MSTR'].CCode

SELECT
       ['Purchasing Requisition Line'].SHIPMTHD AS 'Purchasing Requisition Line-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Purchasing Requisition Line'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD

SELECT
       ['Purchasing Requisition Line'].COMMNTID AS 'Purchasing Requisition Line-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       POP10210 AS ['Purchasing Requisition Line']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Purchasing Requisition Line'].COMMNTID = ['Comment Master'].COMMNTID