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%