Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
cModeProcessing | MODE | char | OPT | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. |
cGLExplanation | PRIM | char | OPT | NONE |
A code that the Inventory Management system uses to select the default description that appears on the second line of a journal entry in the
general ledger.
Valid values are:
1 Item master description (the default).
2 Primary item number. |
cSymToIdentifyShrtInv | SYM1 | char | OPT | NONE |
A symbol that identifies the 8-character short item number when you do not want to use it as the primary number.
A blank in this field
indicates that you want to use this item number as the primary number. That is, you use it most often to enter or review information.
If this is not the
primary number, you must enter a special symbol to identify it. Use a symbol that is not significant for any other purposes of entry such as /, *, or &.
Do not use a period or a comma as a symbol. When you enter this item number on any other form, you must include this symbol as the first
character.
NOTE: Only one of the fields for item number symbols (SYM1, SYM2, SYM3, or SYM6) can be blank to identify it as the primary
number. All others must include a unique symbol. |
cSymToIdentLongInvN | SYM2 | char | OPT | NONE |
A symbol that identifies the 25-character second item number when you do not want to use it as the primary number.
A blank in this field
indicates that you want to use this item number as the primary number. That is, you use it most often to enter or review information.
If this is not the
primary number, you must enter a special symbol to identify it. Use a symbol that is not significant for any other purposes of entry such as /, *,
or &. Do not use a period or a comma as a symbol. When you enter this item number on any other form, you must include this symbol as the
first character.
NOTE: Only one of the fields for item number symbols (SYM1, SYM2, SYM3, or SYM6) can be blank to identify it as the primary
number. All others must include a unique symbol. |
cSymToIdent3rdInvNu | SYM3 | char | OPT | NONE |
A symbol that identifies the 25-character third item number when you do not want to use it as the primary number.
A blank in this field
indicates that you want to use this item number as the primary number. That is, you use it most often to enter or review information.
If this is not the
primary number, you must enter a special symbol to identify it. Use a symbol that is not significant for any other purposes of entry such as /, *, or &.
Do not use a period or a comma as a symbol. When you enter this item number on any other form, you must include this symbol as the first
character.
Note: Only one of the fields for item number symbols (SYM1, SYM2, SYM3, or SYM6) can be blank to identify it as the primary
number. All others must include a unique symbol. |
cSymToIdentCustomer | SYM5 | char | OPT | NONE |
A character that identifies the customer's or supplier's number in your system. When you enter a number preceded by this character, the
system recognizes the number as the customer's or supplier's number. The system then use the cross-reference table to match the number to
your item number. You must complete this field if you want the system to perform cross-referencing. |
cDelimiterSegment | SECD | char | OPT | NONE |
A character separator that you use with configured items during order entry. This character must be the same for each branch/plant. The
default character is a /.
Although you can specify a different character, J.D. Edwards recommends that you do not use an * and that you do not
change the value after you specify it.
For the segment delimiter, use a character that could never appear within an answer to a segment
question.
|
cSeparatorLocation | SEPL | char | OPT | NONE |
A character that divides the elements of the location when you display them on forms or reports. For example, you might use a / as a
separator character to divide elements such as aisle, bin, and shelf in a location code.
The location code can contain up to 20 characters, including
separators.
Separators are not stored in the tables, but are used to edit a location on a form or report. If you do not want to use separators,
leave this field blank.
However, you must enter characters and spaces to equal the correct length of each element in the location code. The
system then displays the location as one string of characters. |
mnNumberCharactersAis | SE01 | MATH_NUMERIC | OPT | NONE |
A number that identifies the number of characters to represent the tank (or aisle for packaged stock). Valid values are numbers 1 through 8. |
mnNumberCharactersBin | SE02 | MATH_NUMERIC | OPT | NONE |
A number that identifies the number of characters to represent the owner for commingled bulk stock (or bin for packaged stock). Valid
values are numbers 1 through 8. |
mnNumberCharactersCod03 | SE03 | MATH_NUMERIC | OPT | NONE |
The number of characters to represent Code 3 in the location format specification. |
mnNumberCharactersCod04 | SE04 | MATH_NUMERIC | OPT | NONE |
The number of characters to represent Code 4 in the location format specification. |
mnNumberCharactersCod05 | SE05 | MATH_NUMERIC | OPT | NONE |
The number of characters to represent Code 5 in the location format specification. |
mnNumberCharactersCod06 | SE06 | MATH_NUMERIC | OPT | NONE |
The number of characters to represent Code 6 in the location format specification. |
mnNumberCharactersCod07 | SE07 | MATH_NUMERIC | OPT | NONE |
The number of characters to represent Code 7 in the location format specification. |
mnNumberCharactersCod08 | SE08 | MATH_NUMERIC | OPT | NONE |
The number of characters to represent Code 8 in the location format specification. |
mnNumberCharactersCod09 | SE09 | MATH_NUMERIC | OPT | NONE |
The number of characters to represent Code 9 in the location format specification. |
mnNumberCharactersCod10 | SE10 | MATH_NUMERIC | OPT | NONE |
The number of characters to represent Code 10 in the location format specification. |
cJustifyAisle | LR01 | char | OPT | NONE |
A character (L or R) that specifies left or right justification for Aisle in the location format. |
cJustifyBin | LR02 | char | OPT | NONE |
Left or Right justification for Bin in the location format specification. |
cJustifyCode3 | LR03 | char | OPT | NONE |
Left or Right justification for Code 3 in the location format specification. |
cJustifyCode4 | LR04 | char | OPT | NONE |
Left or Right justification for Code 4 in the location format specification. |
cJustifyCode5 | LR05 | char | OPT | NONE |
Left or Right justification for Code 5 in the location format specification. |
cJustifyCode6 | LR06 | char | OPT | NONE |
Left or Right justification for Code 6 in the location format specification. |
cJustifyCode7 | LR07 | char | OPT | NONE |
Left or Right justification for Code 7 in the location format specification. |
cJustifyCode8 | LR08 | char | OPT | NONE |
Left or Right justification for Code 8 in the location format specification. |
cJustifyCode9 | LR09 | char | OPT | NONE |
Left or Right justification for Code 09 in the location format specification. |
cJustifyCode10 | LR10 | char | OPT | NONE |
Left or Right justification for Code 10 in the location format specification. |
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
mnPurchaseOrderIssueCst | POCS | MATH_NUMERIC | OPT | NONE |
The amount that the Procurement system uses to calculate the Economic Order Quantity (EOQ). This cost should be the estimate of the
cost of materials,labor, and overhead that you incur when you issue a single purchase order. The default value is .00.
The following example
shows how EOQ is determined using the Purchase Order Issue Cost method:
S Purchase Order Issue Cost = 15.0
I Inventory Carrying Cost =
.09 (9%)
Y Annual Sales in Units = 3,000
C Unit cost of Item = 10.0
EOQ = the square root of ((2S/I) x (Y/C))
The square root of [(2)(15)
divided by 0.09] x 3,000 divided by 10.0 = 316.23 |
mnCarryingCostPerInv | INCS | MATH_NUMERIC | OPT | NONE |
The percentage of inventory investment that the Procurement system uses to calculate Economic Order Quantity (EOQ). The default is .00.
Enter the percentage as a decimal value.
The following example shows how EOQ is determined using the Inventory Carrying Cost
Percentage:
S Purchase Order Issue Cost = 15.0
I Inventory Carrying Cost = .09 (9%)
Y Annual Sales in Units = 3,000
C Unit Cost of Item = 10.0
EOQ
= Square root of ((2S/I) x (Y/C)) = the square root of (2(15) divided by .09)) * (3000 divided by 10) = 316.23
NOTE: Access field help for
the Economic Order Quantity field for more information about the EOQ formula. |
mnWeightFactorLeadTime | IALP | MATH_NUMERIC | OPT | NONE |
This factor is used as the smoothing factor in calculating the moving average lead time values. This allows you to give more or less weight
to historical data versus current data.
For example: Item History records are written/updated in the purchase receipts programs for items by
business unit and fiscal year. The lead time weight factor is used to weight the history as well as the current receipt.
History Lead time = 15
days; Current lead time = 12 days; Factor = .80 Calculation:
1 - .80 = .20 (Historical weight factor)
.8 x 12 = 9.6 days (Current data weighted)
.2 x 15 = 3 days (Historical data weighted)
= 12.6 days Historical leadtime |
mnNoOfDaysInYr | BSDY | MATH_NUMERIC | OPT | NONE |
The number of days in a year that your company is open for business. This field is required. You must specify a number from 252 to 365.
The Procurement system uses this number to calculate the Economic Order Quantity (EOQ). |
mnAbcCode1SalesPercent | IA1 | MATH_NUMERIC | OPT | NONE |
A percentage that tells the system how to define the A group during ABC analysis. This number is the total of the A percentage added to the
percentage you want the system to use when it assigns items to the A group. For example,assume that you want items that make up the top
75% of your selling items in the A group and items that make up the next 20% in the B group. You would enter 95% in this field, which is the
total of 75% and 20%. You enter percentages as decimal amounts. For example, enter 75% as .75.
During ABC analysis, the system compares
the total sales of a single item to the total sales of all items to calculate the value of each item. An item's value is its percentage of the total
sales. The system then arranges the values of all items from those of highest value to those of lowest value and adds the values together
beginning with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items whose value
is included in the total between the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system
assigns that item to the C group. |
mnAbcCode1GrMarginPer | IB1 | MATH_NUMERIC | OPT | NONE |
Percentage that tells the system how to define the A group during ABC analysis. This number is the total of the A percentage added to the
percentage you want the system to use when it assigns items to the B group. For example,you want items that make up the top 75% of your
selling items in the A group and items that make up the next 20% in the B group. You would enter 95% in this field, which is the total of 75% and
20%. You enter each percentage as a decimal amount. For example, enter 75% as .75.
During ABC analysis, the system compares the total
sales of a single item to the total sales of all items to calculate the "value" of each item. An item's value is its percentage of the total sales. The
system then arranges the values of all items from those of highest value to those of lowest value and adds the values together beginning
with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items whose value is
included in the total betwen the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system assigns that
item to the C group. |
mnAbcCode1AvgInvPer | IC1 | MATH_NUMERIC | OPT | NONE |
Percentage that tells the system how to define the A group during ABC analysis. This number is the total of the A percentage added to the
percentage you want the system to use when it assigns items to the B group. For example,you want items that make up the top 75% of your
selling items in the A group and items that make up the next 20% in the B group. You would enter 95% in this field, which is the total of 75% and
20%. You enter each percentage as a decimal amount. For example, enter 75% as .75.
During ABC analysis, the system compares the total
sales of a single item to the total sales of all items to calculate the "value" of each item. An item's value is its percentage of the total sales. The
system then arranges the values of all items from those of highest value to those of lowest value and adds the values together beginning
with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items whose value is
included in the total betwen the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system assigns that
item to the C group. |
mnAbcCode2SalesPercent | IA2 | MATH_NUMERIC | OPT | NONE |
A percentage that tells the system how to define the B group during ABC analysis. This number is the total of the B percentage added to the
percentage you want the system to use when it assigns items to the B group. For example,assume that you want items that make up the top
75% of your selling items in the A group and items that make up the next 20% in the B group. You would enter 95% in this field, which is the
total of 75% and 20%. You enter percentages as decimal amounts. For example, enter 75% as .75.
During ABC analysis, the system compares
the total sales of a single item to the total sales of all items to calculate the value of each item. An item's value is its percentage of the total
sales. The system then arranges the values of all items from those of highest value to those of lowest value and adds the values together
beginning with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items whose value
is included in the total between the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system
assigns that item to the C group. |
mnAbcCode2GrMarginPer | IB2 | MATH_NUMERIC | OPT | NONE |
Percentage that tells the system how to define the B group during ABC analysis. This number is the total of the A percentage added to the
percentage you want the system to use when it assigns items to the B group. For example,you want items that make up the top 75% of your
selling items in the A group and items that make up the next 20% in the B group. You would enter 95% in this field, which is the total of 75% and
20%. You enter each percentage as a decimal amount. For example, enter 75% as .75.
During ABC analysis, the system compares the total
sales of a single item to the total sales of all items to calculate the "value" of each item. An item's value is its percentage of the total sales. The
system then arranges the values of all items from those of highest value to those of lowest value and adds the values together beginning
with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items whose value is
included in the total betwen the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system assigns that
item to the C group. |
mnAbcCode2AvgInvPer | IC2 | MATH_NUMERIC | OPT | NONE |
Percentage that tells the system how to define the B group during ABC analysis. This number is the total of the A percentage added to the
percentage you want the system to use when it assigns items to the B group. For example,you want items that make up the top 75% of your
selling items in the A group and items that make up the next 20% in the B group. You would enter 95% in this field, which is the total of 75% and
20%. You enter each percentage as a decimal amount. For example, enter 75% as .75.
During ABC analysis, the system compares the total
sales of a single item to the total sales of all items to calculate the "value" of each item. An item's value is its percentage of the total sales. The
system then arranges the values of all items from those of highest value to those of lowest value and adds the values together beginning
with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items whose value is
included in the total betwen the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system assigns that
item to the C group. |
mnAbcCode3SalesPercent | IA3 | MATH_NUMERIC | OPT | NONE |
A percentage that tells the system how to define the C group during ABC analysis. This number is the total of the C percentage added to the
percentage you want the system to use when it assigns items to the C group. For example,assume that you want items that make up the top
75% of your selling items in the A group and items that make up the next 20% in the B group. You would enter 95% in this field, which is the
total of 75% and 20%. You enter percentages as decimal amounts. For example, enter 75% as .75.
During ABC analysis, the system compares
the total sales of a single item to the total sales of all items to calculate the value of each item. An item's value is its percentage of the total
sales. The system then arranges the values of all items from those of highest value to those of lowest value and adds the values together
beginning with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items whose value
is included in the total between the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system
assigns that item to the C group. |
mnAbcCode3GrMarginPer | IB3 | MATH_NUMERIC | OPT | NONE |
Percentage that tells the system how to define the C group during ABC analysis. This number is the total of the A percentage added to the
percentage you want the system to use when it assigns items to the B group. For example,you want items that make up the top 75% of your
selling items in the A group and items that make up the next 20% in the B group. You would enter 95% in this field, which is the total of 75% and
20%. You enter each percentage as a decimal amount. For example, enter 75% as .75.
During ABC analysis, the system compares the total
sales of a single item to the total sales of all items to calculate the "value" of each item. An item's value is its percentage of the total sales. The
system then arranges the values of all items from those of highest value to those of lowest value and adds the values together beginning
with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items whose value is
included in the total betwen the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system assigns that
item to the C group. |
mnAbcCode3AvgInvPer | IC3 | MATH_NUMERIC | OPT | NONE |
Percentage that tells the system how to define the C group during ABC analysis. This number is the total of the A percentage added to the
percentage you want the system to use when it assigns items to the B group. For example,you want items that make up the top 75% of your
selling items in the A group and items that make up the next 20% in the B group. You would enter 95% in this field, which is the total of 75% and
20%. You enter each percentage as a decimal amount. For example, enter 75% as .75.
During ABC analysis, the system compares the total
sales of a single item to the total sales of all items to calculate the "value" of each item. An item's value is its percentage of the total sales. The
system then arranges the values of all items from those of highest value to those of lowest value and adds the values together beginning
with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items whose value is
included in the total betwen the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system assigns that
item to the C group. |
mnPeriodNumberCurrent | PNC | MATH_NUMERIC | OPT | NONE |
A number (from 1 to 14) that identifies the current accounting period . The system uses this number to generate error messages, such as
PBCO (posted before cut off) and PACO (posted after cut off). |
cGlInterfaceFlgGeneral | GLPO | char | OPT | NONE |
A code that indicates whether inventory transactions that are processed through this branch/plant create general ledger entries.
In
WorldSoftware, valid values are:
Y Yes, the system creates general ledger entries for inventory transactions for this branch/plant.
N No, the system
does not create general ledger entries for inventory transactions for this branch/plant.
In OneWorld, a checkmark indicates that the system
creates general ledger entries for inventory transactions for this branch/plant. |
cWriteUnits | UNGL | char | OPT | NONE |
A code that indicates whether the system moves units to the general ledger after the system records a journal entry from the following
programs:
P31111 (Work Order Inventory Issues)
P31112 (Work Order Completions)
P31802 (Work Order Journal Entries)
P31842
(Rate Base Journal Entries)
P4112 (Inventory Issues)
P4113 (Inventory Transfers)
P4114 (Inventory Adjustments)
P4116 (Item
Re-Classification)
P41413 (Cycle Count Update)
P41610 (Tag Update)
P42800 (Sales Update)
P4312 (Receipts)
P4314 (Voucher
Match)
P415021 (Update Operational Reconciliation)
P415101 (General Stock Movements)
P41514 (Bulk Manufacturing
Gains/Losses)
P49800 (Sales Update - A7.3 ECS Version)
P49700 (Cycle Billing)
P49510 (Bulk Load Confirmation - XT49799)
P49515 (Bulk
Load Confirm Batch - XT49799)
P49530 (Package Load Confirm - XT49799)
P49572 (Upload Gantry Data - XT49799)
P49710 (Bulk
Delivery Confirm - XT49799)
P49711 (Bulk Delivery Confirm Milk Run - XT49799)
P49715 (Bulk Disposition - XT49799)
P49720
(Package Delivery Confirm - XT49799)
P49731 (Mass Confirm Batch - XT49799) |
cAllocateByLot | CMGL | char | OPT | NONE |
A code that indicates the method that the system uses to commit lot items from inventory. Valid codes are:
1 The normal commitment
method for inventory. The system commits inventory from the primary location and then from secondary locations.
The system commits
inventory from the locations with the most inventory before committing inventory from locations with the least. The system commits backorders to
the primary location.
2 The inventory commitment method by lot number. The system commits inventory by lot number, starting with the
lowest lot number and committing orders to available lots.
3 The inventory commitment method by lot expiration date. The system commits
inventory from the locations with the earliest expiration date first. The system considers only locations with expiration dates greater than or equal
to the sales order or parts list requested date. |
szCostingMethodSales | CSMT | char | OPT | NONE |
A user defined code (40/CM) that indicates the cost method that the system uses to calculate the cost of goods sold for the item. Cost
methods 01-19 are reserved for J.D. Edwards use. |
szCostMethodPurchasing1 | PCSM | char | OPT | NONE |
A user defined code (40/CM) that indicates the cost method that the system uses to determine the cost of the item for purchase orders. Cost
methods 01-19 are reserved for J.D. Edwards use. |
cBackordersAllowedYN | BACK | char | OPT | NONE |
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item
Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the
Branch/Plant Constants program (P41001). Valid values are:
On
Allow backorders for this item.
Off
Do not allow backorders for this item, regardless of
the backorders code that is assigned to the customer.
|
mnCommitmentSpecificDays | COMH | MATH_NUMERIC | OPT | NONE |
A number that the system uses to determine when to commit inventory to an order in sales order processing. This value in days is added to
current date and compared with the promised ship date for the order line. If the promised date is greater than the calculated date, then the
order line will be future committed in the Item Location record (F41021). Enter 999 to eliminate future commits. |
cBatchControlRequirInv | ICRI | char | OPT | NONE |
A code that indicates whether to require entry of batch control information.
For each batch, the system displays a batch control form on which
you must enter information about the number of documents and the total amount of the transactions that you expect in the batch. The system
uses these totals to edit and display differences from the actual transactions you entered. This field applies only to the Inventory
Management and the Purchase Order Management systems. In Inventory Management, Y indicates that the system displays a batch control form
before you issue, adjust, or transfer inventory.
In Purchase Order Management, Y indicates that the system displays a batch control form before
you enter receipts. Valid values are:
Y Yes, require entry of batch control information.
N No, do not require entry of batch control information. |
cManagemtAprlInputInv | IARI | char | OPT | NONE |
A code that indicates whether you want to require approval of batches before they can be posted to the general ledger. Valid values are:
Y Yes, assign a status of Pending to each batch that you create within the listed systems.
N No, assign a status of Approved to each batch. |
cTypeMatch | MATY | char | OPT | NONE |
The type of purchase order matching required for the commodity class. Valid values are:
1. No Match - Invoice Only (Use Voucher Entry)
2. 2 Way - Invoice and Purchase Order
3. 3 Way - Invoice, Purchase Order and Receipt |
szTypeCrossReferTypeC | XRT | char | OPT | NONE |
A user defined code (41/DT) that identifies the type of cross-reference set up for this customer. Examples of cross-reference types include:
o Substitutes
o Replacements
o Bar codes
o Customer item numbers
o Supplier item numbers |
szTypeCrossReferenceT | XRT2 | char | OPT | NONE |
A user defined code (41/DT) that identifies the type of cross-reference set up for this supplier. Examples of cross-reference types include:
1. Substitutes
2. Replacements
3. Bar Codes
4. Customer Numbers
5. Supplier Numbers |
szRoutingApproval | ARTG | char | OPT | NONE |
A code that determines to whom an order is routed for approval. |
cAvailableQuantityC001 | DA01 | char | OPT | NONE |
Code telling the system whether the number of units soft committed to sales orders or work orders should be included in the item availability
calculation.
Valid codes are:
Blank No effect on the quantity available
- Reduces the quantity available (default) |
cAvailableQuantityC002 | DA02 | char | OPT | NONE |
Code telling the system whether the number of units hard committed to a specific location and lot for sales orders is included in the item
availability calculation. Valid codes are:
Blank No effect on the quantity available
- Reduces the quantity available (default) |
cAvailableQuantityC003 | DA03 | char | OPT | NONE |
Code telling the system to include the quantity on any sales order whose requested shipment date is beyond the specific commitment
days. The valid codes are:
Blank No effect on the quantity available
- Reduces the quantity available (default)
|
cAvailableQuantityC004 | DA04 | char | OPT | NONE |
Code telling the system whether the number of units hard committed to a specific location and lot for work orders is included in the item
availability calculation. Valid codes are:
Blank No effect on the quantity available
- Reduces the amount available (default)) |
cAvailableQuantityC005 | DA05 | char | OPT | NONE |
Code indicating whether the system includes the quantity specified as an additional reduction in the item availability calculation. Valid
codes are:
Blank No effect on the quantity available
- Reduces the quantity available (default) |
cAvailableQuantityC006 | DA06 | char | OPT | NONE |
Code indicating whether the system includes this quantity as an additional reduction in the item availablity calculation. Valid codes
are:
Blank No effect on the quantity available
- Reduces the quantity available (default) |
cAvailableQuantityC007 | DA07 | char | OPT | NONE |
Code telling the system to include the number of units on hold in the item availability calculation. Valid codes are:
Blank No effect on the
quantity available
- Reduces the quantity available (default) |
cAvailableQuantityC008 | DA08 | char | OPT | NONE |
Code telling the system whether to include the number of units on purchase orders in the item availability calculation. Valid codes are:
Blank No effect on the quantity available (default)
+ Increases the quantity available |
cAvailableQuantityC009 | DA09 | char | OPT | NONE |
Code telling the system to include the number of units on work orders in the item availability calculation. Valid codes are:
Blank No effect on
the quantity available (default)
+ Increases the quantity available |
cAvailableQuantityC010 | DA10 | char | OPT | NONE |
Code indicating whether the system includes the number of units on other purchase orders in the item availability calculation. Valid codes
are:
Blank No effect on the quantity available (default)
+ Increases the quantity available |
cAvailableQuantityC011 | DA11 | char | OPT | NONE |
Code indicating whether the system includes the number of units reserved as safety stock in the item availability calculation. Valid codes
are:
Blank No effect on the quantity available (default)
- Reduces the quantity available |
cAvailableQuantityC012 | DA12 | char | OPT | NONE |
Code telling the system to include the number of units in inspection in the item availability calculation. Valid codes are:
Blank No effect on
the quantity available (default)
+ Increases the quantity available |
cAvailableQuantityC013 | DA13 | char | OPT | NONE |
Code telling the system to include the number of units in transit in the item availability calculation. Valid codes are:
Blank No effect on the
quantity available (default)
+ Increases the quantity available |
cAvailableQuantityC014 | DA14 | char | OPT | NONE |
Code telling the system to include the number of units in one operation of the receipt routing process in the item availability calculation. You
define which operation from receipt routing corresponds to this field. Valid codes are:
Blank No effect on the quantity available (default)
+
Increases the quantity available |
cAvailableQuantityC015 | DA15 | char | OPT | NONE |
Code telling the system to include the number of units in one operation of the receipt routing process in the item availability calculation. You
define which operation from receipt routing corresponds to this field. Valid codes are:
Blank No effect on the quantity available (default)
+
Increases the quantity available |
cAvailableQuantityC016 ct | DA16 | char | OPT | NONE |
|
cUpdatePrimaryLastin | SYM4 | char | OPT | NONE |
Code indicating whether you want to update the last-in cost in the primary location when you receive and/or voucher match a line. Valid
values are:
Y Indicates that the system should update the last-in cost at the primary
location as well as the location to which you are receiving
an item
N Indicates that the last-in cost should be updated in the received or matched loation only and not at the primary location |
szUnitOfMeasureDimen | WIUM | char | OPT | NONE |
A user defined code (system 00/type UM) that identifies the unit of measure that the system uses to display dimensions for the warehouse.
The system provides the ability to establish inches, centimeters, meters, and so forth,as a measuring standard. |
szUnitOfMeasureVolDisp | VUMD | char | OPT | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to display volume for this branch/plant. The system
inputs a value in this field from Branch/Plant Constants - Page 2 (P410012). You can override this default value. |
szUnitOfMeasureWeight | UWUM | char | OPT | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to indicate weight for this item. You can specify ounces,
grams, kilograms, and so on, as weight standards. The system uses this unit of measure for the item or overrides it for an individual item or
container. |
cUniqueLots | ULOT | char | OPT | NONE |
A code that determines whether the system can assign the same lot to multiple items. Valid values are:
1 Do not allow duplicate lots. The
lot is restricted to one item and one branch/plant.
2 Allow duplicate lots. You can create a lot that contains multiple items and
branch/plants.
3 Do not allow duplicate lots. The lot is restricted to one item, but can contain quantities in multiple branch/plants. |
cControlCodeLocations | LCTL | char | OPT | NONE |
A value or option that indicates which type of location control the system requires. You should use location control if you want to use only
locations that are in the Location Master table (F4100). Turn this option on to indicate that the system uses only locations that are defined in the
Location Master table. When the Warehouse Control option is turned on, the Location Control option must also be turned on.
For PeopleSoft
World, valid values are:
Y
Yes, use only locations in the Location Master table.
N
No, do not restrict locations to those in the Location Master
table. Use all locations that conform to the location format defined on Branch/Plant Constants - Page 2.
|
cControlCodeWarehouse | WCTL | char | OPT | NONE |
A code that determines whether the system creates warehouse transactions for the branch/plant. |
szResourceVersion | MVER | char | OPT | NONE |
A user defined code (40/RV) that identifies an inclusion rule that you want the system to use for this branch/plant. The Manufacturing and
Warehouse Management systems use inclusion rules as follows:
o For Manufacturing:
Allows multiple versions of resource rules for
running MPS, MRP, or DRP.
o For Warehouse Management:
Allows multiple versions of inclusion rules for running putaway and picking. The
system processes only those order lines that match the inclusion rule for a specified branch/plant. |
szLocationShipping | CLOC | char | OPT | NONE |
A code that identifies the location that the system uses for packing and shipping goods out of the warehouse. You can define this location
as a staging location (a location that has unlimited space) through Location Profile (P46020). |
szLocationReceiving | XLOC | char | OPT | NONE |
A code that identifies the location that the system uses for receiving goods into the warehouse. This location defaults into purchase order
detail lines for the item. You can define this location as a staging location (a location that has unlimited space) through Location Profile
(P46020). |
cStrappingTemperatureUnit | STPU | char | OPT | NONE |
A code used to identify the type of temperature. Valid values are:
F Fahrenheit
C Celsius |
cDensityTypeAtStandardTem | DNTP | char | OPT | NONE |
A code used to identify the type of density. Valid values are:
A Absolute Density
G API Specific Gravity
R Relative Density |
mnTempaeratureStandard | TMPS | MATH_NUMERIC | OPT | NONE |
Indicates the temperature to which the system converts all volumes for inventory purposes. This is the depot (branch/plant) standard. You
can convert volumes to a baseline temperature using the Petroleum Measurement Table routines (for example, 60 degrees Fahrenheit or 15
degrees Centigrade) and then convert to the depot standard (for example, 20 degrees Centigrade). |
cMeasurementUSorMetric | USMT | char | OPT | NONE |
Indicates if unit measurements are U.S.-based (Imperial) or metric standards.
Valid values are:
M Metric
U U.S.
If you leave this field blank,
the system uses M (metric). |
cConstantFutureUse1 | OT1Y | char | OPT | NONE |
A code that indicates whether you control the item by potency. |
cConstantFutureUse2 | OT2Y | char | OPT | NONE |
A code that indicates whether you control the item by grade. |
cFutureUse | OT3Y | char | OPT | NONE |
A code that indicates whether another company owns the branch/plant. The Bulk and Packed Load Confirmation programs use this code to
determine if the depot from which product is being loaded is a foreign depot. If it is a foreign depot, you must enter a valid borrow
agreement during load confirmation.
For PeopleSoft World, valid values are:
Y
Another company owns the branch/plant.
N
The branch/plant is not a
foreign depot.
For PeopleSoft EnterpriseOne, a checkmark indicates that another company owns the branch/plant.
|
cFuture4 | OT4Y | char | OPT | NONE |
A code that indicates whether to turn on the Quality Management system (system
37) for the branch/plant.
For WorldSoftware, valid values
are:
Y Yes, turn on Quality Management for this branch/plant.
N No, do not turn on Quality Management for this branch/plant.
For OneWorld, a
checkmark indicates that Quality Management is turned on for the branch/plant. |
cInventoryLotCreation | OT5Y | char | OPT | NONE |
A code that specifies whether distribution programs use total cost or detailed product costs.
|
cUSIncrementsDelimeter | USID | char | OPT | NONE |
This character separates feet from inches and fractions when entering U.S.
increments in tank strappings and the dip volume calculator.
The integer to the left of the delimiter is feet. The integer to the right is inches. Another delimiter denotes fractions of an inch in sixteenths. You
can use any character except a period (.) or a comma (,). If you leave this field blank,the system uses a forward slash (/). |
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile.
|
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565.
The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where:
T
The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program.
SS
The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system.
XXX
The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.
|
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job.
|
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. |
mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. |
szProductCode | SY | char | OPT | NONE |
A user defined code (98/SY) that identifies a system. Valid values include:
01
Address Book
03B
Accounts Receivable
04
Accounts
Payable
09
General Accounting
11
Multicurrency
|
szCostCenter | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
cFutureUse9999 | OT6Y | char | OPT | NONE |
A code that indicates whether the inventory transaction programs can create new lot or serial numbers in the system.
If you leave this option
blank, the system will not allow the inventory transaction programs to create new lot numbers in the system.
If you check this option, the
system allows the inventory transaction programs to create new lot numbers in the system. |
cLocSegCntrl | SCTL | char | OPT | NONE |
|
cSeparatorSegment | SEPS | char | OPT | NONE |
|
cSymToIdentSegItem | SYM6 | char | OPT | NONE |
|
cLotAuditFlag | LAF | char | OPT | NONE |
An option that indicates whether the system creates a lot audit record when certain information is modified.
|
cSpecialLotFormat | LTFM | char | OPT | NONE |
An option that indicates that you can use an external program to format the Lot/Serial Number field.
|
cRestrictWoLotAssignment | RWLA | char | OPT | NONE |
An option that indicates whether special lot number restrictions exist.
|
cLotNumberPreAsignment | LNPA | char | OPT | NONE |
An option that determines whether the system must preassign lot numbers before processing the transaction.
|
szErrorMessageID | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
|
cSuppressErrorMessage | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
runtime error message handling.
1 = suppress runtime error message handling. |
cTableIOStatus | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|