Optional Fields in the F1002Z1 Table
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.
This table lists the optional fields in the F1002Z1 table:
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. |