Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUSTDEFLTS


                            CUSTDEFLTS FILE

                          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    AR136     AR208

UPDATED BY

AR08.1    AR09.1    AR10.1    AR301     AR501     AR550
BL02.1    AR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CDF-COMPANY            Numeric 4                                 AR08.1
Element: Company       Company number.

CDF-DEFAULT-CODE       Alpha 5                                   AR08.1
Element: Default Code  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
                       customer level.

CDF-OPEN-BAL-FWD       Alpha 1                                   AR08.1
Open Item/Balance      Processing receivable records by either
Forward                open item or balance forward methods.
                       Valid values are:

                       B = Balance forward
                       O = Open Item

CDF-AGE-DISPUTES       Alpha 1                                   AR08.1
Element: Age Disputes  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       Alpha 1                                   AR08.1
Finance Charge         This option will specify if disputed
Disputes               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        Alpha 1                                   AR08.1
Auto Application       Automatic cash application indicator.
Flag                   Valid values are:

                       N = No; no automatic cash application
                       Y = Yes; automatic cash application

CDF-DISC-GRACE-PD      Numeric 2                                 AR08.1
Discount Grace         Grace days added to discount date,
Period                 compared to payment deposit date to
                       allow discount during cash application.

CDF-MEMO-TERM          Alpha 5                                   AR08.1
Element: Memo Terms    Memo terms code. Must be a valid net or
                       prepayment type terms code defined in
                       the Lawson Terms system.

CDF-CHRGBK-PRT-FL      Alpha 1                                   AR08.1
Element: Print ChargebaThis option will specify whether
                       chargebacks will be printed. Valid
                       values are:

                       N = Do not print chargeback documents
                       Y = Print chargeback documents

CDF-STATEMENT-REQ      Alpha 1                                   AR08.1
Element: Statement RequStatement 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        Alpha 2                                   AR08.1
Element: Statement CyclStatement Cycle Code. This code allows
                       grouping of customers for statements.

CDF-LOCK-BOX           Alpha 2                                   AR08.1
Element: Lock Box      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.

CDF-ZERO-STMNT-FL      Alpha 1                                   AR08.1
Element: Zero StatementZero 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      Alpha 1                                   AR08.1
Element: Credit StatemeCredit 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      Alpha 1                                   AR08.1
Past Due Only          Past due invoices only statement
Statements             option. Valid values are:

                       N = Do not print past due only
                       statements
                       Y = Print past due only statements

CDF-OVER-STMNT-FL      Alpha 1                                   AR08.1
Over Credit Limit      Over credit limit statement option. If
Statements             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       Signed 18.2 Occurs 3 Times                AR08.1
Maximum Auto           This is the maximum amount allowed
Shortage Amount        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       Signed 5.5 Occurs 3 Times                 AR08.1
Maximum Auto           This is the maximum percentage allowed
Shortage Percent       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       Alpha 4 Occurs 3 Times                    AR08.1
Element: Auto Reason CoThis 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       Alpha 4                                   AR08.1
Element: Discount ReasoThis will be the default reason code
                       for earned discounts.

CDF-LATE-PAY-FL        Alpha 1                                   AR08.1
Element: Finance ChargeFinance 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      Alpha 1                                   AR08.1
Finance Charge         This field will indicate what type of
Calculation            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        Alpha 2                                   AR08.1
Element: Finance ChargeFinance Charge code. This code must be
                       predefined and will contain a monthly
                       finance charge percentage rate.

CDF-FIN-GRAC-DAYS      Numeric 2                                 AR08.1
Finance Charge         Finance Grace Days. The number of grace
Grace Days             days added to due date before finance
                       charges will be assessed.

CDF-FIN-MIN-CHRG       Signed 7.2                                AR08.1
Minimum Finance        The minimum finance charge amount
Charge                 assessed if calculated finance is less
                       than minimum. If minimum charge is zero,
                       there is no override.

CDF-FIN-DOC-PRNT       Alpha 1                                   AR08.1
Print Finance          This option will specify whether or not
Charge Documents       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       Alpha 1                                   AR08.1
Element: Auto Dunning LAutomatic 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           Alpha 5                                   AR08.1
Element: Terms Code    Terms Code. This is the default terms
                       code that will be assigned to customers
                       when default code is specified. Terms
                       code must be a valid code established in
                       the AR terms code file.

CDF-CR-VAR-PCT         Numeric 3                                 AR08.1
Credit Review          Percent of a customer's balance in
Percent                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            Alpha 1                                   AR08.1  AR09.1
Element: Used Flag     Indicates whether or not the default      AR10.1  AR301
                       code has been used. Valid values are:     AR501   AR550
                                                                 BL02.1
                       N = No
                       Y = Yes

CDF-AGING-CODE         Numeric 2                                 AR08.1
Element: Aging Code    This field contains a valid aging code
                       for single customer agings.

