Mapping Fields in the F1001Z1 Table
This appendix discusses how to map fields in these multisite consolidation inbound tables:
Unedited MSC Interoperability Header table (F1001Z1).
Unedited MSC Interoperability Detail table (F1002Z1).
Mapping Fields in the F1001Z1 Table
This section contains lists of the fields in the F1001Z1 table. The lists are group by required, optional, and ignored fields.
Required Fields for F1001Z1
These fields are required in the F1001Z1) In some fields, blank is a value.
Some of these fields are used to identify or control the transfer of consolidation information from the F1001Z1 table to the Multi-Site Consolidation Transfer File Header table (F1001). Values in the other fields are written to the F1001 table.
|
Field Name |
Alias |
Type |
Length |
Definition |
|
EDI - User ID |
IAEDUS |
Alpha |
10 |
Enter the user ID of the person who is running the process or the person who is to receive workflow messages about the transfer. This field, in conjunction with IAEDBT and IAEDTN, uniquely identifies a specific transaction. |
|
EDI - Batch Number |
IAEDBT |
Alpha |
15 |
Enter a number that is used to group transactions for processing. This field, in conjunction with IAEDUS and IAEDTN, uniquely identifies a specific transaction. |
|
EDI - Transaction Number |
IAEDTN |
Alpha |
22 |
Enter a number that identifies a transaction. This field, in conjunction with the SZRC5 from the F1002Z1, uniquely identifies a specific line of a specific transaction. This field, in conjunction with IAEDUS and IAEDBT, uniquely identifies a specific transaction. |
|
Direction Indicator |
IADRIN |
Alpha |
1 |
Enter a value that indicates that the record was written by an external system. The value in this field must be 1 for inbound transactions. |
|
Transaction Action |
IATNAC |
Alpha |
1 |
Enter A for transactions to be processed. No other values are valid. |
|
EDI - Successfully Processed |
IAEDSP |
Alpha |
1 |
Leave this field blank because the system populates it. The value N indicates that the transaction was not processed or was processed in error. After the transaction is successfully processed, the system changes the value in this field to Y. |
|
Consolidation Name |
IACNAM |
Alpha |
3 |
Enter the name of the consolidation. This value must exist in UDC table. |
|
Period Number - General Ledger |
IAPN |
Number |
2 |
Enter the general ledger period number of the transaction. |
|
Fiscal Year |
IAFY |
Number |
2 |
Enter the last two digits of the fiscal year. |
|
Century |
IACTRY |
Number |
2 |
The first two digits of the fiscal year. |
|
Ledger Type |
IALT |
Alpha |
2 |
Enter the ledger type of the transaction. This ledger type must exist in UDC 09/LT. If you leave this field blank, the system uses ledger type AA. |
|
Document Company |
IACO |
Alpha |
5 |
Enter the company of the transaction. This company must exist in the F0010 table. |
Optional Fields for F1001Z1
These fields are optional in the F1001Z1 table. They are not required to process multisite consolidations. The values in these fields are written to the F1001 table, but they are not used by the multisite consolidations programs.
|
Field Name |
Alias |
Type |
Length |
Definition |
|
Category Code File Sent |
IACCSE |
Alpha |
1 |
Enter a value indicates whether the Multi-Site Consolidation Transfer File - Category Codes table (F1003) was created for this consolidation. Values are: Blank or 0: The table was not created 1: The table was created. |
|
EDI - Line Number |
IAEDLN |
Number |
7 |
Not used to process consolidations. |
|
EDI - Document Type |
IAEDCT |
Alpha |
2 |
Not used to process consolidations. |
|
Type Transaction |
IATYTN |
Alpha |
8 |
Not used to process consolidations. |
|
EDI - Translation Format |
IAEDFT |
Alpha |
10 |
Not used to process consolidations. |
|
EDI - Transmission Date |
IAEDDT |
Date |
6 |
Not used to process consolidations. |
|
EDI - Detail Lines Processed |
IAEDDL |
Number |
5 |
Not used to process consolidations. |
|
Trading Partner ID |
IAPNID |
Alpha |
15 |
Not used to process consolidations. |
|
Transmission File Status |
IATRFG |
Alpha |
1 |
Not used to process consolidations. |
|
Number of Records Transmitted |
IATRSE |
Number |
15 |
Not used to process consolidations. |
|
Date - Sent |
IADTSE |
Date |
6 |
Not used to process consolidations. |
|
Number of Records Received |
IATRRC |
Number |
15 |
Not used to process consolidations. |
|
Date - Received |
IADTRI |
Date |
6 |
Not used to process consolidations. |
|
Prior Period Adjustments |
IAIN01 |
Alpha |
1 |
Not used to process consolidations. |
|
Debits = Credits |
IAIN02 |
Alpha |
1 |
Not used to process consolidations. |
|
Source UDC = Target UDC |
IAIN03 |
Alpha |
1 |
Not used to process consolidations. |
|
Source OBJ/Sub = Target OBJ/Sub |
IAIN04 |
Alpha |
1 |
Not used to process consolidations. |
|
Accounts Last Month Not This Month |
IAIN05 |
Alpha |
1 |
Not used to process consolidations. |
|
Business Units Last Month Not This Month |
IAIN06 |
Alpha |
1 |
Not used to process consolidations. |
|
Accounts This Month Not Last Month |
IAIN07 |
Alpha |
1 |
Not used to process consolidations. |
|
Business Units This Month Not Last Month |
IAIN08 |
Alpha |
1 |
Not used to process consolidations. |
|
Integrity Control Status 9 |
IAIN09 |
Alpha |
1 |
Not used to process consolidations. |
|
Integrity Control Status 10 |
IAIN10 |
Alpha |
1 |
Not used to process consolidations. |
|
Integrity Control Status 11 |
IAIN11 |
Alpha |
1 |
Not used to process consolidations. |
|
Integrity Control Status 12 |
IAIN12 |
Alpha |
1 |
Not used to process consolidations. |
Ignored Fields for F1001Z1
The fields in this table are ignored by the system. The system does not use the or write the values in these fields to the 1001 table.
|
Field Name |
Alias |
Type |
Length |
|
User Reserved Reference |
IAURRF |
Alpha |
15 |
|
User Reserved Code |
IAURCD |
Alpha |
2 |
|
User Reserved Code |
IAURC1 |
Alpha |
3 |
|
User Reserved Code |
IAURC2 |
Alpha |
10 |
|
User Reserved Amount |
IAURAT |
Number |
15 |
|
User Reserved Number |
IAURAB |
Number |
8 |
|
Transaction Originator |
IATORG |
Alpha |
10 |
Mapping Fields in the F1002Z1 Table
This section contains lists of the fields in the F1001Z1 table. The lists are group by required, optional, and ignored fields.
Required Fields for F1002Z1
These fields are required in the F1002Z1 table. In some fields, blank is a value. Some of these fields are used to identify or control the transfer of consolidation information from the F1002Z1 table to the F1002 table. Values in the other fields are written to the F1002 table.
|
Field Name |
Alias |
Type |
Length |
Definition |
|
EDI - User ID |
SZEDUS |
Alpha |
10 |
Enter the user ID of the person who is running the process or the person who is to receive workflow messages about the transfer. This field, in conjunction with SZEDBT and SZEDTN, uniquely identifies a specific transaction. |
|
EDI - Batch Number |
SZEDBT |
Alpha |
15 |
Enter a number used to group transactions for processing. This field, in conjunction with SZEDUS and SZEDTN, uniquely identifies a specific transaction. |
|
EDI - Transaction Number |
SZEDTN |
Alpha |
22 |
Enter a number that identifies a transaction. This field, in conjunction with SZRC5), uniquely identifies each transaction. This field, in conjunction with SZEDUS and SZEDBT, also uniquely identifies a specific transaction. |
|
File Line Identifier |
SZRC5 |
Number |
5 |
Enter a number that, in conjunction with SZEDTN, identifies each line of the transaction. |
|
Direction Indicator |
SZDRIN |
Alpha |
1 |
Enter 1 in for inbound transactions. this indicates that the record was written by an external system. |
|
Transaction Action |
SZTNAC |
Alpha |
1 |
Enter A for transactions to be processed. No other values are valid. |
|
EDI - Successfully Processed |
SZEDSP |
Alpha |
1 |
Leave this field blank because the system populates it. The number 0 indicates that the transaction was not processed or was processed in error. After the transaction is successfully processed, the system changes the value in the field to 1. |
|
Business Unit |
SZMCU |
Alpha |
12 |
Enter the business unit of the transaction. This value must be entered in the format that is defined in the account structure. |
|
Object Account |
SZOBJ |
Alpha |
6 |
Enter the object account of the transaction. This value must be entered in the format that is defined in the account structure. |
|
Subsidiary |
SZSUB |
Alpha |
8 |
Enter the subsidiary account of the transaction. This value must be entered in the format that is defined in the account structure. |
|
Description |
SZDL01 |
Alpha |
30 |
Enter a description of the account. |
Optional Fields for F1002Z1
These fields are optional in the F1002Z1 table. They are not required to process multisite consolidations. The values in these fields are written to the F1002 table, but they are not used by the multisite consolidations programs.
|
Field Name |
Alias |
Type |
Length |
Definition |
|
Subledger - G/L |
SZSBL |
Alpha |
8 |
Enter a value that indicates the subledger for the transaction. If you complete this field, you must also enter a value in SZSBLT. |
|
Subledger Type |
SZSBLT |
Alpha |
1 |
Enter a value that indicates the subledger type for the transaction. If you enter a value in this field, the value must exist in UDC table 00/ST. |
|
Currency Code - From |
SZCRCD |
Alpha |
3 |
Enter a code that identifies the currency of the transaction. The value in this field must exist in the F0013 table. |
|
Currency Code - Denominated In |
SZCRCX |
Alpha |
3 |
Enter a code that identifies the currency in which the transaction was denominated. The value in this field must exist in the F0013 table. |
|
Amount Beginning Balance/PYE Forward |
SZAPYC |
Number |
15 |
Enter the cumulative prior year-end balance. The system uses this amount as the beginning balance for balance sheet and job cost accounts. |
|
Amount - Net Posting 01 - Amount - Net Posting 14 |
SZAN01 - SZAN14 |
Number |
15 |
Enter the net amount that is posted during the specified accounting period. These fields represents accounting period 01–14. The system uses the accounting periods from the F0010 table. For each period, the net amount posted is the total of all debits and credits from the first day of the period through the last day of the period. |
|
Amount - Prior Year Net Postings |
SZAPYN |
Number |
15 |
Enter the prior year-end net postings. The system uses this number for profit and loss statement comparisons. |
|
Amount - Week to Date |
SZAWTD |
Number |
15 |
Not used to process consolidations. |
|
Amount - Original/ Beginning Budget |
SZBORG |
Number |
15 |
Not used to process consolidations. |
|
Budget Requested |
SZBREQ |
Number |
15 |
Not used to process consolidations. |
|
Budget Approved |
SZBAPR |
Number |
15 |
Not used to process consolidations. |
Ignored Fields for F1002Z1
The fields in this table are ignored by the system. The system does not use or write values in these fields to the F1002 table.
|
Field Name |
Alias |
Type |
Length |
|
User Reserved Reference |
SZURRF |
Alpha |
15 |
|
User Reserved Code |
SZURCD |
Alpha |
2 |
|
User Reserved Code |
SZURC1 |
Alpha |
3 |
|
User Reserved Code |
SZURC2 |
Alpha |
10 |
|
User Reserved Amount |
SZURAT |
Number |
15 |
|
User Reserved Number |
SZURAB |
Number |
8 |
|
Transaction Originator |
SZTORG |
Alpha |
10 |