Dynamics GP

Based on Dynamics GP 2015 (14.00.0804) in the Fabrikam, Ltd. database (TWO), we have created a reference table for functions.  This was originally created to help create SQL queries for building reports.  Functions that reference user-defined values may not be shown.




Dynamics Functions

TypeWhereValues
AA_FUNCData_Type1 = Alphanumeric
2 = Numeric
3 = Yes/No
4 = Date
AA_FUNCSearch_Type1 = Match All
2 = Match 1 or More
AA_FUNCTree_Type1 = Account Number
2 = Customer
3 = Employee
4 = Item
5 = Site
6 = Vendor
9 =
CPR_FUNCAccrual_Units1 = Days
2 = Hours
CPR_FUNCEthnic_Origin1 = Not Reported
2 = Caucasian
3 = Native
4 = Black
5 = Asian
6 = Hispanic
7 = Other
CPR_FUNCGender1 = Not Reported
2 = Male
3 = Female
CPR_FUNCPay_Periods1 = 12
2 = 24
3 = 26/27
4 = 52/53
CPR_FUNCPaycode_Type1 = Income
2 = Benefit
3 = Deduction
4 = Banked
CPR_FUNCPayment_Method1 = Direct Deposit
2 = Cheque
3 = Cash
DYN_FUNC1099_Box_Type?
DYN_FUNC1099_Type1 = Not a 1099 Vendor
2 = Dividend
3 = Interest
4 = Miscellaneous
DYN_FUNCABC_Code1 = (none)
2 = A
3 = B
4 = C
DYN_FUNCAccount_Category_Number?
DYN_FUNCAccount_Type1 = Posting Account
2 = Unit Account
3 = Posting Allocation Account
4 = Unit Allocation Account
DYN_FUNCAddress_Source0 = None
1 = Ship To
2 = Purchasing
3 = Site
4 = Company
DYN_FUNCAging_Bucket?
DYN_FUNCAllocate_By1 = Line Item
2 = Document/Batch
DYN_FUNCAttendance_TRX_Status1 = Posted
2 = Processing
3 = Processed
4 = Voided
5 = Accrual
6 = Auto Accrual
DYN_FUNCBalance_For_Calculation0 = Net Change
1 = Period Balances
DYN_FUNCBalance _Type0 = Open Item
1 = Balance Forward
DYN_FUNCBatch_Frequency1 = Single Use
2 = Weekly
3 = Biweekly
4 = Semimonthly
5 = Monthly
6 = Bimonthly
7 = Quarterly
8 = Miscellaneous
DYN_FUNCBoolean_All1 = Yes
Else = No
DYN_FUNCCash_Receipt_Type0 = Check
1 = Cash
2 = Credit Card
DYN_FUNCClosed_Year?
DYN_FUNCCM_Trx_Type1 = Deposit
2 = Receipt
3 = Check
4 = Withdrawal
5 = Increase Adjustment
6 = Decrease Adjustment
7 = Transfer
101 = Interest Income
102 = Other Income
103 = Other Expense
104 = Service Charge
DYN_FUNCCommission_Applied_To0 = Sales
1 = Invoice Total
DYN_FUNCComputer_TRX_Type1 = Paycode
2 = Deduction
3 = Benefit
DYN_FUNCControl_Blanket_By1 = Value
Else = Quantity
DYN_FUNCControl_Type_CM1 = Transaction
2 = Receipt
DYN_FUNCControl_Type_PM_Trx0 = Voucher
1 = Payment
DYN_FUNCConversion_Method1 = Current
2 = Weighted Average
3 = Historical
DYN_FUNCCost_Calculation_Method1 = Percent of Extended Cost
2 = Flat Amount
3 = Flat Amount Per Unit
DYN_FUNCCost_Selection1 = Vendor Last Originating Invoice Cost
2 = Item Current Cost
3 = Item Standard Cost
4 = Specified Cost (In Functional Currency)
DYN_FUNCCredit_Limit0 = No Credit
1 = Unlimited
2 = Amount
DYN_FUNCCredit_Limit_Type0 = No Credit
1 = Unlimited
2 = Amount
DYN_FUNCCurrency_Decimals1 = 0
2 = 1
3 = 2
4 = 3
5 = 4
6 = 5
DYN_FUNCDecimal_Places0 = 0
1 = 1
2 = 2
DYN_FUNCDecimal_Places_Currency1 = 0
2 = 1
3 = 2
4 = 3
5 = 4
6 = 6
DYN_FUNCDecimal_Places_QTYS1 = 0
2 = 1
3 = 2
4 = 3
5 = 4
6 = 5
DYN_FUNCDefault_Cash_Account_Type0 = Checkbook
1 = Customer
DYN_FUNCDeposit_Type1 = Deposit with Receipts
2 = Deposit without Receipts
3 = Clearing Deposit
DYN_FUNCDisplay_In_Lookups1 = Sales
2 = Inventory Control
3 = Purchasing
4 = Payroll
DYN_FUNCDocument_Prefix_RM_Trx?
DYN_FUNCDocument_Status_CM_Trx1 = Receipt
2 = Transaction
DYN_FUNCDocument_Status_GL_Sum1 = Current
2 = History
DYN_FUNCDocument_Status_GL_Trx1 = Work
2 = Open
3 = History
DYN_FUNCDocument_Status_IV_Trx1 = Unposted
2 = Posted
DYN_FUNCDocument_Status_PM_Trx1 = Unposted
2 = Posted
3 = History
DYN_FUNCDocument_Status_POP_Line_Items1 = Open
2 = History
DYN_FUNCDocument_Status_Purch_Trx1 = Open
2 = History
DYN_FUNCDocument_Status_RM_Trx1 = Unposted
2 = Posted
3 = History
DYN_FUNCDocument_Status_Sls_Trx1 = Unposted
2 = Posted
DYN_FUNCDocument_Status_SOP_Line_Items1 = Unposted
2 = Posted
DYN_FUNCDocument_Type_IV_Trx1 = Adjustment
2 = Variance
3 = Transfer
4 = Receipt
5 = Return
6 = Sale
7 = Bill of Materials
DYN_FUNCDocument_Type_PM_Trx?
DYN_FUNCDocument_Type_RM_Trx?
DYN_FUNCDocument_Type_Tax_Detail_Trx1 = Financial General Entry
2 = Receivables Sales / Invoices
3 = Receivables Scheduled Payments
4 = Receivables Debit Memos
5 = Receivables Finance Charges
6 = Receivables Service / Repairs
7 = Receivables Warranty
8 = Receivables Credit Memo
9 = Receivables Returns
10 = Receivables Payments
11 = Invoicing Invoice
12 = Invoicing Return
13 = Invoicing Packing Slip
14 = Sales Invoice
15 = Sales Return
16 = Payables Invoice
17 = Payables Finance Charge
18 = Payables Misc Charge
19 = Payables Return
20 = Payables Credit Memo
21 = Payables Payment
22 = Payables Schedule
23 = Purchasing Invoice
DYN_FUNCDTA_Series1 = All
2 = Financial
3 = Sales
4 = Purchasing
5 = Inventory
6 = Payroll
7 = Project
DYN_FUNCEIC_Filing_Status?
DYN_FUNCEthnic_Origin1 = White
2 = American Indian or Alaska Native
3 = Black
4 = Asian or Pacific Islander
5 = Hispanic
6 = Other
7 = N/A
DYN_FUNCFederal_Filing_Status1 = Exempt
DYN_FUNCFinance_Charge_Amt_Type0 = None
1 = Percent
2 = Amount
DYN_FUNCFixed_Or_Variable1 = Fixed Allocation
2 = Variable Allocation
DYN_FUNCForecast_Consumption_Period1 = Days
2 = Weeks
3 = Months
DYN_FUNCFree_On_Board1 = None
2 = Origin
3 = Destination
DYN_FUNCFreight_Taxable1 = Taxable
2 = Nontaxable
3 = Based on customers
DYN_FUNCFunctional_Currency_Decimals1 = 0
2 = 1
3 = 2
4 = 3
5 = 4
6 = 5
DYN_FUNCGender1 = Male
2 = Female
3 = N/A
DYN_FUNCGL_Header_Valid1 = Valid Account Number
2 = Valid Journal Entry
3 = Valid Posting Date
DYN_FUNCGL_Ledger_Description?
DYN_FUNCGL_Ledger_Name?
DYN_FUNCGL_Line_Valid1 = Valid Account Number
2 = Valid Offset Account Number
DYN_FUNCHistory_Year?
DYN_FUNCHR_Status1 = Active
2 = Family Leave
3 = Leave of Absence
4 = Maternity
5 = Retired
6 = Separated
7 = Suspended
8 = Terminated
9 = Other
DYN_FUNCInclude_In_Catalog1 = Procurement
DYN_FUNCItem_Tracking_Option1 = None
2 = Serial Numbers
3 = Lot Numbers
DYN_FUNCItem_Type1 = Sales Inventory
2 = Discontinued
3 = Kit
4 = Misc Charges
5 = Services
6 = Flat Fee
DYN_FUNCIV_Item_Taxable1 = Taxable
2 = Nontaxable
3 = Based on customers
DYN_FUNCKit_COGS_Account_Source0 = From Component Item
1 = From Kit Item
DYN_FUNCLine_Origin1 = Manual
2 = e. Req.
3 = SOP
4 = MRP
5 = SMS-CL
6 = SMS-RT
7 = SMS-DP
8 = MOP
9 = PO Gen
DYN_FUNCLine_Status1 = Gain Or Loss
2 = Normal Rounding
3 = One Sided
4 = Other Rounding
5 = Standard
6 = Unit Account
7 = Exchange Rate Variance
DYN_FUNCMaritalStatus1 = Married
2 = Single
3 = N/A
DYN_FUNCMarkdown_Type0 = Percent
1 = Dollar
DYN_FUNCMaximum_Invoice_Amount_For_Vendors0 = No Maximum
1 = Amount
DYN_FUNCMaximum_Writeoff_Type0 = Not Allowed
1 = Unlimited
2 = Maximum
DYN_FUNCTransaction_State0 = No Euro
1 = Non-Denomination to Non-Denomination
2 = Non-Denomination to Euro
3 = Non-Denomination to Denomination
4 = Denomination to Non-Denomination
5 = Denomination to Denomination
6 = Denomination to Euro
7 = Euro to Denomination
8 = Euro to Non-Denomination
DYN_FUNCMinimum_Payment_Type0 = No Minimum
1 = Percent
2 = Amount
DYN_FUNCMisc_Taxable1 = Taxable
2 = Nontaxable
3 = Based on customers
DYN_FUNCOpen_Year?
DYN_FUNCOrder_Fulfillment_Shortage_Default1 = None
2 = Back Order Remaining
3 = Cancel Remaining
DYN_FUNCOrder_Policy1 = Not Planned
2 = Lot for Lot
3 = Fixed Order Quantity
4 = Period Order Quantity
5 = Order Point
6 = Manually Planned
DYN_FUNCOriginal_Type1 = Quote
2 = Order
3 = Invoice
4 = Return
5 = Back Order
6 = Fulfillment Order
DYN_FUNCOriginating_DTA_Series0 = All
1 = Financial
2 = Sales
3 = Purchasing
4 = Inventory
5 = Payroll
6 = Project
DYN_FUNCOriginating_TRX_Type0 = Standard
1 = Reversing
2 = Clearing
DYN_FUNCOriginating_Type1 = Normal
2 = Clearing
3 = Recurring
4 = Business Form
DYN_FUNCPayment_Entry_Type0 = Check
1 = Cash
2 = Credit Card
DYN_FUNCPayroll_Record_Type1 = Pay Codes
2 = Deductions
3 = Benefits
4 = State Taxes
5 = Local Taxes
DYN_FUNCPO_Line_Status1 = New
2 = Released
3 = Change Order
4 = Received
5 = Closed
6 = Canceled
DYN_FUNCPO_Line_Status_Orig1 = New
2 = Released
3 = Change Order
4 = Received
5 = Closed
6 = Canceled
DYN_FUNCPO_Status1 = New
2 = Released
3 = Change Order
4 = Received
5 = Closed
6 = Canceled
DYN_FUNCPO_Status_Orig1 = New
2 = Released
3 = Change Order
4 = Received
5 = Closed
6 = Canceled
DYN_FUNCPO_Type1 = Standard
2 = Drop-Ship
3 = Blanket
4 = Drop-Ship Blanket
DYN_FUNCPOP_Order_Method1 = Order to Independent Site
2 = Order To Master Site
DYN_FUNCPOP_Tax_Schedule_Source0 = None
1 = Company
2 = Single-use
3 = Purchase
4 = Ship To
5 = Site
DYN_FUNCPOP_Type1 = Shipment
2 = Invoice
3 = Shipment/Invoice
4 = Return
5 = Return w/Credit
6 = IV Return
7 = IV Return w/Credit
8 = In-Transit
DYN_FUNCPOP_Vendor_Selection1 = Site Primary Vendor
2 = Vendor With Lowest Cost
3 = Vendor With Shortest Lead Time
DYN_FUNCPost_Inventory_In1 = Detail
2 = Summary
DYN_FUNCPost_Purchasing_In1 = Detail
2 = Summary
DYN_FUNCPost_Results_To_Customer0 = Receivables/Discount Acct
1 = Sales Offset Acct
DYN_FUNCPost_Results_To_Vendor0 = Payables/Discount Acct
1 = Purchasing Offset Acct
DYN_FUNCPost_To_Cash_Account_From0 = Checkbook
1 = Vendor
DYN_FUNCPosting_Status_MDA1 = Unposted
2 = Posted
3 = Posted With Error
DYN_FUNCPosting_Status_POP_Receipt_Lines1 = Unposted
2 = Posted
DYN_FUNCPosting_Status_POP_Receipts1 = Unposted
2 = Posted
DYN_FUNCPosting_Status_SOP_Line_Items0 = Unposted
2 = Posted
3 = Posted With Error
DYN_FUNCPosting_Type0 = Balance Sheet
1 = Profit and Loss
DYN_FUNCPrice_Method1 = Currency Amount
2 = % of List Price
3 = % Markup - Current Cost
4 = % Markup - Standard Cost
5 = % Margin - Current Cost
6 = % Margin - Standard Cost
DYN_FUNCPrinting_Status1 = Print
DYN_FUNCPriority1 = None
2 = 1
3 = 2
4 = 3
...
98 = 97
99 = 98
100 = 99
DYN_FUNCPurchase_Freight_Taxable1 = Taxable
2 = Nontaxable
3 = Based on vendor
DYN_FUNCPurchase_IV_Item_Taxable1 = Taxable
2 = Nontaxable
3 = Based on vendor
DYN_FUNCPurchase_Misc_Taxable1 = Taxable
2 = Nontaxable
3 = Based on vendor
DYN_FUNCPurchase_Receipt_Type1 = Adjustment
2 = Variance
3 = Transfer
4 = Override
5 = Receipt
6 = Return
7 = Assembly
DYN_FUNCPurchase_Tax_Options1 = Taxable
2 = Nontaxable
3 = Based on vendor
DYN_FUNCPurchasing_Status1 = None
2 = Needs Purchase
3 = Purchased
4 = Partially Received
5 = Fully Received
DYN_FUNCQTY_Type1 = On Hand
2 = Returned
3 = In Use
4 = In Service
5 = Damaged
DYN_FUNCRate_Calc_Method0 = Multiply
1 = Divide
DYN_FUNCRate_Calc_Method_POP_Line_Items0 = Multiply
1 = Divide
DYN_FUNCRate_Calc_Method_POP_Receipts0 = Multiply
1 = Divide
DYN_FUNCRate_Calculation_Method0 = Multiply
1 = Divide
DYN_FUNCReceipt_Type1 = Check
2 = Cash
3 = Credit Card
DYN_FUNCReceiving_MC_Transaction_State0 = No Euro
1 = Non-Denomination to Non-Denomination
2 = Non-Denomination to Euro
3 = Non-Denomination to Denomination
4 = Denomination to Non-Denomination
5 = Denomination to Denomination
6 = Denomination to Euro
7 = Euro to Denomination
8 = Euro to Non-Denomination
DYN_FUNCReceiving_Rate_Calc_Method0 = Multiply
1 = Divide
DYN_FUNCRecord_Status1 = Begin
2 = Comit
3 = Voiding
DYN_FUNCRecord_Type1 = Overall
2 = Site
DYN_FUNCReplenishment_Level1 = Order Point Quantity
2 = Order-Up-To Level
3 = Vendor EOQ
DYN_FUNCReplenishment_Method1 = Make
2 = Buy
DYN_FUNCRequisition_Document_Status1 = Work
2 = History
DYN_FUNCRequisition_Status1 = Saved
2 = Submitted
3 = Partially Purchased
4 = Purchased
5 = Canceled
6 = Voided
DYN_FUNCReversing_Closed_Year?
DYN_FUNCReversing_Year?
DYN_FUNCRM_Document_TypeAll?
DYN_FUNCSalary_Change1 = Reallocate Dollars
2 = Reallocate Hours
3 = Reduce Dollars
4 = Reduce Hours
5 = Additional Amount
DYN_FUNCSeries_GL_Trx1 = All
2 = Financial
3 = Sales
4 = Purchasing
5 = Inventory
6 = Payroll
7 = Project
DYN_FUNCSeries_Tax_Detail_Trx1 = Financial
2 = Receivables
3 = Invoicing
4 = Sales
5 = Payables
6 = Purchasing
DYN_FUNCSick_Time_Accrual_Method0 = Hours Worked
1 = Set Hours
DYN_FUNCSOP_Distribution_Type1 = SALES
2 = RECV
3 = CASH
4 = TAKEN
5 = AVAIL
6 = TRADE
7 = FREIGHT
8 = MISC
9 = TAXES
10 = MARK
11 = COMMEXP
12 = COMMPAY
13 = OTHER
14 = COGS
15 = INV
16 = RETURNS
17 = IN USE
18 = IN SERVICE
19 = DAMAGED
20 = UNIT
21 = DEPOSITS
22 = ROUND
23 = REBATE
DYN_FUNCSOP_Status?
DYN_FUNCSOP_Type1 = Quote
2 = Order
3 = Invoice
4 = Return
5 = Back Order
6 = Fulfillment Order
DYN_FUNCSource_Indicator1 = (none)
2 = Issue
3 = Reverse Issue
4 = Finish Good Post
5 = Reverse Finished Good Post
DYN_FUNCStatement_Cycle1 = No Statement
2 = Weekly
3 = Biweekly
4 = Semimonthly
5 = Monthly
6 = Bimonthly
7 = Quarterly
DYN_FUNCStatus_Group1 = Active
2 = Closed
DYN_FUNCSummary_Type1 = Calendar
2 = Fiscal
DYN_FUNCTax_Detail_Type1 = Sales
2 = Purchases
DYN_FUNCTax_Options1 = Taxable
2 = Nontaxable
3 = Base on customers
DYN_FUNCTax_Schedule_Source0 = No Error
1 = Using Site Schedule ID
2 = Using Ship To Schedule ID
3 = Using Single Schedule
4 = Schedule ID Empty
5 = Schedule ID Not Found
6 = Shipping Method Not Found
7 = Setup File Missing/Damaged
8 = Site Location Not Found
9 = Address Record Not Found
DYN_FUNCTax_Schedule_Source_from_Sales_Line_Item0 = No Error
1 = Using Site Schedule ID
2 = Using Ship To Schedule ID
3 = Using Single Schedule
4 = Schedule ID Empty
5 = Schedule ID Not Found
6 = Shipping Method Not Found
7 = Setup File Missing/Damaged
8 = Site Location Not Found
9 = Address Record Not Found
DYN_FUNCTime_Type1 = Hourly
2 = Salary
3 = Overtime
4 = Benefit
5 = Absent
6 = Other
DYN_FUNCTip_Type1 = Directly
2 = Indirectly
DYN_FUNCTransaction_Type0 = Standard
1 = Reversing
2 = Clearing
DYN_FUNCTransfer_From_QTY_Type1 = On Hand
2 = Returned
3 = In Use
4 = In Service
5 = Damaged
DYN_FUNCTransfer_To_QTY_Type1 = On Hand
2 = Returned
3 = In Use
4 = In Service
5 = Damaged
DYN_FUNCTRX_Frequency1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = Bimonthly
6 = Quarterly
7 = Miscellaneous
DYN_FUNCType_of_Employment1 = Full Time Regular
2 = Full Time Temp
3 = Part Time Regular
4 = Part Time Temp
5 = Intern
6 = Other
DYN_FUNCTypical_Balance0 = Debit
1 = Credit
DYN_FUNCVacation_Accrual_Method0 = Hours Worked
1 = Set Hours
DYN_FUNCValuation_Method1 = FIFO Perpetual
2 = LIFO Perpetual
3 = Average Perpetual
4 = FIFO Periodic
5 = LIFO Periodic
DYN_FUNCVendor_Status1 = Active
2 = Inactive
3 = Temporary
DYN_FUNCVoid_Status0 = Normal
1 = Voided
DYN_FUNCVoided0 = No
1 = Yes
DYN_FUNCWhich_Cash_Account_For_Pay0 = Checkbook
1 = Employee
DYN_FUNCWorkflow_Approval_Status1 = Not Submitted
2 = Submitted
3 = Not Needed
4 = Pending Approval
5 = Pending Changes
6 = Approved
7 = Rejected
8 = Ended
9 = Not Enabled
10 = Disabled
DYN_FUNCWorkflow_Priority1 = Low
2 = Normal
3 = High
DYN_FUNCWorkflow_Status1 = Not Submitted
3 = No Action Needed
4 = Pending User Action
5 = Recalled
6 = Completed
7 = Rejected
9 = Not Activated
DYN_FUNCWriteoff0 = Not Allowed
1 = Unlimited
2 = Maximum
FA_FUNCAmortization_Code1 = Daily
2 = Weekly
3 = Monthly
4 = Quarterly
5 = Yearly
6 = Percentage
7 = Rate
FA_FUNCAsset_Status1 = Active
2 = Deleted
3 = Partial Open
4 = Retired
FA_FUNCAsset_Type1 = New
2 = Used
3 = Leased
FA_FUNCAveraging_Convention1 = Half-Year
2 = Modified Half-Year
3 = Mid-Month (1st)
4 = Mid-Month (15th)
5 = Mid-Quarter
6 = Next Month
7 = Full Month
8 = Next Year
9 = Full Year
10 = Full Year All Year
11 = None
12 = Next Period
13 = Full Period
FA_FUNCDepreciation_Method1 = Straight-Line Orig Life
2 = Straight-Line Rem Life
3 = 125% DB
4 = 150% DB
5 = 175% DB
6 = 200% DB
7 = SOY Digits
8 = Remaining Life
9 = Amortization
10 = ACRS Personal
11 = ACRS Real
12 = ACRS Real MSL
13 = ACRS LIH
14 = ACRS Foreign Real
15 = No Depreciation
16 = Declining Balance
FA_FUNCLease_Type_Lease1 = Capital
2 = Operating
FA_FUNCLuxury_Automobile_Indicator1 = No
2 = Yes
FA_FUNCProperty_Type1 = Personal
2 = Personal, Listed
3 = Real
4 = Real, Listed
5 = Real, Conservation
6 = Real, Energy
7 = Real, Farms
8 = Real, Low Income Housing
9 = Amortizable
FA_FUNCRetirement_Type1 = Abandonment
2 = Casualty
3 = Involuntary Conversion
4 = Life-Kind Exchange
5 = Mass Retirement
6 = Sale
7 = Taxable Exchange
8 = Other
FA_FUNCSwitch_From_1_Method1 = Straight-Line Orig Life
2 = Straight-Line Rem Life
3 = 125% DB
4 = 150% DB
5 = 175% DB
6 = 200% DB
7 = SOY Digits
8 = Remaining Life
9 = Amortization
10 = ACRS Personal
11 = ACRS Real
12 = ACRS Real MSL
13 = ACRS LIH
14 = ACRS Foreign Real
15 = No Depreciation
16 = Declining Balance
FA_FUNCSwitchover1 = No Switch
2 = Straight-Line
FA_FUNCTransaction_Account_Type1 = Reserve
2 = Depreciation
3 = Cost
4 = Proceeds
5 = Recognized Gain/Loss
6 = Non Recognized Gain/Loss
7 = Clearing
FS_FUNCBill_Period1 = Days
2 = Months
3 = Years
FS_FUNCBilling_Cycle1 = Monthly
2 = Bi-Monthly
3 = Quarterly
4 = Semi-Annual
5 = Annual
FS_FUNCBilling_Status1 = Invoiced
2 = Cancelled
3 = On Hold
4 = Pending Cancellation
5 = Evergreen Terminated
FS_FUNCContract_Period1 = Days
2 = Months
3 = Years
FS_FUNCContract_Record_Type1 = Quote
2 = Contract
3 = Template
4 = History
FS_FUNCContract_Transfer_Status1 = Not Transferred
2 = Transferred
3 = Auto-Renewed
FS_FUNCMaster_Service_Record_Type1 = Quote
2 = Open
3 = Invoiced
FS_FUNCOrigin1 = Quote
2 = Open
3 = History
4 = Template
FS_FUNCRenewing_Contract_Type1 = Quote
2 = Contract
3 = Template
4 = History
FS_FUNCReturn_Origin1 = None
2 = Service Call
3 = Sales Invoice
FS_FUNCReturn_Record_Type1 = Open
2 = Closed
FS_FUNCRMA_Status1 = Repair
2 = Credit
3 = Replace
4 = Cross-Ship
5 = None
6 = None
7 = Open RTV or Work Order exists
8 = Received
10 = Closed
20 = Voided
FS_FUNCRTV_Status1 = Entered
2 = Ready To Ship
3 = Shipped
4 = Partial Rcv.
5 = Received
6 = Closed
FS_FUNCService_Record_Type1 = Quote
2 = Open
3 = Invoiced
FS_FUNCSource_Contract_Type1 = Quote
2 = Contract
3 = Template
4 = History
FS_FUNCSVC_Liability_Type1 = Straight-Line
2 = Block Time
3 = Retainage
4 = Based on Calls
5 = Metered
FS_FUNCSVC_PM_Month1 = January
2 = February
3 = March
4 = April
5 = May
6 = June
7 = July
8 = August
9 = September
10 = October
11 = November
12 = December
FS_FUNCWork_Order_Record_Type1 = Quote
2 = Open
3 = History
4 = Template
HR_FUNCAssignment_Status1 = Assigned
2 = Reserved
3 = On Hold with Pay and Benefits
4 = On Hold without Pay and Benefits
5 = Available
6 = Temporary
HR_FUNCBase_Step_Increases_On1 = Hire Date
2 = Adjusted Hire Date
3 = Seniority Date
4 = Manual
HR_FUNCBenefit_Formula1 = Single
2 = Multiple
HR_FUNCBenefit_Frequency1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = Quarterly
6 = Semiannually
7 = Annually
8 = Daily/Miscellaneous
HR_FUNCBenefit_Kind1 = Medical
2 = Life/Disability
3 = Retirement
4 = Miscellaneous Benefits
HR_FUNCBenefit_Method1 = Percent of Gross Wages
2 = Percent of Net Wages
3 = Percent of Deduction
4 = Fixed Amount
5 = Amount per Unit
HR_FUNCBenefit_Status1 = Active
2 = Inactive
3 = Waived
4 = Ineligible
5 = COBRA
6 = Terminated
7 = FMLA
8 = Pending
HR_FUNCColor_Code1 = Blue Diamond
2 = Green Circle
3 = Yellow Square
4 = Red Stop Symbol
5 = Not Available
HR_FUNCCompletion_Status1 = Complete
2 = Incomplete_Ben
3 = Incomplete_Ded
4 = Incomplete_Both
5 = Incomplete_Both_Ben
6 = Incomplete_Both_Ded
HR_FUNCDate2Digits?
HR_FUNCDeduction_Formula0 = Single
1 = Multiple
HR_FUNCDeduction_Method1 = Percent of Gross Wages
2 = Percent of Net Wages
3 = Fixed Amount
4 = Amount per Unit
HR_FUNCDeduction_Type1 = Standard
2 = Garnishment
HR_FUNCEEO_Age1 = 18 - 25
2 = 26 - 35
3 = 36 - 45
4 = 46 - 55
5 = 56 +
6 = Unknown
7 = 00 - 17
HR_FUNCEEOClass & EEOClassPref1 & 0 = First/Mid-Level Officials and MGRs
1 & 1 = Officials and Administrators
2 & * = Professionals
3 & * = Technicians
4 & 0 = Sales Workers
4 & 1 = Protective Service Workers
5 & 0 = Administrative Support Workers
5 & 1 = Paraprofessionals
6 & 0 = Craft Workers
6 & 1 = Administrative Support (Including Clerical and Sales)
7 & 0 = Operatives
7 & 1 = Skilled Craft Workers
8 & 0 = Laborers and Helpers
8 & 1 = Service Maintenance
9 & 0 = Service Workers
10 & 0 = Ex/SR- Level officials and MGRs
HR_FUNCEthnic_Origin1 = White
2 = American Indian or Alaska Native
3 = Black
4 = Asian or Pacific Islander
5 = Hispanic
6 = Other
7 = N/A
HR_FUNCFLSA_Status1 = Exempt
2 = Non Exempt - Salary
3 = Non Exempt - Hourly
HR_FUNCFormatDateMM/DD/YYYY
HR_FUNCGender1 = Male
2 = Female
3 = N/A
HR_FUNCGender_GB1 = Female
2 = Unknown
3 =
HR_FUNCHR_Status1 = Active
2 = Family Leave
3 = Leave of Absence
4 = Maternity
5 = Retired
6 = Separated
7 = Suspended
8 = Terminated
9 = Other
HR_FUNCInheritance_Status1 = Completed
2 = Changed
3 = Saved
HR_FUNCMarital_Status1 = Married
2 = Single
3 = N/A
HR_FUNCPay_Rate_Based_On0 = Seat
1 = Employee Paycode
HR_FUNCPay_Type1 = Hourly
2 = Salary
3 = Piecework
4 = Commission
5 = Business Expense
6 = Overtime
7 = Double Time
8 = Vacation
9 = Sick
10 = Holiday
11 = Pension
12 = Other
13 = Earned Income Credit
14 = Charged Tips
15 = Reported Tips
16 = Minimum Wage Balance
HR_FUNCPermanent_Option0 = Included
1 = Not Included
HR_FUNCPosition_Status1 = Active
2 = Inactive
HR_FUNCPremium_Method0 = Amount
1 = Percent
HR_FUNCRef_Source_DDL1 = Word of Mouth
2 = Referred to by an Employee
3 = Referred to by an Agency
4 = Newspaper
5 = Other
6 = Internet
HR_FUNCReject_Reason1 = Testing
2 = Interview
3 = References
4 = Experience
5 = Education
6 = Other
HR_FUNCRejection_Reason1 = Testing
2 = Interview
3 = References
4 = Experience
5 = Education
6 = Other
HR_FUNCRelocation0 = Yes
1 = No
HR_FUNCSeat_Type0 = Permanent
1 = Temporary
HR_FUNCStatus_Applicant1 = Active
2 = Open
3 = Rejected
4 = Hired
5 = Other
HR_FUNCType_of_Code1 = Benefit
2 = Deduction
3 = Both
HR_FUNCType_of_Employment1 = Full Time Regular
2 = Full Time Temp
3 = Part Time Regular
4 = Part Time Temp
5 = Intern
6 = Other
HR_FUNCUnit_of_Pay1 = Hourly
2 = Salary
MFG_FUNCBOM_Category1 = Regular
2 = Modular
3 = Phantom
4 = Option
MFG_FUNCBOM_Type1 = MFG BOM
2 = ENG. BOM
3 = ARCH. BOM
4 = CONFIG. BOM
5 = SUPER BOM
MFG_FUNCComponent_BOM_Type1 = MFG BOM
2 = ENG. BOM
3 = ARCH. BOM
4 = CONFIG. BOM
5 = SUPER BOM
MFG_FUNCItem_Fulfillment_Method1 = Make to Stock
2 = Make to Order - Manual
3 = Make to Order - Silent
MFG_FUNCItem_Status1 = Active
2 = Inactive
3 = Service
4 = Obsolete
5 = Prerelease
6 = Released
MFG_FUNCItem_Tracking_Option1 = None
2 = Lot Tracked
3 = Serial Tracked
4 = WIP Material
MFG_FUNCMakeBuy1 = Make
2 = Either
3 = Buy
MFG_FUNCMO_Priority1 = High
2 = Medium
3 = Low
MFG_FUNCMO_Status1 = Quote/Estimate
2 = Open
3 = Released
4 = Hold
5 = Canceled
6 = Complete
7 = Partially Received
8 = Closed
MFG_FUNCOffset_From1 = MO Start Date
2 = MO Due Date
MFG_FUNCOutsourced1 = No
2 = Yes
MFG_FUNCScheduling_Method1 = Forward Infinite
2 = Backward Infinite
PA_FUNCAccounting_Method1 = When Performed
2 = When Billed
3 = Cost-to-Cost
4 = Effort-Expended
5 = Completed
6 = Effort Expended - Labor Only
PA_FUNCBilling_Type1 = STD
2 = N/C
3 = N/B
PA_FUNCEmployed_By1 = Company
2 = Placement Agency
3 = Subcontractor
PA_FUNCFreight_Taxable1 = Taxable
2 = Nontaxable
3 = Base on customers
PA_FUNCFrequency1 = Daily
2 = Weekly
3 = Semimonthly
4 = Monthly
5 = Quarterly
6 = Semiannually
7 = Annually
PA_FUNCIV_Transfer_Type1 = Standard
2 = Return
3 = Return From Project
PA_FUNCLabor_Rate_Table_Type1 = Employee
2 = Position
PA_FUNCMisc_Taxable1 = Taxable
2 = Nontaxable
3 = Base on customers
PA_FUNCAccounting_Method1 = When Performed
2 = When Billed
3 = Cost-to-Cost
4 = Effort-Expended
5 = Completed
6 = Effort Expended - Labor Only
PA_FUNCBiller_Trx_Type1 = Invoice
2 = TM Return
PA_FUNCFreight_Taxable_Purchase1 = Taxable
2 = Nontaxable
3 = Based on vendor
PA_FUNCMisc_Taxable_Purchase1 = Taxable
2 = Nontaxable
3 = Based on vendor
PA_FUNCProject_Type1 = Time & Materials
2 = Cost Plus
3 = Fixed Price
PA_FUNCPA_Status1 = Open
2 = On Hold
3 = Closed
4 = Estimate
5 = Completed
6 = PAcontractstatus_6 from PA41701
7 = PAcontractstatus_7 from PA41701
8 = PAcontractstatus_8 from PA41701
9 = PAcontractstatus_9 from PA41701
10 = PAcontractstatus_10 from PA41701
PA_FUNCProfit_Type_CP1 = Billing Rate
2 = Markup %
3 = Profit/Unit-Fixed
4 = Profit/Unit-Variable
5 = Total Profit
6 = % of Baseline
7 = % of Actual
8 = None
9 = Price Level
PA_FUNCProfit_Type_FP1 = Billing Rate
2 = Markup %
3 = Profit/Unit-Fixed
4 = Profit/Unit-Variable
5 = Total Profit
6 = % of Baseline
7 = % of Actual
8 = None
9 = Price Level
PA_FUNCProfit_Type_TM1 = Billing Rate
2 = Markup %
3 = Profit/Unit-Fixed
4 = Profit/Unit-Variable
5 = Total Profit
6 = % of Baseline
7 = % of Actual
8 = None
9 = Price Level
PA_FUNCProject_Type1 = Time & Materials
2 = Cost Plus
3 = Fixed Price
PA_FUNCPurchase_Tax_Option1 = Taxable
2 = Nontaxable
3 = Based on vendor
PA_FUNCSales_Tax_Option1 = Taxable
2 = Nontaxable
3 = Based on customer
PA_FUNCStatus1 = Open
2 = On Hold
3 = Closed
4 = Estimate
5 = Completed
6 = PAprojectstatus_6 from PA41701
7 = PAprojectstatus_7 from PA41701
8 = PAprojectstatus_8 from PA41701
9 = PAprojectstatus_9 from PA41701
10 = PAprojectstatus_10 from PA41701
PA_FUNCTransaction_Type1 = Standard
2 = Referenced
PA_FUNCTransaction_Usage1 = Timesheet
2 = Equipment Log
3 = Miscellaneous Log
4 = Purchases/Material
5 = Employee Expense

 

 

Leave A Reply

Your email address will not be published.