A | B | C | |
---|---|---|---|
1 | Type | Where | Values |
2 | AA_FUNC | Data_Type | 1 = Alphanumeric 2 = Numeric 3 = Yes/No 4 = Date |
3 | AA_FUNC | Search_Type | 1 = Match All 2 = Match 1 or More |
4 | AA_FUNC | Tree_Type | 1 = Account Number 2 = Customer 3 = Employee 4 = Item 5 = Site 6 = Vendor 9 = |
5 | CPR_FUNC | Accrual_Units | 1 = Days 2 = Hours |
6 | CPR_FUNC | Ethnic_Origin | 1 = Not Reported 2 = Caucasian 3 = Native 4 = Black 5 = Asian 6 = Hispanic 7 = Other |
7 | CPR_FUNC | Gender | 1 = Not Reported 2 = Male 3 = Female |
8 | CPR_FUNC | Pay_Periods | 1 = 12 2 = 24 3 = 26/27 4 = 52/53 |
9 | CPR_FUNC | Paycode_Type | 1 = Income 2 = Benefit 3 = Deduction 4 = Banked |
10 | CPR_FUNC | Payment_Method | 1 = Direct Deposit 2 = Cheque 3 = Cash |
11 | DYN_FUNC | 1099_Box_Type | ? |
12 | DYN_FUNC | 1099_Type | 1 = Not a 1099 Vendor 2 = Dividend 3 = Interest 4 = Miscellaneous |
13 | DYN_FUNC | ABC_Code | 1 = (none) 2 = A 3 = B 4 = C |
14 | DYN_FUNC | Account_Category_Number | ? |
15 | DYN_FUNC | Account_Type | 1 = Posting Account 2 = Unit Account 3 = Posting Allocation Account 4 = Unit Allocation Account |
16 | DYN_FUNC | Address_Source | 0 = None 1 = Ship To 2 = Purchasing 3 = Site 4 = Company |
17 | DYN_FUNC | Aging_Bucket | ? |
18 | DYN_FUNC | Allocate_By | 1 = Line Item 2 = Document/Batch |
19 | DYN_FUNC | Attendance_TRX_Status | 1 = Posted 2 = Processing 3 = Processed 4 = Voided 5 = Accrual 6 = Auto Accrual |
20 | DYN_FUNC | Balance_For_Calculation | 0 = Net Change 1 = Period Balances |
21 | DYN_FUNC | Balance _Type | 0 = Open Item 1 = Balance Forward |
22 | DYN_FUNC | Batch_Frequency | 1 = Single Use 2 = Weekly 3 = Biweekly 4 = Semimonthly 5 = Monthly 6 = Bimonthly 7 = Quarterly 8 = Miscellaneous |
23 | DYN_FUNC | Boolean_All | 1 = Yes Else = No |
24 | DYN_FUNC | Cash_Receipt_Type | 0 = Check 1 = Cash 2 = Credit Card |
25 | DYN_FUNC | Closed_Year | ? |
26 | DYN_FUNC | CM_Trx_Type | 1 = 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 |
27 | DYN_FUNC | Commission_Applied_To | 0 = Sales 1 = Invoice Total |
28 | DYN_FUNC | Computer_TRX_Type | 1 = Paycode 2 = Deduction 3 = Benefit |
29 | DYN_FUNC | Control_Blanket_By | 1 = Value Else = Quantity |
30 | DYN_FUNC | Control_Type_CM | 1 = Transaction 2 = Receipt |
31 | DYN_FUNC | Control_Type_PM_Trx | 0 = Voucher 1 = Payment |
32 | DYN_FUNC | Conversion_Method | 1 = Current 2 = Weighted Average 3 = Historical |
33 | DYN_FUNC | Cost_Calculation_Method | 1 = Percent of Extended Cost 2 = Flat Amount 3 = Flat Amount Per Unit |
34 | DYN_FUNC | Cost_Selection | 1 = Vendor Last Originating Invoice Cost 2 = Item Current Cost 3 = Item Standard Cost 4 = Specified Cost (In Functional Currency) |
35 | DYN_FUNC | Credit_Limit | 0 = No Credit 1 = Unlimited 2 = Amount |
36 | DYN_FUNC | Credit_Limit_Type | 0 = No Credit 1 = Unlimited 2 = Amount |
37 | DYN_FUNC | Currency_Decimals | 1 = 0 2 = 1 3 = 2 4 = 3 5 = 4 6 = 5 |
38 | DYN_FUNC | Decimal_Places | 0 = 0 1 = 1 2 = 2 |
39 | DYN_FUNC | Decimal_Places_Currency | 1 = 0 2 = 1 3 = 2 4 = 3 5 = 4 6 = 6 |
40 | DYN_FUNC | Decimal_Places_QTYS | 1 = 0 2 = 1 3 = 2 4 = 3 5 = 4 6 = 5 |
41 | DYN_FUNC | Default_Cash_Account_Type | 0 = Checkbook 1 = Customer |
42 | DYN_FUNC | Deposit_Type | 1 = Deposit with Receipts 2 = Deposit without Receipts 3 = Clearing Deposit |
43 | DYN_FUNC | Display_In_Lookups | 1 = Sales 2 = Inventory Control 3 = Purchasing 4 = Payroll |
44 | DYN_FUNC | Document_Prefix_RM_Trx | ? |
45 | DYN_FUNC | Document_Status_CM_Trx | 1 = Receipt 2 = Transaction |
46 | DYN_FUNC | Document_Status_GL_Sum | 1 = Current 2 = History |
47 | DYN_FUNC | Document_Status_GL_Trx | 1 = Work 2 = Open 3 = History |
48 | DYN_FUNC | Document_Status_IV_Trx | 1 = Unposted 2 = Posted |
49 | DYN_FUNC | Document_Status_PM_Trx | 1 = Unposted 2 = Posted 3 = History |
50 | DYN_FUNC | Document_Status_POP_Line_Items | 1 = Open 2 = History |
51 | DYN_FUNC | Document_Status_Purch_Trx | 1 = Open 2 = History |
52 | DYN_FUNC | Document_Status_RM_Trx | 1 = Unposted 2 = Posted 3 = History |
53 | DYN_FUNC | Document_Status_Sls_Trx | 1 = Unposted 2 = Posted |
54 | DYN_FUNC | Document_Status_SOP_Line_Items | 1 = Unposted 2 = Posted |
55 | DYN_FUNC | Document_Type_IV_Trx | 1 = Adjustment 2 = Variance 3 = Transfer 4 = Receipt 5 = Return 6 = Sale 7 = Bill of Materials |
56 | DYN_FUNC | Document_Type_PM_Trx | ? |
57 | DYN_FUNC | Document_Type_RM_Trx | ? |
58 | DYN_FUNC | Document_Type_Tax_Detail_Trx | 1 = 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 |
59 | DYN_FUNC | DTA_Series | 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll 7 = Project |
60 | DYN_FUNC | EIC_Filing_Status | ? |
61 | DYN_FUNC | Ethnic_Origin | 1 = White 2 = American Indian or Alaska Native 3 = Black 4 = Asian or Pacific Islander 5 = Hispanic 6 = Other 7 = N/A |
62 | DYN_FUNC | Federal_Filing_Status | 1 = Exempt |
63 | DYN_FUNC | Finance_Charge_Amt_Type | 0 = None 1 = Percent 2 = Amount |
64 | DYN_FUNC | Fixed_Or_Variable | 1 = Fixed Allocation 2 = Variable Allocation |
65 | DYN_FUNC | Forecast_Consumption_Period | 1 = Days 2 = Weeks 3 = Months |
66 | DYN_FUNC | Free_On_Board | 1 = None 2 = Origin 3 = Destination |
67 | DYN_FUNC | Freight_Taxable | 1 = Taxable 2 = Nontaxable 3 = Based on customers |
68 | DYN_FUNC | Functional_Currency_Decimals | 1 = 0 2 = 1 3 = 2 4 = 3 5 = 4 6 = 5 |
69 | DYN_FUNC | Gender | 1 = Male 2 = Female 3 = N/A |
70 | DYN_FUNC | GL_Header_Valid | 1 = Valid Account Number 2 = Valid Journal Entry 3 = Valid Posting Date |
71 | DYN_FUNC | GL_Ledger_Description | ? |
72 | DYN_FUNC | GL_Ledger_Name | ? |
73 | DYN_FUNC | GL_Line_Valid | 1 = Valid Account Number 2 = Valid Offset Account Number |
74 | DYN_FUNC | History_Year | ? |
75 | DYN_FUNC | HR_Status | 1 = Active 2 = Family Leave 3 = Leave of Absence 4 = Maternity 5 = Retired 6 = Separated 7 = Suspended 8 = Terminated 9 = Other |
76 | DYN_FUNC | Include_In_Catalog | 1 = Procurement |
77 | DYN_FUNC | Item_Tracking_Option | 1 = None 2 = Serial Numbers 3 = Lot Numbers |
78 | DYN_FUNC | Item_Type | 1 = Sales Inventory 2 = Discontinued 3 = Kit 4 = Misc Charges 5 = Services 6 = Flat Fee |
79 | DYN_FUNC | IV_Item_Taxable | 1 = Taxable 2 = Nontaxable 3 = Based on customers |
80 | DYN_FUNC | Kit_COGS_Account_Source | 0 = From Component Item 1 = From Kit Item |
81 | DYN_FUNC | Line_Origin | 1 = Manual 2 = e. Req. 3 = SOP 4 = MRP 5 = SMS-CL 6 = SMS-RT 7 = SMS-DP 8 = MOP 9 = PO Gen |
82 | DYN_FUNC | Line_Status | 1 = Gain Or Loss 2 = Normal Rounding 3 = One Sided 4 = Other Rounding 5 = Standard 6 = Unit Account 7 = Exchange Rate Variance |
83 | DYN_FUNC | MaritalStatus | 1 = Married 2 = Single 3 = N/A |
84 | DYN_FUNC | Markdown_Type | 0 = Percent 1 = Dollar |
85 | DYN_FUNC | Maximum_Invoice_Amount_For_Vendors | 0 = No Maximum 1 = Amount |
86 | DYN_FUNC | Maximum_Writeoff_Type | 0 = Not Allowed 1 = Unlimited 2 = Maximum |
87 | DYN_FUNC | Transaction_State | 0 = 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 |
88 | DYN_FUNC | Minimum_Payment_Type | 0 = No Minimum 1 = Percent 2 = Amount |
89 | DYN_FUNC | Misc_Taxable | 1 = Taxable 2 = Nontaxable 3 = Based on customers |
90 | DYN_FUNC | Open_Year | ? |
91 | DYN_FUNC | Order_Fulfillment_Shortage_Default | 1 = None 2 = Back Order Remaining 3 = Cancel Remaining |
92 | DYN_FUNC | Order_Policy | 1 = Not Planned 2 = Lot for Lot 3 = Fixed Order Quantity 4 = Period Order Quantity 5 = Order Point 6 = Manually Planned |
93 | DYN_FUNC | Original_Type | 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order |
94 | DYN_FUNC | Originating_DTA_Series | 0 = All 1 = Financial 2 = Sales 3 = Purchasing 4 = Inventory 5 = Payroll 6 = Project |
95 | DYN_FUNC | Originating_TRX_Type | 0 = Standard 1 = Reversing 2 = Clearing |
96 | DYN_FUNC | Originating_Type | 1 = Normal 2 = Clearing 3 = Recurring 4 = Business Form |
97 | DYN_FUNC | Payment_Entry_Type | 0 = Check 1 = Cash 2 = Credit Card |
98 | DYN_FUNC | Payroll_Record_Type | 1 = Pay Codes 2 = Deductions 3 = Benefits 4 = State Taxes 5 = Local Taxes |
99 | DYN_FUNC | PO_Line_Status | 1 = New 2 = Released 3 = Change Order 4 = Received 5 = Closed 6 = Canceled |
100 | DYN_FUNC | PO_Line_Status_Orig | 1 = New 2 = Released 3 = Change Order 4 = Received 5 = Closed 6 = Canceled |