CDF-POD-REQ-FL         Alpha 1                                   AR08.1
Element: POD Required  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          Numeric 3                                 AR08.1
Element: Grace Period  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        Signed 13.0                               AR08.1
Element: Single Order LLimit to the value of a single order.
                       Used by Lawson Order Entry system.

CDF-SGL-HOLD-CODE      Alpha 4                                   AR08.1
Single Order Hold      Used by Lawson Order Entry system. Hold
Code                   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            Signed 13.0                               AR08.1
Element: COD Limit     Total value limit for COD orders. Used
                       by Lawson Order Entry system.

CDF-COD-HOLD-CODE      Alpha 4                                   AR08.1
Element: COD Hold Code 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       Alpha 1                                   AR08.1
Credit Check on        Used by Lawson Order Entry system.
Order Entry            Entry check flag indicates whether
                       credit checking is performed when orders
                       are entered.
                       N = No
                       Y = Yes

CDF-PRT-CHECK-FL       Alpha 1                                   AR08.1
Credit Check on        Used by Lawson Order Entry system.
Picking Lists          Print check flag indicates whether
                       credit checking is performed prior to
                       printing picking lists.
                       N = No
                       Y = Yes

CDF-SHP-CHECK-FL       Alpha 1
Credit Check on        Used by Lawson Order Entry system.
Shipping               Shipping check indicates whether credit
                       checking is performed prior to accepting
                       shipping feedback for an order.

CDF-AGE-CRED-PCT       Percent 5.2  (Percent) Occurs 5 Times     AR08.1
Age Credit Limit       Used by Lawson Order Entry system. This
Percent                is the percentage of the credit limit
                       allowed in this aging period.

CDF-AGE-HOLD-CD        Alpha 4 Occurs 5 Times                    AR08.1
Element: Aging Hold CodUsed 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      Alpha 1                                   AR08.1
Element: Tax Exempt CodThis field will indicate if the
                       customer is exempt from tax. Valid
                       values are:

                       E = Exempt
                       T = Taxable

CDF-TAX-CODE           Alpha 10                                  AR08.1
Element: Tax Code      A user-defined code representing a
                       default tax code. Must be a valid code
                       in the Tax Code file.

CDF-FREIGHT-CODE       Alpha 2                                   AR08.1
Element: Freight Code  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            Alpha 9  (Right Justified)                AR08.1
Element: Vendor ID     This is the carrier vendor number. It
                       must be a valid vendor.

CDF-CIA-FL             Alpha 1                                   AR08.1
Element: Cash In AdvancIndicates whether the customer must pay
                       cash in advance. Valid values are:

                       N = No (default)
                       Y = Yes

CDF-CIA-PCT            Percent 8.5  (Percent)                    AR08.1
Cash In Advance        If cash in advance is required, this
Percent                field indicates the percentage of the
                       order amount required from the customer
                       before accepting an order.

CDF-ORD-DISC-CODE      Alpha 4                                   AR08.1
Element: Order DiscountOrder discount code used to assess
                       discounts on customer orders. Must be a
                       valid order discount code in the Lawson
                       Order Entry system.

CDF-TERRITORY          Alpha 4                                   AR08.1
Element: Sales TerritorSales territory. Must be a valid
                       territory code.

CDF-PRICE-LST          Alpha 14                                  AR08.1
Element: Price List    Used to automatically price orders.
                       Must be a valid price list in the Lawson
                       Order Entry system.

CDF-BACK-ORD-FL        Alpha 1                                   AR08.1
Backorders Allowed     Indicates whether the customer accepts
Flag                   backorders. Valid values are:

                       N = No
                       Y = Yes

CDF-SHIP-COMP-FL       Alpha 1                                   AR08.1
Element: Ship Complete Indicates whether orders must be
                       complete for shipment. Valid values are:


                       N = No
                       Y = Yes

CDF-DEF-SHIP-TO        Numeric 4                                 AR08.1
Element: Ship-to Code  Default ship-to location. Must be a
                       valid ship-to code in the Lawson Order
                       Entry system.

CDF-DEF-METHOD         Alpha 10                                  AR08.1
Default Method for     Default shipment method.
Ship-to

CDF-BRKN-CS-CHRG       Alpha 1                                   AR08.1
Element: Broken Case ChThis 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            Alpha 4                                   AR08.1
Accounts Receivable    AR Code.  This will be the default
Code                   account that will be used in posting the
                       receivables for customers.

CDF-BANK-INST-CODE     Alpha 3                                   AR08.1
Element: Payment Code  This is the default payment code of the
                       customer. It will edit to the Cash
                       Ledger Payment code file. It must be an
                       payment type of cash (check) or Bill of
                       Exchange to be a valid default payment
                       code.

CDF-DRAFT-FLAG         Alpha 1                                   AR08.1
Element: Bill of ExchanIf 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        Alpha 4                                   AR08.1
Element: Major Class   Major class for customer
                       classification.

CDF-MINOR-CLASS        Alpha 4                                   AR08.1
Element: Minor Class   Minor class for customer
                       classification.

