Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following table shows the Microsoft Dynamics GP tables the Transaction Requester uses to retrieve data for the specified document type:
Document type |
Alias |
Tables used |
|---|---|---|
Cash_Receipt |
Cash_Receipt |
RM10201 |
Customer |
Customer Address Internet_Address |
RM00101 RM00102 SY01200 |
Customer_Balances |
Customer Balance |
RM00101 RM00103 |
Employee |
Employee Address |
UPR00100 UPR00102 |
GL_Accounts |
GL_Accounts Details |
GL00105 GL00100 |
GL_Hist_Trans |
GL_Hist_Trans |
GL30000 |
GL_Open_Trans |
GL_Open_Trans |
GL20000 |
GL_Work_Trans |
GL_Work_Trans |
GL10000 |
Item |
Item Quantities |
IV00101 IV00102 |
Item_ListPrice |
Item ListPrice |
IV00101 IV00105 |
ItemPriceLevels |
ItemPriceLevels |
IV00108 |
Payables_History_Transaction |
PM_Hist_Trans Tax |
PM30200 PM30700 |
Payables_Posted_Transaction |
PM_Posted_Trans Tax |
PM2000 PM10500 |
Payables_Transaction |
PM_Trans Tax |
PM1000 PM10500 |
PO_History_Transaction |
PO_Hist_Trans Line Comment |
POP30100 POP30110 POP10150 |
PO_Receiving_Hist_Trans |
PO_Receiving_Hist Line Quantities |
POP30300 POP30310 POP10500 |
PO_Receiving_Transaction |
PO_Receiving Line Quantities |
POP10300 POP10310 POP10500 |
Project_Acct_Contract |
PA_Contract Cont_Bill_Cycle PA_Project |
PA01101 PA02401 PA01201 |
Project_Acct_Contract_Template |
PA_Contract_Temp Cont_Bill_Cycle_Temp |
PA41501 PA42901 |
Project_Acct_Cost_Category |
Cost_Category |
PA01001 |
Project_Acct_Employee_Rate |
PA_Employ_Rate Line |
PA01402 PA01403 |
Project_Acct_EmployeeExpense |
PA_EmpExp Line Tax |
PA10500 PA10501 PA10502 |
Project_Acct_Equipment_Rate |
PA_Equip_Rate Line |
PA01406 PA01407 |
Project_Acct_MiscLog |
PA_MiscLog Line |
PA10200 PA10201 |
Project_Acct_Position_Rate |
PA_Employ_Rate Line |
PA01404 PA01405 |
Project_Acct_Project |
PA_Project Bill_Cycle Budget Budget_IVItems Fee Fee_Schedule Access_List Equip_List |
PA01201 PA61020 PA01301 PA01303 PA02101 PA05200 PA01408 PA01409 |
Project_Acct_Project_Access |
Proj_Acct_List Employee_Detail Address |
PA01408 UPR00100 UPR00102 |
Project_Acct_Project_Template |
PA_Project_Temp Proj_Bill_Cycle_Temp Budget Budget_Items Fee Fee_Schedule Equip_List Access_List |
PA41601 PA60020 PA40201 PA40202 PA60040 PA40203 PA41409 PA41401 |
Project_Acct_Timesheet |
PA_Time Line |
PA10000 PA10001 |
Purchase_Order_Transaction |
Header Line Comment |
POP10100 POP10110 POP10150 |
Receivables_Hist_Trans |
Header Invoice_Tax |
RM30101 RM30601 |
Receivables_Posted_Transaction |
Header Invoice_Tax |
RM20101 RM10601 |
Receivables_Transaction |
Header Invoice_Tax |
RM10301 RM10601 |
RM_SalesPerson |
RM_SalesPerson |
RM00301 |
Sales_History_Transaction |
SO_Hist_Trans Line Line_Tax Commissions Distribution Payments Holds UserDefined Deposit Notes |
SOP30200 SOP30300 SOP10105 SOP10101 SOP10102 SOP10103 SOP10104 SOP10106 SOP30201 SY03900 |
Sales_Transaction |
SO_Trans Commissions Line LineTax Distribution Payments Holds UserDefined Deposit Notes |
SOP10100 SOP10101 SOP10200 SOP10105 SOP10102 SOP10103 SOP10104 SOP10106 SOP30201 SY03900 |
UOFM |
UOFM |
IV40201 |
Vendor |
Vendor Vendor_Addr |
PM00200 PM00300 |
VendorItem |
VendorItem |
IV00103 |