Table and Column Changes in Dynamics GP 2013 R2
Views (17538)
Like
Share
ReportHello everyone!
This blog post is going to list out all the Table and Column changes for GP 2013 R2. This is a big release, with a lot of great new features, and subsequently has a lot of back end changes! I've included some links to help with navigating through this information, along with a "Back to Top" link at the end of each section. Take note that the columns listed in the New Columns section includes column changes to pre-existing tables, and new tables. The third section separates out the column changes to pre-existing tables.
If you have further questions about index, data type, and segments information, please review the SDK documentation for a more in-depth look into the changes.
New Columns in Existing Tables
New Tables:
| Table Technical Name | Table Physical Name |
| cmUnreconciledTrx | CM20502 |
| coAttachEmail | CO00105 |
| coAttachProperties | CO00103 |
| coAttachStatus | CO00104 |
| GL_Transaction_Paste_TEMP | TEMP |
| ivItemClassIncludeInCatalog | IV00120 |
| ivItemIncludeInCatalog | IV00119 |
| IV_Site_Item_Assignments_TEMP | TEMP |
| IV_Suggest_Sales_Analysis_Line_TEMP | TEMP |
| PM_Vendor_Combiner_Modifier_TEMP | TEMP |
| PM_Vendor_Validation_TEMP | TEMP |
| popFeaturedItems | POP40300 |
| popRequisition | POP10200 |
| popRequisitionHist | POP30200 |
| popRequisitionInquiryTemp | TEMP |
| popRequisitionLine | POP10210 |
| popRequisitionLineHist | POP30210 |
| popRequisitionLineTemp | TEMP |
| popRequisitionTemp | TEMP |
| popRequisitionUserAccess | POP40200 |
| popRequisitionUserAccessTemp | TEMP |
| QueryDesigner_Conditions | CO00123 |
| QueryDesigner_ConditionsTemp | TEMP |
| QueryDesigner_FieldLinkTemp | TEMP |
| QueryDesigner_FieldsList | CO00121 |
| QueryDesigner_FieldsListTemp | TEMP |
| QueryDesigner_Relationships | CO00122 |
| QueryDesigner_RelationshipsTemp | Temp |
| rmEmailStmtsHDRTemp | RM50105 |
| RM_Customer_Combiner_Modifier_TEMP | TEMP |
| RM_Customer_Validation_TEMP | TEMP |
| syEmailCardAddress | SY04906 |
| syEmailCardAddressTemp | TEMP |
| syEmailDocumentLines | SY04930 |
| syOfflineCompanies | SY01800 |
| syOfflineCompaniesHistory | SY01801 |
| sySelectedUserMessage | TEMP |
| syUserMessages | SY30000 |
| SY_BackupRestoreMSTR | SY01451 |
| TimecardCurrentListTemp | TEMP |
| uprMstrTCAssignment | UPR00210 |
| uprMstrTCAssignmentDetail | UPR00211 |
| uprMstrTCAssignmentDetailTemp | TEMP |
| uprMstrTimeonBehalf | UPR00200 |
| uprMstrTimeonBehalfClass | UPR00202 |
| uprMstrTimeonBehalfDept | UPR00201 |
| uprMstrTimeonBehalfEmp | UPR00203 |
| uprMstrTimeonBehalfTEMP | TEMP |
| uprReportsToStructureForEmp | TEMP |
| uprSetupBatchPrefix | UPR42500 |
| uprSetupBatchPrefixClass | UPR42504 |
| uprSetupBatchPrefixDept | UPR42502 |
| uprSetupBatchPrefixEmployee | UPR42505 |
| uprSetupBatchPrefixLocation | UPR42501 |
| uprSetupBatchPrefixPosition | UPR42503 |
| uprSetupBatchPrefixTEMP | TEMP |
| uprSetupPayScheduleClass | UPR42105 |
| uprSetupPayScheduleClassTEMP | TEMP |
| uprSetupPayScheduleDept | UPR42103 |
| uprSetupPayScheduleDeptTEMP | TEMP |
| uprSetupPayScheduleDtl | UPR42101 |
| uprSetupPayScheduleDtlTEMP | TEMP |
| uprSetupPayScheduleEmployee | UPR42106 |
| uprSetupPayScheduleEmployeeTEMP | TEMP |
| uprSetupPayScheduleHdr | UPR42100 |
| uprSetupPayScheduleLocation | UPR42102 |
| uprSetupPayScheduleLocationTEMP | TEMP |
| uprSetupPaySchedulePosition | UPR42104 |
| uprSetupPaySchedulePositionTEMP | TEMP |
| uprSetupScheduleSequence | UPR42110 |
| uprSetupScheduleSequenceTEMP | TEMP |
| uprSetupScheduleUnSequenceTEMP | TEMP |
| uprSetupTCAssignment | UPR42300 |
| uprSetupTCAssignmentDetail | UPR42301 |
| uprSetupTCAssignmentDetailTemp | TEMP |
| uprSetupTimeCardRestrictions | UPR42400 |
| uprSetupTimeCardRestrictionsClass | UPR42405 |
| uprSetupTimeCardRestrictionsDept | UPR42403 |
| uprSetupTimeCardRestrictionsDTL | UPR42401 |
| uprSetupTimeCardRestrictionsEmployee | UPR42406 |
| uprSetupTimeCardRestrictionsLocation | UPR42402 |
| uprSetupTimeCardRestrictionsPosition | UPR42404 |
| uprSetupTimeCardRestrictionsTEMP | TEMP |
| uprSetupTimeonBehalf | UPR42200 |
| uprSetupTimeonBehalfClass | UPR42202 |
| uprSetupTimeonBehalfDept | UPR42201 |
| uprSetupTimeonBehalfEmp | UPR42203 |
| uprSetupTimeonBehalfTEMP | TEMP |
| uprTimecardDtl | UPR10501 |
| uprTimecardEntryTrxDtlTEMP | TEMP |
| uprTimecardEntryTrxStartStopTEMP | TEMP |
| uprTimecardEntryTrxTEMP | TEMP |
| uprTimecardHdr | UPR10500 |
| uprTimecardStartStopDtl | UPR10502 |
| uprTimecardTemplateStartStop | UPR00222 |
| uprTimecardTemplateTrx | UPR00220 |
| uprTimecardTemplateTrxDtl | UPR00221 |
| uprTimecardTemplTrxDtlTEMP | TEMP |
| uprTimecardTemplTrxStartStopTEMP | TEMP |
| uprTimecardTemplTrxTEMP | TEMP |
| uprTmcdDtlHIST | UPR30501 |
| uprTmcdHdrHIST | UPR30500 |
| uprTmcdStartStopHIST | UPR30502 |
| UPR_SETP_Timecard_Options | UPR40202 |
| Workflow_Calendar | WF40300 |
| Workflow_Calendar_Down_Days | WF40310 |
| Workflow_Document_Steps | TEMP |
| Workflow_Email_Notifications | WF40400 |
| Workflow_History | WF30100 |
| Workflow_History_Scroll_TEMP | TEMP |
| Workflow_History_TEMP | TEMP |
| Workflow_Instance | WFI10002 |
| Workflow_Master | WF100002 |
| Workflow_Roles | WF40201 |
| Workflow_Setup | WF00100 |
| Workflow_Step | WF100003 |
| Workflow_Step_Instance | WFI10003 |
| Workflow_Step_Instance_Users | WFI10005 |
| Workflow_Tasks | WFI10004 |
| Workflow_Tasks_Homepage_TEMP | TEMP |
| Workflow_Template_Fields | WF40202 |
| Workflow_Template_Fields_TEMP | TEMP |
| Workflow_Type | WF100001 |
| Workflow_Type_Conditions_TEMP | TEMP |
| Workflow_Type_TEMP | TEMP |
| Workflow_Users | WF40200 |
| Workflow_User_Delegation_LINE | WF40510 |
| Workflow_User_Delegation_MSTR | WF40500 |
| Workflow_User_Security | WF00104 |
New Columns:
| Table Technical Name | Table Physical Name | Field Technical Name | Field Physical Name |
| cmUnreconciledTrx | CM20502 | Audit Trail Code | AUDITTRAIL |
| Checkbook ID | CHEKBKID | ||
| Cleared Amount | ClrdAmt | ||
| Cleared Date | clearedate | ||
| CM Trx Number | CMTrxNum | ||
| CM Trx Type | CMTrxType | ||
| CMLinkID | CMLinkID | ||
| Currency ID | CURNCYID | ||
| Deposit Type | DEPTYPE | ||
| Description | DSCRIPTN | ||
| Paid ToRcvd From | paidtorcvdfrom | ||
| Reconcile Number | RECONUM | ||
| Record Number | CMRECNUM | ||
| Source Doc Number | SRCDOCNUM | ||
| Source Doc Type | SRCDOCTYP | ||
| Source Document | SOURCDOC | ||
| TRX Amount | TRXAMNT | ||
| TRX Date | TRXDATE | ||
| User ID | USERID | ||
| coAttachEmail | CO00105 | Attachment ID | Attachment_ID |
| BusObjKey | BusObjKey | ||
| Created Date | CREATDDT | ||
| Created Time | CREATETIME | ||
| Delete | DELETE1 | ||
| Document Number | DOCNUMBR | ||
| Email Allow Attachments | EmailAllowAttachments | ||
| File Type | FileType | ||
| fileName | fileName | ||
| Ord | ORD | ||
| Size | Size | ||
| Start Description | STRTDSCR | ||
| coAttachmentTemp | temp | Allow Attachment Email | AllowAttachmentEmail |
| Allow Attachment Flow | AllowAttachmentFlow | ||
| Attachment Image | AttachmentImage | ||
| Attachment Product Details | AttachmentProductDetails | ||
| Delete | DELETE1 | ||
| coAttachMSTR | CO00101 | Attachment Image | AttachmentImage |
| Attachment Product Details | AttachmentProductDetails | ||
| coAttachProperties | CO00103 | Allow Attachments Email | AllowAttachmentsEmail |
| Attachment Attribute Default | AttachAttributeDefault | ||
| Attachment ID | Attachment_ID | ||
| Attribute Short Name | AttributeShortName | ||
| BusObjKey | BusObjKey | ||
| Default Attach Type | DefaultAttachType | ||
| coAttachRef | CO00102 | Allow Attachment Email | AllowAttachmentEmail |
| Allow Attachment Flow | AllowAttachmentFlow | ||
| Attachment Origin | AttachmentOrigin | ||
| Delete | DELETE1 | ||
| coAttachSetup | CO40100 | Allow Attachments Email | AllowAttachmentsEmail |
| Allow To Delete | AllowToDelete | ||
| Attachment Attribute Default | AttachAttributeDefault | ||
| Attribute | Attribute | ||
| Customer Attachment Type | CustomerAttachmentType | ||
| Delete Password | DeletePassword | ||
| Item Attachment Type | ItemAttachmentType | ||
| Vendor Attachment Type | VendorAttachmentType | ||
| coAttachStatus | CO00104 | Attachment ID | Attachment_ID |
| Attachment Status | AttachmentStatus | ||
| BusObjKey | BusObjKey | ||
| Created Date | CREATDDT | ||
| Created Time | CREATETIME | ||
| Created User ID | CRUSRID | ||
| ddACHCopy | DD10200 | IndexLong | INDXLONG |
| ddACHCrossRef | DD10300 | IndexLong | INDXLONG |
| ddACHFtrSetup | DD40400 | IndexLong | INDXLONG |
| ddACHHdr | DD10400 | IndexLong | INDXLONG |
| ddACHHdrSetup | DD40400 | IndexLong | INDXLONG |
| ddACHItems | DD10500 | IndexLong | INDXLONG |
| ddEmpAcctMstr | DD00200 | IndexLong | INDXLONG |
| ddEmpAcctsTemp | temp | IndexLong | INDXLONG |
| ddEmpLineTemp | TEMP | IndexLong | INDXLONG |
| ddEmpMstr | DD00100 | IndexLong | INDXLONG |
| ddExceptions | DD10700 | IndexLong | INDXLONG |
| ddTrxHistDetail | DD30101 | IndexLong | INDXLONG |
| ddTrxHistHdr | DD30100 | IndexLong | INDXLONG |
| EmployeeListTemp | TEMP | User ID | USERID |
| GL_Transaction_Paste_TEMP | TEMP | Account Index | ACTINDX |
| Account Number String | ACTNUMST | ||
| Credit Amount | CRDTAMNT | ||
| Debit Amount | DEBITAMT | ||
| Description | DSCRIPTN | ||
| Error Status | ErrorStatus | ||
| IndexLong | INDXLONG | ||
| ivItemClassIncludeInCatalog | IV00120 | Include In Catalog | INCLUDEINCATALOG |
| Item Class Code | ITMCLSCD | ||
| ivItemIncludeInCatalog | IV00119 | Include In Catalog | INCLUDEINCATALOG |
| Item Number | ITEMNMBR | ||
| IV_Site_Item_Assignments_TEMP | TEMP | Inactive | INACTIVE |
| Inactive Old | InactiveOld | ||
| Item Number | ITEMNMBR | ||
| Landed Cost Group ID | Landed_Cost_Group_ID | ||
| Landed Cost Group ID Old | LandedCostGroupIDOld | ||
| Location Code | LOCNCODE | ||
| Marked | MARKED | ||
| Picking Ticket Item Option | PICKTICKETITEMOPT | ||
| Picking Ticket Item Option Old | PICKTICKETITEMOPTOLD | ||
| Primary Vendor | PRIMVNDR | ||
| Record Type | RCRDTYPE | ||
| Selected To Save | SelectedToSave | ||
| Vendor ID | VENDORID | ||
| VS Inactive Site | VSInactiveSite | ||
| IV_Suggest_Sales_Analysis_Line_TEMP | TEMP | Decimal Places QTYS Suggest Items | DecimalPlacesQTYSSugItem |
| Inactive | INACTIVE | ||
| Item Type | ITEMTYPE | ||
| Match Percent | MATCHPER | ||
| Sales Script | SALESSCRIPT | ||
| Suggest Item Order | SUGITEMORD | ||
| Suggest_Item_Description | SUGITEMDEC | ||
| Suggest_Item_Number | SUGITEMNMBR | ||
| Suggest_Quantity | SUGQUANTITY | ||
| IV_Suggest_Sales_Setup_LINE | IV00401 | Sales Script | SALESSCRIPT |
| IV_Suggest_Sales_Setup_LINE_TEMP | TEMP | Sales Script | SALESSCRIPT |
| MC_PM_Revaluation | MC020105 | Settled Gain or Loss on Current Trx Amount | SettledGainLossCurTrxAmt |
| Settled Gain or Loss on Disc Avail Amount | SettledGainLossDiscAvlAm | ||
| MUPR_DDNextIdx | DD40700 | IndexLong | INDXLONG |
| PM_SETP | PM40100 | PMDefaultCheckSort | PMDefaultCheckSort |
| PM_Vendor_Combiner_Modifier_TEMP | TEMP | IndexLong | INDXLONG |
| Vendor ID From | VendorIDFrom | ||
| Vendor ID To | VendorIDTo | ||
| Vendor Name From | VendorNameFrom | ||
| Vendor Name To | VendorNameTo | ||
| PM_Vendor_Validation_TEMP | TEMP | IndexLong | INDXLONG |
| ValidationMessages | ValidationMessages | ||
| Vendor ID From | VendorIDFrom | ||
| Vendor ID To | VendorIDTo | ||
| popFeaturedItems | POP40300 | Decimal Places Currency | DECPLCUR |
| Item Description | ITEMDESC | ||
| Item Number | ITEMNMBR | ||
| Non IV | NONINVEN | ||
| Ord | ORD | ||
| U Of M | UOFM | ||
| Unit Cost | UNITCOST | ||
| Vendor ID | VENDORID | ||
| popRequisition | POP10200 | Address 1 | ADDRESS1 |
| Address 2 | ADDRESS2 | ||
| Address 3 | ADDRESS3 | ||
| City | CITY | ||
| Comment ID | COMMNTID | ||
| Comment Note Index | Comment_Note_Index | ||
| Company Name | CMPNYNAM | ||
| Contact | CONTACT | ||
| Country | COUNTRY | ||
| Country Code | CCode | ||
| Created Date | CREATDDT | ||
| Document Amount | DOCAMNT | ||
| Document Date | DOCDATE | ||
| Domain User Name | DomainUserName | ||
| Fax | FAX | ||
| Flags | Flags | ||
| Modified Date | MODIFDT | ||
| Phone 1 | PHONE1 | ||
| Phone 2 | PHONE2 | ||
| Phone 3 | PHONE3 | ||
| POP Requisition Number | POPRequisitionNumber | ||
| Primary Shipto Address Code | PRSTADCD | ||
| Requested By | REQSTDBY | ||
| Required Date | REQDATE | ||
| Requisition Description | RequisitionDescription | ||
| Requisition Note Index | Requisition_Note_Index | ||
| Requisition Status | RequisitionStatus | ||
| State | STATE | ||
| User Defined 1 | USERDEF1 | ||
| User Defined 2 | USERDEF2 | ||
| User To Enter | USER2ENT | ||
| Workflow Status | Workflow_Status | ||
| Zip Code | ZIPCODE | ||
| popRequisitionHist | POP30200 | Address 1 | ADDRESS1 |
| Address 2 | ADDRESS2 | ||
| Address 3 | ADDRESS3 | ||
| City | CITY | ||
| Comment ID | COMMNTID | ||
| Comment Note Index | Comment_Note_Index | ||
| Company Name | CMPNYNAM | ||
| Contact | CONTACT | ||
| Country | COUNTRY | ||
| Country Code | CCode | ||
| Created Date | CREATDDT | ||
| Document Amount | DOCAMNT | ||
| Document Date | DOCDATE | ||
| Domain User Name | DomainUserName | ||
| Fax | FAX | ||
| Flags | Flags | ||
| Modified Date | MODIFDT | ||
| Phone 1 | PHONE1 | ||
| Phone 2 | PHONE2 | ||
| Phone 3 | PHONE3 | ||
| POP Requisition Number | POPRequisitionNumber | ||
| Primary Shipto Address Code | PRSTADCD | ||
| Requested By | REQSTDBY | ||
| Required Date | REQDATE | ||
| Requisition Description | RequisitionDescription | ||
| Requisition Note Index | Requisition_Note_Index | ||
| Requisition Status | RequisitionStatus | ||
| State | STATE | ||
| User Defined 1 | USERDEF1 | ||
| User Defined 2 | USERDEF2 | ||
| User To Enter | USER2ENT | ||
| Voided | VOIDED | ||
| Workflow Status | Workflow_Status | ||
| Zip Code | ZIPCODE | ||
| popRequisitionInquiryTemp | TEMP | Document Amount | DOCAMNT |
| Document Date | DOCDATE | ||
| History | HISTORY | ||
| LineNumber | LineNumber | ||
| Ord | ORD | ||
| POP Requisition Number | POPRequisitionNumber | ||
| Primary Shipto Address Code | PRSTADCD | ||
| QTY To Purchase | QTYTOPURCH | ||
| Requested By | REQSTDBY | ||
| Required Date | REQDATE | ||
| Requisition Description | RequisitionDescription | ||
| Requisition Status | RequisitionStatus | ||
| Vendor ID | VENDORID | ||
| Workflow Status | Workflow_Status | ||
| popRequisitionLine | POP10210 | Account Note Index | ACCNTNTINDX |
| Address 1 | ADDRESS1 | ||
| Address 2 | ADDRESS2 | ||
| Address 3 | ADDRESS3 | ||
| Address Code | ADRSCODE | ||
| Address Source | ADDRSOURCE | ||
| City | CITY | ||
| Comment ID | COMMNTID | ||
| Comment Note Index | Comment_Note_Index | ||
| Company Name | CMPNYNAM | ||
| Contact | CONTACT | ||
| Country | COUNTRY | ||
| Country Code | CCode | ||
| Currency ID | CURNCYID | ||
| Currency Index | CURRNIDX | ||
| Currency Note Index | Currency_Note_Index | ||
| Decimal Places Currency | DECPLCUR | ||
| Decimal Places QTYS | DECPLQTY | ||
| Denomination Exchange Rate | DENXRATE | ||
| Exchange Date | EXCHDATE | ||
| Exchange Rate | XCHGRATE | ||
| Exchange Table ID | EXGTBLID | ||
| Extended Cost | EXTDCOST | ||
| Fax | FAX | ||
| Flags | Flags | ||
| Freight Amount | FRTAMNT | ||
| Invalid Data Flag | InvalidDataFlag | ||
| Inventory Index | INVINDX | ||
| Item Description | ITEMDESC | ||
| Item Number | ITEMNMBR | ||
| Item Number Note Index | Item_Number_Note_Index | ||
| Item Tracking Option | ITMTRKOP | ||
| LineNumber | LineNumber | ||
| Location Code | LOCNCODE | ||
| Location Code Note Index | Location_Code_Note_Index | ||
| MC Transaction State | MCTRXSTT | ||
| Non IV | NONINVEN | ||
| Ord | ORD | ||
| Originating Decimal Places Currency | ODECPLCU | ||
| Originating Extended Cost | OREXTCST | ||
| Originating Freight Amount | ORFRTAMT | ||
| Originating Tax Amount | ORTAXAMT | ||
| Originating Unit Cost | ORUNTCST | ||
| Phone 1 | PHONE1 | ||
| Phone 2 | PHONE2 | ||
| Phone 3 | PHONE3 | ||
| POP Requisition Number | POPRequisitionNumber | ||
| Print Phone Number GB | Print_Phone_NumberGB | ||
| QTY Committed In Base | QTYCMTBASE | ||
| QTY Ordered | QTYORDER | ||
| QTY Uncommitted In Base | QTYUNCMTBASE | ||
| Rate Calc Method | RATECALC | ||
| Rate Type ID | RATETPID | ||
| Requested By | REQSTDBY | ||
| Required Date | REQDATE | ||
| Requisition Line Status | RequisitionLineStatus | ||
| Shipping Method | SHIPMTHD | ||
| Shipping Method Note Index | ShippingMethodNoteIndex | ||
| State | STATE | ||
| Tax Amount | TAXAMNT | ||
| Time | TIME1 | ||
| U Of M | UOFM | ||
| U Of M QTY In Base | UMQTYINB | ||
| Unit Cost | UNITCOST | ||
| User Defined 1 | USERDEF1 | ||
| User Defined 2 | USERDEF2 | ||
| Valuation Method | VCTNMTHD | ||
| Vendor ID | VENDORID | ||
| Vendor Note Index | Vendor_Note_Index | ||
| Zip Code | ZIPCODE | ||
| popRequisitionLineHist | POP30210 | Account Note Index | ACCNTNTINDX |
| Address 1 | ADDRESS1 | ||
| Address 2 | ADDRESS2 | ||
| Address 3 | ADDRESS3 | ||
| Address Code | ADRSCODE | ||
| Address Source | ADDRSOURCE | ||
| City | CITY | ||
| Comment ID | COMMNTID | ||
| Comment Note Index | Comment_Note_Index | ||
| Company Name | CMPNYNAM | ||
| Contact | CONTACT | ||
| Country | COUNTRY | ||
| Country Code | CCode | ||
| Currency ID | CURNCYID | ||
| Currency Index | CURRNIDX | ||
| Currency Note Index | Currency_Note_Index | ||
| Decimal Places Currency | DECPLCUR | ||
| Decimal Places QTYS | DECPLQTY | ||
| Denomination Exchange Rate | DENXRATE | ||
| Exchange Date | EXCHDATE | ||
| Exchange Rate | XCHGRATE | ||
| Exchange Table ID | EXGTBLID | ||
| Extended Cost | EXTDCOST | ||
| Fax | FAX | ||
| Flags | Flags | ||
| Freight Amount | FRTAMNT | ||
| Invalid Data Flag | InvalidDataFlag | ||
| Inventory Index | INVINDX | ||
| Item Description | ITEMDESC | ||
| Item Number | ITEMNMBR | ||
| Item Number Note Index | Item_Number_Note_Index | ||
| Item Tracking Option | ITMTRKOP | ||
| LineNumber | LineNumber | ||
| Location Code | LOCNCODE | ||
| Location Code Note Index | Location_Code_Note_Index | ||
| MC Transaction State | MCTRXSTT | ||
| Non IV | NONINVEN | ||
| Ord | ORD | ||
| Originating Decimal Places Currency | ODECPLCU | ||
| Originating Extended Cost | OREXTCST | ||
| Originating Freight Amount | ORFRTAMT | ||
| Originating Tax Amount | ORTAXAMT | ||
| Originating Unit Cost | ORUNTCST | ||
| Phone 1 | PHONE1 | ||
| Phone 2 | PHONE2 | ||
| Phone 3 | PHONE3 | ||
| POP Requisition Number | POPRequisitionNumber | ||
| Print Phone Number GB | Print_Phone_NumberGB | ||
| QTY Committed In Base | QTYCMTBASE | ||
| QTY Ordered | QTYORDER | ||
| QTY Uncommitted In Base | QTYUNCMTBASE | ||
| Rate Calc Method | RATECALC | ||
| Rate Type ID | RATETPID | ||
| Requested By | REQSTDBY | ||
| Required Date | REQDATE | ||
| Requisition Line Status | RequisitionLineStatus | ||
| Shipping Method | SHIPMTHD | ||
| Shipping Method Note Index | ShippingMethodNoteIndex | ||
| State | STATE | ||
| Tax Amount | TAXAMNT | ||
| Time | TIME1 | ||
| U Of M | UOFM | ||
| U Of M QTY In Base | UMQTYINB | ||
| Unit Cost | UNITCOST | ||
| User Defined 1 | USERDEF1 | ||
| User Defined 2 | USERDEF2 | ||
| Valuation Method | VCTNMTHD | ||
| Vendor ID | VENDORID | ||
| Vendor Note Index | Vendor_Note_Index | ||
| Zip Code | ZIPCODE | ||
| popRequisitionLineTemp | TEMP | Account Note Index | ACCNTNTINDX |
| Address 1 | ADDRESS1 | ||
| Address 2 | ADDRESS2 | ||
| Address 3 | ADDRESS3 | ||
| Address Code | ADRSCODE | ||
| Address Source | ADDRSOURCE | ||
| City | CITY | ||
| Comment ID | COMMNTID | ||
| Comment Note Index | Comment_Note_Index | ||
| Company Name | CMPNYNAM | ||
| Contact | CONTACT | ||
| Country | COUNTRY | ||
| Country Code | CCode | ||
| Currency ID | CURNCYID | ||
| Currency Index | CURRNIDX | ||
| Currency Note Index | Currency_Note_Index | ||
| Decimal Places Currency | DECPLCUR | ||
| Decimal Places QTYS | DECPLQTY | ||
| Denomination Exchange Rate | DENXRATE | ||
| Exchange Date | EXCHDATE | ||
| Exchange Rate | XCHGRATE | ||
| Exchange Table ID | EXGTBLID | ||
| Extended Cost | EXTDCOST | ||
| Fax | FAX | ||
| Flags | Flags | ||
| Freight Amount | FRTAMNT | ||
| Invalid Data Flag | InvalidDataFlag | ||
| Inventory Index | INVINDX | ||
| Item Description | ITEMDESC | ||
| Item Number | ITEMNMBR | ||
| Item Number Note Index | Item_Number_Note_Index | ||
| Item Tracking Option | ITMTRKOP | ||
| LineNumber | LineNumber | ||
| Location Code | LOCNCODE | ||
| Location Code Note Index | Location_Code_Note_Index | ||
| MC Transaction State | MCTRXSTT | ||
| Non IV | NONINVEN | ||
| Ord | ORD | ||
| Originating Decimal Places Currency | ODECPLCU | ||
| Originating Extended Cost | OREXTCST | ||
| Originating Freight Amount | ORFRTAMT | ||
| Originating Tax Amount | ORTAXAMT | ||
| Originating Unit Cost | ORUNTCST | ||
| Phone 1 | PHONE1 | ||
| Phone 2 | PHONE2 | ||
| Phone 3 | PHONE3 | ||
| POP Requisition Number | POPRequisitionNumber | ||
| Print Phone Number GB | Print_Phone_NumberGB | ||
| QTY Committed In Base | QTYCMTBASE | ||
| QTY Ordered | QTYORDER | ||
| QTY Uncommitted In Base | QTYUNCMTBASE | ||
| Rate Calc Method | RATECALC | ||
| Rate Type ID | RATETPID | ||
| Requested By | REQSTDBY | ||
| Required Date | REQDATE | ||
| Requisition Line Status | RequisitionLineStatus | ||
| Shipping Method | SHIPMTHD | ||
| Shipping Method Note Index | ShippingMethodNoteIndex | ||
| State | STATE | ||
| Tax Amount | TAXAMNT | ||
| Time | TIME1 | ||
| U Of M | UOFM | ||
| U Of M QTY In Base | UMQTYINB | ||
| Unit Cost | UNITCOST | ||
| User Defined 1 | USERDEF1 | ||
| User Defined 2 | USERDEF2 | ||
| Valuation Method | VCTNMTHD | ||
| Vendor ID | VENDORID | ||
| Vendor Note Index | Vendor_Note_Index | ||
| Zip Code | ZIPCODE | ||
| popRequisitionTemp | TEMP | Address 1 | ADDRESS1 |
| Address 2 | ADDRESS2 | ||
| Address 3 | ADDRESS3 | ||
| City | CITY | ||
| Comment ID | COMMNTID | ||
| Comment Note Index | Comment_Note_Index | ||
| Company Name | CMPNYNAM | ||
| Contact | CONTACT | ||
| Country | COUNTRY | ||
| Country Code | CCode | ||
| Created Date | CREATDDT | ||
| Document Amount | DOCAMNT | ||
| Document Date | DOCDATE | ||
| Domain User Name | DomainUserName | ||
| Fax | FAX | ||
| Flags | Flags | ||
| Modified Date | MODIFDT | ||
| Phone 1 | PHONE1 | ||
| Phone 2 | PHONE2 | ||
| Phone 3 | PHONE3 | ||
| POP Requisition Number | POPRequisitionNumber | ||
| Primary Shipto Address Code | PRSTADCD | ||
| Requested By | REQSTDBY | ||
| Required Date | REQDATE | ||
| Requisition Description | RequisitionDescription | ||
| Requisition Note Index | Requisition_Note_Index | ||
| Requisition Status | RequisitionStatus | ||
| State | STATE | ||
| User Defined 1 | USERDEF1 | ||
| User Defined 2 | USERDEF2 | ||
| User To Enter | USER2ENT | ||
| Workflow Status | Workflow_Status | ||
| Zip Code | ZIPCODE | ||
| popRequisitionUserAccess | POP40200 | Edit Access All | EditAccessAll |
| Edit Access Created By | EditAccessCreatedBy | ||
| Index | INDEX1 | ||
| User ID | USERID | ||
| popRequisitionUserAccessTemp | TEMP | Changed | CHANGED |
| Edit Access All | EditAccessAll | ||
| Edit Access Created By | EditAccessCreatedBy | ||
| Index | INDEX1 | ||
| Original Edit Access All | OriginalEditAccessAll | ||
| Original Edit Access Created By | OrigEditAccessCreateBy | ||
| User ID | USERID | ||
| popSelectPOItemsTemp | TEMP | Workflow Status | Workflow_Status |
| POP_PO | POP10100 | Workflow Status | Workflow_Status |
| POP_POHist | POP30100 | Workflow Status | Workflow_Status |
| POP_POLine | POP10110 | QTY Committed In Base Orig | QTYCommittedInBaseOrig |
| POP_PO_TEMP | TEMP | Workflow Status | Workflow_Status |
| POP_Setup | POP40100 | POP Requisition Number | POPRequisitionNumber |
| Req Hdr User Defined Prompt 1 | Req_Hdr_UD_Prompt1 | ||
| Req Hdr User Defined Prompt 2 | Req_Hdr_UD_Prompt2 | ||
| Req Line User Defined Prompt 1 | Req_Line_UD_Prompt1 | ||
| Req Line User Defined Prompt 2 | Req_Line_UD_Prompt2 | ||
| Requisition Code | RequisitionCode | ||
| Requisition Cost Selection | RequisitionCostSelection | ||
| Requisition Create One PO Per Address | ReqCreateOnePOPerAddress | ||
| Requisition Default Doc Date | RequisitionDefDocDate | ||
| Requisition Default Site Method | RequisitionDefSiteMethod | ||
| Requisition Maintain History | RequisitionMaintainHist | ||
| Requisition Transfer Line Comments | ReqTransferLineComments | ||
| Requisition Vendor Selection | RequisitionVendorSelect | ||
| SearchPOQtysFromRequisition | SearchPOQtysFromRequisit | ||
| PurchasingTrxTemp | TEMP | Comment ID | COMMNTID |
| Requested By | REQSTDBY | ||
| Requisition Description | RequisitionDescription | ||
| Requisition Status | RequisitionStatus | ||
| User Defined 1 | USERDEF1 | ||
| User Defined 2 | USERDEF2 | ||
| Workflow Due Time | Workflow_Due_Time | ||
| Workflow Instance ID | WorkflowInstanceID | ||
| Workflow Status | Workflow_Status | ||
| Workflow Step Instance ID | WorkflowStepInstanceID | ||
| Workflow Step Type | Workflow_Step_Type | ||
| Workflow Type Name | Workflow_Type_Name | ||
| QueryDesigner_Conditions | CO00123 | ConditionsGuid | ConditionsGuid |
| DateFilter | DateFilter | ||
| EnumFilter | EnumFilter | ||
| FieldComparison | FieldComparison | ||
| FieldDataType | FieldDataType | ||
| FieldsListGuid | FieldsListGuid | ||
| FromDictID | FromDictID | ||
| FromField | FromField | ||
| FromFieldListSequence | FromFieldListSequence | ||
| FromTable | FromTable | ||
| IntegerFilter | IntegerFilter | ||
| NumericFilter | NumericFilter | ||
| QueryConditon | QueryConditon | ||
| QueryOperator | QueryOperator | ||
| Sequence Number | SEQNUMBR | ||
| StringFilter | StringFilter | ||
| TimeFilter | TimeFilter | ||
| ToDictID | ToDictID | ||
| ToField | ToField | ||
| ToFieldListSequence | ToFieldListSequence | ||
| ToTable | ToTable | ||
| QueryDesigner_ConditionsTemp | TEMP | ConditionsGuid | ConditionsGuid |
| DateFilter | DateFilter | ||
| EnumFilter | EnumFilter | ||
| FieldComparison | FieldComparison | ||
| FieldDataType | FieldDataType | ||
| FieldsListGuid | FieldsListGuid | ||
| FromDictID | FromDictID | ||
| FromField | FromField | ||
| FromFieldListSequence | FromFieldListSequence | ||
| FromTable | FromTable | ||
| IntegerFilter | IntegerFilter | ||
| NumericFilter | NumericFilter | ||
| QueryConditon | QueryConditon | ||
| QueryOperator | QueryOperator | ||
| Sequence Number | SEQNUMBR | ||
| StringFilter | StringFilter | ||
| TimeFilter | TimeFilter | ||
| ToDictID | ToDictID | ||
| ToField | ToField | ||
| ToFieldListSequence | ToFieldListSequence | ||
| ToTable | ToTable | ||
| QueryDesigner_FieldLinkTemp | TEMP | FromDictID | FromDictID |
| FromField | FromField | ||
| FromFieldPhysicalName | FromFieldPhysicalName | ||
| FromTable | FromTable | ||
| FromTablePhysicalName | FromTablePhysicalName | ||
| ToDictID | ToDictID | ||
| ToField | ToField | ||
| ToFieldPhysicalName | ToFieldPhysicalName | ||
| ToTable | ToTable | ||
| ToTablePhysicalName | ToTablePhysicalName | ||
| QueryDesigner_FieldsList | CO00121 | Currency Symbol | CRNCYSYM |
| Decimal Places Currency | DECPLCUR | ||
| DecimalDigits | DecimalDigits | ||
| DefaultField | DefaultField | ||
| FieldDataType | FieldDataType | ||
| FieldDisplayName | FieldDisplayName | ||
| FieldPhysicalName | FieldPhysicalName | ||
| FieldsListGuid | FieldsListGuid | ||
| FieldSource | FieldSource | ||
| RelativeDecimalPosition | RelativeDecimalPosition | ||
| Sequence Number | SEQNUMBR | ||
| ShowCurrencySymbol | ShowCurrencySymbol | ||
| ShowPercentSign | ShowPercentSign | ||
| TableDictID | TableDictID | ||
| TableDisplayName | TableDisplayName | ||
| TablePhysicalName | TablePhysicalName | ||
| TableSeries | TableSeries | ||
| TableTechnicalName | TableTechnicalName | ||
| QueryDesigner_FieldsListTemp | TEMP | Currency Symbol | CRNCYSYM |
| Decimal Places Currency | DECPLCUR | ||
| DecimalDigits | DecimalDigits | ||
| DefaultField | DefaultField | ||
| FieldDataType | FieldDataType | ||
| FieldDisplayName | FieldDisplayName | ||
| FieldPhysicalName | FieldPhysicalName | ||
| FieldsListGuid | FieldsListGuid | ||
| FieldSource | FieldSource | ||
| RelativeDecimalPosition | RelativeDecimalPosition | ||
| Sequence Number | SEQNUMBR | ||
| ShowCurrencySymbol | ShowCurrencySymbol | ||
| ShowPercentSign | ShowPercentSign | ||
| TableDictID | TableDictID | ||
| TableDisplayName | TableDisplayName | ||
| TablePhysicalName | TablePhysicalName | ||
| TableSeries | TableSeries | ||
| TableTechnicalName | TableTechnicalName | ||
| QueryDesigner_Relationships | CO00122 | FieldsListGuid | FieldsListGuid |
| FromDictID | FromDictID | ||
| FromField | FromField | ||
| FromFieldPhysicalName | FromFieldPhysicalName | ||
| FromTable | FromTable | ||
| FromTablePhysicalName | FromTablePhysicalName | ||
| Group ID | Group_ID | ||
| JoinType | JoinType | ||
| Sequence Number | SEQNUMBR | ||
| ToDictID | ToDictID | ||
| ToField | ToField | ||
| ToFieldPhysicalName | ToFieldPhysicalName | ||
| ToTable | ToTable | ||
| ToTablePhysicalName | ToTablePhysicalName | ||
| QueryDesigner_RelationshipsTemp | Temp | FieldsListGuid | FieldsListGuid |
| FromDictID | FromDictID | ||
| FromField | FromField | ||
| FromFieldPhysicalName | FromFieldPhysicalName | ||
| FromTable | FromTable | ||
| FromTablePhysicalName | FromTablePhysicalName | ||
| Group ID | Group_ID | ||
| JoinType | JoinType | ||
| Sequence Number | SEQNUMBR | ||
| ToDictID | ToDictID | ||
| ToField | ToField | ||
| ToFieldPhysicalName | ToFieldPhysicalName | ||
| ToTable | ToTable | ||
| ToTablePhysicalName | ToTablePhysicalName | ||
| rmEmailStmtsHDRTemp | RM50105 | Address 1 | ADDRESS1 |
| Address 2 | ADDRESS2 | ||
| Address 3 | ADDRESS3 | ||
| Aging Period Amounts | AGPERAMT | ||
| Aging Periods Descriptions | AGPERDSC | ||
| Amount Due | AMNTDUE | ||
| City | CITY | ||
| Company ID | CMPANYID | ||
| Contact Person | CNTCPRSN | ||
| Currency ID | CURNCYID | ||
| Currency Index | CURRNIDX | ||
| Customer Balance | CUSTBLNC | ||
| Customer Messages | CUSTMSGS | ||
| Customer Number | CUSTNMBR | ||
| Date | DATE1 | ||
| Deposits Received | DEPRECV | ||
| Description | DSCRIPTN | ||
| Document Array Abbreviation | DOCARABR | ||
| Document Array Description | DOCARDSC | ||
| Location ID | LOCATNID | ||
| Minimum Payment Due | MINPYDUE | ||
| Payment Terms ID | PYMTRMID | ||
| Phone 1 | PHONE1 | ||
| Phone 2 | PHONE2 | ||
| Phone 3 | PHONE3 | ||
| Printing Status | PRNTSTUS | ||
| Process Index | Process_Index | ||
| Run Number | RNNMBR | ||
| State | STATE | ||
| Statement ID | STMNTID | ||
| Statement Messages | STMTMSGS | ||
| Statement Name | STMTNAME | ||
| User ID | USERID | ||
| Zip | ZIP | ||
| RM_Customer_Combiner_Modifier_TEMP | TEMP | Customer Name From | CustomerNameFrom |
| Customer Name To | CustomerNameTo | ||
| Customer Number From | Customer_Number_From | ||
| Customer Number To | Customer_Number_To | ||
| IndexLong | INDXLONG | ||
| RM_Customer_Validation_TEMP | TEMP | Customer Number From | Customer_Number_From |
| Customer Number To | Customer_Number_To | ||
| IndexLong | INDXLONG | ||
| ValidationMessages | ValidationMessages | ||
| RM_Statements_ROPT | RM40501 | Print Remaining Docs | PrintRemainingDocs |
| SOP_POGenItem | temp | Invalid Data Flag | InvalidDataFlag |
| Inventory Index | INVINDX | ||
| Requested By | REQSTDBY | ||
| Shipping Method | SHIPMTHD | ||
| SOP_POGenPO | temp | Invalid Data Flag | InvalidDataFlag |
| SOP_POGenSOLine | temp | Address Source | ADDRSOURCE |
| Break Field 2 | BRKFLD2 | ||
| Currency ID | CURNCYID | ||
| Freight Amount | FRTAMNT | ||
| Inventory Index | INVINDX | ||
| Item Number | ITEMNMBR | ||
| Non IV | NONINVEN | ||
| Originating Freight Amount | ORFRTAMT | ||
| Requested By | REQSTDBY | ||
| Requisition Date | REQTNDT | ||
| Requisition Description | RequisitionDescription | ||
| SOPO SOLINE Errors 2 | SOPO_SOLINE_Errors_2 | ||
| Unit Cost In Base U Of M | UNITCOSTINBSUOFM | ||
| SOP_POGenVendor | temp | Invalid Data Flag | InvalidDataFlag |
| SOP_POPLink | SOP60100 | Document Date | DOCDATE |
| Item Description | ITEMDESC | ||
| U Of M | UOFM | ||
| SOP_Suggest_Sales_Trx_TEMP | TEMP | QTY Available | QTYAVAIL |
| Quantity to Add | QTYTOADD | ||
| Sales Script | SALESSCRIPT | ||
| syCurrentResources | SY09400 | Avail Limited Users | AvailLmtdUsrs |
| syEmailCardAddress | SY04906 | Address Code | ADRSCODE |
| Email Card Address | EmailCardAddress | ||
| Email Card ID | EmailCardID | ||
| Email Dictionary ID | EmailDictionaryID | ||
| Email Document ID | EmailDocumentID | ||
| Email Recipient Type Bcc | EmailRecipientTypeBcc | ||
| Email Recipient Type Cc | EmailRecipientTypeCc | ||
| Email Recipient Type To | EmailRecipientTypeTo | ||
| Email Series ID | EmailSeriesID | ||
| Module | MODULE1 | ||
| syEmailCardAddressTemp | TEMP | Address Code | ADRSCODE |
| Email Card Address | EmailCardAddress | ||
| Email Recipient Type Bcc | EmailRecipientTypeBcc | ||
| Email Recipient Type Cc | EmailRecipientTypeCc | ||
| Email Recipient Type Sort | EmailRecipientTypeSort | ||
| Email Recipient Type To | EmailRecipientTypeTo | ||
| syEmailCardSetup | SY04904 | Email Address Option | EmailAddressOption |
| syEmailDocumentLines | SY04930 | Email Message ID | EmailMessageID |
| Email Message Type | Email_Message_Type | ||
| FieldName | FieldName | ||
| Ord Line | Ord Line | ||
| Sequence Number | SEQNUMBR | ||
| Workflow Type Name | Workflow_Type_Name | ||
| syEmailMessages | SY04901 | Email Message Type | Email_Message_Type |
| Workflow Type Name | Workflow_Type_Name | ||
| syEmailReportSetup | SY04950 | Email File Format | EmailFileFormat |
| syListOptions | SY07200 | ListOption2 | ListOption2 |
| syListViewOptions | SY07225 | ListOption2 | ListOption2 |
| syOfflineCompanies | SY01800 | Company ID | CMPANYID |
| Offline Date | Offline_Date | ||
| Offline Message | Offline_Message | ||
| Offline Message Type | Offline_Message_Type | ||
| Offline Time | Offline_Time | ||
| Offline User | Offline_User | ||
| syOfflineCompaniesHistory | SY01801 | Company ID | CMPANYID |
| Offline Date | Offline_Date | ||
| Offline Time | Offline_Time | ||
| Offline User | Offline_User | ||
| Online Date | Online_Date | ||
| Online Time | Online_Time | ||
| Online User | Online_User | ||
| Sequence Number | SEQNUMBR | ||
| syReportProcessingStatusHdr | TEMP | Print to File | PRNTOFIL |
| syReportProcessingStatusLine | TEMP | Print to File | PRNTOFIL |
| syResourceExclusions | SY05200 | Resource Technical Name | RESTECHNAME |
| sySelectedUserMessage | TEMP | Company ID | CMPANYID |
| Company Name | CMPNYNAM | ||
| IsOffline | IsOffline | ||
| Selected User | SelectedUser | ||
| User ID | USERID | ||
| syUserMessages | SY30000 | Company ID | CMPANYID |
| Offline Message | Offline_Message | ||
| Sequence Number | SEQNUMBR | ||
| User ID | USERID | ||
| SY_BackupRestoreMSTR | SY01451 | Azure storage Account Name | AzureStorageAccName |
| Azure URL | AzureURL | ||
| Database Name | DBNAME | ||
| fileName | fileName | ||
| Storage Type | StorageType | ||
| Use compression | Usecompression | ||
| SY_Company_MSTR | SY01500 | Offline User | Offline_User |
| SY_Current_Activity | ACTIVITY | IsOffline | IsOffline |
| SY_Security_Operations_Report_TEMP | TEMP | Limited Window | LimitedWindow |
| SY_Security_Operation_Access_TEMP | TEMP | UserType | UserType |
| SY_Users_MSTR | SY01400 | ADObjectGuid | ADObjectGuid |
| SQLLoginID | SQLLoginID | ||
| Web Client User | WCUser | ||
| Window Command Display | WindowCommandDisplay | ||
| taxHistoryPrintTemp | temp | Discount Taken Amount | DISTKNAM |
| Document Number STR30 | DOCNUM30 | ||
| GST Discount Amount | GSTDSAMT | ||
| TimecardCurrentListTemp | TEMP | Comment Text | CMMTTEXT |
| Department | DEPRTMNT | ||
| Division Code | DIVISIONCODE_I | ||
| Employee ID | EMPLOYID | ||
| Employee Name | EMPLNAME | ||
| Employee Suffix | EMPLSUFF | ||
| End Date | ENDDATE | ||
| First Name | FRSTNAME | ||
| Group ID | Group_ID | ||
| InfoValue | InfoValue | ||
| Job Title | JOBTITLE | ||
| Last Name | LASTNAME | ||
| LevelLabel | LVLLABEL | ||
| Location ID | LOCATNID | ||
| Marked To Process | MKTOPROC | ||
| Middle Name | MIDLNAME | ||
| Pay Period | PAYPEROD | ||
| Pay Schedule | Pay_Schedule | ||
| Period ID | PERIODID | ||
| Period Name | PERNAME | ||
| Phone 1 | PHONE1 | ||
| Phone 2 | PHONE2 | ||
| Start Date | STRTDATE | ||
| Supervisor | SUPERVISOR | ||
| Supervisor Code | SUPERVISORCODE_I | ||
| Supervisor Employee ID | Supervisor_Employee_ID | ||
| Units To Pay | UNTSTOPY | ||
| User ID | USERID | ||
| Workflow Status | Workflow_Status | ||
| Year | YEAR1 | ||
| uprCrossCompanySummRptsTemp | TEMP | FICA/Med Add Tax Rate | FICAMed_Add_Tax_Rate |
| Medicare Tax Additional | Medicare_Tax_Additional | ||
| Medicare Wages and Tips Additional | Med_Wages_and_Tips_Add | ||
| uprMstrTCAssignment | UPR00210 | Assignment Code | ASSIGNMENTCODE |
| Employee ID | EMPLOYID | ||
| Inactive | INACTIVE | ||
| uprMstrTCAssignmentDetail | UPR00211 | Assignment Code | ASSIGNMENTCODE |
| Assignment Type | ASSIGNMENTTYPE | ||
| Employee ID | EMPLOYID | ||
| Time Card Code | TIMECARDCODE | ||
| uprMstrTCAssignmentDetailTemp | TEMP | Assignment Code | ASSIGNMENTCODE |
| Assignment Type | ASSIGNMENTTYPE | ||
| CB Selected | SELECTED | ||
| Description | DSCRIPTN | ||
| Employee ID | EMPLOYID | ||
| Inactive | INACTIVE | ||
| Time Card Code | TIMECARDCODE | ||
| uprMstrTimeonBehalf | UPR00200 | Admin Code | Admin_Code |
| Employee ID | EMPLOYID | ||
| Inactive | INACTIVE | ||
| Time on Behalf Code | Time_on_Behalf_Code | ||
| uprMstrTimeonBehalfClass | UPR00202 | Employee Class | EMPLCLAS |
| Employee ID | EMPLOYID | ||
| Time on Behalf Code | Time_on_Behalf_Code | ||
| uprMstrTimeonBehalfDept | UPR00201 | Department | DEPRTMNT |
| Employee ID | EMPLOYID | ||
| Time on Behalf Code | Time_on_Behalf_Code | ||
| uprMstrTimeonBehalfEmp | UPR00203 | Employee ID | EMPLOYID |
| Employee ID Assigned | Employee_ID_Assigned | ||
| Time on Behalf Code | Time_on_Behalf_Code | ||
| uprMstrTimeonBehalfTEMP | TEMP | Description | DSCRIPTN |
| Employee ID | EMPLOYID | ||
| Inactive | INACTIVE | ||
| Included | INCLUDED | ||
| Payroll Code 15U | Payroll_Code_15U | ||
| Time on Behalf Code | Time_on_Behalf_Code | ||
| Time on Behalf Type | Time_on_Behalf_Type | ||
| uprReportsToStructureForEmp | TEMP | Employee ID | EMPLOYID |
| Employee Suffix | EMPLSUFF | ||
| First Name | FRSTNAME | ||
| Group ID | Group_ID | ||
| Last Name | LASTNAME | ||
| LevelLabel | LVLLABEL | ||
| Middle Name | MIDLNAME | ||
| Phone 1 | PHONE1 | ||
| Phone 2 | PHONE2 | ||
| Supervisor | SUPERVISOR | ||
| Supervisor Code | SUPERVISORCODE_I | ||
| Supervisor Employee ID | Supervisor_Employee_ID | ||
| Supervisor First Name | Supervisor_First_Name | ||
| Supervisor Last Name | Supervisor_Last_Name | ||
| Supervisor Middle Name | Supervisor_Middle_Name | ||
| User ID | USERID | ||
| uprSetupBatchPrefix | UPR42500 | Batch Prefix | Batch_Prefix |
| Description | DSCRIPTN | ||
| uprSetupBatchPrefixClass | UPR42504 | Batch Prefix | Batch_Prefix |
| Employee Class | EMPLCLAS | ||
| uprSetupBatchPrefixDept | UPR42502 | Batch Prefix | Batch_Prefix |
| Department | DEPRTMNT | ||
| uprSetupBatchPrefixEmployee | UPR42505 | Batch Prefix | Batch_Prefix |
| Employee ID | EMPLOYID | ||
| uprSetupBatchPrefixLocation | UPR42501 | Batch Prefix | Batch_Prefix |
| Location ID | LOCATNID | ||
| uprSetupBatchPrefixPosition | UPR42503 | Batch Prefix | Batch_Prefix |
| Job Title | JOBTITLE | ||
| uprSetupBatchPrefixTEMP | TEMP | Batch Prefix | Batch_Prefix |
| CB Selected | SELECTED | ||
| Description | DSCRIPTN | ||
| Inactive | INACTIVE | ||
| Payroll Code 15U | Payroll_Code_15U | ||
| Type ID | TYPEID | ||
| uprSetupPayScheduleClass | UPR42105 | Employee Class | EMPLCLAS |
| Pay Schedule | Pay_Schedule | ||
| uprSetupPayScheduleClassTEMP | TEMP | CB Selected | SELECTED |
| Description | DSCRIPTN | ||
| Employee Class | EMPLCLAS | ||
| Pay Schedule | Pay_Schedule | ||
| uprSetupPayScheduleDept | UPR42103 | Department | DEPRTMNT |
| Pay Schedule | Pay_Schedule | ||
| uprSetupPayScheduleDeptTEMP | TEMP | CB Selected | SELECTED |
| Department | DEPRTMNT | ||
| Description | DSCRIPTN | ||
| Pay Schedule | Pay_Schedule | ||
| uprSetupPayScheduleDtl | UPR42101 | End Date | ENDDATE |
| Pay Schedule | Pay_Schedule | ||
| Period ID | PERIODID | ||
| Period Name | PERNAME | ||
| Start Date | STRTDATE | ||
| Year | YEAR1 | ||
| uprSetupPayScheduleDtlTEMP | TEMP | End Date | ENDDATE |
| Pay Schedule | Pay_Schedule | ||
| Period ID | PERIODID | ||
| Period Name | PERNAME | ||
| Start Date | STRTDATE | ||
| Year | YEAR1 | ||
| uprSetupPayScheduleEmployee | UPR42106 | Employee ID | EMPLOYID |
| Pay Schedule | Pay_Schedule | ||
| uprSetupPayScheduleEmployeeTEMP | TEMP | CB Selected | SELECTED |
| Description | DSCRIPTN | ||
| Employee ID | EMPLOYID | ||
| Inactive | INACTIVE | ||
| Pay Schedule | Pay_Schedule | ||
| uprSetupPayScheduleHdr | UPR42100 | Current Pay Periods | Current_Pay_Periods |
| Description | DSCRIPTN | ||
| Past Pay Periods | Past_Pay_Periods | ||
| Pay Period | PAYPEROD | ||
| Pay Schedule | Pay_Schedule | ||
| uprSetupPayScheduleLocation | UPR42102 | Location ID | LOCATNID |
| Pay Schedule | Pay_Schedule | ||
| uprSetupPayScheduleLocationTEMP | TEMP | CB Selected | SELECTED |
| Location ID | LOCATNID | ||
| Location Name | LOCATNNM | ||
| Pay Schedule | Pay_Schedule | ||
| uprSetupPaySchedulePosition | UPR42104 | Job Title | JOBTITLE |
| Pay Schedule | Pay_Schedule | ||
| uprSetupPaySchedulePositionTEMP | TEMP | CB Selected | SELECTED |
| Description | DSCRIPTN | ||
| Job Title | JOBTITLE | ||
| Pay Schedule | Pay_Schedule | ||
| uprSetupScheduleSequence | UPR42110 | Pay Schedule | Pay_Schedule |
| Sequence Number | SEQNUMBR | ||
| uprSetupScheduleSequenceTEMP | TEMP | Pay Schedule | Pay_Schedule |
| Sequence Number | SEQNUMBR | ||
| uprSetupScheduleUnSequenceTEMP | TEMP | Pay Schedule | Pay_Schedule |
| Sequence Number | SEQNUMBR | ||
| uprSetupTCAssignment | UPR42300 | Assignment Code | ASSIGNMENTCODE |
| Default CB | Default_CB | ||
| Description | DSCRIPTN | ||
| Inactive | INACTIVE | ||
| uprSetupTCAssignmentDetail | UPR42301 | Assignment Code | ASSIGNMENTCODE |
| Assignment Type | ASSIGNMENTTYPE | ||
| Time Card Code | TIMECARDCODE | ||
| uprSetupTCAssignmentDetailTemp | TEMP | Assignment Code | ASSIGNMENTCODE |
| Assignment Type | ASSIGNMENTTYPE | ||
| CB Selected | SELECTED | ||
| Description | DSCRIPTN | ||
| Inactive | INACTIVE | ||
| Time Card Code | TIMECARDCODE | ||
| uprSetupTimeCardRestrictions | UPR42400 | Days Worked CB | Days_Worked_CB |
| Department CB | Department_CB | ||
| Description | DSCRIPTN | ||
| Local Tax CB | Local_Tax_CB | ||
| Notes CB | Notes_CB | ||
| Per Day CB | Per_Day_CB | ||
| Per Day Max | Per_Day_Max | ||
| Per Pay Period CB | Per_Pay_Period_CB | ||
| Per Period Max | Per_Period_Max | ||
| Per Period Min | Per_Period_Min | ||
| Position CB | Position_CB | ||
| Require Electronic Signature | Require_Electronic_Signa | ||
| Required Start/Stop CB | Required_StartStop_CB | ||
| Restriction Code | Restriction_Code | ||
| Shift CB | Shift_CB | ||
| State Tax CB | State_Tax_CB | ||
| Weeks Worked CB | Weeks_Worked_CB | ||
| uprSetupTimeCardRestrictionsClass | UPR42405 | Employee Class | EMPLCLAS |
| Restriction Code | Restriction_Code | ||
| uprSetupTimeCardRestrictionsDept | UPR42403 | Department | DEPRTMNT |
| Restriction Code | Restriction_Code | ||
| uprSetupTimeCardRestrictionsDTL | UPR42401 | Days Worked CB | Days_Worked_CB |
| Department CB | Department_CB | ||
| Local Tax CB | Local_Tax_CB | ||
| Notes CB | Notes_CB | ||
| Per Day CB | Per_Day_CB | ||
| Per Day Max | Per_Day_Max | ||
| Per Pay Period CB | Per_Pay_Period_CB | ||
| Per Period Max | Per_Period_Max | ||
| Per Period Min | Per_Period_Min | ||
| Position CB | Position_CB | ||
| Require Electronic Signature | Require_Electronic_Signa | ||
| Required Start/Stop CB | Required_StartStop_CB | ||
| Restriction Code | Restriction_Code | ||
| Restriction Type | Restriction_Type | ||
| Shift CB | Shift_CB | ||
| State Tax CB | State_Tax_CB | ||
| Weeks Worked CB | Weeks_Worked_CB | ||
| uprSetupTimeCardRestrictionsEmployee | UPR42406 | Employee ID | EMPLOYID |
| Restriction Code | Restriction_Code | ||
| uprSetupTimeCardRestrictionsLocation | UPR42402 | Location ID | LOCATNID |
| Restriction Code | Restriction_Code | ||
| uprSetupTimeCardRestrictionsPosition | UPR42404 | Job Title | JOBTITLE |
| Restriction Code | Restriction_Code | ||
| uprSetupTimeCardRestrictionsTEMP | TEMP | CB Selected | SELECTED |
| Description | DSCRIPTN | ||
| Inactive | INACTIVE | ||
| Payroll Code 15U | Payroll_Code_15U | ||
| Restriction Code | Restriction_Code | ||
| Type ID | TYPEID | ||
| uprSetupTimeonBehalf | UPR42200 | Admin Code | Admin_Code |
| Description | DSCRIPTN | ||
| Inactive | INACTIVE | ||
| Time on Behalf Code | Time_on_Behalf_Code | ||
| uprSetupTimeonBehalfClass | UPR42202 | Employee Class | EMPLCLAS |
| Time on Behalf Code | Time_on_Behalf_Code | ||
| uprSetupTimeonBehalfDept | UPR42201 | Department | DEPRTMNT |
| Time on Behalf Code | Time_on_Behalf_Code | ||
| uprSetupTimeonBehalfEmp | UPR42203 | Employee ID Assigned | Employee_ID_Assigned |
| Time on Behalf Code | Time_on_Behalf_Code | ||
| uprSetupTimeonBehalfTEMP | TEMP | Description | DSCRIPTN |
| Inactive | INACTIVE | ||
| Included | INCLUDED | ||
| Payroll Code 15U | Payroll_Code_15U | ||
| Time on Behalf Code | Time_on_Behalf_Code | ||
| Time on Behalf Type | Time_on_Behalf_Type | ||
| uprTimecardDtl | UPR10501 | Comment Text | CMMTTEXT |
| Days Worked | DAYSWRDK | ||
| Department | DEPRTMNT | ||
| Employee ID | EMPLOYID | ||
| Job Title | JOBTITLE | ||
| Local Tax | LOCALTAX | ||
| Pay Code | PayCode | ||
| Pay Schedule | Pay_Schedule | ||
| Period ID | PERIODID | ||
| Sequence Number | SEQNUMBR | ||
| Shift Code | SHFTCODE | ||
| State Code | STATECD | ||
| TRX Date | TRXDATE | ||
| TRX Number | TRXNUMBER | ||
| Units To Pay | UNTSTOPY | ||
| Weeks Worked | WKSWRKD | ||
| Year | YEAR1 | ||
| uprTimecardEntryTrxDtlTEMP | TEMP | Comment Text | CMMTTEXT |
| Days Worked | DAYSWRDK | ||
| Department | DEPRTMNT | ||
| Job Title | JOBTITLE | ||
| Local Tax | LOCALTAX | ||
| Pay Code | PayCode | ||
| Sequence Number | SEQNUMBR | ||
| Shift Code | SHFTCODE | ||
| State Code | STATECD | ||
| TRX Date | TRXDATE | ||
| TRX Number | TRXNUMBER | ||
| Units To Pay | UNTSTOPY | ||
| Weeks Worked | WKSWRKD | ||
| uprTimecardEntryTrxStartStopTEMP | TEMP | End Time | ENDTIME |
| Line SEQ Number | LNSEQNBR | ||
| Start Time | STRTTIME | ||
| TRX Number | TRXNUMBER | ||
| Units To Pay | UNTSTOPY | ||
| uprTimecardEntryTrxTEMP | TEMP | Daily Hours | Daily_Hours |
| Daily TRX Numbers | Daily_TRX_Numbers | ||
| Pay Code | PayCode | ||
| Sequence Number | SEQNUMBR | ||
| uprTimecardHdr | UPR10500 | Employee ID | EMPLOYID |
| Pay Schedule | Pay_Schedule | ||
| Period ID | PERIODID | ||
| Workflow Status | Workflow_Status | ||
| Year | YEAR1 | ||
| uprTimecardStartStopDtl | UPR10502 | Employee ID | EMPLOYID |
| End Time | ENDTIME | ||
| Line SEQ Number | LNSEQNBR | ||
| Pay Schedule | Pay_Schedule | ||
| Period ID | PERIODID | ||
| Start Time | STRTTIME | ||
| TRX Number | TRXNUMBER | ||
| Units To Pay | UNTSTOPY | ||
| Year | YEAR1 | ||
| uprTimecardTemplateStartStop | UPR00222 | DayOfWeek | DayOfWeek |
| Employee ID | EMPLOYID | ||
| End Time | ENDTIME | ||
| Line SEQ Number | LNSEQNBR | ||
| Sequence Number | SEQNUMBR | ||
| Start Time | STRTTIME | ||
| Units To Pay | UNTSTOPY | ||
| uprTimecardTemplateTrx | UPR00220 | Daily Hours | Daily_Hours |
| Employee ID | EMPLOYID | ||
| Pay Code | PayCode | ||
| Sequence Number | SEQNUMBR | ||
| uprTimecardTemplateTrxDtl | UPR00221 | Comment Text | CMMTTEXT |
| DayOfWeek | DayOfWeek | ||
| Days Worked | DAYSWRDK | ||
| Department | DEPRTMNT | ||
| Employee ID | EMPLOYID | ||
| Job Title | JOBTITLE | ||
| Local Tax | LOCALTAX | ||
| Sequence Number | SEQNUMBR | ||
| Shift Code | SHFTCODE | ||
| State Code | STATECD | ||
| Weeks Worked | WKSWRKD | ||
| uprTimecardTemplTrxDtlTEMP | TEMP | Comment Text | CMMTTEXT |
| DayOfWeek | DayOfWeek | ||
| Days Worked | DAYSWRDK | ||
| Department | DEPRTMNT | ||
| Job Title | JOBTITLE | ||
| Local Tax | LOCALTAX | ||
| Sequence Number | SEQNUMBR | ||
| Shift Code | SHFTCODE | ||
| State Code | STATECD | ||
| Units To Pay | UNTSTOPY | ||
| Weeks Worked | WKSWRKD | ||
| uprTimecardTemplTrxStartStopTEMP | TEMP | DayOfWeek | DayOfWeek |
| End Time | ENDTIME | ||
| Line SEQ Number | LNSEQNBR | ||
| Sequence Number | SEQNUMBR | ||
| Start Time | STRTTIME | ||
| Units To Pay | UNTSTOPY | ||
| uprTimecardTemplTrxTEMP | TEMP | Daily Hours | Daily_Hours |
| Pay Code | PayCode | ||
| Sequence Number | SEQNUMBR | ||
| uprTmcdDtlHIST | UPR30501 | Comment Text | CMMTTEXT |
| Days Worked | DAYSWRDK | ||
| Department | DEPRTMNT | ||
| Employee ID | EMPLOYID | ||
| Job Title | JOBTITLE | ||
| Local Tax | LOCALTAX | ||
| Pay Code | PayCode | ||
| Pay Schedule | Pay_Schedule | ||
| Period ID | PERIODID | ||
| Sequence Number | SEQNUMBR | ||
| Shift Code | SHFTCODE | ||
| State Code | STATECD | ||
| TRX Date | TRXDATE | ||
| TRX Number | TRXNUMBER | ||
| Units To Pay | UNTSTOPY | ||
| Weeks Worked | WKSWRKD | ||
| Year | YEAR1 | ||
| uprTmcdHdrHIST | UPR30500 | Employee ID | EMPLOYID |
| Pay Schedule | Pay_Schedule | ||
| Period ID | PERIODID | ||
| Workflow Status | Workflow_Status | ||
| Year | YEAR1 | ||
| uprTmcdStartStopHIST | UPR30502 | Employee ID | EMPLOYID |
| End Time | ENDTIME | ||
| Line SEQ Number | LNSEQNBR | ||
| Pay Schedule | Pay_Schedule | ||
| Period ID | PERIODID | ||
| Start Time | STRTTIME | ||
| TRX Number | TRXNUMBER | ||
| Units To Pay | UNTSTOPY | ||
| Year | YEAR1 | ||
| UPR_MSTR | UPR00100 | User ID | USERID |
| UPR_SETP_Class | UPR41200 | Assignment Code | ASSIGNMENTCODE |
| Time on Behalf Code | Time_on_Behalf_Code | ||
| UPR_SETP_Info | UPR40200 | Include Inactive Employees | INCINEMP |
| View Multiple Directs | VIEWMULTDIR | ||
| UPR_SETP_Timecard_Options | UPR40202 | Assignment Priority | ASGMTPRTY |
| Setup Key | SETUPKEY | ||
| UPR_TEMP_941_Totals | temp | FICA/Med Add Tax Rate | FICAMed_Add_Tax_Rate |
| Medicare Tax Additional | Medicare_Tax_Additional | ||
| Medicare Wages and Tips Additional | Med_Wages_and_Tips_Add | ||
| Workflow_Calendar | WF40300 | DayOfWeek | DayOfWeek |
| End Time | ENDTIME | ||
| IsWorkDay | IsWorkDay | ||
| Start Time | STRTTIME | ||
| Workflow_Calendar_Down_Days | WF40310 | Date | DATE1 |
| DateDescription | DateDescription | ||
| Year | YEAR1 | ||
| Workflow_Document_Steps | TEMP | Workflow Business Object Key | WfBusObjKey |
| Workflow Due Date | Workflow_Due_Date | ||
| Workflow Due Time | Workflow_Due_Time | ||
| Workflow Instance ID | WorkflowInstanceID | ||
| Workflow Name | Workflow_Name | ||
| Workflow Number Assigned | Workflow_Number_Assigned | ||
| Workflow Step Instance ID | WorkflowStepInstanceID | ||
| Workflow Step Name | Workflow_Step_Name | ||
| Workflow Step Predecessor | WF_Step_Predecessor | ||
| Workflow Step Sequence | Workflow_Step_Sequence | ||
| Workflow Task Assigned | Workflow_Task_Assigned | ||
| Workflow Task Assigned To | WorkflowTaskAssignedTo | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow User | Workflow_User | ||
| Workflow_Email_Notifications | WF40400 | Email Message ID | EmailMessageID |
| Workflow Name | Workflow_Name | ||
| Workflow Notification Action | WF_Notification_Action | ||
| Workflow Notification CC | Workflow_Notification_CC | ||
| Workflow Notification Enabled | WF_Notification_Enabled | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow_History | WF30100 | Workflow Action | Workflow_Action |
| Workflow Comments | Workflow_Comments | ||
| Workflow Completion Date | Workflow_Completion_Date | ||
| Workflow Completion Time | Workflow_Completion_Time | ||
| Workflow Due Date | Workflow_Due_Date | ||
| Workflow Due Time | Workflow_Due_Time | ||
| Workflow History User | Workflow_History_User | ||
| Workflow Instance ID | WorkflowInstanceID | ||
| Workflow Name | Workflow_Name | ||
| Workflow Step Assign To | Workflow_Step_Assign_To | ||
| Workflow Step Instance ID | WorkflowStepInstanceID | ||
| Workflow Step Name | Workflow_Step_Name | ||
| Workflow_History_Scroll_TEMP | TEMP | Node ID | Node_ID |
| Workflow Action | Workflow_Action | ||
| Workflow Comments | Workflow_Comments | ||
| Workflow Completion Date | Workflow_Completion_Date | ||
| Workflow Completion Time | Workflow_Completion_Time | ||
| Workflow Due Date | Workflow_Due_Date | ||
| Workflow Due Time | Workflow_Due_Time | ||
| Workflow History User | Workflow_History_User | ||
| Workflow Step Assign To | Workflow_Step_Assign_To | ||
| Workflow Step Instance ID | WorkflowStepInstanceID | ||
| Workflow Step Name | Workflow_Step_Name | ||
| Workflow_History_TEMP | TEMP | Node ID | Node_ID |
| Workflow Action | Workflow_Action | ||
| Workflow Comments | Workflow_Comments | ||
| Workflow Completion Date | Workflow_Completion_Date | ||
| Workflow Completion Time | Workflow_Completion_Time | ||
| Workflow Due Date | Workflow_Due_Date | ||
| Workflow Due Time | Workflow_Due_Time | ||
| Workflow History User | Workflow_History_User | ||
| Workflow Instance ID | WorkflowInstanceID | ||
| Workflow Name | Workflow_Name | ||
| Workflow Step Assign To | Workflow_Step_Assign_To | ||
| Workflow Step Instance ID | WorkflowStepInstanceID | ||
| Workflow Step Name | Workflow_Step_Name | ||
| Workflow Step Predecessor | WF_Step_Predecessor | ||
| Workflow Step Sequence | Workflow_Step_Sequence | ||
| Workflow Step Status | Workflow_Step_Status | ||
| Workflow_Instance | WFI10002 | BusObjKey | BusObjKey |
| DictID | DICTID | ||
| Document Drill Down | Document_Drill_Down | ||
| FormID | FormID | ||
| Note Index | NOTEINDX | ||
| Table Physical Name | TBLPHYSNM | ||
| Workflow Allow Originator to be an Approver | WF_AllowOrigApprover | ||
| Workflow Alternate Final Approver | WF_Alt_FinalApprover | ||
| Workflow Business Object Key | WfBusObjKey | ||
| Workflow Delegate To | Workflow_Delegate_To | ||
| Workflow Description | Workflow_Description | ||
| Workflow Instance ID | WorkflowInstanceID | ||
| Workflow Manually Delegate | Workflow_Manually_Delega | ||
| Workflow Name | Workflow_Name | ||
| Workflow Originator | Workflow_Originator | ||
| Workflow Overdue Task Action | WF_Overdue_Task_Action | ||
| Workflow Require One Approver | Workflow_Require_One_App | ||
| Workflow Send Notifications for Completed Actions | WF_SendNotificatications | ||
| Workflow Status | Workflow_Status | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow Use Alternate Final Approver | WF_Use_Alt_Final_Approv | ||
| Workflow Version | Workflow_Version | ||
| Workflow Where Clause | Workflow_Where_Clause | ||
| Workflow_Master | WF100002 | Active | ACTIVE |
| Note Index | NOTEINDX | ||
| Workflow Allow Originator to be an Approver | WF_AllowOrigApprover | ||
| Workflow Alternate Final Approver | WF_Alt_FinalApprover | ||
| Workflow Delegate To | Workflow_Delegate_To | ||
| Workflow Description | Workflow_Description | ||
| Workflow Manually Delegate | Workflow_Manually_Delega | ||
| Workflow Name | Workflow_Name | ||
| Workflow Overdue Task Action | WF_Overdue_Task_Action | ||
| Workflow Require One Approver | Workflow_Require_One_App | ||
| Workflow Send Notifications for Completed Actions | WF_SendNotificatications | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow Use Alternate Final Approver | WF_Use_Alt_Final_Approv | ||
| Workflow Version | Workflow_Version | ||
| Workflow_Roles | WF40201 | FieldPhysicalName | FieldPhysicalName |
| TableDictID | TableDictID | ||
| TablePhysicalName | TablePhysicalName | ||
| TableRelationship | TableRelationship | ||
| Workflow Role Table | Workflow_Role_Table | ||
| Workflow Type Name | Workflow_Type_Name | ||
| WorkflowRole | WorkflowRole | ||
| WorkflowRoleID | WorkflowRoleID | ||
| Workflow_Setup | WF00100 | Display Name | DSPLNAME |
| Enable Workflow Email | Enable_Workflow_Email | ||
| Enable Workflow Notification Service | EnableWFNotifService | ||
| IsSSL | IsSSL | ||
| Server ID | SERVERID | ||
| Server Port | Server_Port | ||
| Setup Key | SETUPKEY | ||
| SMTP Authentication | SMTP_Authentication | ||
| SMTP Password | SMTP_Password | ||
| SMTP User | SMTP_User | ||
| Web Service Server | Web_Service_Server | ||
| Web Service Server Port | Web_Service_Server_Port | ||
| Web Service Server SSL | Web_Service_Server_SSL | ||
| Workflow_Step | WF100003 | Email Message ID | EmailMessageID |
| Note Index | NOTEINDX | ||
| Workflow Apply Workflow Calendar | WF_Apply_WF_Calendar | ||
| Workflow Name | Workflow_Name | ||
| Workflow Step Assign To | Workflow_Step_Assign_To | ||
| Workflow Step Completion Policy | WF_Step_Completion_Polic | ||
| Workflow Step Condition | Workflow_Step_Condition | ||
| Workflow Step Conditions | Workflow_Step_Conditions | ||
| Workflow Step Description | WF_Step_Description | ||
| Workflow Step Name | Workflow_Step_Name | ||
| Workflow Step Order | Workflow_Step_Order | ||
| Workflow Step Predecessor | WF_Step_Predecessor | ||
| Workflow Step Send Email | Workflow_Step_Send_Email | ||
| Workflow Step Sequence | Workflow_Step_Sequence | ||
| Workflow Step Time Limit | Workflow_Step_Time_Limit | ||
| Workflow Step Time Limit UofM | WF_Step_Time_Limit_UofM | ||
| Workflow Step Type | Workflow_Step_Type | ||
| Workflow Version | Workflow_Version | ||
| Workflow_Step_Instance | WFI10003 | Email Message ID | EmailMessageID |
| Note Index | NOTEINDX | ||
| Workflow Apply Workflow Calendar | WF_Apply_WF_Calendar | ||
| Workflow Instance ID | WorkflowInstanceID | ||
| Workflow Name | Workflow_Name | ||
| Workflow Step Assign To | Workflow_Step_Assign_To | ||
| Workflow Step Completion Policy | WF_Step_Completion_Polic | ||
| Workflow Step Condition | Workflow_Step_Condition | ||
| Workflow Step Conditions | Workflow_Step_Conditions | ||
| Workflow Step Description | WF_Step_Description | ||
| Workflow Step Instance ID | WorkflowStepInstanceID | ||
| Workflow Step Name | Workflow_Step_Name | ||
| Workflow Step Order | Workflow_Step_Order | ||
| Workflow Step Predecessor | WF_Step_Predecessor | ||
| Workflow Step Send Email | Workflow_Step_Send_Email | ||
| Workflow Step Sequence | Workflow_Step_Sequence | ||
| Workflow Step Status | Workflow_Step_Status | ||
| Workflow Step Time Limit | Workflow_Step_Time_Limit | ||
| Workflow Step Time Limit UofM | WF_Step_Time_Limit_UofM | ||
| Workflow Step Type | Workflow_Step_Type | ||
| Workflow Version | Workflow_Version | ||
| Workflow_Step_Instance_Users | WFI10005 | ADDisplayName | ADDisplayName |
| UsersListGuid | UsersListGuid | ||
| Workflow Step Instance ID | WorkflowStepInstanceID | ||
| Workflow Task Assigned To | WorkflowTaskAssignedTo | ||
| Workflow User | Workflow_User | ||
| Workflow_Tasks | WFI10004 | Workflow Action Date | Workflow_Action_Date |
| Workflow Action Time | Workflow_Action_Time | ||
| Workflow Due Date | Workflow_Due_Date | ||
| Workflow Due Time | Workflow_Due_Time | ||
| Workflow Instance ID | WorkflowInstanceID | ||
| Workflow Name | Workflow_Name | ||
| Workflow Step Completion Policy | WF_Step_Completion_Polic | ||
| Workflow Step Description | WF_Step_Description | ||
| Workflow Step Instance ID | WorkflowStepInstanceID | ||
| Workflow Step Name | Workflow_Step_Name | ||
| Workflow Step Order | Workflow_Step_Order | ||
| Workflow Step Predecessor | WF_Step_Predecessor | ||
| Workflow Step Sequence | Workflow_Step_Sequence | ||
| Workflow Step Type | Workflow_Step_Type | ||
| Workflow Task Assigned To | WorkflowTaskAssignedTo | ||
| Workflow Task Escalated | Workflow_Task_Escalated | ||
| Workflow Version | Workflow_Version | ||
| Workflow_Tasks_Homepage_TEMP | TEMP | DictID | DICTID |
| FormID | FormID | ||
| Window Name | WINNAME | ||
| Workflow Business Object Key | WfBusObjKey | ||
| Workflow Due Date | Workflow_Due_Date | ||
| Workflow Due Time | Workflow_Due_Time | ||
| Workflow Step Type | Workflow_Step_Type | ||
| Workflow Task Assigned To | WorkflowTaskAssignedTo | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow_Template_Fields | WF40202 | Additional Fields | AdditionalFields |
| Email Message Type | Email_Message_Type | ||
| FieldDataType | FieldDataType | ||
| FieldName | FieldName | ||
| FieldPhysicalName | FieldPhysicalName | ||
| Ord Line | Ord Line | ||
| Resource ID | RSRCID | ||
| Sequence Number | SEQNUMBR | ||
| TableDictID | TableDictID | ||
| TablePhysicalName | TablePhysicalName | ||
| TableRelationship | TableRelationship | ||
| TableSeries | TableSeries | ||
| Workflow Template Field Type | WF_Template_Field_Type | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow_Template_Fields_TEMP | TEMP | Additional Fields | AdditionalFields |
| Email Message Type | Email_Message_Type | ||
| FieldDataType | FieldDataType | ||
| FieldName | FieldName | ||
| FieldPhysicalName | FieldPhysicalName | ||
| Ord Line | Ord Line | ||
| Resource ID | RSRCID | ||
| Sequence Number | SEQNUMBR | ||
| TableDictID | TableDictID | ||
| TablePhysicalName | TablePhysicalName | ||
| TableRelationship | TableRelationship | ||
| TableSeries | TableSeries | ||
| Workflow Template Field Type | WF_Template_Field_Type | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow_Type | WF100001 | DictID | DICTID |
| FieldsListGuid | FieldsListGuid | ||
| FormID | FormID | ||
| Function Name | FUNCNAME | ||
| Note Index | NOTEINDX | ||
| Series | SERIES | ||
| Window Name | WINNAME | ||
| Workflow Class | Workflow_Class | ||
| Workflow Managers | Workflow_Managers | ||
| Workflow Type Business Object Key | WfTypeBusObjKey | ||
| Workflow Type Description | WF_Type_Description | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow_Type_Conditions_TEMP | TEMP | Cost Amount | COSTAMNT |
| Count | Count1 | ||
| Field Data Type | Field_Data_Type | ||
| Field Name | FIELDNAM | ||
| Unit_Acct | Unit_Acct | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow_Type_TEMP | TEMP | DictID | DICTID |
| FormID | FormID | ||
| Window Name | WINNAME | ||
| Workflow Class | Workflow_Class | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow_Users | WF40200 | ADAlias | ADAlias |
| ADDisplayName | ADDisplayName | ||
| ADDistinguishedName | ADDistinguishedName | ||
| ADDomain | ADDomain | ||
| ADLogin | ADLogin | ||
| ADObjectGuid | ADObjectGuid | ||
| ADType | ADType | ||
| HierarchyLevel | HierarchyLevel | ||
| Sequence | SEQUENCE1 | ||
| UsersListGuid | UsersListGuid | ||
| WorkflowHierarchy | WorkflowHierarchy | ||
| WorkflowHierarchyID | WorkflowHierarchyID | ||
| WorkflowRole | WorkflowRole | ||
| WorkflowRoleID | WorkflowRoleID | ||
| WorkflowSelectionType | WorkflowSelectionType | ||
| Workflow_User_Delegation_LINE | WF40510 | ADDisplayName | ADDisplayName |
| Domain User Name | DomainUserName | ||
| End Date | ENDDATE | ||
| Start Date | STRTDATE | ||
| UsersListGuid | UsersListGuid | ||
| Workflow Type Name | Workflow_Type_Name | ||
| Workflow_User_Delegation_MSTR | WF40500 | ADDisplayName | ADDisplayName |
| Domain User Name | DomainUserName | ||
| UsersListGuid | UsersListGuid | ||
| Workflow Auto Delegate Tasks | WF_Auto_Delegate_Tasks | ||
| Workflow Select Delegate | Workflow_Select_Delegate | ||
| Workflow_User_Security | WF00104 | User ID | USERID |
| Workflow Type Name | Workflow_Type_Name |
New Columns in Existing Tables:
| Table Technical Name | Table Physical Name | Field Technical Name | Field Physical Name |
| coAttachmentTemp | temp | Allow Attachment Email | AllowAttachmentEmail |
| Allow Attachment Flow | AllowAttachmentFlow | ||
| Attachment Image | AttachmentImage | ||
| Attachment Product Details | AttachmentProductDetails | ||
| Delete | DELETE1 | ||
| coAttachMSTR | CO00101 | Attachment Image | AttachmentImage |
| Attachment Product Details | AttachmentProductDetails | ||
| coAttachRef | CO00102 | Allow Attachment Email | AllowAttachmentEmail |
| Allow Attachment Flow | AllowAttachmentFlow | ||
| Attachment Origin | AttachmentOrigin | ||
| Delete | DELETE1 | ||
| coAttachSetup | CO40100 | Allow Attachments Email | AllowAttachmentsEmail |
| Allow To Delete | AllowToDelete | ||
| Attachment Attribute Default | AttachAttributeDefault | ||
| Attribute | Attribute | ||
| Customer Attachment Type | CustomerAttachmentType | ||
| Delete Password | DeletePassword | ||
| Item Attachment Type | ItemAttachmentType | ||
| Vendor Attachment Type | VendorAttachmentType | ||
| ddACHCopy | DD10200 | IndexLong | INDXLONG |
| ddACHCrossRef | DD10300 | IndexLong | INDXLONG |
| ddACHFtrSetup | DD40400 | IndexLong | INDXLONG |
| ddACHHdr | DD10400 | IndexLong | INDXLONG |
| ddACHHdrSetup | DD40400 | IndexLong | INDXLONG |
| ddACHItems | DD10500 | IndexLong | INDXLONG |
| ddEmpAcctMstr | DD00200 | IndexLong | INDXLONG |
| ddEmpAcctsTemp | temp | IndexLong | INDXLONG |
| ddEmpLineTemp | TEMP | IndexLong | INDXLONG |
| ddEmpMstr | DD00100 | IndexLong | INDXLONG |
| ddExceptions | DD10700 | IndexLong | INDXLONG |
| ddTrxHistDetail | DD30101 | IndexLong | INDXLONG |
| ddTrxHistHdr | DD30100 | IndexLong | INDXLONG |
| EmployeeListTemp | TEMP | User ID | USERID |
| IV_Suggest_Sales_Setup_LINE | IV00401 | Sales Script | SALESSCRIPT |
| IV_Suggest_Sales_Setup_LINE_TEMP | TEMP | Sales Script | SALESSCRIPT |
| MC_PM_Revaluation | MC020105 | Settled Gain or Loss on Current Trx Amount | SettledGainLossCurTrxAmt |
| Settled Gain or Loss on Disc Avail Amount | SettledGainLossDiscAvlAm | ||
| MUPR_DDNextIdx | DD40700 | IndexLong | INDXLONG |
| PM_SETP | PM40100 | PMDefaultCheckSort | PMDefaultCheckSort |
| popSelectPOItemsTemp | TEMP | Workflow Status | Workflow_Status |
| POP_PO | POP10100 | Workflow Status | Workflow_Status |
| POP_POHist | POP30100 | Workflow Status | Workflow_Status |
| POP_POLine | POP10110 | QTY Committed In Base Orig | QTYCommittedInBaseOrig |
| POP_PO_TEMP | TEMP | Workflow Status | Workflow_Status |
| POP_Setup | POP40100 | POP Requisition Number | POPRequisitionNumber |
| Req Hdr User Defined Prompt 1 | Req_Hdr_UD_Prompt1 | ||
| Req Hdr User Defined Prompt 2 | Req_Hdr_UD_Prompt2 | ||
| Req Line User Defined Prompt 1 | Req_Line_UD_Prompt1 | ||
| Req Line User Defined Prompt 2 | Req_Line_UD_Prompt2 | ||
| Requisition Code | RequisitionCode | ||
| Requisition Cost Selection | RequisitionCostSelection | ||
| Requisition Create One PO Per Address | ReqCreateOnePOPerAddress | ||
| Requisition Default Doc Date | RequisitionDefDocDate | ||
| Requisition Default Site Method | RequisitionDefSiteMethod | ||
| Requisition Maintain History | RequisitionMaintainHist | ||
| Requisition Transfer Line Comments | ReqTransferLineComments | ||
| Requisition Vendor Selection | RequisitionVendorSelect | ||
| SearchPOQtysFromRequisition | SearchPOQtysFromRequisit | ||
| PurchasingTrxTemp | TEMP | Comment ID | COMMNTID |
| Requested By | REQSTDBY | ||
| Requisition Description | RequisitionDescription | ||
| Requisition Status | RequisitionStatus | ||
| User Defined 1 | USERDEF1 | ||
| User Defined 2 | USERDEF2 | ||
| Workflow Due Time | Workflow_Due_Time | ||
| Workflow Instance ID | WorkflowInstanceID | ||
| Workflow Status | Workflow_Status | ||
| Workflow Step Instance ID | WorkflowStepInstanceID | ||
| Workflow Step Type | Workflow_Step_Type | ||
| Workflow Type Name | Workflow_Type_Name | ||
| RM_Statements_ROPT | RM40501 | Print Remaining Docs | PrintRemainingDocs |
| SOP_POGenItem | temp | Invalid Data Flag | InvalidDataFlag |
| Inventory Index | INVINDX | ||
| Requested By | REQSTDBY | ||
| Shipping Method | SHIPMTHD | ||
| SOP_POGenPO | temp | Invalid Data Flag | InvalidDataFlag |
| SOP_POGenSOLine | temp | Address Source | ADDRSOURCE |
| Break Field 2 | BRKFLD2 | ||
| Currency ID | CURNCYID | ||
| Freight Amount | FRTAMNT | ||
| Inventory Index | INVINDX | ||
| Item Number | ITEMNMBR | ||
| Non IV | NONINVEN | ||
| Originating Freight Amount | ORFRTAMT | ||
| Requested By | REQSTDBY | ||
| Requisition Date | REQTNDT | ||
| Requisition Description | RequisitionDescription | ||
| SOPO SOLINE Errors 2 | SOPO_SOLINE_Errors_2 | ||
| Unit Cost In Base U Of M | UNITCOSTINBSUOFM | ||
| SOP_POGenVendor | temp | Invalid Data Flag | InvalidDataFlag |
| SOP_POPLink | SOP60100 | Document Date | DOCDATE |
| Item Description | ITEMDESC | ||
| U Of M | UOFM | ||
| SOP_Suggest_Sales_Trx_TEMP | TEMP | QTY Available | QTYAVAIL |
| Quantity to Add | QTYTOADD | ||
| Sales Script | SALESSCRIPT | ||
| syCurrentResources | SY09400 | Avail Limited Users | AvailLmtdUsrs |
| syEmailCardSetup | SY04904 | Email Address Option | EmailAddressOption |
| syEmailMessages | SY04901 | Email Message Type | Email_Message_Type |
| Workflow Type Name | Workflow_Type_Name | ||
| syEmailReportSetup | SY04950 | Email File Format | EmailFileFormat |
| syListOptions | SY07200 | ListOption2 | ListOption2 |
| syListViewOptions | SY07225 | ListOption2 | ListOption2 |
| syReportProcessingStatusHdr | TEMP | Print to File | PRNTOFIL |
| syReportProcessingStatusLine | TEMP | Print to File | PRNTOFIL |
| syResourceExclusions | SY05200 | Resource Technical Name | RESTECHNAME |
| SY_Company_MSTR | SY01500 | Offline User | Offline_User |
| SY_Current_Activity | ACTIVITY | IsOffline | IsOffline |
| SY_Security_Operations_Report_TEMP | TEMP | Limited Window | LimitedWindow |
| SY_Security_Operation_Access_TEMP | TEMP | UserType | UserType |
| SY_Users_MSTR | SY01400 | ADObjectGuid | ADObjectGuid |
| SQLLoginID | SQLLoginID | ||
| Web Client User | WCUser | ||
| Window Command Display | WindowCommandDisplay | ||
| taxHistoryPrintTemp | temp | Discount Taken Amount | DISTKNAM |
| Document Number STR30 | DOCNUM30 | ||
| GST Discount Amount | GSTDSAMT | ||
| uprCrossCompanySummRptsTemp | TEMP | FICA/Med Add Tax Rate | FICAMed_Add_Tax_Rate |
| Medicare Tax Additional | Medicare_Tax_Additional | ||
| Medicare Wages and Tips Additional | Med_Wages_and_Tips_Add | ||
| UPR_MSTR | UPR00100 | User ID | USERID |
| UPR_SETP_Class | UPR41200 | Assignment Code | ASSIGNMENTCODE |
| Time on Behalf Code | Time_on_Behalf_Code | ||
| UPR_SETP_Info | UPR40200 | Include Inactive Employees | INCINEMP |
| View Multiple Directs | VIEWMULTDIR | ||
| UPR_TEMP_941_Totals | temp | FICA/Med Add Tax Rate | FICAMed_Add_Tax_Rate |
| Medicare Tax Additional | Medicare_Tax_Additional | ||
| Medicare Wages and Tips Additional | Med_Wages_and_Tips_Add |
Deleted Columns:
| Table Technical Name | Table Physical Name | Field Technical Name | Field Physical Name |
| ddACHCopy | DD10200 | Index | INDEX1 |
| ddACHCrossRef | DD10300 | Index | INDEX1 |
| ddACHFtrSetup | DD40400 | Index | INDEX1 |
| ddACHHdr | DD10400 | Index | INDEX1 |
| ddACHHdrSetup | DD40400 | Index | INDEX1 |
| ddACHItems | DD10500 | Index | INDEX1 |
| ddEmpAcctMstr | DD00200 | Index | INDEX1 |
| ddEmpAcctsTemp | temp | Index | INDEX1 |
| ddEmpLineTemp | TEMP | Index | INDEX1 |
| ddEmpMstr | DD00100 | Index | INDEX1 |
| ddExceptions | DD10700 | Index | INDEX1 |
| ddTrxHistDetail | DD30101 | Index | INDEX1 |
| ddTrxHistHdr | DD30100 | Index | INDEX1 |
| MUPR_DDNextIdx | DD40700 | Index | INDEX1 |
Comments
-
This is a VERY helpful post Dan! Somehow, when going from GP 2013 SP1 to GP 2016 R2, we applied the interim update (2013R2) and in one of the companies, it did not create any of the tables on your "new table list". So, I kept getting errors when it would try to access those tables to upgrade to Gp2016R2. So, what I did was go to one of the other database and scripted out the tables and it worked. We don't use those tables yet, so it was fine to go ahead and script out a blank table.. :)
-
-
-
-
-
-
1,730
*This post is locked for comments