Export (0) Print
Expand All

Requester document tables

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


Show:
© 2014 Microsoft