AR Customer Defaults
The AR Customer Defaults file contains a set of customer options which help speed the entry time of adding customers. Some options may default from the company record to the defaults record. When adding a customer, a default code must be specified.
REFERENCED BY
AR04.1 | AR07.1 | AR208 |
AR08.1 | AR09.1 | AR10.1 | AR301 | AR501 | AR550 |
TX140 | AR01.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
CDF-COMPANY Element: Company | Numeric 4 The number representing an AR company. |
|
||||||||
CDF-DEFAULT-CODE Element: Default Code | Alpha 5 Default code identifying many options that will be used at the customer level. Each customer record will require a default code at customer creation time with each option maintainable at the company customer level. |
|
||||||||
CDF-OPEN-BAL-FWD Open Item/Balance Forward | Alpha 1 Processing receivable records by either open item or balance forward methods. Valid values are: B = Balance forward O = Open Item |
|
||||||||
CDF-AGE-DISPUTES Element: Age Disputes | Alpha 1 This option will specify how disputed invoices will be aged. Valid values are: N = Age disputes in current column Y = Age disputes |
|
||||||||
CDF-DISPUTES-FIN Finance Charge Disputes | Alpha 1 This option will specify if disputed invoices are exempt from being assessed finance charges. Valid values are: N = No; finance charges do not apply Y = Yes; subject to finance charges |
|
||||||||
CDF-AUTO-APP-FL Auto Application Flag | Alpha 1 Automatic cash application indicator. Valid values are: N = No; no automatic cash application Y = Yes; automatic cash application |
|
||||||||
CDF-DISC-GRACE-PD Discount Grace Period | Numeric 2 Grace days added to discount date, compared to payment deposit date to allow discount during cash application. |
|
||||||||
CDF-MEMO-TERM Element: Memo Terms | Alpha 5 Memo terms code. Must be a valid terms code in the Lawson Terms system. |
|
||||||||
CDF-CHRGBK-PRT-FL Element: Print Chargebacks | Alpha 1 This option will specify whether chargebacks will be printed. Valid values are: N = Do not print chargeback documents Y = Print chargeback documents |
|
||||||||
CDF-STATEMENT-REQ Element: Statement Required | Alpha 1 Statement required option. If statements are required the default selection criteria will include current, past due and credit open items. Zero balance statements will not be produced unless specified. Individual statement options may override this set of default criteria. Valid values are: N = No statements required Y = Statements required |
|
||||||||
CDF-STMNT-CYCLE Element: Statement Cycle | Alpha 2 Statement Cycle Code. This code allows grouping of customers for statements. |
|
||||||||
CDF-LOCK-BOX Element: Lock Box | Alpha 2 This is an optional Remit-To Location address code for payment receipt. If entered, it must be a valid Lock Box code. The remit-to location will be used for external forms. |
|
||||||||
CDF-ZERO-STMNT-FL Element: Zero Statements | Alpha 1 Zero Balance Statement option. If this flag is set to Yes, a statement will be produced showing no detail and a balance amount of zero. Valid values are: N = Do not send zero balance statements Y = Send zero balance statements |
|
||||||||
CDF-CRED-STMNT-FL Element: Credit Statements | Alpha 1 Credit balance statement option. If Yes is specified, credit balance statements will be produced for the customer. Valid values are: N = Do not print credit balance statements Y = Print credit balance statements |
|
||||||||
CDF-PAST-STMNT-FL Past Due Only Statements | Alpha 1 Past due invoices only statement option. Valid values are: N = Do not print past due only statements Y = Print past due only statements |
|
||||||||
CDF-OVER-STMNT-FL Over Credit Limit Statements | Alpha 1 Over credit limit statement option. If this option is Yes, only if a customer's balance is greater than the customer's credit limit will a statement be produced. Valid values are: N = No credit limit/balance checking Y = Statement only if balance exceeds credit limit |
|
||||||||
CDF-MAX-AUTO-AMT Maximum Auto Shortage Amount | Signed 18.2 Occurs 3 Times This is the maximum amount allowed shortage during cash application that will be automatically adjusted. This is one of three fields that may be used for this purpose. If multiple allowed shortage amounts are used, they must be in ascending amount sequence. |
|
||||||||
CDF-MAX-AUTO-PCT Maximum Auto Shortage Percent | Signed 5.5 Occurs 3 Times This is the maximum percentage allowed shortage amount during cash application that will be automatically adjusted. This is one of three fields that may be used for this purpose. If multiple allowed shortage percentages are used, they must be in ascending percent sequence. |
|
||||||||
CDF-AUTO-REAS-CD Element: Auto Reason Code | Alpha 4 Occurs 3 Times This reason code is required if auto amount or auto percent has been indicated. This will allow tracking adjustment records by this reason. |
|
||||||||
CDF-DISC-REAS-CD Element: Discount Reason Code | Alpha 4 This will be the default reason code for earned discounts. |
|
||||||||
CDF-LATE-PAY-FL Element: Finance Charge Type | Alpha 1 Finance Charge Type. It will indicate what type of charges will be assessed. Valid values are: Blank = No charges F = Finance charges assessed L = Late payment charges assessed B = Both finance and late payment charges assessed |
|
||||||||
CDF-FIN-CALC-TYPE Finance Charge Calculation | Alpha 1 This field will indicate what type of calculation will be used in determining the finance charge amount. Valid values are: D = Detail per record calculation N = Net past due balance calculation |
|
||||||||
CDF-FIN-CHRG-CD Element: Finance Charge Code | Alpha 2 Finance Charge code. This code must be predefined and will contain a monthly finance charge percentage rate. |
|
||||||||
CDF-FIN-GRAC-DAYS Finance Charge Grace Days | Numeric 2 Finance Grace Days. The number of grace days added to due date before finance charges will be assessed. |
|
||||||||
CDF-FIN-MIN-CHRG Minimum Finance Charge | Signed 7.2 The minimum finance charge amount assessed if calculated finance is less than minimum. If minimum charge is zero, there is no override. |
|
||||||||
CDF-FIN-DOC-PRNT Print Finance Charge Documents | Alpha 1 This option will specify whether or not finance charge documents are required to be printed. Valid values are: N = Do not print finance charge documents Y = Print finance charge documents |
|
||||||||
CDF-AUTO-DUNN-FL Element: Auto Dunning Letter | Alpha 1 Automatic Dunning Letter flag. Indicates whether or not the customer will receive automatic dunning letters. Valid values are: N = No automatic Dunning letters Y = Automatic Dunning letters |
|
||||||||
CDF-TERMS-CD Element: Terms Code | Alpha 5 Terms Code. This is the default terms code that will be assigned to customers when the default code is specified. The terms code must be a valid in the Lawson Terms system. |
|
||||||||
CDF-CR-VAR-PCT Credit Review Percent | Numeric 3 Percent of a customer's balance in relation to their credit limit for review purposes. This percent will be use to compare balances greater as well as less than a credit limit. |
|
||||||||
CDF-USED-FL Element: Used Flag | Alpha 1 Indicates whether or not the default code has been used. Valid values are: N = No Y = Yes |
|
||||||||
CDF-AGING-CODE Element: Aging Code | Numeric 2 This field contains a valid aging code for single customer agings. |
|
||||||||
CDF-POD-REQ-FL Element: POD Required | Alpha 1 POD required flag. Used by Lawson Order Entry system. Customer requires that a Proof of Delivery form to accompany the shipment. The shipment will not be billed until POD is returned or the POD grace period expires. N = No Y = Yes |
|
||||||||
CDF-GRACE-PER Element: Grace Period | Numeric 3 Used by Lawson Order Entry. The number of days after the POD is printed after which billing will automatically assume it is OK to bill the customer. |
|
||||||||
CDF-SGL-ORD-LIM Element: Single Order Limit | Signed 13.0 Limit to the value of a single order. Used by Lawson Order Entry system. |
|
||||||||
CDF-SGL-HOLD-CODE Single Order Hold Code | Alpha 4 Used by Lawson Order Entry system. Hold code to apply to a non-COD order when the order total amount exceeds the single order limit. If single order limit greater than zero, then this field is required. If the single order limit equals zero and single order hold code is entered, then every non-COD order will be on hold. |
|
||||||||
CDF-COD-LIM Element: COD Limit | Signed 13.0 Total value limit for COD orders. Used by Lawson Order Entry system. |
|
||||||||
CDF-COD-HOLD-CODE Element: COD Hold Code | Alpha 4 This is the hold code applied to the order if it exceeds the COD order limit. Used by Lawson Order Entry system. |
|
||||||||
CDF-ENT-CHECK-FL Credit Check on Order Entry | Alpha 1 Used by Lawson Order Entry system. Entry check flag indicates whether credit checking is performed when orders are entered. N = No Y = Yes |
|
||||||||
CDF-PRT-CHECK-FL Credit Check on Picking Lists | Alpha 1 Used by Lawson Order Entry system. Print check flag indicates whether credit checking is performed prior to printing picking lists. N = No Y = Yes |
|
||||||||
CDF-SHP-CHECK-FL Credit Check on Shipping | Alpha 1 Used by Lawson Order Entry system. Shipping check indicates whether credit checking is performed prior to accepting shipping feedback for an order. |
|
||||||||
CDF-AGE-CRED-PCT Age Credit Limit Percent | Percent 5.2 (Percent) Occurs 5 Times Used by Lawson Order Entry system. This is the percentage of the credit limit allowed in this aging period. |
|
||||||||
CDF-AGE-HOLD-CD Element: Aging Hold Code | Alpha 4 Occurs 5 Times Used by Lawson Order Entry system. This is the hold code applied to an order if it is added when the customer fails the credit check because of the aging period limit. |
|
||||||||
CDF-TAX-EXEMPT-CD Element: Tax Exempt Cd | Alpha 1 This field will indicate if the customer is exempt from tax. Valid values are: E = Exempt T = Taxable |
|
||||||||
CDF-TAX-CODE Element: Tax Code | Alpha 10 A user-defined code representing a default tax code. Must be a valid code in the Tax Code file. |
|
||||||||
CDF-FREIGHT-CODE Element: Freight Code | Alpha 2 This field contains the freight code. This is must be valid in the OE Freight Code file. This determines whether carrier and charge are allowed for the shipment. |
|
||||||||
CDF-CARRIER Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||||||
CDF-CIA-FL Element: Cia Fl | Alpha 1 Indicates whether the customer must pay cash in advance. Valid values are: N = No (default) Y = Yes |
|
||||||||
CDF-CIA-PCT Element: Cia Pct | Percent 8.5 (Percent) If cash in advance is required, this field indicates the percentage of the order amount required from the customer before accepting an order. |
|
||||||||
CDF-ORD-DISC-CODE Element: Ord Disc Code | Alpha 4 Order discount code used to assess discounts on customer orders. Must be a valid order discount code in the Lawson Order Entry system. |
|
||||||||
CDF-TERRITORY Element: Territory | Alpha 4 Sales territory. Must be a valid territory code. |
|
||||||||
CDF-PRICE-LST Element: Price List | Alpha 14 Used to automatically price orders. Must be a valid price list in the Lawson Order Entry system. |
|
||||||||
CDF-BACK-ORD-FL Element: Back Ord Fl | Alpha 1 Indicates whether the customer accepts backorders. Valid values are: N = No Y = Yes |
|
||||||||
CDF-SHIP-COMP-FL Element: Ship Complete | Alpha 1 Indicates whether orders must be complete for shipment. Valid values are: N = No Y = Yes |
|
||||||||
CDF-SUBSTITUTES-FL Element: All Flag | Alpha 1 |
|
||||||||
CDF-DEF-SHIP-TO Element: Ship To | Numeric 4 Default ship-to location. Must be a valid ship-to code in the Lawson Order Entry system. |
|
||||||||
CDF-DEF-METHOD Element: Def Method | Alpha 10 Default shipment method. |
|
||||||||
CDF-BRKN-CS-CHRG Element: Brkn Cs Chrg | Alpha 1 This flag determines if there is a charge if a broken case is required to satisfy an order in Order Entry. N = No Y = Yes |
|
||||||||
CDF-AR-CODE Element: Ar Code | Alpha 4 AR Code. This will be the default account that will be used in posting the receivables for customers. |
|
||||||||
CDF-BANK-INST-CODE Element: Payment Code | Alpha 3 This is the default payment code of the customer. It will edit to the Cash Ledger Payment code file. It must be an Cash Payment type, or Bill of Exchange type to be a valid default payment code. |
|
||||||||
CDF-DRAFT-FLAG Element: Bill of Exchange | Alpha 1 If the payment code type is a bill of exchange, this field will indicate if the bill of exchange will be generated in summary, or individually (1 BOE for 1 Invoice). Valid values are: I = Individual BOE per payment obligation S = Summarize payment obligation to one bill of exchange |
|
||||||||
CDF-MAJOR-CLASS Element: Major Class | Alpha 4 Major class for customer classification. |
|
||||||||
CDF-MINOR-CLASS Element: Minor Class | Alpha 4 Minor class for customer classification. |
|
||||||||
CDF-CREDIT-ANLYST Element: Credit Analyst | Alpha 4 Credit analyst code. |
|
||||||||
CDF-SALESMAN Element: SalesRep | Numeric 4 This field contains the code that represents the primary salesrep of this customer. |
|
||||||||
CDF-REVALUE-FL Element: Revaluation | Alpha 1 Currency revaluation indicator used for non-base currency open items. Valid values are: N = No revaluation Y = Revaluation |
|
||||||||
CDF-CR-LIMIT-HOLD Element: Credit Limit Hold | Alpha 4 Indicates whether a customer is on hold due to exceeding credit limit. |
|
||||||||
CDF-OR-LIMIT-HOLD Element: Order Limit Hold | Alpha 4 Indicates whether a customer is on hold due to exceeding order limit. |
|
||||||||
CDF-PK-PRIORITY Element: Pk Priority | Numeric 2 Picking priority assigned to this customer. Used by batch inventory allocation to determine which customers get first option on available inventory. |
|
||||||||
CDF-SALESMAN-2 Element: SalesRep 2 | Numeric 4 This field contains the code representing the secondary salesrep. |
|
||||||||
CDF-COMM-SPLIT Element: Comm Split | Percent 5.3 (Percent) This field contains the commission split. This defaults from OECUSTOMER. |
|
||||||||
CDF-ACKNOW-FL Element: Acknow Fl | Alpha 1 Indicates whether the customer requires printed acknowledgments. Valid values are: N = No Y = Yes |
|
||||||||
CDF-PO-REQ-FL Element: POD Required | Alpha 1 Indicates whether the customer's purchase order number must be entered before releasing an order. Valid values are: N = No Y = Yes |
|
||||||||
CDF-DEF-LOCATION Element: Location | Alpha 5 Default ship-from location or warehouse for the customer. |
|
||||||||
CDF-CUSTOMER-CODE Element: Customer Code | Alpha 4 Customer code. This is a code used to classify customers for Sales Analysis. |
|
||||||||
CDF-MINIMUM Use Minimum Finance Charge | Alpha 1 Used to determine if minimum finance charges are used. Valid values are: Y = Use minimum amount if calculated amount is less than minimum amount. N = No charge if calculated amount is less than minimum amount. If minimum amount is blank, then calculated amount is charged. |
|
||||||||
CDF-FIN-CYCLE Element: Finance Cycle Code | Alpha 2 Defaults cycle code used to group customers for finance charge processing. |
|
||||||||
CDF-DUN-CYCLE Element: Dunning Cycle Code | Alpha 2 Default cycle code used to group customers for dunning letter selection by AR160 (Dunning Letter Select). |
|
||||||||
CDF-AUTO-METHOD Auto Cash Application Method | Alpha 1 Indicates the default automatic cash application method. " " = None A = Algorithm B = Balance Forward L = Last Statetment R = Remittance |
|
||||||||
CDF-LINE-ITEM-REQ Element: Line Items Required | Alpha 1 Indicates if line items are required for an invoice or credit memo from the Lawson Billing system, upon transaction interface. Valid values: N = Line items are not produced Y = Line items are produced |
|
||||||||
CDF-AUTO-REMOVE Element: Auto Remove | Alpha 1 Field will determine if transactions can be automatically written off via AR135 Automatic Transaction Removal. N = No Y = Yes |
|
||||||||
CDF-CB-DTL-DATE Element: Cb Dtl Date | Alpha 1 This field will control the dates used in calculating the the transaction and due dates for detail chargebacks. I = Invoice P = Payment |
|
||||||||
CDF-I-FIN-MIN-CHRG Element: I Fin Min Chrg | Signed 7.2 Minimum finance charge amount for an invoice. |
|
||||||||
CDF-DUN-LTR-IND Element: Dun Ltr Ind | Alpha 1 Specifies whether the advanced dunning letter process is to be used for this customer. |
|
||||||||
CDF-DUN-PROCESS-CD Element: Dun Process Cd | Alpha 6 Dunning letter process code for this customer. A unique code that represents a combination of Dunning letter options. |
|
||||||||
CDF-LANGUAGE-CODE Element: Language Code | Alpha 10 The customer's preferred language code (locale). Specifies the language in which a dunning letter is sent. |
|
||||||||
CDF-ASSESS-DUN-FEE Element: Assess Dun Fee | Alpha 1 Specifies whether to assess a dunning letter fee. |
|
||||||||
CDF-TAX-PRINT-CD Element: Tax Print Cd | Alpha 1 D = Calc by line - print detail P = Price incl tax - print summary S = Calc by line - print summary T = Calc and print in summary " " = Space |
|
||||||||
CDF-CUST-AUDIT Element: Cust Audit | Alpha 1 Determines if customer record changes will create an audit record. Valid values are: N = No Audit record created Y = Audit record created |
|
||||||||
CDF-APPLY-MIXED Element: Apply Mixed | Alpha 1 This field indicates if transactions with mixed signed line items will have credit lines applied to debit lines upon transaction interface and transaction release. |
|
||||||||
CDF-PAY-AUTO-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||
CDF-PAY-AUTO-PCT Element: Max Auto Pct | Signed 5.5 |
|
||||||||
CDF-PAY-REAS-CD Element: Auto Reas Cd | Alpha 4 |
|
||||||||
CDF-ALLOW-RETURNS Element: All Flag | Alpha 1 " " Y = Yes N = No L = Limit |
|
||||||||
CDF-ALLOW-RTN-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||
CDF-MULT-DUN-LTR Element: Flag | Alpha 1 " " N = No Y = Yes |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CDFSET1 |
COMPANY DEFAULT-CODE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Agingholdcode | HOLDCODES |
Required
| |||||||||||||||
Arcomp | ARCOMP |
Required
| |||||||||||||||
Arreason | ARREASON |
Required
| |||||||||||||||
Codholdcode | HOLDCODES |
Required
| |||||||||||||||
Sglholdcode | HOLDCODES |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.