Dynamics GP Project Accounting Tables

Project Accounting

PDK40400Class Master22257
PDK40300Class Restrictions22258
GST00111GST PA PM Class MSTR22526
GST00103GST PA Purchasing Receipt22527
GST00104GST PA Purchasing Receipt22528
PA10707PA PAPOSOPPOLink22417
PA43001PA Accounts Setup File22078
PA43002PA Accounts Template Setup File22223
PA000002PA Adjustment Activity22277
PA13400PA Aging Reconcile Control22191
PA13300PA Aging WIP Reconcile Control22197
PA23101PA Applied Header History22471
PA33101PA Applied Header Open22472
PA33601PA Applied History File22010
PA23000PA Applied OPEN22334
PA33602PA Applied Sub Detail History File22040
PA23010PA Applied Sub Detail OPEN22371
PA42602PA Bill Format Print SETP22449
PA42601PA Bill Format Setup22014
PA42501PA Biller Module Setup22012
PA33401PA Billing Apply Distribution History22084
PA33204PA Billing Commissions HIST22065
PA11000PA Billing Commissions LINK22109
PA11300PA Billing Contract Link22117
PA11500PA Billing Contracts22108
PA02000PA Billing Cycle MSTR22265
PA33200PA Billing Detail HIST22352
PA23200PA Billing Detail OPEN22341
PA13200PA Billing Detail WORK22328
PA30703PA Billing Distribution History22269
PA10802PA Billing Distribution WORK22270
PA33100PA Billing Header HIST22351
PA23100PA Billing Header OPEN22340
PAV43100PA Billing Header View22577
PA13100PA Billing Header WORK22327
PA01601PA Billing Notes Master22162
PA11400PA Billing Project Link22168
PA33201PA Billing Sub-Detail HIST Fee22318
PA33202PA Billing Sub-Detail HIST FF22317
PA33203PA Billing Sub-Detail HIST TM22358
PA23201PA Billing Sub-Detail OPEN Fee22350
PA23202PA Billing Sub-Detail OPEN FF22339
PA23203PA Billing Sub-Detail OPEN TM22343
PA13201PA Billing Sub-Detail WORK Fee22364
PA13203PA Billing Sub-Detail WORK FF22372
PA13202PA Billing Sub-Detail WORK TM22373
PA11700PA Billing Subline Tax Detail22193
PA33206PA Billing Subline Tax Detail Hist22075
PA11100PA Billing Tax Detail22112
PA33205PA Billing Tax Detail Hist22076
PA01303PA Budget IVItems22291
PA01301PA Budget Master File22041
PA01342PA Budget MSTR COST SUM22578
PA01341PA Budget MSTR WIP SUM22550
PA01304PA Budget Periodic Totals Master File22324
PA40201PA Budget Template File22042
PA89422PA Budget Template File Lookup22543
PA40202PA Budget Template IV Items22132
PA33702PA Change Order Detail HIST22503
PA23401PA Change Order Detail OPEN22504
PA12001PA Change Order Detail WORK22505
PA23501PA Change Order Fee Detail OPEN22516
PA12102PA Change Order Fee Detail WORK22506
PA23500PA Change Order Fee Header OPEN22517
PA12101PA Change Order Fee Header WORK22507
PA23502PA Change Order Fee Schedule OPEN22518
PA12103PA Change Order Fee Schedule WORK22519
PA33701PA Change Order Header HIST22508
PA23400PA Change Order Header OPEN22509
PA12000PA Change Order Header WORK22510
PA02701PA Change Order Key Master22511
PA11801PA Combined History Detail File22220
PA11800PA Combined History Header file22140
PA02001PA Combined History Setup22221
PA42902PA Contr Templ RR Cycle Link22491
PA42901PA Contract Billing Cycle Link22375
PA02401PA Contract Billing Cycle Link File22354
PA01141PA Contract Change Order Master22512
PA41101PA Contract Class Setup File22022
PA01122PA Contract CO Periodic Totals MSTR22530
PA01151PA Contract Customer List MSTR22534
PA01101PA Contract Master File22021
PA01162PA Contract MSTR COST SUM22579
PA01131PA Contract MSTR SUM22200
PA01161PA Contract MSTR WIP SUM22551
PA01121PA Contract Periodic Totals MSTR22163
PA01111PA Contract Revenue Sources Master File22345
PA02501PA Contract RR Cycle Link File22486
PA91304PA Contract Segment Override Detail22454
PA91301PA Contract Segment Override Header22453
PA92304PA Contract Template Seg Override Detail22457
PA92301PA Contract Template Seg Override Header22456
PA41501PA Contract TemplateFile22023
PA41001PA Cost Category Class Setup File22024
PA01001PA Cost Category Master File22025
PA14100PA Cost Trx Add On The Fly22552
PA02301PA Customer Billing Cycle Link File22355
PA42801PA Customer Class Billing Cycle Link22368
PA42802PA Customer Class RR Cycle Link22487
PA40501PA Customer Class Setup22000
PA00512PA Customer CO Periodic Totals MSTR22531
PA00501PA Customer MSTR22001
PA00532PA Customer MSTR COST SUM22580
PA00521PA Customer MSTR SUM22190
PA00531PA Customer MSTR WIP SUM22189
PA00511PA Customer Periodic Totals MSTR22183
PA02601PA Customer RR Cycle Link File22488
PA13204PA Distribution Work File22370
PA40601PA Employee Class Setup22013
PA10501PA Employee Expense Detail File22081
PA30501PA Employee Expense Detail History File22119
PA30504PA Employee Expense Distribution History22229
PA10504PA Employee Expense Distribution WORK22228
PA10500PA Employee Expense Header File22080
PA30500PA Employee Expense Header History File22145
PA42401PA Employee Expense Setup22011
PA10502PA Employee Expense Tax WORK file22194
PA30503PA Employee Expense Tax WORK HIstory file22195
PA00601PA Employee MSTR22002
PA01402PA Employee Rate Table HDR22111
PA01403PA Employee Rate Table LINE22299
PA40701PA Equipment Class Setup File22031
PA10101PA Equipment Log Detail File22086
PA30201PA Equipment Log Detail History File22150
PA30203PA Equipment Log Distribution History22230
PA10103PA Equipment Log Distribution WORK22233
PA10100PA Equipment Log Header File22077
PA30200PA Equipment Log Header History File22149
PA41901PA Equipment Log Setup22006
PA00701PA Equipment Master File22032
PA01406PA Equipment Rate Table HDR22304
PA01407PA Equipment Rate Table LINE22301
PA00401PA Fee Master File22325
PA03400PA Generic File Log22245
PA30904PA Invenotry Transfer Tax HiST file22492
PA10904PA Invenotry Transfer Tax WORK file22493
eePAIVLNPA Invent Transfer Line22268
PA30903PA Inventory Distribution History22294
PA10903PA Inventory Distribution WORK22293
EEPAIVRQPA Inventory Returned Quantities22267
PA10902PA Inventory Serial and Lot Number Work22283
PA10905PA Inventory Transaction Bin Quantities Work22630
PA30901PA Inventory Transfer History Detail22276
PA30900PA Inventory Transfer History Header22275
PA42701PA Inventory Transfer Setup22272
PA10901PA Inventory Transfer Work Detail22274
PA10900PA Inventory Transfer Work Header22273
PA30902PA Item Serial and Lot Number History22284
PA01404PA Job Title Rate Table Header22303
PA01405PA Job Title Rate Table Line22300
PA01901PA Key Master22214
PA01801PA Location Format Setup22166
PA01202PA MC Project Master File22061
PA40801PA Miscellaneous Class Setup File22026
PA30303PA Miscellaneous Log Distribution History22231
PA10201PA Miscellaneous Log Detail File22057
PA10203PA Miscellaneous Log Distribution WORK22234
PA10200PA Miscellaneous Log Header File22056
PA30301PA Miscellaneous Log History Detail File22048
PA30300PA Miscellaneous Log History File22055
PA42001PA Miscellaneous Log Setup22007
PA00801PA Miscellaneous Master File22027
PA10705PA PO Distribution Work22295
PA14300PA PO Project Assignment22593
PA14301PA PO Project Assignment Detail22618
PA31101PA PO Receipt History22387
PA10702PA PO Receipt Line22187
PA31102PA PO Receipt Line History22386
PA10721PA PO Receipt Line Quantities22385
PA10701PA PO Receipt Work22158
PA14400PA PO Receivings Assignment22619
PA14401PA PO Receivings Assignment Detail22620
PA10731PA PO Shipment Invoice Apply22188
PA10704PA PO Tax22296
PA31103PA PO Tax History22323
PA30000PA Posting Definitions Master History22051
PA000001PA Proj Contr Activity Master22452
PA01408PA Project Access List MSTR22305
PA41401PA Project Access Template SETP22307
PA61020PA Project Billing Cycle Link File22335
PA05100PA Project Billing Master File22330
PA05100APA Project Billing Master File22631
PA41701PA Project Budget Setup22004
PA01241PA Project Change Order Master22513
PA41201PA Project Class Setup File22029
PA33502PA Project Closing Distribution HIST22135
PA11902PA Project Closing Distribution WORK22130
PA33501PA Project Closing History22138
PA11905PA Project Closing History Budget22564
PA11906PA Project Closing History Fee22565
PA11903PA Project Closing Work Budget22566
PA11901PA Project Closing WORK Detail22137
PA11904PA Project Closing Work Fee22567
PA11900PA Project Closing WORK Header22136
PA01222PA Project CO Periodic Totals MSTR22532
PA01410PA Project Customer List Master22535
PA01409PA Project Equipment List MSTR22306
PA41409PA Project Equipment Template SETP22308
PA02101PA Project Fee Master File22058
PA05200PA Project Fee Schedule Master File22082
PA00402PA Project Fee Totals Master File22083
PA01201PA Project Master File22030
PA01252PA Project MSTR COST SUM22581
PA01231PA Project MSTR SUM22206
PA01251PA Project MSTR WIP SUM22553
PA01221PA Project Periodic Totals MSTR22182
PA01211PA Project Revenue Sources Master File22346
PA61040PA Project RR Cycle Link File22489
PA70101PA Project Series Report Options22054
PA41701APA Project Source Setup22496
PA60020PA Project Template Billing Cycle Link File22331
PA60040PA Project Template Fee Master22332
PA40203PA Project Template Fee Sched Master File22050
PA41601PA Project Template File22028
PA60030PA Project Template RR Cycle Link File22497
PA30600PA Purchase Order History22073
PA10601PA Purchase Order Line22064
PA30601PA Purchase Order Line History22074
PA42201PA Purchase Order Setup22009
PA10602PA Purchase Order Tax22288
PA30602PA Purchase Order Tax History22287
PA10600PA Purchase Order Work22063
GST00105PA Purchasing Tax History22529
SY00500PA Report Posting Definitions Master22612
POP30100PA Report Purchase Order History22446
POP10110PA Report Purchase Order Line22495
POP30110PA Report Purchase Order Line History22584
POP10100PA Report Purchase Order Work22433
POP30000PA Report Purchasing Batch History22611
POP30390PA Report Purchasing Distribution History22614
POP10390PA Report Purchasing Distribution Work22613
POP30300PA Report Purchasing Receipt History22597
POP10310PA Report Purchasing Receipt Line22601
POP30310PA Report Purchasing Receipt Line History22604
POP10300PA Report Purchasing Receipt Work22585
PA33302PA Rev Recognition Budget DTL HIST File22313
PA23304PA Rev Recognition Budget DTL Work File22309
PA33305PA Rev Recognition Distribution History22316
PA23305PA Rev Recognition Distribution Work22315
PA33303PA Rev Recognition Fee DTL HIST File22314
PA23303PA Rev Recognition Fee DTL Work File22311
PA33301PA Rev Recognition Header HIST File22337
PA23301PA Rev Recognition Header Work File22131
PA33304PA Rev Recognition Proj Detail HIST File22338
PA23302PA Rev Recognition Proj Detail WORK File22144
PA02010PA RR Cycle MSTR22490
PA41301PA Segment Override Header22239
PA41302PA Segment Override Line22038
PA41304PA Segment Override Template Detail22252
PA41303PA Segment Override Template Header22251
PA00502PA Third Party Customer MSTR22536
PA00503PA Third Party Customer MSTR122542
PA10001PA Timesheet Detail File22036
PA30101PA Timesheet Detail History File22045
PA30103PA Timesheet Distribution History22232
PA10003PA Timesheet Distribution WORK22235
PA10000PA Timesheet Header File22035
PA30100PA Timesheet Header History File22037
PA41801PA Timesheet Setup22005
PA00000PA Trigger Settings22242
PA40102PA U of M Schedule Detail Setup22271
PA40101PA U of M Schedule Setup22292
PA43102PA User Defined Bill Format DTL SETP22089
PA43101PA User Defined Bill Format SETP22008
PA40401PA Users Class Master22018
PA01501PA Users Master22017
PA40901PA Vendor Class Setup22020
PA00901PA Vendor MSTR22033
PA01100PA_ContractList_View22583
PA00504PA_Customer_MSTR_II22562
PA01200PA_ProjectListView22589
PA40030paAllocationDtl22391
PA40020paAllocationHdr22413
PA44011paBenefitAllocationSetup22458
PA44012paBenefitSetup22461
PA44013paBenefitSetupDetail22462
PA30905PAInventory Transaction Bin Quantities History22629
PDK00200Palette Master22254
PDK01800Palette Template22253
PA14200paProjectAllocation22464
PA34010paProjectAllocationProcessed22465
PA43010paTS0122537
PAUPR01paUPRFICA22563
PDK01601PDK Billing Notes Master22160
PDK00001PDK Data Conversion Status22247
PDK10503PDK eExpense22554
PDK00102PDK Employee Expense Delegates22347
PDK10500PDK Employee Expense HDR22067
PDK10501PDK Employee Expense LINE22148
PDK10502PDK Employee Expense Tax WORK22161
PDK90003PDK File Error Log22248
PDK03900PDK Record Notes Master22240
PDK01000PDK Registration Master22243
PDK70101PDK Report Options22246
PDK90100PDK Security22256
PDK00101PDK Timesheet Delegates22348
PDK10000PDK Timesheet HDR22224
PDK10001PDK Timesheet LINE22236
PDK00300PDK Timesheet Template Header22208
PDK00301PDK Timesheet Template LINE22392
PDK40001PDK Users22244
PDK40000PDK Users Class22262
PDK_SQL_OptionsPDK_SQL_Options22212
PDK_VersionPDK_Version22353
PDK70300Report Option Names22255
PDK02000Security Restrictions22260
PDK02400System Password Master22263
SY02600User Notes Master22261
SY02600User Notes Master22264
PDK00700Window Notes Master22241
PDK00400Work Menu Master22266
Project Accounting

