CU_CustomerTemplate CRM Customer Template Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/CU"+%C$+"/CU_CustomerTemplate.M4T"
kPRIMARY: CustomerTemplate
Fld Column Name M/L TUR Description/Notes Class
1 CustomerTemplate. . . . . . . 20 SNY CustomerTemplate. . . . . . . .
2 CustomerTemplateDesc. . . . . 30 SNN Customer Template Description .DESCRIPTION
3 TermsCode . . . . . . . . . . 2 SNY Terms Code. . . . . . . . . . .ARTERMS
DfltVal:00 Mask:00 FmtType:ZE
ROFILL
4 ShipCode. . . . . . . . . . . 15 SYN Shipping Code . . . . . . . . .SHIPCODE
5 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . .
6 PaymentType . . . . . . . . . 5 SNY Payment Type. . . . . . . . . .PAYMENTTYPE
DfltVal:CHECK
7 CreditHold. . . . . . . . . . 1 SYN Credit Hold . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
8 OpenItemCustomer. . . . . . . 1 SYN Open Item Customer. . . . . . .YESNO
DfltVal:N Valid:Y,N
9 CustomerSort. . . . . . . . . 10 SNN CustomerSort. . . . . . . . . .
10 CustomerType. . . . . . . . . 4 SYN Customer Type . . . . . . . . .
11 BatchFax. . . . . . . . . . . 1 SNN Batch Fax . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
12 StatementCycle. . . . . . . . 1 SYN Statement Cycle . . . . . . . .
13 PrintDunningMessage . . . . . 1 SNN Print Dunning Message On StatemYESNO
DfltVal:Y Valid:Y,N
14 DiscountRate. . . . . . . . . 8.3 NNY DiscountRate. . . . . . . . . .
DfltVal:0 Mask:##0.000
15 CreditLimit . . . . . . . . . 14.2 NNN Credit Limit. . . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
16 FinanceChrgRate . . . . . . . 9.3 NNN Finance Charge Rate . . . . . .
Mask:####.000%