|
|
CUSTDEFLTS FILE
AR Customer Defaults
AR Customer Defaults
REFERENCED BY
AR04.1 AR07.1 AR136 AR208
UPDATED BY
AR01.1 AR08.1 AR10.1 AR501 AR550 AR700
AR951 AR973 BL02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDF-COMPANY Numeric 4 AR08.1 AR951
Company Company number. AR973
CDF-DEFAULT-CODE Alpha 5 AR08.1 AR951
Default Code Default code identifying many options AR973
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 AR951
Open Item/Balance Processing receivable records by either AR973
Forward open item or balance forward methods.
Valid values are:
B = Balance forward
O = Open Item
CDF-AGE-DISPUTES Alpha 1 AR08.1 AR951
Age Disputes This option will specify how disputed AR973
invoices will be aged. Valid values are:
N = Age disputes in current column
Y = Age disputes
CDF-DISPUTES-FIN Alpha 1 AR08.1 AR951
Finance Charge This option will specify if disputed AR973
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 AR951
Auto Application Automatic cash application indicator. AR973
Flag Valid values are:
N = No; no automatic cash application
Y = Yes; automatic cash application
CDF-DISC-GRACE-PD Numeric 2 AR08.1 AR951
Discount Grace Grace days added to discount date, AR973
Period compared to payment deposit date to
allow discount during cash application.
CDF-MEMO-TERM Alpha 5 AR08.1 AR951
Memo Terms Memo terms code. Must be a valid net or AR973
prepayment type terms code defined in
the Lawson Terms system.
CDF-CHRGBK-PRT-FL Alpha 1 AR08.1 AR951
Print Chargebacks This option will specify whether AR973
chargebacks will be printed. Valid
values are:
N = Do not print chargeback documents
Y = Print chargeback documents
CDF-STATEMENT-REQ Alpha 1 AR08.1 AR951
Statement Required Statement required option. If AR973
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 AR951
Statement Cycle Statement Cycle Code. This code allows AR973
grouping of customers for statements.
CDF-LOCK-BOX Alpha 2 AR08.1 AR951
Lock Box This is an optional Remit-To Location AR973
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 AR951
Zero Statements Zero Balance Statement option. If this AR973
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 AR951
Credit Statements Credit balance statement option. If Yes AR973
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 AR951
Past Due Only Past due invoices only statement AR973
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 AR951
Over Credit Limit Over credit limit statement option. If AR973
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 15.2 Occurs 3 Times AR08.1 AR951
Maximum Auto This is the maximum amount allowed AR973
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 AR951
Maximum Auto This is the maximum percentage allowed AR973
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 AR951
Auto Reason Code This reason code is required if auto AR973
amount or auto percent has been
indicated. This will allow tracking
adjustment records by this reason.
CDF-DISC-REAS-CD Alpha 4 AR08.1 AR951
Discount Reason Code This will be the default reason code AR973
for earned discounts.
CDF-LATE-PAY-FL Alpha 1 AR08.1 AR951
Finance Charge Type Finance Charge Type. It will indicate AR973
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 AR951
Finance Charge This field will indicate what type of AR973
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 AR951
Finance Charge Code Finance Charge code. This code must be AR973
predefined and be associated with at
least one monthly finance charge
percentage rate and effective date.
CDF-FIN-GRAC-DAYS Numeric 2 AR08.1 AR951
Finance Charge Finance Grace Days. The number of grace AR973
Grace Days days added to due date before finance
charges will be assessed.
CDF-FIN-MIN-CHRG Signed 7.2 AR08.1 AR951
Minimum Finance The minimum finance charge amount AR973
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 AR951
Print Finance This option will specify whether or not AR973
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 AR951
Auto Dunning Letter Automatic Dunning Letter flag. AR973
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 AR951
Terms Code Terms Code. This is the default terms AR973
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 AR951
Credit Review Percent of a customer's balance in AR973
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 AR10.1
Used Flag Indicates whether or not the default AR501 AR550
code has been used. Valid values are: AR951 AR973
BL02.1
N = No
Y = Yes
CDF-AGING-CODE Numeric 2 AR08.1 AR951
Aging Code This field contains a valid aging code AR973
for single customer agings.
CDF-POD-REQ-FL Alpha 1 AR08.1 AR951
POD Required POD required flag. Used by Lawson Order AR973
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.
CDF-GRACE-PER Numeric 3 AR08.1 AR951
Grace Period Used by Lawson Order Entry. The number AR973
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 AR951
Single Order Limit Limit to the value of a single order. AR973
Used by Lawson Order Entry system.
CDF-SGL-HOLD-CODE Alpha 4 AR08.1 AR951
Single Order Hold Used by Lawson Order Entry system. Hold AR973
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 AR951
COD Limit Total value limit for COD orders. Used AR973
by Lawson Order Entry system.
CDF-COD-HOLD-CODE Alpha 4 AR08.1 AR951
COD Hold Code This is the hold code applied to the AR973
order if it exceeds the COD order limit.
Used by Lawson Order Entry system.
CDF-ENT-CHECK-FL Alpha 1 AR08.1 AR951
Credit Check on Used by Lawson Order Entry system. AR973
Order Entry Entry check flag indicates whether
credit checking is performed when orders
are entered.
CDF-PRT-CHECK-FL Alpha 1 AR08.1 AR951
Credit Check on Used by Lawson Order Entry system. AR973
Picking Lists Print check flag indicates whether
credit checking is performed prior to
printing picking lists.
CDF-SHP-CHECK-FL Alpha 1 AR951 AR973
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 AR951
Age Credit Limit Used by Lawson Order Entry system. This AR973
Percent is the percentage of the credit limit
allowed in this aging period.
CDF-AGE-HOLD-CD Alpha 4 Occurs 5 Times AR08.1 AR951
Aging Hold Code Used by Lawson Order Entry system. This AR973
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 AR951
Tax Exempt Code This field will indicate if the AR973
customer is exempt from tax. Valid
values are:
E = Exempt
T = Taxable
CDF-TAX-CODE Alpha 10 AR08.1 AR951
Tax Code A user-defined code representing a AR973
default tax code. Must be a valid code
in the Tax Code file.
CDF-FREIGHT-CODE Alpha 2 AR08.1 AR951
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 AR08.1 AR951
Carrier Vendor This is the carrier vendor number. It
Number must be a valid vendor.
CDF-CIA-FL Alpha 1 AR08.1 AR951
Cash In Advance Flag Indicates 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 AR951
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 AR951
Order Discount Code 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 Alpha 4 AR08.1 AR951
Sales Territory Sales territory. Must be a valid AR973
territory code.
CDF-PRICE-LST Alpha 14 AR08.1 AR951
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 AR951
Backorders Allowed Indicates whether the customer accepts
Flag backorders. Valid values are:
N = No
Y = Yes
CDF-SHIP-COMP-FL Alpha 1 AR08.1 AR951
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 AR951
Default Ship-to for Default ship-to location. Must be a
Customer valid ship-to code in the Lawson Order
Entry system.
CDF-DEF-METHOD Alpha 10 AR08.1 AR951
Default Method for Default shipment method.
Ship-to
CDF-BRKN-CS-CHRG Alpha 1 AR08.1 AR951
Broken Case Charge This flag determines if there is a AR973
charge if a broken case is required to
satisfy an order in Order Entry.
CDF-AR-CODE Alpha 4 AR08.1 AR951
Accounts Receivable AR Code. This will be the default AR973
Code account that will be used in posting the
receivables for customers.
CDF-BANK-INST-CODE Alpha 3 AR08.1 AR951
Payment Code This is the default payment code of the AR973
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 AR951
Bill of Exchange If the payment code type is a bill of AR973
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 AR951
Major Class Major class for customer AR973
classification.
CDF-MINOR-CLASS Alpha 4 AR08.1 AR951
Minor Class Minor class for customer AR973
classification.
CDF-CREDIT-ANLYST Alpha 4 AR08.1 AR951
Credit Analyst Credit analyst code. AR973
CDF-SALESMAN Numeric 4 AR08.1 AR951
Sales Rep This field contains the code that AR973
represents the primary salesrep of this
line. If left blank, this defaults from
the order header.
CDF-REVALUE-FL Alpha 1 AR08.1 AR951
Revaluation Currency revaluation indicator used for AR973
non-base currency open items. Valid
values are:
N = No revaluation
Y = Revaluation
CDF-CR-LIMIT-HOLD Alpha 4 AR08.1 AR951
Credit Limit Hold Indicates whether a customer is on hold AR973
due to exceeding credit limit.
CDF-OR-LIMIT-HOLD Alpha 4 AR08.1 AR951
Order Limit Hold Indicates whether a customer is on hold AR973
due to exceeding order limit.
CDF-CC-TYPE Alpha 2 AR08.1 AR951
Credit Card Type Credit card type for this customer. AR973
CDF-CC-NUMBER Alpha 17 AR08.1 AR951
Credit Card Number Credit card number for the AR973
corresponding credit card type.
CDF-CC-EXP-DATE Numeric 6 AR08.1 AR951
Credit Card Credit card expiration date for the AR973
Expiration Date corresponding credit card number.
CDF-PK-PRIORITY Numeric 2 AR08.1 AR951
Picking Priority Picking 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 AR951
Sales Rep 2 This field contains the code AR973
representing the second salesrep. This
defaults from the order header.
CDF-COMM-SPLIT Percent 5.3 (Percent) AR08.1 AR951
Commission Split This field contains the commission AR973
Percentage split. This defaults from OECUSTOMER.
CDF-ACKNOW-FL Alpha 1 AR08.1 AR951
Acknowledgment Indicates whether the customer requires AR973
Required Flag printed acknowledgments. Valid values
are:
N = No
Y = Yes
CDF-PO-REQ-FL Alpha 1 AR08.1 AR951
POD Required Indicates whether the customer's AR973
purchase order number must be entered
before releasing an order. Valid values
are:
N = No
Y = Yes
CDF-DEF-LOCATION Alpha 5 AR08.1 AR951
Default Location Default ship-from location or warehouse AR973
for Operator for the customer.
CDF-CUSTOMER-CODE Alpha 4 AR08.1 AR951
Customer Code Customer code. This is a code used to AR973
classify customers for Sales Analysis.
CDF-MINIMUM Alpha 1 AR08.1 AR951
Use Minimum Finance Used to determine if minimum finance AR973
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 AR951
Finance Cycle Code Defaults cycle code used to group AR973
customers for finance charge processing.
CDF-DUN-CYCLE Alpha 2 AR08.1 AR951
Dunning Cycle Code Default cycle code used to group AR973
customers for dunning letter selection
by AR160 (Dunning Letter Select).
CDF-AUTO-METHOD Alpha 1 AR08.1 AR951
Auto Cash Indicates the default automatic cash AR973
Application Method application method.
CDF-LINE-ITEM-REQ Alpha 1 AR08.1 AR973
Line Items Required Indicates 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 AR700
Automatic This field determines if payments or AR951 AR973
Transaction Removal transactions can be removed
automatically. Valid values are:
N = No
Y = Yes
CDF-I-FIN-MIN-CHRG Signed 7.2 AR08.1
Invoice Minimum Minimum finance charge amount for an
Finance Charge invoice.
CDF-DUN-LTR-IND Alpha 1 AR08.1
Dunning Letter Specifies whether the advanced dunning
Indicator letter is to be used for this customer.
Y = Yes
N = No
CDF-DUN-PROCESS-CD Alpha 6 AR08.1
Dunning Process Code Dunning letter process code for this
customer. A unique code that represents
a combination of Dunning letter
options.
CDF-LANGUAGE-CODE Alpha 10 AR08.1
Language Code the customer's preferred language code.
Specifies the language in which a
dunning letter is sent..
CDF-ASSESS-DUN-FEE Alpha 1 AR08.1
Assess Dunning Fee? Specifies whether to assess a dunning
letter fee.
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
AR10.1 AR136
AR208 AR501
AR550 AR700
AR951 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
|