Customer Template Maintenance Database Information

Data for Customer Template Maintenance is stored in the customer-template table.

Fields

Field	Field Name
Active	active
Used for Prospect/Customer Generation	prospect-cust-gen
Type	cust-type
Customer MFG#	cust-mfg-num
Country	country
Language	language

Field	Field Name
Active	billto-active
Use Billing Customer Code Address Information	use-billing-customer-address

Field	Field Name
Sales Representative 1	default-sales-agent
Sales Representative 2	second-sales-agent
Shipping Location	shipping-location-key
Sales Location	sales-location-key
Customer Division	cust-division
Sales Group	group-id
Sales Territory	territory
Default Shipper	preferred-shipper
Freight Cap %	freight-cap-pct
Pricing Customer Code	price-cust-key
Price Book Group	price-book-group-key
History Customer Code	history-company
Bookings Group	bookings-group-id
Commission Book	comm-book-name
Sales Representative By Line Item	commission-by-line
Marketing Representative 1	marketing-person1-key
Marketing Representative 2	marketing-person2-key
Order Acknowledgment Form Name	oa-form-name
Invoice Form Name	invoice-form-name
Pack List Form Name	pack-list-form-name
Exempt from Excise Tax	bvgtax-exempt

Field	Field Name
Billing Customer Code	billing-customer-key
Credit Customer Code	credit-customer-key
Paying Customer Code	payer-customer-key
Remit-to Address ID	remit-to-key
Payment Method	default-payment-method
A/R	ar-gl-acct-ptr
A/R Write off Mask	ar-write-off-acct-mask
Default Currency	default-currency
A/R Absorption	ar-absorb-gl-acct-ptr
Invoice Consolidation	consolidate-invoices
A/R Clearing	ar-clearing-gl-acct-ptr
Invoice Method	invoice-method
Cash Disc Mask	disc-acct-mask
Invoice Print Frequency	invoice-print-freq
Chargeback Team	chrgbck-team-key
Chargeback Group	chrgbck-group-key
Chargeback Division	chrgbck-div-key
Chargeback Default Grouping	chrgbck-dflt
Collection Team	collect-team-key
Collection Group	collect-group-key
Collection Division	collect-div-key
Collection Default Grouping	collect-dflt
Credit Team	credit-team-key
Credit Group	credit-group-key
Credit Division	credit-div-key
Credit Default Grouping	credit-dflt
Collection Statement Group	collect-statement-key
Collection Letter Group	collect-letter-key
Finance Charge Group	finance-charge-key

Field	Field Name
Default Order Class	order-class
Default F.O.B.	fob-key in
Order Priority	order-priority
Customer Pick Group	pick-group-key
Rewards Customer	reward-cust-key
Companion Book ID	comp-book-key
Shipping Label Format	ucc128-format
Pallet Label Format	pallet-label-format
Label Reprint Option	relabel-option
Shipping Method	shipping-method
Consignment Location	consignment-loc-key
Royalty Book Name	royal-book-name
Ship Orders Complete	ship-complete
Ship Backorders Complete	ship-bo-complete
Orders Default As Freight Free	freight-free
Internal Customer	internal-customer
Require Order Acknowledgment	req-ord-acknow
Generate Co-Op Amounts	co-op-flag
Cancel Backorder	cancel-backorder
Create Consolidated Pick Demands	Consolidated-pick-ticket
Require PO Number	req-po-num
Create Default Packages at Pick Demand Create	pick-create-ucc128
Use Pallet Shipping Labels	pallet-ucc128
Allow Mixed Cartons	mixed-cartons
No Cartonization	no-cartons
No Banding	no-banding
Beverage Type	beverage-type

Field	Field Name
Forecast Group	forecast-group-key
Point of Sale Region ID	region-key
Profit Group Code	profit-group-code
Customer Service Team	cust-service-team-key
Cash Flow Group Code	cf-cust-group-key
Customer Allowance Group	accrual-group-key
EDI Trade ID	trade-id
Do Not Send EDI ASN	skip-856
Auto Create Drop Ship POs	create-ds-po
Auto Create Shipment & Container	create-ship-cnt

Field	Field Name
Customer User Defined 1-20	user-defined-1 to user-defined-20

Field	Field Name
Market Segment User Defined 1-20	market-segment-1 to market-segment-20