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 |
|
|
K_PRODFLT - Product Filtered at Period End |