Dynamics GP Security – Resource – Task – Roles – Company Link

Dynamics GP Security – Resource – Task – Roles – Company Link

GP Security

Updates –
1) User names with ID’s are located at DYNAMICS..SY01400
2) Extract list of SQL Users in SQL Database : SELECT * FROM sys.database_principals where type =’S’
3) Extract list of Members in DYNGRP roles : SELECT USER_NAME(memberuid) FROM sys.sysmembers WHERE USER_NAME(groupuid) = ‘DYNGRP’
4) Extract list of users having access to Dynamics GP Database : select * from dynamics..sy60100
5) Setting up a GP user – 1 – Run macro to create the user in GP
6) Setting up a GP user – 2 – Add the user id SY60100 Table (user existing record as template – change company id (SY01500))
7) Setting up a GP user – 3 – Add user to DB – Create user [USERID] for login [USERID] at company database
8) Setting up a GP user – 4 – Add user to DYNGRP – exec sp_Addrolemember ‘DYNGRP’ , ‘USERID’ at company database

Cheers!
Sanjay

GP Tables

Manufacturing

TABLEDESCRIPTIONGROUPRESOURCE ID
BM010115Bill Of Material Line FileBOM22007
BM010300Bill Of Materials Log FileBOM22012
BM010200BOM <--> Routing LinkBOM22015
BM010415BOM RevisionBOM22214
BMS10000BOM SecurityBOM22660
BC010000Buyer CodesInventory22065
CT40401IC COST Item Class SetupInventory22912
CT00102IC COST Item MasterInventory22913
CT00001IC COST Standard Company DefaultsInventory22917
CT00002IC COST Standard Item Class DefaultsInventory22915
CT00003IC COST Standard Item DefaultsInventory22916
IVR10300Inventory Item ABC SettingsInventory22614
IVR10015Item Engineering FileInventory22004
IVR40400Manufacturing Item Class SetupInventory22803
ICGL0102Manufacturing Series GL LineInventory22906
IVIC0200Manufacturing Series Inventory HeaderInventory22895
IVIC0101Manufacturing Series Inventory LineInventory22897
IVR40500Manufacturing Series Item Class Fulfill SetupInventory22871
IC10200Manufacturing Series Purchase ReceiptsInventory22000
WO010701Manufacture Order Closing FileMOP22046
WO010615Manufacture Order Finished Serial AssignMOP22045
WOA01060Manufacture Order Finished Serial Assign ArchiveMOP22175
WO010213Manufacture Order HistoryMOP22117
WO010302Manufacture Order Lot IssueMOP22115
WO010400Manufacture Order Lot/Serial IssueMOP22113
WO010032Manufacture Order MasterMOP22044
WOUF0132Manufacture Order Reporting OptionsMOP22238
WO010515Manufacture Order Serial IssueMOP22114
WOPS0100Manufacture Order Setup FileMOP22123
WO010116MOP Historical VarianceMOP22135
PK010033Picklist FileMOP22109
PK020031Picklist File for a single Finished GoodMOP22389
MOP10213Manufacture Order ActivityMOP22329
MOP1600Manufacture Order Complete Close WorkMOP22364
MOP10223Manufacture Order LockingMOP22319
MOP1020Manufacture Order Lot IssueMOP22330
MOP1030Manufacture Order Lot IssueMOP22349
MOP1027Manufacture Order Lot IssueMOP22398
MOP1090Manufacture Order Lot Issue HISTMOP22420
MOP1025Manufacture Order Pending BinMOP22403
MOP1095Manufacture Order Pending Bin HISTMOP22419
MOP1026Manufacture Order Pending Bin TrxMOP22402
MOPV1100Manufacturing Order List ViewMOP22504
MF010130MPS LineMPS22187
MF010330MPS Line HeaderMPS22687
MF010030MPS MasterMPS22169
MF010230MPS ScheduleMPS22688
MF010430MPS Transaction LogMPS22690
MP010000Manufacture Order LockingMRP22509
MP030000MRP Exclusion ListMRP22610
MPS10000MRP SecurityMRP22206
MPPS0130MRP Setup FileMRP22149
MP040000MRP StatusesMRP22241
RT010500Routing Cycle TimeRouting22723

