Recharge_Center_Chartstring_Validation.xlsx

	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV
1	Do Not Use	Recharge Chartstring Validation													User Guide
2		VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG	VCHR_HDR_STG
3		000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
4		BUSINESS_UNIT	VOUCHER_ID	VOUCHER_STYLE	INVOICE_ID	INVOICE_DT	VENDOR_ID	VNDR_LOC	ADDRESS_SEQ_NUM	GRP_AP_ID	ORIGIN	OPRID	ACCOUNTING_DT	POST_VOUCHER	DST_CNTRL_ID	VOUCHER_ID_RELATED	GROSS_AMT	DSCNT_AMT	TAX_EXEMPT	SALETX_AMT	FREIGHT_AMT	MISC_AMT	PYMNT_TERMS_CD	ENTERED_DT	TXN_CURRENCY_CD	RT_TYPE	RATE_MULT	RATE_DIV	VAT_ENTRD_AMT	MATCH_ACTION	CUR_RT_SOURCE	DSCNT_AMT_FLG	DUE_DT_FLG	VCHR_APPRVL_FLG	BUSPROCNAME	APPR_RULE_SET	VAT_DCLRTN_POINT	VAT_CALC_TYPE	VAT_CALC_GROSS_NET	VAT_RECALC_FLG	VAT_CALC_FRGHT_FLG	VAT_TREATMENT_GRP	COUNTRY_SHIP_FROM	STATE_SHIP_FROM	COUNTRY_SHIP_TO	STATE_SHIP_TO	COUNTRY_VAT_BILLFR	COUNTRY_VAT_BILLTO	VAT_EXCPTN_CERTIF	VAT_ROUND_RULE	COUNTRY_LOC_SELLER	STATE_LOC_SELLER	COUNTRY_LOC_BUYER	STATE_LOC_BUYER	COUNTRY_VAT_SUPPLY	STATE_VAT_SUPPLY	COUNTRY_VAT_PERFRM	STATE_VAT_PERFRM	STATE_VAT_DEFAULT	PREPAID_REF	PREPAID_AUTO_APPLY	DESCR254_MIXED	EIN_FEDERAL	EIN_STATE_LOCAL	BUSINESS_UNIT_PO	PO_ID	PACKSLIP_NO	PAY_TRM_BSE_DT_OPT	VAT_CALC_MISC_FLG	PAY_SCHEDULE_TYPE	TAX_GRP	TAX_PYMNT_TYPE	INSPECT_DT	INV_RECPT_DT	RECEIPT_DT	BILL_OF_LADING	CARRIER_ID	DOC_TYPE	DSCNT_DUE_DT	DSCNT_PRORATE_FLG	DUE_DT	FRGHT_CHARGE_CODE	LC_ID	MISC_CHARGE_CODE	REMIT_ADDR_SEQ_NUM	SALETX_CHARGE_CODE	VCHR_BLD_CODE	BUSINESS_UNIT_AR	CUST_ID	ITEM	ITEM_LINE	VCHR_SRC	VAT_EXCPTN_TYPE	TERMS_BASIS_DT	USER_VCHR_CHAR1	USER_VCHR_CHAR2	USER_VCHR_DEC	USER_VCHR_DATE	USER_VCHR_NUM1
5		Business Unit	Voucher ID	Voucher Style	Invoice Number	Invoice Date	Supplier ID	Supplier Location	Address Sequence Number	Control Group ID	Origin	User ID	Accounting Date	Post Voucher Now	Accounting Template	Related Voucher	Gross Invoice Amount	Discount Amount	Tax Exempt Flag	Sales Tax Amount	Freight Amount	Misc. Amount	Payment Terms ID	Entered on	Transaction Currency	Rate Type	Rate Multiplier	Rate Divisor	Entered VAT Amount	Match Action	Exchange Rate Source	Discount Amount Control	Due Date Control	Voucher Approval Flag	Business Process Name	Approval Rule Set	Declaration Point	Calculation Type	Calculate at Gross or Net	Recalculate at Payment	Include Freight	VAT Treatment Group	Ship From Country	Ship From State	Ship to Country	Ship to State	Seller's Registration Country	Buyer's Registration Country	VAT Certificate ID	VAT Rounding Rule	Seller's Location Country	Seller's Location State	Buyer's Location Country	Buyer's Location State	VAT Place of Supply Country	VAT Place of Supply State	Service Performed Country	Service Performed State	Defaulting State	Prepayment Reference	Auto Apply Prepayment	More Information	EIN Federal	EIN State Local	PO Business Unit	PO Number	Packing Slip Number	Pay Terms Basis Date Type	Include Miscellaneous	Pay Schedule Type	Tax Group Code	Tax Payment Type Code	Inspection Date	Invoice Receipt Date	Received Date	Bill of Lading	Carrier ID	Document Type	Discount Due Date	Prorate Discount	Due Date	Freight Charge	Letter of CreditID	Miscellaneous Charge	Remitting Address	Sales Tax Charge	Voucher Build Code	AR Business Unit	Customer ID	Item ID	Item Line	Voucher Source	Exception Type	Payment Terms Basis Date	User Character Field	User Character Field 2	User Amount Field	User Date	User Number field
6		CHAR	CHAR	CHAR	CHAR	DATE	CHAR	CHAR	NUMBER	CHAR	CHAR	CHAR	DATE	CHAR	CHAR	CHAR	NUMBER	NUMBER	CHAR	NUMBER	NUMBER	NUMBER	CHAR	DATE	CHAR	CHAR	NUMBER	NUMBER	NUMBER	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	DATE	DATE	DATE	CHAR	CHAR	CHAR	DATE	CHAR	DATE	CHAR	CHAR	CHAR	NUMBER	CHAR	CHAR	CHAR	CHAR	CHAR	NUMBER	CHAR	CHAR	DATE	CHAR	CHAR	NUMBER	DATE	NUMBER
7		Character	Character	Character	Character-Mixed Case	Date	Character	Character	Number	Character	Character	Character-Mixed Case	Date	Character	Character	Character	Signed Nbr	Signed Nbr	Character	Signed Nbr	Signed Nbr	Signed Nbr	Character	Date	Character	Character	Signed Nbr	Number	Signed Nbr	Character	Character	Character	Character	Character	Character-Mixed Case	Character-Mixed Case	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character	Character-Mixed Case	Character	Character	Character	Character	Character-Mixed Case	Character	Character	Character	Character	Character	Date	Date	Date	Character	Character	Character	Date	Character	Date	Character	Character	Character	Number	Character	Character	Character	Character	Character	Number	Character	Character	Date	Character	Character	Signed Nbr	Date	Number
8		5	8	4	30	10	10	10	3	10	3	30	10	1	10	8			1				5	10	3	5				1	1	1	1	1	30	30	1	1	1	1	1	4	3	6	3	6	3	3	20	1	3	6	3	6	3	6	3	6	6	10	1	254	9	20	5	10	22	1	1	3	4	5	10	10	10	30	10	8	10	1	10	10	12	10	3	10	6	5	15	30	6	4	1	10	1	1		10	3
9		Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No		No	No	No	No	No	No	No
10		UMNIS	NEXT	JRNL	Blank	Blank	Blank	Blank	Blank	Blank	Blank		Blank	Blank	Blank	Blank	0	0	Blank	0	0	0	Blank	Blank	Blank	Blank	0	0	0	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	Blank	0	Blank	Blank	Blank	Blank	Blank	0	XMLS	Blank	Blank	Blank	Blank	0	Blank	0

11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100