The following table shows the Microsoft Dynamics GP tables the Transaction Requester uses to retrieve data for the specified document type:
![[spacer]](1p.gif){kind=small}
|
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 |