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 |
1,730
*This post is locked for comments