IH_INVOICETYPE

0

ih_hist.ih_invoicetype

Internal use only. Specifies the column name in ih_hist for invoice_type, or 0 if not supported on this version of the source system. There are two invoice type columns in the EE version of ih_hist. This allows us to capture both.

When extracting from EE sources, invoice type needs to reference a new column in the ih_hist table.

OP

P

INV_BALANCE_HIST_START_DATE

2008-01-01

2008-01-01

The START date used for Inventory Transactions history loading

 

OP

M

INV_FUTURE_DEMAND_MONTHS

12

3

The number of months to include in future demand calculation (12 or less).

The days_on_hand_projected field calculates how many days there will be sufficient inventory for a particular item (by source/domain/site). The calculation requires the sum of future orders for the item that were created by MRP (Manufacturing Resource Planning, automated future orders based on need/use). This parameter allows you to limit how many months ahead to look for future orders in order to calculate projected days on hand values.

OP

M

INV_HISTORICAL_PERIOD_COUNT

-24

-24

Number of periods to use to determine Average daily issued quantity historical.

 

OP

M

INV_HISTORY_DATE

<Set to today's date before starting the initial history load>

2012-08-28

The first processing date for loading inventory. Format is YYYY-MM-DD. Set Programmatically by INITIAL_JOB_SETUP

 

OP

P

INV_LAST_IN_MSTR_EXTRACT

 

40574.53221

Last Extract Timestamp of data currently in load_in_mstr

 

OP

P

INV_PROCESS_CONNECTION_NAME

 

2010SE

Indicates the connection name used by the Inventory process job

 

OP

P

INV_PROCESS_DAYS

10

10

The number of days of Inventory to extract and process from permanent Data Store tables

 

OP

M

INV_PROCESS_RUNNING

N

N

Indicates if an Inventory process is currently running (Y,N)

Used to prevent multiple copies of the Inventory job from running at the same time. Under normal conditions, do not update this manually. However, if a job fails and is deleted, reset this to "N" to run the job again. But use caution and ensure that there really is no copy of the job running before chaning from to "N" from "Y".

OP

P

INV_PROCESS_RUNNING_JOB_NAME

 

DAILY_INV_PROCESS_CHAINED

Indicates the current or last run job name for INVENTORY processing.

 

OP

P

INV_PROJECTED_DAYS_ON_HAND_MAX

999

99999

If there is no mrp_demand to calculate projected days on hand, the number to display to represent an infinite amount of days.

 

OP

M

INV_REVALUE_PERIODS

100

10

The number of periods to revalue in inventory balances

 

OP

M

INV_TRANS_TYPES

'CST-ADJ','CST-TR','CYC-CNT','CYC-ERR','CYC-RCNT','ISS-CHL','ISS-COR','ISS-DO','ISS-FAS','ISS-GIT','ISS-POIT','ISS-PRV','ISS-RV','ISS-SCRP','ISS-SO','ISS-TR','ISS-UNP','ISS-WO','PLCG-ADJ','RCT-CHL','RCT-DO','RCT-FAS','RCT-GIT','RCT-PO','RCT-POIT','RCT-RS','RCT-SOR','RCT-TR','RCT-UNP','RCT-WO','RJCT-WO','TAG-CNT','CN-CNT'

 

Transaction types (tr_type) that are related to inventory changes

 

OP

Do Not Edit

INV_TRANS_TYPES_CONS

'CN-SHIP','CN-USE','CN-ADJ','CN-RCT','CN-ISS'

'CN-SHIP','CN-USE','CN-ADJ','CN-RCT','CN-ISS'

Transaction types (tr_type) that are related to consignment inventory movements

 

OP

Do Not Edit

INV_TRANS_TYPES_COUNT_ERR

'CYC-ERR'

'CYC-ERR'

Transaction types (tr_type) that are related to count errors

 

OP

Do Not Edit

INV_TRANS_TYPES_COUNT_TR

'CYC-CNT'

'CYC-CNT'

Transaction types (tr_type) that are related to count transactions

 

OP

Do Not Edit

INV_TRANS_TYPES_CUST

'ISS-SO','RCT-SOR','ISS-COR'

'ISS-SO','RCT-SOR','ISS-COR'

Transaction types (tr_type) that are related to customers

 

OP

Do Not Edit

INV_TRANS_TYPES_GIT

'ISS-GIT','ISS-POIT', 'RCT-GIT','RCT-POIT'

'ISS-GIT','ISS-POIT', 'RCT-GIT','RCT-POIT'

Transaction types (tr_type) that are related to goods in transit (GIT).

 

OP

Do Not Edit

INV_TRANS_TYPES_ISSUED

'ISS_SO','ISS-COR','ISS-WO','ISS-FAS','ISS-DO','ISS-RMA'

'ISS_SO','ISS-COR','ISS-WO','ISS-FAS','ISS-DO','ISS-RMA'

Transaction types (tr_type) that are related to inventory issued

 

OP

Do Not Edit

INV_TRANS_TYPES_RECEIVED

'RCT-FAS','RCT-PO','RCT-WO','RCT-DO'

'RCT-FAS','RCT-PO','RCT-WO','RCT-DO'

Transaction types (tr_type) that are related to inventory received

 

OP

Do Not Edit

INV_TRANS_TYPES_RECOUNT

'CYC-RCNT'

'CYC-RCNT'

Transaction types (tr_type) that are related to recount transactions

 

OP

Do Not Edit

INV_TRANS_TYPES_SALES

'ISS-SO','ISS-COR'

'ISS-SO','ISS-COR'

Transaction types (tr_type) that are related to sales orders

 

OP

Do Not Edit

