CUSTDEFLTS – AR Customer Defaults

System: Accounts Receivable (AR)
Prefix: CDF
Primary key: COMPANY, DEFAULT-CODE
Fields: 95
Updated by: 8 programs
Referenced by: 3 programs

CUSTDEFLTS is the AR Customer Defaults table in Lawson Accounts Receivable (prefix CDF). It is indexed by COMPANY, DEFAULT-CODE (CDFSET1). It is related 1:1 to HOLDCODES, ARCOMP and ARREASON. It is updated by AR01.1, AR08.1, AR09.1, AR10.1, AR301, AR501, AR550 and TX140 and referenced by AR04.1, AR07.1 and AR208. The table has 95 fields, 1 index and 5 documented relations.

About CUSTDEFLTS

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.

Fields (95)

Column = COBOL field name without the CDF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CDF-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	AR08.1
`CDF-DEFAULT-CODE` PK 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.	AR08.1
`CDF-OPEN-BAL-FWD` OPEN_BAL_FWD	Alpha 1	Processing receivable records by either open item or balance forward methods. Valid values are: `B` Balance forward `O` Open Item	AR08.1
`CDF-AGE-DISPUTES` 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	AR08.1
`CDF-DISPUTES-FIN` DISPUTES_FIN	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	AR08.1
`CDF-AUTO-APP-FL` AUTO_APP_FL	Alpha 1	Automatic cash application indicator. Valid values are: `N` No; no automatic cash application `Y` Yes; automatic cash application	AR08.1
`CDF-DISC-GRACE-PD` DISC_GRACE_PD	Numeric 2	Grace days added to discount date, compared to payment deposit date to allow discount during cash application.	AR08.1
`CDF-MEMO-TERM` MEMO_TERM	Alpha 5	Memo terms code. Must be a valid terms code in the Lawson Terms system.	AR08.1
`CDF-CHRGBK-PRT-FL` CHRGBK_PRT_FL	Alpha 1	This option will specify whether chargebacks will be printed. Valid values are: `N` Do not print chargeback documents `Y` Print chargeback documents	AR08.1
`CDF-STATEMENT-REQ` STATEMENT_REQ	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	AR08.1
`CDF-STMNT-CYCLE` STMNT_CYCLE	Alpha 2	Statement Cycle Code. This code allows grouping of customers for statements.	AR08.1
`CDF-LOCK-BOX` 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.	AR08.1
`CDF-ZERO-STMNT-FL` ZERO_STMNT_FL	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	AR08.1
`CDF-CRED-STMNT-FL` CRED_STMNT_FL	Alpha 1	Credit balance statement option. If Yes is specified, credit balance statements will be produced for the customer. Valid values are: statements `N` Do not print credit balance `Y` Print credit balance statements	AR08.1
`CDF-PAST-STMNT-FL` PAST_STMNT_FL	Alpha 1	Past due invoices only statement option. Valid values are: statements `N` Do not print past due only `Y` Print past due only statements	AR08.1
`CDF-OVER-STMNT-FL` OVER_STMNT_FL	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: credit limit `N` No credit limit/balance checking `Y` Statement only if balance exceeds	AR08.1
`CDF-MAX-AUTO-AMT` MAX_AUTO_AMT	Signed 18.2 Occurs 3 Times ×3	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.	AR08.1
`CDF-MAX-AUTO-PCT` MAX_AUTO_PCT	Signed 5.5 Occurs 3 Times ×3	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.	AR08.1
`CDF-AUTO-REAS-CD` AUTO_REAS_CD	Alpha 4 Occurs 3 Times ×3	This reason code is required if auto amount or auto percent has been indicated. This will allow tracking adjustment records by this reason.	AR08.1
`CDF-DISC-REAS-CD` DISC_REAS_CD	Alpha 4	This will be the default reason code for earned discounts.	AR08.1
`CDF-LATE-PAY-FL` LATE_PAY_FL	Alpha 1	Finance Charge Type. It will indicate what type of charges will be assessed. Valid values are: charges assessed `Blank` No charges `F` Finance charges assessed `L` Late payment charges assessed `B` Both finance and late payment	AR08.1
`CDF-FIN-CALC-TYPE` FIN_CALC_TYPE	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	AR08.1
`CDF-FIN-CHRG-CD` FIN_CHRG_CD	Alpha 2	Finance Charge code. This code must be predefined and will contain a monthly finance charge percentage rate.	AR08.1
`CDF-FIN-GRAC-DAYS` FIN_GRAC_DAYS	Numeric 2	Finance Grace Days. The number of grace days added to due date before finance charges will be assessed.	AR08.1
`CDF-FIN-MIN-CHRG` FIN_MIN_CHRG	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.	AR08.1
`CDF-FIN-DOC-PRNT` FIN_DOC_PRNT	Alpha 1	This option will specify whether or not finance charge documents are required to be printed. Valid values are: documents `N` Do not print finance charge `Y` Print finance charge documents	AR08.1
`CDF-AUTO-DUNN-FL` AUTO_DUNN_FL	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	AR08.1
`CDF-TERMS-CD` TERMS_CD	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.	AR08.1
`CDF-CR-VAR-PCT` CR_VAR_PCT	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.	AR08.1
`CDF-USED-FL` USED_FL	Alpha 1	Indicates whether or not the default code has been used. Valid values are: `N` No `Y` Yes	AR08.1, AR09.1, AR10.1, AR301, AR501, AR550, TX140
`CDF-AGING-CODE` AGING_CODE	Numeric 2	This field contains a valid aging code for single customer agings.	AR08.1
`CDF-POD-REQ-FL` POD_REQ_FL	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	AR08.1
`CDF-GRACE-PER` GRACE_PER	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.	AR08.1
`CDF-SGL-ORD-LIM` SGL_ORD_LIM	Signed 13.0	Limit to the value of a single order. Used by Lawson Order Entry system.	AR08.1
`CDF-SGL-HOLD-CODE` SGL_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.	AR08.1
`CDF-COD-LIM` COD_LIM	Signed 13.0	Total value limit for COD orders. Used by Lawson Order Entry system.	AR08.1
`CDF-COD-HOLD-CODE` 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.	AR08.1
`CDF-ENT-CHECK-FL` ENT_CHECK_FL	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	AR08.1
`CDF-PRT-CHECK-FL` PRT_CHECK_FL	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	AR08.1
`CDF-SHP-CHECK-FL` SHP_CHECK_FL	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_CRED_PCT	Percent 5.2 (Percent) Occurs 5 Times ×5	Used by Lawson Order Entry system. This is the percentage of the credit limit allowed in this aging period.	AR08.1
`CDF-AGE-HOLD-CD` AGE_HOLD_CD	Alpha 4 Occurs 5 Times ×5	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.	AR08.1
`CDF-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	This field will indicate if the customer is exempt from tax. Valid values are: `E` Exempt `T` Taxable	AR08.1
`CDF-TAX-CODE` TAX_CODE	Alpha 10	A user-defined code representing a default tax code. Must be a valid code in the Tax Code file.	AR08.1
`CDF-FREIGHT-CODE` 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.	AR08.1
`CDF-CARRIER` CARRIER	Alpha 9 (Right Justified)	The vendor's identification code.	AR08.1
`CDF-CIA-FL` CIA_FL	Alpha 1	Indicates whether the customer must pay cash in advance. Valid values are: `N` No (default) `Y` Yes	AR08.1
`CDF-CIA-PCT` 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.	AR08.1
`CDF-ORD-DISC-CODE` 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.	AR08.1
`CDF-TERRITORY` TERRITORY	Alpha 4	Sales territory. Must be a valid territory code.	AR08.1
`CDF-PRICE-LST` PRICE_LST	Alpha 14	Used to automatically price orders. Must be a valid price list in the Lawson Order Entry system.	AR08.1
`CDF-BACK-ORD-FL` BACK_ORD_FL	Alpha 1	Indicates whether the customer accepts backorders. Valid values are: `N` No `Y` Yes	AR08.1
`CDF-SHIP-COMP-FL` SHIP_COMP_FL	Alpha 1	Indicates whether orders must be complete for shipment. Valid values are: `N` No `Y` Yes	AR08.1
`CDF-SUBSTITUTES-FL` SUBSTITUTES_FL	Alpha 1	—	—
`CDF-DEF-SHIP-TO` DEF_SHIP_TO	Numeric 4	Default ship-to location. Must be a valid ship-to code in the Lawson Order Entry system.	AR08.1
`CDF-DEF-METHOD` DEF_METHOD	Alpha 10	Default shipment method.	AR08.1
`CDF-BRKN-CS-CHRG` 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	AR08.1
`CDF-AR-CODE` AR_CODE	Alpha 4	AR Code. This will be the default account that will be used in posting the receivables for customers.	AR08.1
`CDF-BANK-INST-CODE` BANK_INST_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.	AR08.1
`CDF-DRAFT-FLAG` DRAFT_FLAG	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: obligation bill of exchange `I` Individual BOE per payment `S` Summarize payment obligation to one	AR08.1
`CDF-MAJOR-CLASS` MAJOR_CLASS	Alpha 4	Major class for customer classification.	AR08.1
`CDF-MINOR-CLASS` MINOR_CLASS	Alpha 4	Minor class for customer classification.	AR08.1
`CDF-CREDIT-ANLYST` CREDIT_ANLYST	Alpha 4	Credit analyst code.	AR08.1
`CDF-SALESMAN` SALESMAN	Numeric 4	This field contains the code that represents the primary salesrep of this customer.	AR08.1
`CDF-REVALUE-FL` REVALUE_FL	Alpha 1	Currency revaluation indicator used for non-base currency open items. Valid values are: `N` No revaluation `Y` Revaluation	AR08.1
`CDF-CR-LIMIT-HOLD` CR_LIMIT_HOLD	Alpha 4	Indicates whether a customer is on hold due to exceeding credit limit.	AR08.1
`CDF-OR-LIMIT-HOLD` OR_LIMIT_HOLD	Alpha 4	Indicates whether a customer is on hold due to exceeding order limit.	AR08.1
`CDF-PK-PRIORITY` 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.	AR08.1
`CDF-SALESMAN-2` SALESMAN_2	Numeric 4	This field contains the code representing the secondary salesrep.	AR08.1
`CDF-COMM-SPLIT` COMM_SPLIT	Percent 5.3 (Percent)	This field contains the commission split. This defaults from OECUSTOMER.	AR08.1
`CDF-ACKNOW-FL` ACKNOW_FL	Alpha 1	Indicates whether the customer requires printed acknowledgments. Valid values are: `N` No `Y` Yes	AR08.1
`CDF-PO-REQ-FL` PO_REQ_FL	Alpha 1	Indicates whether the customer's purchase order number must be entered before releasing an order. Valid values are: `N` No `Y` Yes	AR08.1
`CDF-DEF-LOCATION` DEF_LOCATION	Alpha 5	Default ship-from location or warehouse for the customer.	AR08.1
`CDF-CUSTOMER-CODE` CUSTOMER_CODE	Alpha 4	Customer code. This is a code used to classify customers for Sales Analysis.	AR08.1
`CDF-MINIMUM` MINIMUM	Alpha 1	Used to determine if minimum finance charges are used. Valid values are: amount is less than minimum amount. less than minimum amount. If minimum amount is blank, then calculated amount is charged. `Y` Use minimum amount if calculated `N` No charge if calculated amount is	AR08.1
`CDF-FIN-CYCLE` FIN_CYCLE	Alpha 2	Defaults cycle code used to group customers for finance charge processing.	AR08.1
`CDF-DUN-CYCLE` DUN_CYCLE	Alpha 2	Default cycle code used to group customers for dunning letter selection by AR160 (Dunning Letter Select).	AR08.1
`CDF-AUTO-METHOD` AUTO_METHOD	Alpha 1	Indicates the default automatic cash application method. " " = None `A` Algorithm `B` Balance Forward `L` Last Statetment `R` Remittance	AR08.1
`CDF-LINE-ITEM-REQ` LINE_ITEM_REQ	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	AR08.1
`CDF-AUTO-REMOVE` AUTO_REMOVE	Alpha 1	Field will determine if transactions can be automatically written off via AR135 Automatic Transaction Removal. `N` No `Y` Yes	AR08.1
`CDF-CB-DTL-DATE` 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	AR08.1
`CDF-I-FIN-MIN-CHRG` I_FIN_MIN_CHRG	Signed 7.2	Minimum finance charge amount for an invoice.	AR08.1
`CDF-DUN-LTR-IND` DUN_LTR_IND	Alpha 1	Specifies whether the advanced dunning letter process is to be used for this customer.	AR08.1
`CDF-DUN-PROCESS-CD` DUN_PROCESS_CD	Alpha 6	Dunning letter process code for this customer. A unique code that represents a combination of Dunning letter options.	AR08.1
`CDF-LANGUAGE-CODE` LANGUAGE_CODE	Alpha 10	The customer's preferred language code (locale). Specifies the language in which a dunning letter is sent.	AR08.1
`CDF-ASSESS-DUN-FEE` ASSESS_DUN_FEE	Alpha 1	Specifies whether to assess a dunning letter fee.	AR08.1
`CDF-TAX-PRINT-CD` TAX_PRINT_CD	Alpha 1	" " = Space `D` Calc by line - print detail `P` Price incl tax - print summary `S` Calc by line - print summary `T` Calc and print in summary	—
`CDF-CUST-AUDIT` 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	AR08.1
`CDF-APPLY-MIXED` 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.	AR08.1
`CDF-PAY-AUTO-AMT` PAY_AUTO_AMT	Signed 18.2	—	AR08.1
`CDF-PAY-AUTO-PCT` PAY_AUTO_PCT	Signed 5.5	—	AR08.1
`CDF-PAY-REAS-CD` PAY_REAS_CD	Alpha 4	—	AR08.1
`CDF-ALLOW-RETURNS` ALLOW_RETURNS	Alpha 1	" " `Y` Yes `N` No `L` Limit	AR08.1
`CDF-ALLOW-RTN-DATE` ALLOW_RTN_DATE	Numeric 8 (yyyymmdd)	—	AR08.1
`CDF-MULT-DUN-LTR` MULT_DUN_LTR	Alpha 1	" " `N` No `Y` Yes	AR08.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CDFSET1`	`COMPANY`, `DEFAULT-CODE`	Primary		AR01.1, AR04.1, AR07.1, AR08.1, AR09.1, AR10.1, AR208, AR301 +3 more

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Agingholdcode	HOLDCODES	Required		`ACO-CUST-GROUP` → `HDD-CUST-GROUP`, `CDF-AGE-HOLD-CD` → `HDD-HOLD-CODE`
Arcomp	ARCOMP	Required		`CDF-COMPANY` → `ACO-COMPANY`
Arreason	ARREASON	Required	When CDF-AUTO-REAS-CD != Spaces	`CDF-COMPANY` → `ARR-COMPANY`, `"AD"` → `ARR-TYPE`, `CDF-AUTO-REAS-CD` → `ARR-REASON-CODE`
Codholdcode	HOLDCODES	Required	When CDF-COD-HOLD-CODE != Spaces	`ACO-CUST-GROUP` → `HDD-CUST-GROUP`, `CDF-COD-HOLD-CODE` → `HDD-HOLD-CODE`
Sglholdcode	HOLDCODES	Required	When CDF-SGL-HOLD-CODE != Spaces	`ACO-CUST-GROUP` → `HDD-CUST-GROUP`, `CDF-SGL-HOLD-CODE` → `HDD-HOLD-CODE`

Programs

Updated by (8)

AR01.1 Company
AR08.1 Customer Defaults
AR09.1 Customer Group Address
AR10.1 Customer
AR301 Customer Purge
AR501 Customer Conversion
AR550 Customer Interface
TX140 Vertex Geocode Update

Referenced by (3)

AR04.1 Cycle Codes
AR07.1 Finance Charge
AR208 Customer Defaults Listing