GP Tables

Payables Management

TableDescriptionResource ID
PM00100Class Master File49
PM00101Vendor Class Accounts638
PM00200Vendor Master File48
PM00201Vendor Master Summary182
PM00202Vendor Master Period Summary225
PM00203Vendor Accounts639
PM00204Purchasing 1099 Period Detail1245
PM00300Address Master50
PM00400Key Master File181
PM10000Transaction WORK File223
PM10100Distribution WORK OPEN202
PM10200Apply To WORK OPEN File191
PM10201Payment Apply To Work File211
PM10300Payment WORK212
PM10400Manual Payment WORK File209
PM10500Tax Work File220
PM10600Distribution Void WORK Temporary File201
PM10801Payment Stub Duplicate406
PM10900Void Payment WORK Temporary File227
PM10901Void Transaction WORK Temporary File229
PM10902Tax Void Work Temporary File219
PM20000Transaction OPEN File192
PM20100Apply To OPEN OPEN Temporary File195
PM20200Distribution OPEN OPEN Temporary File196
PM20400Scheduled Payments Header979
PM20401Scheduled Payment LINE1033
PM30200Paid Transaction History File210
PM30300Apply To History File194
PM30401Scheduled Payments Header History984
PM30600Distribution History File199
PM30700Tax History File218
PM30800Tax Invoices854
PM40100Setup File183
PM40101Period Setup File176
PM40102Payables Document Types203
PM40103Payables Distribution Type SETP457
PM401041099 Setup File1214
PM50100History Removal Tempoary File787
PM70500Purchasing Report Options177
PM80100Reprint Transaction Batch Headers214
PM80200Void Reprint Void Payment WORK134
PM80300Reprint Void Transaction WORK132
PM80500Reprint Posting Journal Apply To File213
PM80600Reprint Distribution215
PM80700Reprint Tax216
PM80800Reprint Transaction Check Register File217
PM80900Mass Voucher Apply Temp File619
PM80905Payables Apply Document Browse108
PM80950Remittance Temp1343
PM80960Exception List Temp1342
PM81000Modified Vendor Class Accounts646
PMV0100Scheduled Payment Header View985

