Upload Credit Card Payment

Menu Path: Accounting > Maintenance > Configuration > Upload Card Payment

Step 1: Click file link: 'Download Template File'

Notes:

select source fields and add to target fields
default format is “comma” delimiter

Step 2: Fill in the data

No	Field Name	Data Type	Remakrs	Where to find	Sample Data
1	BRANCH_OPT	String with Maximum (20) Characters	Compulsory, act OR inactive (case sensitive)		act
2	CASHBOOK_OPT	String with Maximum (20) Characters	Compulsory, true OR false		true
3	COMPANY_CODE	String with Maximum (100) Characters	Compulsory	Control Panel > Developer > Organization Structure > Company > Edit > Company Code	A Co.
4	PAYMENT_MODE	String with Maximum (30) Characters	Compulsory		RHB-VISA
5	SORTCODE	String with Maximum (20) Characters	Compulsory		RHB-VISA
6	BRANCH_CODE	String with Maximum (1000) Characters	Compulsory if BRANCH_OPT is act. Comma separated if more than one	Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code"	A Co.-B1
7	CASHBOOK	String with Maximum (20) Characters	Compulsory if CASHBOOK_OPT is true.	Accounting > Maintenance > Configuration > Cashbook Maintenance
8	CUST_ADMIN_FEE_RATIO	Floating Point Number	e.g. 0.01 = 1%, 0.025 = 2.5%
9	PCT_CHARGES	Floating Point Number	e.g. 0.01 = 1%, 0.025 = 2.5%		0.5
10	TAX_PCT_CHARGES	Floating Point Number	e.g. 0.01 = 1%, 0.025 = 2.5%
11	WHT_PCT_CHARGES	Floating Point Number	e.g. 0.01 = 1%, 0.025 = 2.5%
12	ABS_CHARGES	Floating Point Number
13	APPROVAL_PARTY	String with Maximum (20) Characters
14	BANK_CODE	String with Maximum (20) Characters
15	BANK_NAME	String with Maximum (500) Characters
16	CUST_ADMIN_FEE_ABS	Floating Point Number
17	CUST_ADMIN_FEE_ITEMID	Integer
18	CUST_ADMIN_FEE_MAX_AMOUNT	Floating Point Number
19	CUST_ADMIN_FEE_MIN_AMOUNT	Floating Point Number
20	CUST_ADMIN_FEE_OPTION	String with Maximum (50) Characters
21	CUST_ADMIN_FEE_ROUNDING_MODE	Integer
22	CUST_ADMIN_FEE_ROUNDING_SCALE	Integer
23	DEFAULT_CARD_TYPE	String with Maximum (20) Characters
24	DEFAULT_PAYMENT_REMARKS	String with Maximum (50) Characters
25	DEFAULT_PAYMENT_STATUS	String with Maximum (20) Characters
26	LAST_UPDATE	String in the following format (yyyy-mm-dd)
27	LIMIT_MAX	Floating Point Number
28	LIMIT_MIN	Floating Point Number
29	NAMESPACE	String with Maximum (20) Characters
30	PAYMENT_TYPE	String with Maximum (20) Characters
31	PCCENTER_OPT	String with Maximum (20) Characters
32	PKID	Integer
33	POLICY_CHARGES	String with Maximum (20) Characters
34	PROPERTY1	String with Maximum (50) Characters
35	PROPERTY2	String with Maximum (50) Characters
36	PROPERTY3	String with Maximum (50) Characters
37	STATUS	String with Maximum (20) Characters
38	TAX_ABS_CHARGES	Floating Point Number
39	TAX_CHARGES	String with Maximum (20) Characters
40	TAX_CODE	String with Maximum (100) Characters
41	TAX_OPTION	String with Maximum (100) Characters
42	TAX_TYPE	String with Maximum (100) Characters
43	WHT_ABS_CHARGES	Floating Point Number
44	WHT_CHARGES	String with Maximum (20) Characters
45	WHT_TAX_CODE	String with Maximum (100) Characters
46	WHT_TAX_OPTION	String with Maximum (100) Characters
47	WHT_TAX_TYPE	String with Maximum (100) Characters