Numeric Values

Numeric fields in Flat File Cross-Reference program (P47002) output appear as 32 positions. The first position indicates the sign of the subsequent value. A 0 indicates the number that follows is positive, and a dash indicates that the number that follows is negative. The next 20 positions indicate the whole number portion of the value, followed by a separator and then by 10 digits that indicate the decimal portion of the value. The separator character is based on the setting in the user preference for the decimal format character. Typically in North America, this value is a period. Numeric values always appear in this format, regardless of whether the field in the EDI outbound interface table is stored with a decimal.

This table shows the flat file format that corresponds to the values shown in the EDI outbound interface tables:

Value in Interface Table	Format in Flat File
1 or 1.0	000000000000000000001.0000000000
100686.54	000000000000000100686.5400000000
100686.54-	-00000000000000100686.5400000000
0	00000000000000000000000000000000

When you send or receive documents with decimal numbers, you must use a place holder such as a period (.) to indicate the position of the decimal. You define the place holder in the user preference table.