QRYTCEfields.xls

	A	B	C	D	E	F
1	Field Name	Start Position	Length	Type	Decimal	Description
2	TCMBOXNO	1	10	A		Transaction Center Mailbox Number
3	TCSMBOXNO	11	10	A		Summary Mailbox Number
4	TCORGID	21	4	A		Organization ID
5	TCNETWORK	25	2	A		Network ID Code
6	TCTRANTYPE	27	1	A		Transaction Type (S/R)
7	TCCOMMSESS	28	10	A		Communication Session Number
8	TCDOCNAME	38	10	A		Document Name
9	TCMAILSTS	48	3	A		Mail Status
10	TCMAILDATE	51	8	S	0	Mail Date (YYYYMMDD)
11	TCMAILTIME	59	6	S	0	Mail Time (HHMMSS)
12	TCATCSESSN	65	8	S	0	Add-to-TC Session Number
13	TCPRGWAIT	73	3	S	0	Auto Purge Wait in Days
14	TCACKSTS	76	3	A		Acknowledgement Status
15	TCFAMBOXNO	79	10	A		Functional Acknowledgement Mailbox Number
16	TCFADATE	89	8	S	0	Functional Acknowledgement Sent/Received Date
17	TCFATPIDNO	97	11	S	0	Functional Ack Trading Partner Relationship ID
18	TCLINKFLD	108	10	A		User Link Field Name
19	TCLINKDATA	118	30	A		User Link Field Data
20	TCTPNAME	148	35	A		Trading Partner Name
21	TCTPINTID	183	15	A		Trading Partner Internal ID
22	TCTPRIDNO	198	11	S	0	Trading Partner Relationship ID
23	TCTESTIND	209	1	A		Test/Production Indicator Code
24	TCXLATEFMT	210	10	A		Translation Format Name
25	TCUFDNAME	220	10	A		User file Definition Name
26	TCTAGSEP	230	1	A		Segment Tag Separator Character
27	TCELMTSEP	231	1	A		Element Separator Character
28	TCSUBELSEP	232	1	A		Sub-element Separator Character
29	TCSEGTERM	233	1	A		Segment Terminator/ Row Delimiter
30	TCREPTSEP	234	1	A		Element Repetition Separator Character
31	TCRELCHAR	235	1	A		Release Character
32	TCDECCHAR	236	1	A		Decimal Mark Character
33	TCSNTXAGCY	237	3	A		Syntax Controlling Agency Code
34	TCSNTXLVL	240	1	A		Syntax Level Code
35	TCSNTXVER	241	3	S	0	Syntax Level Version
36	TCICREF	244	14	A		Interchange Reference Number
37	TCGRPREF	258	14	A		Group Reference Number
38	TCDOCREF	272	14	A		Document Reference Number
39	TCICENVID	286	6	A		Interchange Envelope ID
40	TCGRPENVID	292	6	A		Group Envelope ID
41	TCAUTQUAL	298	2	A		ENV-ISA01
42	TCAUTINFO	300	10	A		ENV-ISA02/BG01
43	TCSECQUAL	310	2	A		ENV-ISA03/UNB06B
44	TCSECINFO	312	14	A		ENV-ISA04/BG02/UNB06A/STX06
45	TCISNDRQ	326	4	A		ENV-ISA05/ICS05/UNB02B
46	TCISNDRID	330	35	A		ENV-ISA06/ICS06/BG03/UNB02A/STX02A
47	TCISNDRIID	365	35	A		ENV-UNB02C
48	TCISNDRSID	400	35	A		ENV-UNB02D
49	TCIRCVRQ	435	4	A		ENV-ISA07/ICS07/UNB03B
50	TCIRCVRID	439	35	A		ENV-ISA08/ICS08/BG04/UNB03A/STX03A
51	TCIRCVRIID	474	35	A		ENV-UNB03C
52	TCIRCVRSID	509	35	A		ENV-UNB03D
53	TCIEDATE	544	8	A		ENV-ISA09/ICS09/BG05/UNB04A/STX04
54	TCIETIME	552	4	A		ENV-ISA10/ICS10/BG06/UNB04B/STX04
55	TCIESTDID	556	4	A		ENV-ISA11/ICS03
56	TCIEVERID	560	12	A		ENV-ISA12/ICS04
57	TCIACKREQ	572	1	A		ENV-ISA14/UNB09
58	TCIUSAGE	573	1	A		ENV-ISA15/UNB11
59	TCIAPPREF	574	14	A		ENV-UNB07/STX07
60	TCIPRTYCOD	588	1	A		ENV-UNB08/STX08
61	TCIAGREEMN	589	35	A		ENV-UNB10
62	TCGFUNCID	624	6	A		GS-GS01/UNG01
63	TCGSNDRQ	630	4	A		GS-UNG02B
64	TCGSNDRID	634	35	A		GS-GS02/UNG02/STX02B
65	TCGRCVRQ	669	4	A		GS-UNG03B
66	TCGRCVRID	673	35	A		GS-GS03/UNG03A/STX03B
67	TCGEDATE	708	8	A		GS-GS04/UNG04A
68	TCGETIME	716	4	A		GS-GS05/UNG04B
69	TCGSTDAGCY	720	3	A		GS-GS07/UNG06
70	TCGSTDVER	723	12	A		GS-GS08/UNG07
71	TCGPSWD	735	14	A		GS-UNG08
72	TCISCLDVER	749	6	A		ENV-UNB01C
73	TCICHARENC	755	3	A		ENV-UNB01D
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