	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

20 COLUMNS | 1 INDEXES | 812 | 74 | F7404573 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
74: EMEA Localization
1	812	F7404573	KI	20	1	Detail Payment Instructions EXT. for German Payments	Secondary Master Files	04: Accounts Payable	AS400 Coexistence Tables

TOP 812 | 74 | F7404573 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	KIHDC	Payment Group Control Nbr - A/P Checks	Numeric	Generic Edit	8	Allow NULL?
2	KICKC	Check Control Number - A/P Checks	Numeric	Generic Edit	8	Allow NULL?
3	KIRC	Record Code - A/P Checkwriter Work File	Character	Generic Edit	1	Allow NULL?
4	KIKCO	Document Company	String	Generic Edit	5	Allow NULL?
5	KIDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
6	KIDCT	Document Type	String	UDC (00 DT)	2	Allow NULL?
7	KISFX	Document Pay Item	String	Generic Edit	3	Allow NULL?
8	KISFXE	Pay Item Extension Number	Numeric	Generic Edit	2	Allow NULL?
9	KIZT16	Intruction Code 1-Z1 Recd 'T' element 16	Numeric	UDC (74 27)	2	Allow NULL?
10	KIZT17	Intruction Code 2-Z1 Recd 'T' element 17	Numeric	UDC (74 27)	2	Allow NULL?
11	KIZT18	Intruction Code 3-Z1 Recd 'T' element 18	Numeric	UDC (74 27)	2	Allow NULL?
12	KIZT19	Intruction Code 4-Z1 Recd 'T' element 19	Numeric	UDC (74 27)	2	Allow NULL?
13	KIZT21	Cost Settlement Code-Recd 'T' element 21	Numeric	UDC (74 28)	2	Allow NULL?
14	KIZT22	Label of Payment - Recd 'T' element 22	Numeric	UDC (74 29)	2	Allow NULL?
15	KIZW03	Type of transaction concerned	Numeric	Generic Edit	1	Allow NULL?
16	KIZW04	Code Number - Z1 Record 'W' element 04	Numeric	UDC (74 30)	3	Allow NULL?
17	KIZAIC	Additional Instruction Code Info.	String	Generic Edit	25	Allow NULL?
18	KIZIPB	Instruction to Principal's Bank	String	Generic Edit	27	Allow NULL?
19	KIZCNT	Contact Name and Telephone Number	String	Generic Edit	35	Allow NULL?
20	KIZRC	Reporting Code	Character	Generic Edit	1	Allow NULL?

Number

Description

PaymentGroupControlNbr (Primary/Unique)

Element	Alias	Description	Sequence
1	HDC	Payment Group Control Nbr - A/P Checks	Ascending
2	CKC	Check Control Number - A/P Checks	Ascending
3	RC	Record Code - A/P Checkwriter Work File	Ascending
4	KCO	Document Company	Ascending
5	DOC	Document (Voucher Invoice etc.)	Ascending
6	DCT	Document Type	Ascending
7	SFX	Document Pay Item	Ascending
8	SFXE	Pay Item Extension Number	Ascending