QY2 Records and Fields Master List 05-02-18.xlsx

	A	B	C
1	Record	Record Descr	Field Name
2	BCT_CTL	BCTP Control Log	BCT_SOURCE
3	BCT_CTL	BCTP Control Log	BCT_STATUS
4	BCT_CTL	BCTP Control Log	BUSINESS_UNIT
5	BCT_CTL	BCTP Control Log	CHNLNAME
6	BCT_CTL	BCTP Control Log	DEVICE_DTTIME
7	BCT_CTL	BCTP Control Log	DEVICE_ID
8	BCT_CTL	BCTP Control Log	DEVICE_LAST_SEQ
9	BCT_CTL	BCTP Control Log	DT_TIMESTAMP
10	BCT_CTL	BCTP Control Log	EIP_CTL_ID
11	BCT_CTL	BCTP Control Log	EIP_TRANS_SRC
12	BCT_CTL	BCTP Control Log	EIP_TRANS_SRC_REF
13	BCT_CTL	BCTP Control Log	ERRORS_FLG
14	BCT_CTL	BCTP Control Log	MSGNAME
15	BCT_CTL	BCTP Control Log	OPRID
16	BCT_CTL	BCTP Control Log	PARTIAL_FLG
17	BCT_CTL	BCTP Control Log	PROCESS_INSTANCE
18	BCT_CTL	BCTP Control Log	PUBID
19	BCT_CTL	BCTP Control Log	PUBNODE
20	BCT_CTL	BCTP Control Log	SUBNAME
21	BCT_CTL	BCTP Control Log	TRANSACTION_CODE
22	BCT_CTL	BCTP Control Log	TRANS_PROGRAM
23	BI_ACCT_ENTRY	Billing Account Entry table	ACCOUNT
24	BI_ACCT_ENTRY	Billing Account Entry table	ACCOUNTING_DT
25	BI_ACCT_ENTRY	Billing Account Entry table	ACCOUNTING_PERIOD
26	BI_ACCT_ENTRY	Billing Account Entry table	ACCT_ENTRY_TYPE
27	BI_ACCT_ENTRY	Billing Account Entry table	ALTACCT
28	BI_ACCT_ENTRY	Billing Account Entry table	APPL_JRNL_ID
29	BI_ACCT_ENTRY	Billing Account Entry table	BUDGET_DT
30	BI_ACCT_ENTRY	Billing Account Entry table	BUDGET_HDR_STATUS
31	BI_ACCT_ENTRY	Billing Account Entry table	BUDGET_LINE_STATUS
32	BI_ACCT_ENTRY	Billing Account Entry table	BUSINESS_UNIT
33	BI_ACCT_ENTRY	Billing Account Entry table	BUSINESS_UNIT_GL
34	BI_ACCT_ENTRY	Billing Account Entry table	CF16_AN_SBR
35	BI_ACCT_ENTRY	Billing Account Entry table	CURRENCY_CD
36	BI_ACCT_ENTRY	Billing Account Entry table	DEPTID
37	BI_ACCT_ENTRY	Billing Account Entry table	DISC_SUR_ID
38	BI_ACCT_ENTRY	Billing Account Entry table	DISC_SUR_INDICATOR
39	BI_ACCT_ENTRY	Billing Account Entry table	DISC_SUR_LVL
40	BI_ACCT_ENTRY	Billing Account Entry table	DOC_SEQ_DATE
41	BI_ACCT_ENTRY	Billing Account Entry table	DOC_SEQ_NBR
42	BI_ACCT_ENTRY	Billing Account Entry table	DOC_TYPE
43	BI_ACCT_ENTRY	Billing Account Entry table	DTTM_STAMP
44	BI_ACCT_ENTRY	Billing Account Entry table	ENTRY_EVENT
45	BI_ACCT_ENTRY	Billing Account Entry table	FISCAL_YEAR
46	BI_ACCT_ENTRY	Billing Account Entry table	FOREIGN_AMOUNT
47	BI_ACCT_ENTRY	Billing Account Entry table	FOREIGN_CURRENCY
48	BI_ACCT_ENTRY	Billing Account Entry table	FROM_ACCRUAL
49	BI_ACCT_ENTRY	Billing Account Entry table	GL_DISTRIB_STATUS
50	BI_ACCT_ENTRY	Billing Account Entry table	INVOICE
51	BI_ACCT_ENTRY	Billing Account Entry table	JOURNAL_DATE
52	BI_ACCT_ENTRY	Billing Account Entry table	JOURNAL_ID
53	BI_ACCT_ENTRY	Billing Account Entry table	JOURNAL_LINE
54	BI_ACCT_ENTRY	Billing Account Entry table	JRNL_LN_REF
55	BI_ACCT_ENTRY	Billing Account Entry table	KK_TRAN_OVER_DTTM
56	BI_ACCT_ENTRY	Billing Account Entry table	KK_TRAN_OVER_FLAG
57	BI_ACCT_ENTRY	Billing Account Entry table	KK_TRAN_OVER_OPRID
58	BI_ACCT_ENTRY	Billing Account Entry table	LEDGER
59	BI_ACCT_ENTRY	Billing Account Entry table	LEDGER_GROUP
60	BI_ACCT_ENTRY	Billing Account Entry table	LINE_DESCR
61	BI_ACCT_ENTRY	Billing Account Entry table	LINE_DST_SEQ_NUM
62	BI_ACCT_ENTRY	Billing Account Entry table	LINE_SEQ_NUM
63	BI_ACCT_ENTRY	Billing Account Entry table	MONETARY_AMOUNT
64	BI_ACCT_ENTRY	Billing Account Entry table	OPEN_ITEM_KEY
65	BI_ACCT_ENTRY	Billing Account Entry table	PC_CF1_N_SBR
66	BI_ACCT_ENTRY	Billing Account Entry table	PROCESS_INSTANCE
67	BI_ACCT_ENTRY	Billing Account Entry table	RATE_DIV
68	BI_ACCT_ENTRY	Billing Account Entry table	RATE_MULT
69	BI_ACCT_ENTRY	Billing Account Entry table	RT_TYPE
70	BI_ACCT_ENTRY	Billing Account Entry table	STATISTICS_CODE
71	BI_ACCT_ENTRY	Billing Account Entry table	STATISTIC_AMOUNT
72	BI_ACCT_ENTRY	Billing Account Entry table	TAX_AUTHORITY_CD
73	BI_ACCT_ENTRY	Billing Account Entry table	USER1
74	BI_ACCT_ENTRY	Billing Account Entry table	USER2
75	BI_ACCT_ENTRY	Billing Account Entry table	USER3
76	BI_ACCT_ENTRY	Billing Account Entry table	USER4
77	BI_ACCT_ENTRY	Billing Account Entry table	USER5
78	BI_HDR	Bill Header	ACCEPTGIRO_IND
79	BI_HDR	Bill Header	ACCOUNTING_DT
80	BI_HDR	Bill Header	ACCRUE_UNBILLED
81	BI_HDR	Bill Header	ACTIVITY_TYPE
82	BI_HDR	Bill Header	ADDRESS_SEQ_NUM
83	BI_HDR	Bill Header	ADD_DTTM
84	BI_HDR	Bill Header	ADJUSTED_FLAG
85	BI_HDR	Bill Header	AG_REF_NBR
86	BI_HDR	Bill Header	AP_CREATED_DT
87	BI_HDR	Bill Header	AR_DST_OPT
88	BI_HDR	Bill Header	AR_ENTRY_CREATED
89	BI_HDR	Bill Header	AR_LVL
90	BI_HDR	Bill Header	ATT_IVC_IMG_FLG
91	BI_HDR	Bill Header	AUTO_GEN_IVC_NUM
92	BI_HDR	Bill Header	BANK_ACCT_KEY
93	BI_HDR	Bill Header	BANK_CD
94	BI_HDR	Bill Header	BASE_CURRENCY
95	BI_HDR	Bill Header	BILLING_AUTHORITY
96	BI_HDR	Bill Header	BILLING_FREQUENCY
97	BI_HDR	Bill Header	BILLING_SPECIALIST
98	BI_HDR	Bill Header	BILL_BY_ID
99	BI_HDR	Bill Header	BILL_CYCLE_ID
100	BI_HDR	Bill Header	BILL_FSS_STATUS