INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

REQUISITION_NUM

Req

I 10

Enter the Requisition Number you wish to modify.

LINE_NUM

Req

I 9

Enter the Requisition Line Number.

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values are:

• A (Add) – Adds the record to the database. PENTA provides an error message if the record already exists in the database.

• C (Change) – Update an existing record. If the column is not updateable, PENTA records an error.

• D (Delete) – Delete an existing record. If PENTA cannot delete the column, it records an error.

• U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied column in the existing record.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

LONG_DESCR

Opt

C 2000

The description of the line item. If null, PENTA copies the description from the Product/Supplier Product.

REQUISITION_LINE_STAT_CD

Opt

C! 1

Available status codes:

• A – Active

• C – Complete

• X – Cancelled

• R – 100% Released

Status Code is required when adding a line #.

JOB_ID

Opt

X

Enter the ID of the job for the requisition line #.

Entry establishes distribution type as Job; only one distribution can be selected per line #.

Required on new records if distribution type is Job.

If option 107 is on (Y), then intercompany check is performed on the Requisition’s OU and the Job’s OU. OU is defaulted to Job’s OU.

COST_TYPE_CD

Opt

C! 4

Enter the Cost Type Code for the Job on the requisition line.

Required on new records if distribution type is Job.

Cost type must be valid for the Job and Job’s OU.

CC

Opt

X

Enter the CostCode for the Job and cost type on the requisition line.

Required on new records if distribution type is Job.

Status of Costcode must be Active (A).

If the Job requires valid Costcodes, the Costcode must be valid for the Job and Cost Type entered on the Requisition.

DR_OU_ID

Opt

X

Enter the OU ID for the requisition line #.

Entry establishes distribution type as Account; only one distribution can be selected per line #.

Required on new records if distribution type is Account.

If option 107 is on (Y), then intercompany check is performed on the Requisition’s OU and the entered OU.

ACCT_NUM

Opt

X

Enter the Account number for the Requisition line #.

Must be a non-edit rule account.

FA_ID

Opt

X

Enter the Fixed Asset ID for the requisition line #.

Entry establishes distribution type as Fixed Asset; only one distribution can be selected per line #.

Required on new records if distribution type is Fixed Asset.

If option 107 is on (Y), then intercompany check is performed on the Requisition’s OU and the Charge OU of FA and Category.

FA_EXP_CAT_NUM

Opt

I 3

Enter the Fixed Asset Expense Category number for the requisition line #.

Expense Category must be valid for FA.

WO_ID

Opt

C 25

Enter the Work Order ID for the requisition line #.

Entry establishes distribution type as Work Order; only one distribution can be selected per line #.

Required on new records if distribution type is Work Order.

Status of WO cannot be Complete (W), On Hold (H), Quote (Q), or Cancelled (X).

WO_OU_ID

Opt

X

Enter the Organization Unit ID for the WO of the requisition line #.

Required on new records if distribution type is Work Order.

If option 107 is on (Y), then intercompany check is performed on the Requisition’s OU and the WO’s OU. Must be valid for the WO ID.

WO_COST_TYPE_CD

Opt

C 4

Enter the Cost Type for the Work Order of the requisition line #.

Required on new records if distribution type is Work Order.

Status of WO Cost Type must be Active (A) and valid for the WO ID.

WO_TASK_ID

Opt

C 10

Enter the Task ID for the Work Order of the requisition line #.

Must be a valid Task ID for the WO’s OU.

MAINT_CONTRACT_ID

Opt

C 15

Enter the Maintenance Contract ID for the Work Order of the requisition line #.

Default to value on WO, if not entered.

Contract must reference the customer specified on WO.

WHSE_ID

Opt

C 4

Enter the Warehouse ID where the units will be transferred from for the requisition line #.

Entry establishes distribution type as Warehouse; only one distribution can be selected per line #.

The balance sheet OU ID of the Warehouse must match the balance sheet OU ID of the Requisition.

ITEM_NUM

Opt

