	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

21 COLUMNS | 2 INDEXES | 812 | 74R | F74R9004 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
74R: CIS
1	812	F74R9004	CR	21	2	Correspondence Rules - RUS -09 - 74R	Files	74: EMEA Localization

TOP 812 | 74R | F74R9004 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	CRR74RUID	Correspondence Rule ID	Numeric	Generic Edit	6	Allow NULL?
2	CRICUT	Batch Type	String	UDC (98 IT)	2	Allow NULL?
3	CRDCT	Document Type	String	UDC (00 DT)	2	Allow NULL?
4	CRR74DOBJ	Debit Object Account	String	Generic Edit	6	Allow NULL?
5	CRR74DSUB	Debit Subsidiary	String	Generic Edit	8	Allow NULL?
6	CRR74COBJ	Credit Object Account	String	Generic Edit	6	Allow NULL?
7	CRR74CSUB	Credit Subsidiary	String	Generic Edit	8	Allow NULL?
8	CRR74CAFR	Category Code General From	String	Generic Edit	10	Allow NULL?
9	CRR74CATH	Category Code General Thru	String	Generic Edit	10	Allow NULL?
10	CRR74CCA1	Correspondence Category Code 01	String	UDC (74R C1)	3	Allow NULL?
11	CRR74CCA2	Correspondence Category Code 02	String	UDC (74R C2)	3	Allow NULL?
12	CRR74CCA3	Correspondence Category Code 03	String	UDC (74R C3)	3	Allow NULL?
13	CRR74CCA4	Correspondence Category Code 04	String	UDC (74R C4)	10	Allow NULL?
14	CRR74CCA5	Correspondence Category Code 05	String	UDC (74R C5)	10	Allow NULL?
15	CRR74CLOD	Account Level of Detail	Numeric	Generic Edit	2	Allow NULL?
16	CRR74ACCT	Account Type	String	UDC (74R AT)	2	Allow NULL?
17	CRUSER	User ID	String	Generic Edit	10	Allow NULL?
18	CRPID	Program ID	String	Generic Edit	10	Allow NULL?
19	CRJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
20	CRUPMJ	Date - Updated	Date	Generic Edit	6
21	CRUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Number

Description

RUID (Primary/Unique)

Element	Alias	Description	Sequence
1	R74RUID	Correspondence Rule ID	Ascending

ICUT DCT ACCOUNTS

Element	Alias	Description	Sequence
1	ICUT	Batch Type	Ascending
2	DCT	Document Type	Ascending
3	R74DOBJ	Debit Object Account	Ascending
4	R74DSUB	Debit Subsidiary	Ascending
5	R74CAFR	Category Code General From	Ascending
6	R74COBJ	Credit Object Account	Ascending
7	R74CSUB	Credit Subsidiary	Ascending
8	R74CATH	Category Code General Thru	Ascending