File Name . . . . K_PRODFLT
Library . . . . K3S_5DTA
Format Descr. . . Products filtered perd end
Format Name . . . RK_PRODFLT
File Type . . . . PF Unique Keys- N
Field Name FMT Start Lngth Dec Key Field Description
PT_COMP A 1 1 Company ID
PT_BUYR A 2 5 Buy group ID
PT_CHKTYP3 A 7 3 Period end check type
PT_LOCN A 10 5 Location ID
PT_FLTUNIT P 15 5 2 Filter units
PT_FLTDOLR P 18 5 2 Filter dollars
PT_LAST30 P 21 1 0 Last 30 days flag
PT_SUPL A 22 10 Supplier ID
PT_SUPLSUB A 32 10 Sub supplier ID
PT_NAME A 42 40 Supplier name
PT_PROD A 82 25 Product ID
PT_DESC1 A 107 40 Product description 1
PT_PRODSEQ A 147 40 Product sequence #
PT_BIRTH L 187 10 Product birth date
PT_USRSTAT A 197 1 User status M,P,W,F
PT_SYSSTAT A 198 1 Systm status D,N,R,L,S
PT_SEASONL A 199 10 Seasonal profile ID
PT_DELTCNT P 209 1 0 Delete count days
PT_PER01 P 210 7 0 Period 01 history
PT_PER02 P 214 7 0 Period 02 history
PT_PER03 P 218 7 0 Period 03 history
PT_PRVFCST P 222 9 2 Prev demand forecast
PT_NEWFCST P 227 9 2 New demand forecast
PT_DIFUNIT P 232 9 2 Difference in units
PT_DIFDOLR P 237 9 2 Difference in dollars
PT_DIFDAYS P 242 3 0 Difference in days
PT_ENDPER A 244 1 End of period code
PT_EXCEPTN P 245 1 0 Exception type 1,2,3