GP Tables

Receivable Management

TABLEDESCRIPTIONRESOURCE ID
RM00101Customer Master141
RM00102Customer Master Address167
RM00103Customer Master Summary161
RM00104Customer Period Summary166
RM00105National Accounts Master654
RM00106Statements E-mail Addresses928
RM00201Class Master165
RM00301Salesperson Master155
RM00302Salesperson Master Summary156
RM00303Sales Territory Master153
RM00305Sales Territory Master Summary154
RM00401Key147
RM00500Extended Pricing Price Sheet Links1056
RM00700Report Options179
RM10101Distribution Work146
RM10201Cash Receipts Work151
RM10301Sales Work148
RM10501Commission Work152
RM10504Unpaid Removed Commissions360
RM10601Tax Work157
RM10901Aging Reconcile Control278
RM20101Open143
RM20101Open Debit Copy752
RM20102Realtime Posting348
RM20201Apply Open150
RM20400Scheduled Payment Header1035
RM20401Scheduled Payment Line1038
RM30101History344
RM30201Apply History337
RM30202Apply Reprint Journal357
RM30301Receivables GL Distribution History342
RM30401Scheduled Payment Header History1036
RM30501Commission History340
RM30502Batch History163
RM30601Tax History352
RM30701Reprint Statements Header923
RM30702Reprint Statements Transactions926
RM40101Module Setup185
RM40102Reprint Statements Identifier924
RM40201Period Setup145
RM40401Document Type Setup144
RM40501Statements Options351
RM40601Statement Messages Setup350
RM50100History Removal Tempoary826
RM50101Statements Emailed Header Temp929
RM50102Statements Emailed RecipientsTemp930
RM50103Email Statements Header Temporary1086
RM50104Email Statements Transactions Temporary1087
RMV0100Scheduled Payment Header View1037

