File Field Analysis

File Index Menu Scheduled Jobs Top level Programs
File: IS867P3
Library: FASTBREED
Description: Std Cost Conversion File
Format: R867P3
Fields: 79
Created:
Retrieved:

Fields

Field Long Name Description Type Len,Dec Column Headings Ref File
CMPUNQ CMPUNQ Company Unique Number Zoned Decimal 5,0 CMPUNQ// /
CNFIL1 CNFIL1 1st File Name Alpha 10 CNFIL1// /
CNMBR1 CNMBR1 File Member Alpha 10 CNMBR1// /
CNITM1 CNITM1 Field - Item Number Alpha 10 CNITM1// /
CNWHS1 CNWHS1 Field - Location Alpha 10 CNWHS1// /
CNCST1 CNCST1 Field - Standard Cost Alpha 10 CNCST1// /
CNLN1A CNLN1A Field Length - Item Number Zoned Decimal 2,0 CNLN1A// /
CNLN1B CNLN1B Field Length - Location Zoned Decimal 2,0 CNLN1B// /
CNDTE1 CNDTE1 File 1 Effectivity Date Flag Alpha 1 CNDTE1// /
CN1MM CN1MM Field - Eff Date MM Alpha 10 CN1MM// /
CN1DD CN1DD Field - Eff Date DD Alpha 10 CN1DD// /
CN1YY CN1YY Field - Eff Date YY Alpha 10 CN1YY// /
CN1C CN1C Field - Eff Date CC Alpha 10 CN1C// /
CN1CY CN1CY Field - Eff Date CCYY Alpha 10 CN1CY// /
CN1MDY CN1MDY Field - Eff Date MMDDYY Alpha 10 CN1MDY// /
CN1YMD CN1YMD Field - Eff Date YYMMDD Alpha 10 CN1YMD// /
C1CYMD C1CYMD Field - Eff Date CCYYMMDD Alpha 10 C1CYMD// /
C1MDCY C1MDCY Field - Eff Date MMDDYY Alpha 10 C1MDCY// /
CN2MM CN2MM Field - Obs Date MM Alpha 10 CN2MM// /
CN2DD CN2DD Field - Obs Date DD Alpha 10 CN2DD// /
CN2YY CN2YY Field - Obs Date YY Alpha 10 CN2YY// /
CN2C CN2C Field - Obs Date CC Alpha 10 CN2C// /
CN2CY CN2CY Field - Obs Date CCYY Alpha 10 CN2CY// /
CN2MDY CN2MDY Field - Obs Date MMDDYY Alpha 10 CN2MDY// /
CN2YMD CN2YMD Field - Obs Date YYMMDD Alpha 10 CN2YMD// /
C2CYMD C2CYMD Field - Obs Date CCYYMMDD Alpha 10 C2CYMD// /
C2MDCY C2MDCY Field - Obs Date MMDDYY Alpha 10 C2MDCY// /
CNFIL2 CNFIL2 2nd File Name Alpha 10 CNFIL2// /
CNMBR2 CNMBR2 File Member Alpha 10 CNMBR2// /
CNITM2 CNITM2 Field - Item Number Alpha 10 CNITM2// /
CNWHS2 CNWHS2 Field - Location Alpha 10 CNWHS2// /
CNCST2 CNCST2 Field - Standard Cost Alpha 10 CNCST2// /
CNLN2A CNLN2A Field Length - Item Number Zoned Decimal 2,0 CNLN2A// /
CNLN2B CNLN2B Field Length - Location Zoned Decimal 2,0 CNLN2B// /
CNDTE2 CNDTE2 File 2 Effectivity Date Flag Alpha 1 CNDTE2// /
CN3MM CN3MM Field - Eff Date MM Alpha 10 CN3MM// /
CN3DD CN3DD Field - Eff Date DD Alpha 10 CN3DD// /
CN3YY CN3YY Field - Eff Date YY Alpha 10 CN3YY// /
CN3C CN3C Field - Eff Date CC Alpha 10 CN3C// /
CN3CY CN3CY Field - Eff Date CCYY Alpha 10 CN3CY// /
CN3MDY CN3MDY Field - Eff Date MMDDYY Alpha 10 CN3MDY// /
CN3YMD CN3YMD Field - Eff Date YYMMDD Alpha 10 CN3YMD// /
C3CYMD C3CYMD Field - Eff Date CCYYMMDD Alpha 10 C3CYMD// /
C3MDCY C3MDCY Field - Eff Date MMDDYY Alpha 10 C3MDCY// /
CN4MM CN4MM Field - Obs Date MM Alpha 10 CN4MM// /
CN4DD CN4DD Field - Obs Date DD Alpha 10 CN4DD// /
CN4YY CN4YY Field - Obs Date YY Alpha 10 CN4YY// /
CN4C CN4C Field - Obs Date CC Alpha 10 CN4C// /
CN4CY CN4CY Field - Obs Date CCYY Alpha 10 CN4CY// /
CN4MDY CN4MDY Field - Obs Date MMDDYY Alpha 10 CN4MDY// /
CN4YMD CN4YMD Field - Obs Date YYMMDD Alpha 10 CN4YMD// /
C4CYMD C4CYMD Field - Obs Date CCYYMMDD Alpha 10 C4CYMD// /
C4MDCY C4MDCY Field - Obs Date MMDDYY Alpha 10 C4MDCY// /
CNFIL3 CNFIL3 3rd File Name Alpha 10 CNFIL3// /
CNMBR3 CNMBR3 File Member Alpha 10 CNMBR3// /
CNITM3 CNITM3 Field - Item Number Alpha 10 CNITM3// /
CNWHS3 CNWHS3 Field - Location Alpha 10 CNWHS3// /
CNCST3 CNCST3 Field - Standard Cost Alpha 10 CNCST3// /
CNLN3A CNLN3A Field Length - Item Number Zoned Decimal 2,0 CNLN3A// /
CNLN3B CNLN3B Field Length - Location Zoned Decimal 2,0 CNLN3B// /
CNDTE3 CNDTE3 File 3 Effectivity Date Flag Alpha 1 CNDTE3// /
CN5MM CN5MM Field - Eff Date MM Alpha 10 CN5MM// /
CN5DD CN5DD Field - Eff Date DD Alpha 10 CN5DD// /
CN5YY CN5YY Field - Eff Date YY Alpha 10 CN5YY// /
CN5C CN5C Field - Eff Date CC Alpha 10 CN5C// /
CN5CY CN5CY Field - Eff Date CCYY Alpha 10 CN5CY// /
CN5MDY CN5MDY Field - Eff Date MMDDYY Alpha 10 CN5MDY// /
CN5YMD CN5YMD Field - Eff Date YYMMDD Alpha 10 CN5YMD// /
C5CYMD C5CYMD Field - Eff Date CCYYMMDD Alpha 10 C5CYMD// /
C5MDCY C5MDCY Field - Eff Date MMDDYY Alpha 10 C5MDCY// /
CN6MM CN6MM Field - Obs Date MM Alpha 10 CN6MM// /
CN6DD CN6DD Field - Obs Date DD Alpha 10 CN6DD// /
CN6YY CN6YY Field - Obs Date YY Alpha 10 CN6YY// /
CN6C CN6C Field - Obs Date CC Alpha 10 CN6C// /
CN6CY CN6CY Field - Obs Date CCYY Alpha 10 CN6CY// /
CN6MDY CN6MDY Field - Obs Date MMDDYY Alpha 10 CN6MDY// /
CN6YMD CN6YMD Field - Obs Date YYMMDD Alpha 10 CN6YMD// /
C6CYMD C6CYMD Field - Obs Date CCYYMMDD Alpha 10 C6CYMD// /
C6MDCY C6MDCY Field - Obs Date MMDDYY Alpha 10 C6MDCY// /

Logical Files using IS867P3

Logical File Description Library Member Access Path Keys
(no keys defined)