AR_CONTROLS
Accounts Receivable Controls
tableFINAR
AR_CONTROLS — Accounts Receivable Controls. FIN table in the standard Ross ERP 8.0 schema: 153 columns, used by 519 programs. Columns, data types, keys, foreign keys and relationships.
Open AR_CONTROLS in the interactive Data Dictionary →Part of AR tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | DIVISION | varchar(2) | PK | Division |
| 4 | DIVISION_NAME | varchar(30) | Division Name | |
| 5 | AR_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Auto AR Postings |
| 6 | AR_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Auto AR Postings |
| 7 | AR_DISCOUNT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Auto AR Discount |
| 8 | AR_DISCOUNT_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Auto AR Discount |
| 9 | AR_FREIGHT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Auto AR Freight |
| 10 | AR_FREIGHT_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Auto AR Freight |
| 11 | CURRENT_PERIOD | smallint | Current Period | |
| 12 | CURRENT_YEAR | smallint | Current Year | |
| 13 | AR_CR_BANK_CODE | varchar(6) | FK→GL_SHORT_CODES | Default GL Short Code for Bank Account |
| 14 | BANK_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Cash Postings |
| 15 | DEF_PRODUCT_TAX_CODE | varchar(5) | FK→TAX_CODES | Default Product Tax Code |
| 16 | DEF_CUSTOMER_TAX_CODE | varchar(5) | FK→TAX_CODES | Default Customer Tax Code |
| 17 | DISCOUNT_FLAG | varchar(1) | Cash Discount Tax | |
| 18 | POST_FUTURE_FLAG | varchar(1) | Allow Postings to Future Periods | |
| 19 | POST_PAST_FLAG | varchar(1) | Allow Postings to Past Periods | |
| 20 | TAX_BASED_ON | varchar(1) | Tax Based On | |
| 21 | USE_TAXABLE_VALUE | varchar(1) | Calc Sales Tax on Taxable Value | |
| 22 | GO_LIVE | varchar(1) | Is this module live | |
| 23 | CASH_DISCOUNT_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Default Short Code for Cash Discount |
| 24 | CASH_DISCOUNT_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Default Cash Discount |
| 25 | CONTRACT_PRICES_IN_USE | varchar(1) | Contract Prices in Use | |
| 26 | CONTRACT_PRICES_OVERRIDE | varchar(1) | Allow Contract Price Override | |
| 27 | PROMOTION_PRICES_IN_USE | varchar(1) | Promotion Prices in Use | |
| 28 | PROMOTION_PRICE_OVERRIDE | varchar(1) | Allow Promotion Price Override | |
| 29 | PRICE_GROUP_OVERRIDE | varchar(1) | Price Group Override | |
| 30 | SALES_PRICE_OVERRIDE | varchar(1) | Sales Price Override on Orders | |
| 31 | PROMOTION_OVERRIDE_CONTRACTS | varchar(1) | Allow promotion prices to override contract prices | |
| 32 | LINE_DISCOUNT_INV_FLAG | varchar(6) | Line Discount Inventory Flag | |
| 33 | LINE_DISCOUNT_CUST_FLAG | varchar(6) | Line Discount Customer Flag | |
| 34 | LINE_DISCOUNT_BREAK_ON | varchar(6) | Line Discount Break On Flag | |
| 35 | LINE_DISCOUNT_CALC_FLAG | varchar(6) | Line Discount Calculation Flag | |
| 36 | LINE_DISCOUNT_OVERRIDE | varchar(1) | Override Line Discounts | |
| 37 | ORDER_DISCOUNT_BREAK_ON | varchar(6) | Order Discount Break On Flag | |
| 38 | ORDER_DISCOUNT_CALC_FLAG | varchar(6) | Order Discount Calculation Flag | |
| 39 | ORDER_DISCOUNT_OVERRIDE | varchar(1) | Override Order Discounts | |
| 40 | PHYSICAL_UNITS_IN_USE | varchar(1) | Weight/Volume in Use for Sales Ordering | |
| 41 | DEFAULT_WEIGHT_UNIT | varchar(4) | FK→UNITS_OF_MEASURE | Default Weight Unit |
| 42 | DEFAULT_VOLUME_UNIT | varchar(4) | FK→UNITS_OF_MEASURE | Default Volume Unit |
| 43 | SALES_PRICE_HISTORY | varchar(1) | Sales Price History in Use | |
| 44 | AR_CURRENCY_EXCHANGE_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Auto AR Currency |
| 45 | AR_CURRENCY_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account For Auto AR Currency. |
| 46 | SALES_COMMISSION_IN_USE | varchar(1) | Sales Commission in Use | |
| 47 | SALES_COMM_NET_LDISC | varchar(1) | Sales Commission net of line discounts | |
| 48 | SALES_COMM_NET_ODISC | varchar(1) | Sales Commission net of order discount | |
| 49 | LINE_DISCOUNT_IN_USE | varchar(1) | Is Line Discounting In Use? | |
| 50 | ORDER_DISCOUNT_IN_USE | varchar(1) | Is order discounting in use | |
| 51 | BANK_RECONCILIATION_IN_USE | varchar(1) | Bank Reconciliation In Use | |
| 52 | AR_MISC_CODE | varchar(6) | FK→GL_SHORT_CODES | Miscellaneous Postings Short Code |
| 53 | AR_MISC_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | AR Miscellaneous Full Account Code |
| 54 | PERMIT_RESERVATION | varchar(1) | Permit Reservation Of Inventory | |
| 55 | SOP_ACTIVE | varchar(1) | Sales Order Processing Active | |
| 56 | SOP_CURRENT_PERIOD | smallint | SOP Current Period | |
| 57 | SOP_CURRENT_YEAR | smallint | SOP Current Year | |
| 58 | FREIGHT_TAXABLE | varchar(1) | ||
| 59 | MISCELLANEOUS_TAXABLE | varchar(1) | ||
| 60 | RECALC_PRICE_ON_INVOICE | varchar(1) | Recalculate Sales Prices on Invoice | |
| 61 | RECALC_DISCOUNT_ON_INVOICE | varchar(1) | Recalculate Order & Line discount on Invoice | |
| 62 | CUSTOMER_PERF_IN_USE | varchar(1) | Customer Performance in Use | |
| 63 | DEF_FREIGHT_TAX_CODE | varchar(5) | FK→TAX_CODES | Default Tax Code for Freight |
| 64 | DEF_MISC_TAX_CODE | varchar(5) | FK→TAX_CODES | Default Tax Code for Miscellaneous |
| 65 | SYS_DEF_RATE_AUTHORITY | varchar(6) | FK→SYS_RATE_AUTHORITIES | |
| 66 | SYS_DEF_RATE_TYPE | varchar(6) | FK→SYS_RATE_TYPES | |
| 67 | SYS_LANGUAGE_CODE | varchar(8) | FK→SYS_LANGUAGE_CODES | Language Code |
| 68 | SYS_CURRENCY_CODE | varchar(6) | FK→SYS_CURRENCY_CODES | Currency Code |
| 69 | SYS_CURRENCY_METHOD | varchar(1) | Currency Method | |
| 70 | SYS_RATE_AUTH_IN_USE | varchar(1) | Currency Rate Authority in Use | |
| 71 | SYS_RATE_TYPE_IN_USE | varchar(1) | Currency Rate Type in Use | |
| 72 | ATP_AT_ORDER_ENTRY | varchar(1) | Display available to promise at order entry | |
| 73 | TAX_REFERENCE | varchar(20) | Tax Reference | |
| 74 | SYS_TAX_REFERENCE_BRANCH | varchar(4) | Tax Branch Reference | |
| 75 | SYS_EC_ADDRESS_CODE | varchar(10) | FK→CORPORATE_ADDRESSES | |
| 76 | SOP_CONSOLIDATE_GL_POSTINGS | varchar(1) | ||
| 77 | AR_CONSOLIDATE_GL_POSTINGS | varchar(1) | ||
| 78 | SYS_DATE_CODE | varchar(6) | Currency Date Code | |
| 79 | SYS_CURRENCY_DATE_OVERRIDE | varchar(1) | Allow Override of Currency Date | |
| 80 | SYS_DRAFTS_IN_USE | varchar(1) | Drafts In Use | |
| 81 | SYS_CURRENCY_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Control for Unrealized Gains/Losses |
| 82 | SYS_CURRENCY_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for AR Controls for Unrealized Currency |
| 83 | ALLOW_RETURN_TO_EXPIRED_LOT | varchar(1) | Allow Credit Notes to return stock to expired lots | |
| 84 | SYS_EDI_DEFAULT_WAREHOUSE | varchar(2) | EDI Default Warehouse | |
| 85 | IC_ATP_SELECTION_METHOD | varchar(1) | ATP Automatic Select | |
| 86 | SOP_REQUIRED_DATE_METHOD | varchar(1) | Required Date Method | |
| 87 | AR_BASE_ROUNDING_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Base Rounding |
| 88 | AR_BASE_ROUNDING_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Base Rounding Full Account |
| 89 | USE_LINE_DISCOUNT_ACCT | varchar(1) | Indicates the source of line discount posting account | |
| 90 | USE_ORDER_DISCOUNT_ACCT | varchar(1) | Indicates the source of the order discount account(s) | |
| 91 | SYS_TAX_ON_CASH | varchar(1) | Tax on Cash | |
| 92 | DISCOUNTS_POSTED_AT | varchar(1) | Discount Posted At | |
| 93 | SOP_AR_FREIGHT_IN_USE | varchar(1) | AR Freight in use | |
| 94 | SOP_FREIGHT_CALC_WH | varchar(6) | Freight Calculation Warehouse | |
| 95 | SOP_RECALC_FREIGHT_AT_INVOICE | varchar(1) | Recalculate Freight at Invoice | |
| 96 | SOP_ALLOW_FREIGHT_OVERRIDE | varchar(1) | Allow freight override | |
| 97 | SOP_LINE_DISC_FREIGHT_INCLUSIVE | varchar(1) | ||
| 98 | SOP_FREIGHT_GL_DEFAULT | varchar(8) | ||
| 99 | SOP_FREIGHT_RECOVERY_CODE | varchar(6) | Freight Recovery code | |
| 100 | SOP_FREIGHT_RECOVERY_ACCOUNT | varchar(50) | Freight Recovery Account | |
| 101 | SOP_FREIGHT_ALLOWANCE_CODE | varchar(6) | Freight Allowance Code | |
| 102 | SOP_FREIGHT_ALLOWANCE_ACCOUNT | varchar(50) | Freight allowance account | |
| 103 | SOP_AR_FREIGHT_POSTINGS | varchar(1) | Controls whether AR freight postings should be made | |
| 104 | SYS_SECOND_BASE_CURRENCY_CODE | varchar(6) | Second Base Currency Code | |
| 105 | SOP_PRODUCT_FREIGHT_ALLOC | varchar(1) | ||
| 106 | MP_FREIGHT_ON_AWARDS | varchar(1) | Charge Freight on Product Awards | |
| 107 | SYS_NETTING_CODE | varchar(6) | Short Code for Netting | |
| 108 | SYS_NETTING_FULL_ACCOUNT | varchar(50) | Full Account for Netting | |
| 109 | PAY_STAT_AUTO_APPROVAL | varchar(1) | Automatic approval for payment statements | |
| 110 | APS_DP_IN_USE | varchar(1) | APS Demand Planning Interface in use | |
| 111 | HOLD_STATUS_CODE | varchar(6) | Sales Order Hold Status Code | |
| 112 | CREDIT_NOTE_CREDIT_TERMS | varchar(1) | Credit Terms Code | |
| 113 | SOP_CUSTOMER_PO_REQUIRED | numeric(3,0) | Flag for requiring a customer PO number | |
| 114 | SALES_ORDER_LEAD_TIME | smallint | ||
| 115 | TP_PROMOTIONS_IN_USE | varchar(1) | Promotions in Use | |
| 116 | TP_AUTO_APPROVE | smallint | Allow Auto Approval | |
| 117 | TP_ACCRUAL_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Accrual short code for promotion discounts |
| 118 | TP_ACCRUAL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Accrual account for promotion discounts |
| 119 | SYS_BILLBACK_IN_USE | varchar(1) | ||
| 120 | AR_WRITE_OFF_LIMIT | numeric(20,2) | Auto write off limit in base currency | |
| 121 | AR_WRITE_OFF_PERCENT | numeric(10,2) | Auto write off percent | |
| 122 | AR_AUTO_WO_TRAN_TYPE | varchar(2) | ||
| 123 | AR_CD_TOLERANCE | smallint | Cash discount tolerance in days | |
| 124 | PRICING_METHOD | smallint | Pricing method, tax exclusive or inclusive | |
| 125 | SALES_PRICE_OVERRIDE_INV | varchar(1) | Sales Price Override on Invoices and Credit Notes | |
| 126 | TP_PROMOTIONS_OVERRIDE | varchar(1) | Override Promotions in Orders | |
| 127 | TP_PROMOTIONS_OVERRIDE_INV | varchar(1) | Override promotions in Invoices and Credit Notes | |
| 128 | TP_APPLICATION_TYPE | smallint | Type of Application of Discounts | |
| 129 | TP_ADD_DISCRETIONARY | smallint | Load discretionary | |
| 130 | REQUIRE_SHIP_INFO_FLAG | varchar(1) | Carrier Flag | |
| 131 | ALLOW_PAY_CUSTOMER_CHANGE | varchar(1) | ||
| 132 | DESPATCH_PRINT_REQUIRED | varchar(1) | Ship note print required during the shipping process | |
| 133 | SHIPPING_DOC_IN_USE | varchar(1) | Shipping documentation in use flag | |
| 134 | CHECK_JOB_CLOSED | varchar(1) | ||
| 135 | LS_STATE_LICENSE_IN_USE | varchar(1) | State License In Use | |
| 136 | LS_DEA_EFFECTIVE_DATE | datetime | DEA Effective Date | |
| 137 | LS_DEA_EXPIRY_DATE | datetime | DEA Expiry Date | |
| 138 | LS_DEA_LICENSE_NUMBER | varchar(10) | DEA License Number | |
| 139 | BRACKET_PRICE_UOM | varchar(4) | FK→UNITS_OF_MEASURE | |
| 140 | ACCEPT_ZERO_PRICE | varchar(1) | Accept Zero Price | |
| 141 | SHIPPING_LEAD_TIME | smallint | Shipping Lead Time | |
| 142 | COST_BASED_PRICE_OVERRIDE | varchar(1) | Allow Cost Based Price Override | |
| 143 | RS_CRM_TEMPLATE_CUSTOMER | varchar(8) | ||
| 144 | RS_CRM_TEMPLATE_CUST_ADDR | varchar(10) | ||
| 145 | MINIMUM_ORDER_VALUE | numeric(20,2) | Minimum Order Value | |
| 146 | APTEAN_PAY_BANK_CODE | varchar(6) | ||
| 147 | APTEAN_PAY_ID | varchar(60) | ||
| 148 | PAYMENT_CARD_IN_USE | varchar(1) | ||
| 149 | VERIFICATION_CODE | varchar(100) | ||
| 150 | PREAUTH_BUFFER_PERCENT | numeric(10,2) | ||
| 151 | SALES_ORDER_TYPE | varchar(6) | Sales Order Type | |
| 152 | DEFAULT_CUST_NUMBER | varchar(8) | ||
| 153 | DEFAULT_BOD_CODE | varchar(8) |