GP Tables

Inventory

TABLEDESCRIPTIONRESOURCE ID
IV00101Item Master364
IV00102Item Quantity Master372
IV00103Item Vendor Master367
IV00104Item Kit Master366
IV00105Item Currency Master777
IV00106Item Purchasing776
IV00107Item Price List Options833
IV00108Item Price List832
IV00109Item Serial Number Mask831
IV00111Site Defaults935
IV00112Item Site Bin Master981
IV00115Multiple Manufacture Items Master1134
IV00117Item Site Bin Priorities1082
IV00118Item Cost Change History1183
IV00200Item Serial Number Master383
IV00300Item Lot Number Master377
IV00301Item Lot Attribute Master376
IV10000Inventory Transaction Work394
IV10001Inventory Transaction Amounts Work395
IV10002Inventory Serial and Lot Number Work396
IV10003Inventory Transaction Bin Quantities Work983
IV10004Inventory Bin Quantity Transfer1027
IV10200Inventory Purchase Receipts Work378
IV10201Inventory Purchase Receipts Detail1165
IV10300Stock Count861
IV10301Stock Count Line862
IV10302Stock Count Serial Lot863
IV10303Stock Count U of M864
IV30100Inventory Transaction Batch History390
IV30101Inventory Sales Summary History385
IV30102Inventory Sales Summary Period History386
IV30200Inventory Transaction History391
IV30300Inventory Transaction Amounts History392
IV30301Inventory Transaction Detail History128
IV30302Inventory Transaction Bin Quantities History982
IV30400Item Serial and Lot Number History393
IV30500Inventory Distribution History363
IV30600Item Lot Attribute History463
IV30700Stock Count History866
IV30701Stock Count Line History867
IV30702Stock Count Serial Lot History868