X

Enter the Tag ID for the requisition line #.

VEN_ID

Opt

X

Enter the Vendor ID where the units will be purchased from for the requisition line #.

Status must be Active (A) or On Hold (H).

Must be valid for the Requisition’s OU.

If a vendor is specified on the catalog, it must match the vendor on the requisition.

CATALOG_ID

Opt

C 10

Enter the Catalog ID where the materials will be purchased for the requisition line #.

VEN_PROD_ID

Opt

C 26

Enter the Supplier Product ID for the materials in the Catalog for the requisition line #.

The entered supplier product ID must exist in the catalog.

PROD_ID

Opt

X

Enter the Product ID for that will be purchased or transferred with the requisition line #.

If a product and supplier product have been entered, then the product tied to the supplier product must match the product entered.

Defaults from the catalog and supplier ID if product ID is not entered.

PUM

Opt

C! 5

Enter the Purchase Unit of Measure for the Product entered on the requisition line #.

Must be a valid for Catalog Product if Catalog Product entered.

Defaults from the Product/Supplier Product UM if not entered.

REQUISITION_UNITS

Opt

F 9.3

Enter the number of units for the being requested for the requisition line #.

Units is required when adding a new line #.

D_NEEDED_DATE

Opt

D

Enter the delivery date needed for the requisition line #.

Date cannot be greater than 365 days from today.

PUM_PRICING_FACTOR_CD

Opt

C 2

Enter the Purchase Unit of Measure pricing factor code for the requisition line #. This is the code identifying the vendor-pricing rules for purchased products.

PRICE_MULT

Opt

F 2.3

Enter the Price Multiplier, the number the unit price will be multiplied by when calculated the requisition line # amount.

UP

Opt

F 9.3

Enter the Unit Price of each unit for the requisition line #.

BID_UNIT_PRICE

Opt

F 8.2

Enter the Bid Unit Price, the unit price used on the estimate, for the requisition line #.

RET_PCT

Opt

F 3.3

Enter the Retention Percent PENTA should withhold from each invoice generated on or after the Effective Date for the requisition line #.

Must be between 0 and 100, inclusive.

MANUFACTURER_ID

Opt

C! 10

Enter the Manufacturer ID for the product of the requisition line #.

Disallowed if Supplier Product and Catalog are entered.

Default from Product Catalog for entered Catalog & Product/Supplier Product if not entered.

MANUFACTURER_CAT_NUM

Opt

C 26

Enter the Manufacturer Catalog # for the Product of the requisition line #.

Disallowed if Supplier Product and Catalog are entered.

Default from Product Catalog for entered Catalog & Product/Supplier Product if not entered.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

REQUISITION_NUM

Req

I 10

Enter the Requisition Number you wish to modify.

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values are:

• A (Add) – Adds the record to the database. PENTA provides an error message if the record already exists in the database.

• C (Change) – Update an existing record. If the column is not updateable, PENTA records an error.

• D (Delete) – Delete an existing record. If PENTA cannot delete the column, it records an error.

• U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied column in the existing record.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

OU_ID

Opt

X

Identify the OU assigned to the Requisition.

Required if adding a new requisition and Job ID is not specified. If a Job ID is specified and No OU is entered, the Job OU ID is defaulted.

The balance sheet OU ID of the Requisition must match the balance sheet OU ID of the Warehouse if a warehouse is specified.

If option 107 is on (Y), then intercompany check is performed on the Requisition’s OU and the Job’s OU, if Job ID is entered.

DESCR

Opt

C 30

Description of the Requisition

REQUISITION_STAT_CD

Opt

C! 1

Status of the Requisition. Available values are:

• A – Active

• C – Complete

• X – Cancelled

Default status of "A" if none is entered.

User must have module security access to update the status of a requisition, Allow Access to Details = Y.

VEN_ID

Opt

X

ID of the Vendor that products will be purchased from one the requisition.

Status of Vendor must be Active (A) or On Hold (H)

JOB_ID

Opt