INV_TRANS_TYPES_SUPPLIER

'ISS-PRV','RCT-PO'

'ISS-PRV','RCT-PO'

Transaction types (tr_type) that are related to suppliers

 

OP

Do Not Edit

JOB_INV_PROCESS_BATCH_ID

0

754

The batch id for the current DAILY_INV_PROCESS_JOB job.

 

OP

P

JOB_OP_PROCESS_BATCH_ID

0

755

The batch id for the current DAILY_OP_PROCESS_JOB job.

 

OP

P

JOB_PO_PROCESS_BATCH_ID

0

752

The batch id for the current DAILY_PO_PROCESS_JOB job.

 

OP

P

OP_HIST_LOAD_MAXSIZE

5000000

5000000

The maximum number of rows to load in an iteration loading op_hist

 

OP

P

OP_HIST_LOAD_RUNNING

C

C

Indicates if a load of op_hist is running (Y/N/C)

 

OP

P

OP_HIST_TRAN_MAX

 

19975

DON’T UPDATE MANUALLY. Maximum Transaction Id to extract this iteration.

 

OP

P

OP_HIST_TRAN_MAX_Sxx

 

433

DON’T UPDATE MANUALLY. Maximum Transaction Id to extract this iteration.

 

OP

P

OP_LOAD_LOOKBACK_DAYS

20

20

The number of days to look back in QAD when extracting OP data

Used to limit the amount of data extracted from wo_mstr, wod_det, and wr_route to just those open or closed between today and (today - lookback days)

OP

M

OP_MOVING_AVG_WEEKS

13

13

The Number of Weeks to base Moving Average on.

 

OP

M

OP_OEE_SNAPSHOT_FREQUENCY

B

B

The frequency of snapshots in the OP OEE snapshot tables. Possible values are: W for Weekly, M for Monthly, B for both weekly and monthly.

 

OPOP

M

OP_PROCESS_CONNECTION_NAME

 

QMI

Indicates the connection name used by the OP process job.

 

OP

P

OP_PROCESS_DAYS

5

5

The number of days of OP to extract and process from permanent staging tables.

 

OP

M

OP_PROCESS_RUNNING

N

N

Indicates if an OP process is currently running (Y,N)

 

OP

P

OP_PROCESS_RUNNING_JOB_NAME

 

DAILY_OP_PROCESS_CHAINED

Indicates the current or last run job name for module processing.

 

OP

P

PO_BOOKING_DATE

<Set to today's date before starting the initial history load>

2011-01-28

The processing date used for PO bookings processing. Format is YYYY-MM-DD

 

OP

M/P

PO_BOOKING_FIRST_DATE

<Set to today's date before starting the initial history load>

2011-01-28

The first processing date for loading bookings. Format is YYYY-MM-DD

 

OP

M/P

PO_EARLY_TOLERANCE_DELAY

2

4

Number of days an order is early and still is considered as "on-time".

 

OP

M

PO_LATE_TOLERANCE_DELAY

2

1

Number of days a PO can be late and still considered as on time.

 

OP

M

PO_LOOKBACK_DAYS

30

60

Set to the number of days the user is able to backdate the receipt date. This is used by the load table load_prh_hist.

 

OP

M

PO_ORDER_HISTORY_DATE

<Set to today's date before starting the initial history load>

2011-01-28

The processing date used for PO orders history calculations Format is YYYY-MM-DD

 

OP

P

PO_PERCENT_QTY_OVER

10

10

Percentage of Receipt Quantity over Order Quantity for a Purchase Order to still be considered In Full

 

OP

M

PO_PERCENT_QTY_UNDER

20

20

Percentage of Receipt Quantity under Order Quantity for a Purchase Order to still be considered In Full

 

OP

M

PO_PROCESS_CONNECTION_NAME

 

2010SE

Indicates the connection name used by the PO process job.

 

OP

P

PO_PROCESS_DAYS

10

10

The number of days of PO to extract and process from permanent staging tables.

 

OP

M

PO_PROCESS_RUNNING

N

N

Indicates if a PO process is currently running (Y,N)

Used to prevent multiple copies of the Purchasing job from running at the same time. Under normal conditions, do not update this manually. However, if a job fails and is deleted, reset this to "N" to run the job again. But use caution and ensure that there really is no copy of the job running before chaning from to "N" from "Y".

OP

P

PO_PROCESS_RUNNING_JOB_NAME

 

DAILY_PO_PROCESS_2010SE

Indicates the current or last run job name for PO processing.

 

OP

P

PO_RET_QTY_TOLERANCE

15

15

Percentage of Returns Quantity used for calculating Defect Rate.

 

OP

M

PO_SNAPSHOT_FREQUENCY

B

M

The frequency of snapshots in the PO order snapshot table. Possible values are: W for Weekly, M for Monthly, B for both weekly and monthly.

 

OP

M

PO_SNAPSHOT_HIST_START_DATE

<Set to today's date before starting the initial history load>

2011-01-28

The first date in the PO order snapshot table in the format YYYY-MM-DD for the first run

 

OP

P

PO_SNAPSHOT_NUM_DAYS

31

31

The number of days of snapshots to load back each run.

 

OP

M

PO_SNAPSHOT_REPLACE_FLAG

N

N

Indicates that snapshots are replaced or not. Y for replace, N for not replaced.

Y to replace the snapshot for recalculated periods when the snapshot job is run; N to add new records and not update previously calculated records. Default value is N.

OP

M

PO_SNAPSHOT_START_DATE

 

1997-05-24

Internal use only. The setup procedure for the PO snapshot tables updates this parameter to determine the date at which to start.

 

OP

P