GP Tables

General Ledger

TABLEDESCRIPTIONRESOURCE ID
GL00100Breakdown Account Master10014
GL00100Account Master3
GL00100Distribution Account Master10013
GL00102Account Category Master7
GL00103Fixed Allocation Master6
GL00104Variable Allocation Master5
GL00105Account Index Master531
GL00200Budget Master18
GL00201Budget Summary Master19
GL10000Transaction Work11
GL10001Transaction Amounts Work13
GL10002Transaction Clearing Amounts Work12
GL10100Quick Journal Work15
GL10101Quick Journal Amounts Work16
GL10110Account Current Summary Master4
GL10111Account Summary History42
GL10300General Ledger Tax Work936
GL11000GL Distribution Register Temporary102
GL12000Budget Transaction Work1344
GL12001Budget Transaction Amounts Work1346
GL20000Year-to-Date Transaction Open46
GL30000Account Transaction History45
GL32000Budget Transaction History1345

GP Tables

Purchase Order Processing

TableDescriptionResource ID
POP00101Buyer Master751
POP10100Purchase Order Work586
POP10110Purchase Order Line581
POP10140Purchasing Manufacturer Numbers1135
POP10150Purchase Order Comment371
POP10160Purchase Order Tax909
POP10300Purchasing Receipt Work585
POP10306Purchasing Receipt User-Defined931
POP10310Purchasing Receipt Line587
POP10330Purchasing Serial Lot Work588
POP10340Purchasing Bin Quantities Work1186
POP10360Purchasing Tax589
POP10390Purchasing Distribution Work590
POP10500Purchasing Receipt Line Quantities583
POP10550Purchasing Comment582
POP10600Purchasing Shipment Invoice Apply641
POP10700Purchasing Landed Cost939
POP30000Purchasing Batch History607
POP30100Purchase Order History598
POP30110Purchase Order Line History596
POP30160Purchase Order Tax History910
POP30300Purchasing Receipt History591
POP30310Purchasing Receipt Line History592
POP30330Purchasing Serial Lot History593
POP30340Purchasing Bin Quantities History1185
POP30360Purchasing Tax History594
POP30390Purchasing Distribution History595
POP30700Purchasing Landed Cost History940

