Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our BS scripts. All of our scripts for Dynamics GP can be found here
BS Scripts
 
No records to display.
Module List > Module COMPANY..BS tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change


ClearPixel
Freq
Used
 Display Name
 B3900000BSSI_Palette_Activity
 B3900001BSSI_1099SmartListWork
 B3900100BSSI_Setup
 B3900101BSSI_Facility_Acct_Subst_Setup
 B3900102BSSI_FA_Acct_Subst_Setup
 B3900103BSSI_Facility_Item_Transfer_Setup
 B3900104BSSI_Facility_Item_Rel_HDR
 B3900105BSSI_Facility_Item_Rel_LINE
 B3900106BSSI_User_Mapping
 B3900107BSSI_PM1099SETP
 B3900110BSSI_Facility_DocumentID_Setup
 B3900120BSSI_Facility_DocumentID_Hdr
 B3900130BSSI_PO_Type_Setup
 B3900140BSSI_Rcpt_Type_Setup
 B3900150BSSI_RcptNumber_Key_MSTR
 B3900160BSSI_PONumber_Key_MSTR
 B3900170BSSI_Facility_Account_Setup
 B3900200BSSI_User_Facility
 B3900201BSSI_Advanced_User_Facility
 B3900202BSSI_User_Default_Facility
 B3900204BSSI_pm1099PeriodDtl
 B3900208BSSI_1099TaxRegistration
 B3900210BSSI_UserClass_Facility
 B3900211BSSI_Adv_UserClass_Facility
 B3900220BSSI_Facility_Vendor
 B3900230BSSI_Facility_VendorClass
 B3900240BSSI_Facility_Site
 B3900241BSSI_Facility_Site_BP
 B3900250BSSI_Facility_Employee
 B3900260BSSI_Facility_EmployeeClass
 B3900270BSSI_Facility_Customer
 B3900271BSSI_Facility_Portfolio
 B3900272BSSI_Facility_Item
 B3900280BSSI_Facility_CustomerClass
 B3900281BSSI_Facility_Item_Class
 B3900290BSSI_Facility_Asset
 B3900291BSSI_Facility_AssetClass
 B3900292BSSI_AssetContext
 B3900293BSSI_FA_General_Information_WORK
 B3900294BSSI_FA_AP_Post_MSTR
 B3900295BSSI_FA_Form_Context
 B3900296BSSI_FA_CreateGroup_FormContext
 B3900297BSSI_FA_Report_Parameters
 B3900298BSSI_Assign_Exception_WORK
 B3900300BSSI_UserFacility_TEMP
 B3900310BSSI_MultiFacility_TEMP
 B3900311BSSI_MultiFacility_SOPInq_Temp
 B3900312BSSI_PM_Check_Register_TEMP
 B3900314BSSI_MuliFacility_TRX_Temp
 B3900315BSSI_MultiFacility_REP_Temp
 B3900316BSSI_Reports_Queue
 B3900317BSSI_MultiFacility_Rep_Queue
 B3900318BSSI_Reports_Queue_Status
 B3900319BSSI_SY_Key_TEMP
 B3900320BSSI_PM_Key_MSTR_TEMP
 B3900325BSSI_IntercompanyRefTemp
 B3900328BSSI_Mass_Check_Temp
 B3900330BSSI_SY_Report_Option
 B3900400BSSI_Facility_Setup
 B3900401BSSI_Facility_Segment
 B3900402BSSI_Centralize_AR_Setup
 B3900403BSSI_Cent_AR_Child_Facility
 B3900500BSSI_Facility_Acct_SETP
 B3900600BSSI_Facility_Alloc_SETP
 B3900601BSSI_Facility_Alloc_Hist
 B3900610BSSI_CN_Query_MSTR
 B3900700BSSI_Facility_Alloc_Hdr
 B3900800BSSI_Facility_Check_SETP
 B3900850BSSI_AP_Repl_Template_HDR
 B3900851BSSI_AP_Repl_Template_Line
 B3900900BSSI_Batch_Header
 B3900901BSSI_Batch_Temp
 B3900902BSSI_AdvanceAcctSubsSetup
 B3900903BSSI_PeriodCloseByFacility