X

ID of the Job on the requisition.

Either Job ID OR Warehouse ID may be entered, but not both.

Status of Job must be Active (A).

COST_TYPE_CD

Opt

C 4

Enter the Cost Type Code for the Job on the requisition.

Status of Cost Type must be Active (A) and the Cost type must be valid for the Job and the Job’s OU.

CC

Opt

X

Enter the Costcode for the Job and cost type on the requisition.

Status of Costcode must be Active (A).

If the Job requires valid Costcodes, the Costcode must be valid for the Job and Cost Type entered on the Requisition.

WHSE_ID

Opt

C 4

ID of the Warehouse products will be transferred from on the requisition.

Either Warehouse ID OR Job ID may be entered, but not both.

The balance sheet OU ID of the Warehouse must match the balance sheet OU ID of the Requisition.

D_NEEDED_DATE

Opt

D

Enter the delivery date needed for the requisition.

Date cannot be greater than 365 days from today.

SHIP_NAME

Opt

C 30

Enter the name of the address for the requisition.

SHIP_ADDR_1

Opt

C 30

Enter the first line of the shipping address.

SHIP_ADDR_2

Opt

C 30

Enter the second line of the shipping address.

SHIP_ADDR_3

Opt

C 30

Enter the third line of the shipping address.

SHIP_CITY

Opt

C 20

Enter the city of the shipment address.

SHIP_ST_CD

Opt

C! 4

Enter the state or province of the shipment address.

SHIP_POSTAL_CD

Opt

C 10

Enter the postal (or zip) code of the shipment address.

SHIP_COUNTRY_CD

Opt

C! 3

Enter the country of the shipment address.

REQUESTER_EMP_ID

Opt

X

Enter the employee ID of the person requesting the requisition.

RET_PCT

Opt

F 8.3

Enter the retention percentage for the requisition.

Must be between 0 and 100, inclusive.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

SEQ_NUM

Req

I 10

Enter the Sequence Number you wish for the interface request to process the text.

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values are:

• A (Add) – Adds the record to the database. PENTA provides an error message if the record already exists in the database.

• C (Change) – Update an existing record. If the column is not updateable, PENTA records an error.

• D (Delete) – Delete an existing record. If PENTA cannot delete the column, it records an error.

• U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied column in the existing record.

REQUISITION_NUM

Req

I 10

Enter the Requisition Number you wish to modify.

LINE_NUM

Req

I 9

Enter the Line # for which you are modifying Requisition text.

For Requisition Master level text, enter zero (0).

RQSTN_TEXT_LEVEL_CD

Req

C 1

Enter the Text Level Code of the text you are modifying.

Valid values are:

• M = Requisition Master level

• D = Requisition Detail level

RQSTN_TEXT_TYPE_CD

Req

C 1

Enter the Type Code for the text you are modifying.

Valid values are:

• L = Leading text

• F = Following text

STD_TEXT_SEQ_NUM

Opt

I 10

• Enter the Standard Text # you are modifying.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

TEXT_3

Opt

L

Enter the text that is being modifying in either the leading or following text.

Not allowed if Standard Text # is specified. Required if Standard Text # is not specified

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

SEQ_NUM

Req

I 10

Enter the Sequence Number you wish for the interface request to process the comments.

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values are:

• A (Add) – Adds the record to the database. PENTA provides an error message if the record already exists in the database.

• C (Change) – Update an existing record. If the column is not updateable, PENTA records an error.

• D (Delete) – Delete an existing record. If PENTA cannot delete the column, it records an error.

• U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied column in the existing record.

REQUISITION_NUM

Req

I 10

Enter the Requisition Number you wish to add comments to.

LINE_NUM

Opt

I 9

Enter the Line # that you are adding Requisition comments to.

For Requisition Master level comments, enter null.

D_HIST_DATE

Req

D

Enter the date for which the comment is being recorded.

Must be within one year of today’s date.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

TEXT_3

Req

L

Enter the text of the comment that is being added.