CUSTDEFLTS

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


UPDATED BY
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.
AR08.1
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.
AR08.1
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
AR08.1
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
AR08.1
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
AR08.1
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
AR08.1
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.
AR08.1
CDF-MEMO-TERM
Element: Memo Terms
Alpha 5
Memo terms code. Must be a valid terms code in the Lawson Terms system.
AR08.1
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
AR08.1
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
AR08.1
CDF-STMNT-CYCLE
Element: Statement Cycle
Alpha 2
Statement Cycle Code. This code allows grouping of customers for statements.
AR08.1
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.
AR08.1
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
AR08.1
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
AR08.1
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
AR08.1
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
AR08.1
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.
AR08.1
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.
AR08.1
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.
AR08.1
CDF-DISC-REAS-CD
Element: Discount Reason Code
Alpha 4
This will be the default reason code for earned discounts.
AR08.1
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
AR08.1
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
AR08.1
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.
AR08.1
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.
AR08.1
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.
AR08.1
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
AR08.1
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
AR08.1
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.
AR08.1
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.
AR08.1
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
AR08.1 AR09.1
AR10.1 AR301
AR501 AR550
TX140
CDF-AGING-CODE
Element: Aging Code
Numeric 2
This field contains a valid aging code for single customer agings.
AR08.1
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
AR08.1
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.
AR08.1
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.
AR08.1
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.
AR08.1
CDF-COD-LIM
Element: COD Limit
Signed 13.0
Total value limit for COD orders. Used by Lawson Order Entry system.
AR08.1
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.
AR08.1
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
AR08.1
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
AR08.1
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.
AR08.1
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.
AR08.1
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
AR08.1
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.
AR08.1
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.
AR08.1
CDF-CARRIER
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AR08.1
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
AR08.1
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.
AR08.1
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.
AR08.1
CDF-TERRITORY
Element: Territory
Alpha 4
Sales territory. Must be a valid territory code.
AR08.1
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.
AR08.1
CDF-BACK-ORD-FL
Element: Back Ord Fl
Alpha 1
Indicates whether the customer accepts backorders. Valid values are: N = No Y = Yes
AR08.1
CDF-SHIP-COMP-FL
Element: Ship Complete
Alpha 1
Indicates whether orders must be complete for shipment. Valid values are: N = No Y = Yes
AR08.1
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.
AR08.1
CDF-DEF-METHOD
Element: Def Method
Alpha 10
Default shipment method.
AR08.1
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
AR08.1
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.
AR08.1
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.
AR08.1
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
AR08.1
CDF-MAJOR-CLASS
Element: Major Class
Alpha 4
Major class for customer classification.
AR08.1
CDF-MINOR-CLASS
Element: Minor Class
Alpha 4
Minor class for customer classification.
AR08.1
CDF-CREDIT-ANLYST
Element: Credit Analyst
Alpha 4
Credit analyst code.
AR08.1
CDF-SALESMAN
Element: SalesRep
Numeric 4
This field contains the code that represents the primary salesrep of this customer.
AR08.1
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
AR08.1
CDF-CR-LIMIT-HOLD
Element: Credit Limit Hold
Alpha 4
Indicates whether a customer is on hold due to exceeding credit limit.
AR08.1
CDF-OR-LIMIT-HOLD
Element: Order Limit Hold
Alpha 4
Indicates whether a customer is on hold due to exceeding order limit.
AR08.1
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.
AR08.1
CDF-SALESMAN-2
Element: SalesRep 2
Numeric 4
This field contains the code representing the secondary salesrep.
AR08.1
CDF-COMM-SPLIT
Element: Comm Split
Percent 5.3 (Percent)
This field contains the commission split. This defaults from OECUSTOMER.
AR08.1
CDF-ACKNOW-FL
Element: Acknow Fl
Alpha 1
Indicates whether the customer requires printed acknowledgments. Valid values are: N = No Y = Yes
AR08.1
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
AR08.1
CDF-DEF-LOCATION
Element: Location
Alpha 5
Default ship-from location or warehouse for the customer.
AR08.1
CDF-CUSTOMER-CODE
Element: Customer Code
Alpha 4
Customer code. This is a code used to classify customers for Sales Analysis.
AR08.1
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.
AR08.1
CDF-FIN-CYCLE
Element: Finance Cycle Code
Alpha 2
Defaults cycle code used to group customers for finance charge processing.
AR08.1
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).
AR08.1
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
AR08.1
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
AR08.1
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
AR08.1
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
AR08.1
CDF-I-FIN-MIN-CHRG
Element: I Fin Min Chrg
Signed 7.2
Minimum finance charge amount for an invoice.
AR08.1
CDF-DUN-LTR-IND
Element: 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
Element: 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
Element: 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
Element: Assess Dun Fee
Alpha 1
Specifies whether to assess a dunning letter fee.
AR08.1
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
AR08.1
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.
AR08.1
CDF-PAY-AUTO-AMT
Element: Intl Amt
Signed 18.2
AR08.1
CDF-PAY-AUTO-PCT
Element: Max Auto Pct
Signed 5.5
AR08.1
CDF-PAY-REAS-CD
Element: Auto Reas Cd
Alpha 4
AR08.1
CDF-ALLOW-RETURNS
Element: All Flag
Alpha 1

" "
Y = Yes
N = No
L = Limit
AR08.1
CDF-ALLOW-RTN-DATE
Element: Date
Numeric 8 (yyyymmdd)
AR08.1
CDF-MULT-DUN-LTR
Element: Flag
Alpha 1

" "
N = No
Y = Yes
AR08.1


CUSTDEFLTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDFSET1 COMPANY
DEFAULT-CODE
AR01.1 AR04.1
AR07.1 AR08.1
AR09.1 AR10.1
AR208 AR301
AR501 AR550
TX140


CUSTDEFLTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:09:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.