Freq
Used
 Display Name
 B3910000BSSI_IV_TRX_WORK_HDR
 B3910001BSSI_IV_TRX_HIST_HDR
 B3910002BSSI_IV_TRX_HIST_Batch
 B3910003BSSI_IV_Assembly_HIST_Batch
 b3910004BSSI_IV_SVC_Transfer_HDR
 B3910005BSSI_IV_TRX_WORK_LINE
 B3910006BSSI_IV_TRX_HIST_LINE
 B3910007BSSI_PDK_Timesheet_HDR
 B3910100BSSI_PO_Header
 B3910102BSSI_JC_Job_MSTR
 B3910200BSSI_IV_Assembly_Work
 B3910300BSSI_POP_Receipt_Hdr
 B3910301BSSI_IV_Stock_Count_WORK
 b3910304BSSI_IV_SVC_Transfer_HDR_Hist
 B3910310BSSI_POP_Dist_Allocation
 B3910320BSSI_POP_Dist_Original
 B3910400BSSI_AP_Replicator_Work_HDR
 B3910401BSSI_AP_Replicator_Work_DTL
 B3910500BSSI_PM_BEGINBAL
 B3910501BSSI_RM_BEGINBAL
 B3910502BSSI_GL_BEGINBAL
 B3910503BSSI_GL_OPEN_BEGINBAL
 B3910504BSSI_PDK_Emp_Exp_HDR
 B3910505BSSI_RM_Customer_MSTR_SUM
 B3910506BSSI_CNAgingPercentageWORK
 B3910507BSSI_SVC_RMA_MSTR
 B3910508BSSI_SVC_RTV_MSTR
 B3910509BSSI_SVC_RMA_MSTR_HIST
 B3910510BSSI_SVC_RTV_MSTR_HIST
 B3910700BSSI_RM_Options_ROPT
 B3910800BSSI_MC_Rev_HDR_WORK
 B3915000BSSI_FA_Retirement_MSTR
 B3915010BSSI_FA_Transfer_MSTR
 B3915020BSSI_FA_Select_Asset_HDR
 B3915021BSSI_FA_Select_Asset_HDR_Facilities
 B3919901BSSI_WSJCJobMSTR
 B3919905BSSI_WSJCInvoiceWORK
 B3919908BSSI_WSJCUnitTRXHDRWORK
 B3919909BSSI_WSJCUnitTRXHDROPEN
Freq
Used
 Display Name
 B3920000BSSI_PM_Transaction_Work
 B3920001BSSI_PM_Transaction_OPEN
 B3920100BSSI_PM_Original_Distribution_WORK
 B3920101BSSI_PM_Original_Distribution_OPEN
 B3920102BSSI_PM_Original_Distribution_Paid_HIST
 B3920200BSSI_PM_Paid_Transaction_HIST
 B3920300BSSI_PM_Payment_WORK
 B3920310BSSI_PM_Dist_Allocation
 B3920320BSSI_PM_Dist_Allocation_Hist
 B3920330BSSI_PM_Dist_Allocation_Paid_Hist
 B3920400BSSI_PM_Manual_WORK
 B3920401BSSI_PM_SCH_HDR_HIST
 B3920402BSSI_RM_SCH_HDR_HIST
 B3920410BSSI_PM_SCH_HDR
 B3920411BSSI_RM_SCH_HDR
 B3920420BSSI_PM_MassVoucher_Temp
 B3920430BSSI_AP_Replicator_Open_HDR
 B3920431BSSI_AP_Replicator_Open_DTL
 B3920440BSSI_AP_Replicator_Hist_HDR
 B3920441BSSI_AP_Replicator_Hist_DTL
 B3920601BSSI_CM_Transfer_Log
 B3921000BSSI_PM_Trx_HDR_WORK
Work Tables
Freq
Used
 Display Name
 B3930000BSSI_GL_Account_TRX_HIST
 B3930100BSSI_SOP_HDR_WORK
 B3930101BSSI_SOP_Extra_Temp
 B3930200BSSI_SOP_HDR_HIST
 B3930201BSSI_IV_Assembly_HIST
 B3930300BSSI_IVC_HDR_WORK
 B3930400BSSI_IVC_HDR_HIST
 B3930500BSSI_SOP_Restriction_MSTR
 B3930600 
 B3930700BSSI_IV_Stock_Count_HIST
 B3939901BSSI_WSJCJobMSTRHIST