GP Tables

Sales Order Processing

TableDescriptionResource ID
SOP00100Sales Process Holds Master451
SOP00200Sales Prospect Master527
SOP00300
Sales Customer Item Substitute1160
SOP10100
Sales Transaction Work438
SOP10101
Sales Commissions Work and History447
SOP10102Sales Distribution Work and History525
SOP10103Sales Payment Work and History523
SOP10104Sales Process Holds Work and History449
SOP10105Sales Taxes Work and History537
SOP10106Sales User-Defined Work History749
SOP10107Sales Tracking Numbers Work History1015
SOP10200Sales Transaction Amounts Work465
SOP10201Sales Serial/Lot Work and History462
SOP10202Sales Line Comment Work and History464
SOP10203
Sales Order Bin Quantities Work and History968
SOP30100Sales Batch History544
SOP30200Sales Transaction History448
SOP30201Sales Deposit History493
SOP30300Sales Transaction Amounts History461
SOP60200Sales Picking Instruction Cross Reference1149
SOP60300Sales Customer Item Cross Reference1158

GP Tables

System

TableDescriptionComments
SY09000Security Tasks Master
SY09100
Security Roles Master
SY09400

GP Securable Resources
SY10500
Security Assignment User Role
SY10600
Security Assignment Role Task
SY10700
Security Assignment Task Operations
SY60100User-Company Access