CDF-CREDIT-ANLYST      Alpha 4                                   AR08.1
Element: Credit AnalystCredit analyst code.

CDF-SALESMAN           Numeric 4                                 AR08.1
Element: SalesRep      This field contains the code that
                       represents the primary salesrep of this
                       line. If left blank, this defaults from
                       the order header.

CDF-REVALUE-FL         Alpha 1                                   AR08.1
Element: Revaluation   Currency revaluation indicator used for
                       non-base currency open items. Valid
                       values are:

                       N = No revaluation
                       Y = Revaluation

CDF-CR-LIMIT-HOLD      Alpha 4                                   AR08.1
Element: Credit Limit HIndicates whether a customer is on hold
                       due to exceeding credit limit.

CDF-OR-LIMIT-HOLD      Alpha 4                                   AR08.1
Element: Order Limit HoIndicates whether a customer is on hold
                       due to exceeding order limit.

CDF-PK-PRIORITY        Numeric 2                                 AR08.1
Element: Picking PrioriPicking priority assigned to this
                       customer. Used by batch inventory
                       allocation to determine which customers
                       get first option on available inventory.


CDF-SALESMAN-2         Numeric 4                                 AR08.1
Element: SalesRep 2    This field contains the code
                       representing the second salesrep. This
                       defaults from the order header.

CDF-COMM-SPLIT         Percent 5.3  (Percent)                    AR08.1
Commission Split       This field contains the commission
Percentage             split. This defaults from OECUSTOMER.

CDF-ACKNOW-FL          Alpha 1                                   AR08.1
Acknowledgement        Indicates whether the customer requires
Required Flag          printed acknowledgments. Valid values
                       are:

                       N = No
                       Y = Yes

CDF-PO-REQ-FL          Alpha 1                                   AR08.1
Element: POD Required  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       Alpha 5                                   AR08.1
Element: Location Code Default ship-from location or warehouse
                       for the customer.

CDF-CUSTOMER-CODE      Alpha 4                                   AR08.1
Element: Customer Code Customer code. This is a code used to
                       classify customers for Sales Analysis.

CDF-MINIMUM            Alpha 1                                   AR08.1
Use Minimum Finance    Used to determine if minimum finance
Charge                 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          Alpha 2                                   AR08.1
Element: Finance Cycle Defaults cycle code used to group
                       customers for finance charge processing.


CDF-DUN-CYCLE          Alpha 2                                   AR08.1
Element: Dunning Cycle Default cycle code used to group
                       customers for dunning letter selection
                       by AR160 (Dunning Letter Select).

CDF-AUTO-METHOD        Alpha 1                                   AR08.1
Auto Cash              Indicates the default automatic cash
Application Method     application method.
                       " " = None
                       A = Algorithm
                       B = Balance Forward
                       L = Last Statetment
                       R = Remittance

CDF-LINE-ITEM-REQ      Alpha 1                                   AR08.1
Element: Line Items ReqIndicates if line items are required
                       for an invoice. Valid values:

                       N = Line items are not produced
                       Y = Line items are produced

CDF-AUTO-REMOVE        Alpha 1                                   AR08.1
Element: Auto Remove   Field will determine if transactions can
                       be automatically written off.
                       N = No
                       Y = Yes

CDF-CB-DTL-DATE        Alpha 1                                   AR08.1
Element: Cb Dtl Date   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     Signed 7.2                                AR08.1
Element: I Fin Min ChrgMinimum finance charge amount for an
                       invoice.


CDF-DUN-LTR-IND        Alpha 1                                   AR08.1
Element: Dun Ltr Ind   Specifies whether the advanced dunning
                       letter process is to be used for this
                       customer.


CDF-DUN-PROCESS-CD     Alpha 6                                   AR08.1
Element: Dun Process CdDunning letter process code for this
                       customer.  A unique code that represents
                       a combination of Dunning letter options.



CDF-LANGUAGE-CODE      Alpha 10                                  AR08.1
Element: Language Code The customer's preferred language code
                       (locale).  Specifies the language in
                       which a dunning letter is sent.


CDF-ASSESS-DUN-FEE     Alpha 1                                   AR08.1
Element: Assess Dun FeeSpecifies whether to assess a dunning
                       letter fee.


CDF-TAX-PRINT-CD       Alpha 1                                   AR08.1
Element: Tax Print Cd  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         Alpha 1                                   AR08.1
Element: Cust Audit

CDF-APPLY-MIXED        Alpha 1                                   AR08.1
Element: Apply Mixed

                         CUSTDEFLTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CDFSET1   COMPANY       This path is used for record uniqueness  AR01.1  AR04.1
          DEFAULT-CODE  and selection.                           AR07.1  AR08.1
                                                                 AR09.1  AR10.1
                                                                 AR10.4  AR136
                                                                 AR208   AR301
                                                                 AR501   AR550
                                                                 BL02.1

                         CUSTDEFLTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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