Freq
Used
 Display Name
 B3940100BSSI_GL_TRX_HDR_WORK
 B3940101BSSI_GS_PM_1099
 B3940200BSSI_GL_YTD_TRX_OPEN
 B3940201BSSI_JE_Allocation_Work
 B3940300BSSI_GL_Business_Form_SETP
 B3940301BSSI_GS_PM_1099_HIST
 B3940400BSSI_GL_Business_Form_HDR_WORK
 B3940410BSSI_IVItemMSTR
 B3940420BSSI_IVItemClass
 B3940501BSSI_RM_Statements_ROPT
 B3940700BSSI_IV_Location_SETP
 B3940800BSSI_PM_PPS_TEMP
 B3940801BSSI_PM_Apply_To_HIST_TEMP
 B3941400BSSI_UPRSETPLocalTax
 B3950000BSSI_RM_Sales_Work
 B3950001BSSI_RM_Sales_OPEN
 B3950002BSSI_RM_OPEN_TEMP
 B3950003BSSI_RM_Sales_Work_Temp
 B3950020BSSI_RM_HISTORY
 B3950100BSSI_RM_Cash_WORK
 B3950200BSSI_RM_Receipt_WORK
 B3950310BSSI_RM_Dist_Allocation
 B3950320BSSI_RM_Dist_Allocation_Hist
 B3950330BSSI_RM_Dist_Allocation_Paid_Hist
 B3950340BSSI_RM_Original_Distribution_WORK
 B3950341BSSI_Distribution_Work_Temp
 B3950350BSSI_RM_Original_Distribution_OPEN
 B3950360BSSI_RM_Original_Distribution_Hist
 B3960000BSSI_SVC_Contract_Type
 B3960001BSSI_SVC_Contract_Type_TEMP
 B3960002BSSI_SVC_RMA_Dist_TEMP
 B3960003BSSI_SVC_RTV_Dist_TEMP
 B3960100BSSI_SVC_Contract_HDR
 B3960200BSSI_SVC_Contract_HIST
 B3960400BSSI_PA_Misc_Log_HDR
 B3960410BSSI_PA_Log_HDR_Hist
 B3960420BSSI_PA_IV_Trfr_WORK_HDR
 B3960430BSSI_PA_IV_Trfr_HDR_Hist
 B3960440BSSI_PA_Timesheet_WORK_HDR
 B3960441BSSI_PA_Line_Allocation
 B3960443BSSI_PA_Line_Alloc_Hist
 B3960450BSSI_PA_Timesheet_HDR_Hist
 B3960460BSSI_PA_Billing_Hdr_Work
 B3960465BSSI_PA_Billing_Hdr_Open
 B3960470BSSI_PA_Billing_Hdr_Hist
 B3960500BSSI_PA_Project_Mstr
 B3960600BSSI_PA_Contract_Mstr
 B3960650BSSI_PA_ChangeOrder_Work
 B3960660BSSI_PA_ChangeOrder_Open
 B3960700BSSI_PA_Equipment_Mstr
 B3960710BSSI_PA_Equipment_Log_WORK_HDR
 B3960720BSSI_PA_Equipment_Log_HDR_HIST
 B3960750BSSI_PA_Cost_Category_MSTR
 B3960800BSSI_PA_Miscellaneous_Mstr
 B3960850BSSI_PA_Fee_Mstr
 B3960900BSSI_PA_Employee_Expense_WORK_HDR
 B3960910BSSI_PA_Employee_Expense_HDR_HIST
 B3961000BSSI_PA_Rev_Recog_HDR_WORK
 B3961001BSSI_PA_Rev_Recog_HDR_HIST
 B3970100BSSI_PO_Header_Hist
 B3970300BSSI_POP_Receipt_Hdr_Hist
 B3970310BSSI_POP_Dist_Allocation_Hist
 B3970320BSSI_POP_Dist_Original_Hist
 B3970500BSSI_SVC_Options_ROPT
 B3971000BSSI_MFG_MOP_Receipt_MSTR
 B3971001BSSI_MFG_MOP_Order_MSTR
 B3971002BSSI_MFG_MOP_Close
 B3971200BSSI_MFG_MOP_PickDoc_MSTR
 B3979000BSSI_BAS_ReportOptions
 B3980100BSSI_SY_Location_MSTR
 B3980101BSSI_uprSetupSupervisor
 B3980102BSSI_UPR_SETP_Workers_Comp
 B3980103BSSI_UPR_Setup_Shift_Code
 B3980104BSSI_UPR_SETP_Futa/Suta
 B3980105BSSI_UPR_Futa/Suta_TSA
 B3980106BSSI_Direct_Deposits_ACH
 B3980107BSSI_GS_FUTA_Capture
 B3980108BSSI_GS_SUTA_Capture
 B3980109BSSI_GS_941_Capture
 B3980110BSSI_UPR_MSTR
 B3980111BSSI_UPR_MSTR_Pay_Type
 B3980200BSSI_Employee_Pay_Run
 B3980201BSSI_CheckBook_CheckNumb
 B3980210BSSI_UPR_WORK_HDR
 B3980220BSSI_ddTrxHistDetail
 B3980230BSSI_UPR_Transaction_HIST
 B3980240BSSI_UPR_Check_HIST
 B3980250BSSI_UPR_Manual_Check_HDR
 B3980251BSSI_UPR_Batch_HDR
 B3980260BSSI_UPR_Distribution_WORK
 B3980270 
 B3980280BSSI_UPRTRXBatchDetail
 B3980281BSSI_UPR_TEMP_WORK
 B3980282BSSI_UPRWORKPost
 B3980283 
 B3980284BSSI_UPRTransactionHIST
 B3980300BSSI_Period_End_Facility
 B3990000BSSI_1099_Amounts
 B3999999BSSI_IV_TRX_WORK_TRANSFER
 BSSI0200BSSI_Product_Setup
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3