Detailed Table Specifications

This section defines the data element in each table to be loaded or updated by the Import Purchase Order process.

Purchase Order Header (PO_HDR)

Costpoint inserts a corresponding PO_HDR_DFLT row whenever a new PO_HDR row is inserted. For details, please see the PO_HDR_DFLT table following this table.

Column Name Costpoint Column Name Source Defaults Validations/Notes
Purchase Order ID PO_ID Input file. None. Required; must not exist in the purchase order (PO) History table.

PO_HDR must have same company ID as user.

PO Release Number PO_RLSE_NO Input file. None. Required; must be a valid number.

Must be greater than zero if the PO is a Release; must be zero if the PO is not a Release.

If this value is greater than zero, a PO must already exist with that PO ID and a Release number of zero. The PO must be a blanket type, and it must have an open status.

PO Change Order Number PO_CHNG_ORD_NO Input file. Zero. Required; must be a valid number.
PO Type S_PO_TYPE Input file. If Release Number is 0, set to P; otherwise, set to R. If entered, must be P (Purchase Order), B (Blanket Order), S (Subcontract PO), or R (Release Order). If Release number is greater than zero, PO type must be R. If Release Number is zero, PO type must be P, B, or S. The system will display an error message if the input file changes the PO Type of an already existing PO.
Buyer BUYER_ID Input file. None. Required; must exist in the Buyer table.

Buyer must be authorized to enter the PO Type (on the Manage Buyers screen in Costpoint Purchasing).

Buyer must be authorized for the Project and/or Account/Org combination (on the Manage Buyers)

Must have same Company ID as user.

Vendor VEND_ID Input file. None. Required; must exist in the Vendor table.

The Vendor Status for PO cannot be H (Inactive) or W (Give Warning).

PO Vendor cannot have an approval status (VEND. VEND_APPRVL_CD) of N (Not Approved) or P (Pending).

Vendor Address Code ADDR_DC Input file. The Address Code from the Vendor table default in VEND_ADDR row for Vendor ID where S_ORD_ADDR_CD = D Required; the Vendor Address Code and the Vendor must exist in the Vendor Address table with an Order Address Code of Y (Yes) or D (Default).

Must have same Company ID as user.

PO Status S_PO_STATUS_TYPE Input file. Uses the Initial Status on the Configure Purchasing Settings screen in Costpoint Purchasing. Optional.

Must be C (Closed), O (Open), P (Pending), or V (Void).

PO Total — Trans Currency TRN_PO_TOT_AMT Set by the application. Calculated by application as the total of all PO Line Totals (sum of PO_LN. TRN_PO_LN_TOT_AMT) None.
PO Total —Func Currency PO_TOT_AMT Set by the application. Calculated as the total of all PO Line Totals (sum of PO_LN.PO_LN_TOT_AMT)" None.
Sales Tax Total — Trans Currency TRN_SALES_TAX_AMT Set by the application. Calculated as the total sales tax of all PO Lines (sum of PO_LN.TRN_SALES_TAX_AMT). None.
Sales Tax Total — Func Currency SALES_TAX_AMT Set by application. Calculated as the total sales tax of all PO Lines (sum of PO_LN.SALES_TAX_AMT). None.
Blanket Amount — Trans Currency TRN_BLKT_AMT Set by the application Zero. None.
Blanket Amount — Func Currency BLKT_AMT Set by application. Zero. None.
Total Released Amount — Trans Currency TRN_TOT_RLSED_AMT Set by the application If the PO type is a Release, this must be calculated for the Blanket. If the PO is a new Release, Costpoint adds the PO Total Amount (PO_HDR.TRN_PO_TOT_AMT) for the release to the original Total Released Amount (TRN_TOT_RLSED_AMT).

If the PO is a change, Costpoint adds the difference between the new release PO_HDR.TRN_PO_TOT_AMT and the original amount for that release's PO Total Amount to the original Total Released Amount (TRN_TOT_RLSED_AMT).

If the Blanket Amount and Total Released Amount are equal (TRN_TOT_RLSED_AMT = TRN_BLKT_AMT), and the Do Not Allow Rlse Amts to Exceed Total Blanket Amt check box is selected (EXCD_BLKT_TOT_FL = Y) on the Configure Purchasing Settings screen in Costpoint Purchasing, set the header and the status of all open lines to S (System Closed).

None.
Total Released Amount — Func Currency TOT_RLSED_AMT Set by application. If the PO type is a Release, this must be calculated for the Blanket. If the PO is a new Release, Costpoint adds the PO Total Amount (PO_HDR.PO_TOT_AMT) for the release to the original Total Released Amount (TOT_RLSED_AMT) of the blanket.

If the PO is a change, Costpoint adds the difference between the new release PO_HDR.TRN_PO_TOT_AMT and the original amount for that release's PO Total Amount to the original Total Released Amount (TOT_RLSED_AMT) of the blanket.

If the Blanket Amount and Total Released Amount are equal (TOT_RLSED_AMT = BLKT_AMT), and the Do Not Allow Rlse Amts to Exceed Total Blanket Amt check box is selected (EXCD_BLKT_TOT_FL = Y) on the Configure Purchasing Settings screen in Purchasing, set the header and the status of all open lines to S (System Closed).

Contact Last Name CNTACT_LAST_NAME Set by application. The Contact Last Name from the Vendor Address Contact table; otherwise, the default is a space. None.
Contact First Name CNTACT_FIRST_NAME Set by application. The Contact First Name from the Vendor Address Contact table; otherwise, the default is a space. None.
Order Date ORD_DT Set by application. If the record is a change to an existing PO, the Order Date from the existing PO will not be changed.
FOB Point FOB_FLD Input file. The FOB Point from the Vendor table; otherwise, the default is a space. None.
Retain PO RETAIN_PO_FL Set by the application. Y (Yes).
PO Printed PO_PRNTD_FL Set by the application. N (No).
Confirming PO CNFRM_FL Set by the application. Uses the Confirming PO on the Configure Purchasing Settings screen in Costpoint.
Acknowledgment Required ACKN_FL Set by the application. N (No).
Acknowledgment Date ACKN_DT Set by the application. If the data being processed is a change to an existing PO, the system will use the Acknowledgment Date from the existing PO Header; otherwise, the Acknowledgment Date will be NULL. None.
Vendor Sales Order VEND_SO_ID Set by the application. Space. None.
Terms TERMS_DC Input file. The Terms from the Vendor table. Must exist in the Vendor Terms table.
Period Of Performance Starting PERF_START_DT Set by the application. Null.
Period Of Performance Ending PERF_END_DT Set by the application. Null.
Restrict Release Items to Items on Blanket RLSE_FROM_BLKT_FL Set by the application. N (No).
Restrict Release Line Totals to Blanket Line Totals RLSE_LN_TOT_FL Set by the application. N (No).
Do Not Exceed Blanket Gross Unit Cost on Rel Line GROSS_UNIT_CST_FL Set by the application. N (No).
Do Not Allow Rel Amts to Exceed Total Blanket Amount EXCD_BLKT_TOT_FL Set by the application. N (No).
Return Location BRNCH_LOC_ID Input file. The Branch Location ID from the Buyer table. Must exist in the Branch Locations table. Must have same Company ID as user.
Return Address Code BRNCH_ADDR_DC Input file. The Branch Address Code from the Buyer table. Must exist in the Branch Locations table. The Branch Address Code and the Branch Location ID must exist in the Branch Locations table with a Return Address of Y (Yes) or D (Default).
Bill To Location BILL_TO_LOC_ID Input file. The Bill To Location ID from the Buyer table. Must exist in the Branch Locations table. Must have same Company ID as user.
Bill To Address Code BILL_TO_ADDR_DC Input file. The Bill To Address Code from the Buyer table. Must exist in the Branch Locations table. The Bill To Address Code and the Bill To Location ID must exist in the Branch Locations table with a Bill to Address of Y (Yes) or D (Default).
Change Date CHNG_DT Input file. The current system date. Must be a valid date.
Approval Date APPRVL_DT Set by application. For new POs, if PO Header Status is Open (PO_HDR.S_PO_STATUS_TYPE = “O”) set Approval Date = Order Date (PO_HDR.APPRVL_DT = PO_HDR.ORD_DT). If PO Header Status is not Open (PO_HDR.S_PO_STATUS_TYPE != “O”) set Approval Date (PO_HDR.APPRVL_DT) to NULL.

If the data being processed is a change to an existing PO, the Approval Date from the existing PO is used (if not null). If null, follow logic for new POs.

None.
Approval User APPRVL_USER_ID Set by the application. For new POs, if PO Header Status is Open (PO_HDR.S_PO_STATUS_TYPE = “O”) set Approval User = Modified By (PO_HDR. APPRVL_USER_ID= PO_HDR.MODIFIED_BY). If PO Header Status is not Open (PO_HDR.S_PO_STATUS_TYPE != “O”) set Approval Date (PO_HDR.APPRVL_DT) to NULL.

If the data being processed is a change to an existing PO, the Approval User ID from the existing PO is used (if not null). If null, follow logic for new POs.

None.
Procurement Type PROCURE_TYPE_CD Input file. Space. Must exist in the Procurement Type table.
Contact Phone PHONE_ID Set by the application. The Phone Number from the Vendor Address Contact table; otherwise, the default is a space. None.
Contact Fax FAX_ID Set by the application. The Fax Number from the Vendor Address Contact table; otherwise, the default is a space. None.
User MODIFIED_BY Set by the application. PO-UPLOAD (the last upload is processed by the application). None.
Time Stamp TIME_STAMP Set by the application. Current system date and time. None.
Row Version ROWVERSION Set by the application. Zero. None.
Locking Flag LOCK_FL Set by the application. N (No).
Vouchered Amount — Trans Currency TRN_VCHRD_AMT Set by the application Zero for new POs.

If the data being processed is a change to an existing PO, the vouchered amount (TRN_VCHRD_AMT) from the existing PO_HDR row is used

None.
Vouchered Amount — Func Currency VCHRD_AMT Set by the application. Zero for new POs.

If the data being processed is a change to an existing PO, the vouchered amount (VCHRD_AMT) from the existing PO_HDR row is used.

None.
GSA GSA_FL Set by the application N (No).
Last Change Date LAST_CHNG_DTT Set by the application. Current System Date.

If the record in the Input file is a new PO, the Last Change Date will be set to the Change Date from the Input file.

If the record is a change to an existing PO, the Last Change Date will be set to the Change Date from the existing PO.

Last Modification Date LAST_MOD_DTT Set by the application. Current system date. None.
Disadvantaged Flag CL_DISADV_FL Set by the application. The Disadvantaged Flag from the Vendor table. None.
Historical Black College Flag CL_HIST_BL_CLG_FL Set by the application. The Historical Black College Flag from the Vendor table. None.
HUBZone Flag CL_LAB_SRPL_FL Set by the application. The HUBZone Flag from the Vendor table. None.
Woman-Owned Flag CL_WOM_OWN_FL Set by the application. The Vendor ID's Woman-Owned Flag from the Vendor table. None.
CIS Code CIS_CD Input file. If there is no value in the input file, the default will be the PO vendor's CIS code (VEND_CIS_INFO.CIS_CD). If no code is linked to the vendor, the default is null. Must exist in CIS_CODES table.

If the PO's CIS Code is not null, the functional currency for the purchase order must be "British Pounds" (GL_CONFIG.FUNC_S_CRNCY_CD must be "GBP").

Transaction Currency Code TRN_CRNCY_CD Input file (Transaction Currency) VEND.DFLT_TRN_CRNCY_ID (for input file Vendor)

Else, from multicurrency settings (MU_SETTINGS.DFLT_TR_S_CRNCY_CD) for user's company.

Else, Functional Currency Code (GL_CONFIG.FUNC_S_CRNCY_CD) for user's company.

If not in input file, and the data being processes is a change to an existing PO, use existing PO_HDR value.

Must exist in Currencies Used in Costpoint table (CURRENCY).

Transaction to Functional Currency combination must be a member of the PO Hdr Rate Group in the Rate Group Currency table (RT_GRP_CRNCY)

If the PO vendor is limited to certain currencies (VEND.LIMIT_TRN_CRNCY_FL=Y), only currencies existing in VEND_LIMIT_CRNCY table for matching vendor are allowed.

Transaction Currency Date TRN_CRNCY_DT Input file (Rate Date) Current Date None.
Rate Group RATE_GRP_ID Input file (Rate Group) Default Rate Group from Manage Vendors (VEND.DFLT_RT_GRP_ID) associated with the input file Vendor. If not available, load from multicurrency settings (MU_SETTINGS.DFLT_RT_GRP_ID) for user’s company. If not available, this will be Null. If not in input file, and the data being processed is a change to an existing PO, use existing PO_HDR value. Must exist in Rate Group table (RT_GRP).

Transaction to Functional Currency combination must be a member of the PO Hdr Rate Group in the Rate Group Currency table (RT_GRP_CRNCY)

Euro to Functional Rate EUR_TO_FUNC_RT Set by Application When transaction currency is an EU country currency (with Convert to Euro Currency flag checked):

= MU_CRNCY_STATUS. EURO_TO_CRNCY_RT for EU country Func currencies (with Convert to Euro Currency flag checked),using functional currency code (GL_CONFIG.FUNC_S_CRNCY_CD) for user’s company;

= RT_BY_DT.EXCH_RT (or from RT_BY_PD depending upon setting) for EU country Functional currencies (with Convert to Euro Currency flag Unchecked), using functional currency code (GL_CONFIG.FUNC_S_CRNCY_CD) for user’s company;

= RT_BY_DT.EXCH_RT (or from RT_BY_PD depending upon setting) for non EU country functional currencies, using functional currency code (GL_CONFIG.FUNC_S_CRNCY_CD) for user’s company;

When transaction currency is either non-EU currency or is an EU country currency (with Convert to Euro Currency flag Unchecked), value = 1;

If this is unavailable, set to 1. If not in input file, and the data being processed is a change to an existing PO, use existing PO_HDR value.

None.
Transaction to Euro Rate TRN_TO_EUR_RT Set by Application When transaction currency is an EU country currency (with Convert to Euro Currency flag checked), value = Euro-to-Currency Exchange Rate in the Multicurrency Status table for matching transactional currency code;

When transaction currency is either non-EU currency or is an EU country currency (with Convert to Euro Currency flag Unchecked) value = RT_BY_DT.EXCH_RT (or from RT_BY_PD depending upon setting);

If this is unavailable, default is set to 1.

If not in input file, and the data being processed is a change to an existing PO, use existing PO_HDR value.

None.
Transaction Freeze Rate Flag TRN_FREEZE_RT_FL Set by Application Flag indicating whether the exchange rate has been 'frozen' (fixed) for this transaction. Gain or loss calculations will be based on this rate, even if exchange rates have changed.

Set to N (No) if PO_HDR.S_PO_STATUS_TYPE =  P (Pending). Otherwise set to Y (Yes).

If not in input file, and the data being processed is a change to an existing PO, Costpoint uses the existing PO_HDR value.

None.
Transaction to Euro Rate Flag TRN_TO_EUR_RT_FL Set by application. Flag indicating whether this transaction involves an EC member that uses the  Euro.

Set to Y if the transaction currency is a Euro currency (row exists in MU_CRNCY_STATUS table with matching TRN_CRNCY_CD).Else set to N.

If not in input file, and the data being processed is a change to an existing PO, use existing PO_HDR value.

None.
Recovery Rate — Trans Currency RECOVERY_RT Set by application. Set to ‘1’ (100%) None.
Recovery Amount — Trans Currency TRN_RECOVERY_AMT Set by application. PO_LN.TRN_RECOVERY_AMT = [(PO_LN.TRN_SALES_TAX_AMT + PO_LN.TRN_LN_CHG_TAX_AMT) * PO_LN.RECOVERY_RT * SALES_TAX.RECOV_PCT based on the SALES_TAX_CD associated with the PO_LN.SHIP_ID]. None.
Recovery Amount — Func Currency RECOVERY_AMT Set by application. PO_LN.RECOVERY_AMT = [(PO_LN.SALES_TAX_AMT + PO_LN.PO_LN_CHG_TAX_AMT) * PO_LN.RECOVERY_RT * SALES_TAX.RECOV_PCT based on the SALES_TAX_CD associated with the PO_LN.SHIP_ID]. None.

Purchase Order Header Default Row (PO_HDR_DFLT)

Whenever a new PO_HDR row is inserted, Costpoint inserts a corresponding PO_HDR_DFLT row and populates the PO Header Default fields as shown in the following table:

Column Name Costpoint Column Name Source Defaults Validations/Notes
PO ID PO_ID Set by application PO_HDR.PO_ID
PO Release Number PO_RLSE_NO Set by application PO_HDR.PO_RLSE_NO
Project PROJ_ID Set by application Null
Org ORG_ID Set by application Null
Account ACCT_ID Set by application Null
Proj Abbrev PROJ_ABBRV_CD Set by application Space
Org Abbrev ORG_ABBRV_CD Set by application Space
Inv Abbrev INVT_ABBRV_CD Set by application Null.
Reference 1 REF_STRUC_1_ID Set by application Null.
Reference 2 REF_STRUC_2_ID Set by application Null.
Ship ID SHIP_ID Set by application PO_SETTINGS. DFLT_SHIP_ID
Ship Via SHIP_VIA_FLD Set by application If the record in the Input File is a new PO, load the VEND.SHIP_VIA_FLD associated with PO_HDR.VEND_ID. Else space.

If the Vendor of data being processed is a change to an existing PO, change the VEND.SHIP_VIA_FLD associated with the new PO_HDR.VEND_ID. Else space.

Drop Shipment DROP_SHIP_FL Set by application N
Default Taxable Status S_PO_TAXABLE_TYPE Set by application PO_SETTINGS.S_PO_TAXABLE_TYPE
Volume Discount VOL_DISC_PCT_RT Set by application 0 (Zero).
Requisition RQ_ID Set by application Space
Order Reference ORDER_REF_ID Set by application Space
Deliver To DEL_TO_FLD Set by application Space
Desired Date DESIRED_DT Set by application System Date
Due Date DUE_DT Set by application System Date
Auto Voucher AUTO_VCHR_FL Set by application If the record in the Input File is a new PO, load the VEND.AUTO_VCHR_FL associated with PO_HDR.VEND_ID.

If the Vendor of data being processed is a change to an existing PO, change the VEND.AUTO_VCHR_FL associated with the new PO_HDR.VEND_ID

Modified By MODIFIED_BY Set by application User ID.
Time Stamp TIME_STAMP Set by application System Date/Time.
Proj Acct Abbrev PROJ_ACCT_ABBRV_CD Set by application Null.
Row Version ROWVERSION Set by application 0 (Zero).

Purchase Order Header Text (PO_TEXT)

Column Name Costpoint Column Name Source Defaults Validations/Notes
Purchase Order ID PO_ID Input file. None. Required; must exist in the PO Header table.
PO Release Number PO_RLSE_NO Input file. None. Required; must exist in the PO Header table.
Sequence Number SEQ_NO Input file. Load DFLT_SEQ_NO from TEXT_WHERE_USED row with TEXT_WHERE_USED.AUTODFLT_FL = ‘Y’ and TEXT_WHERE_USED.S_WHERE_USED_CD = ‘P’, and corresponding STD_TEXT row (with matching TEXT_CD) has STD_TEXT.COMPANY_ID equal to that of the user’s. Do not override matching Text Codes in the input file. Required.
Text Code TEXT_CD Input file. Load TEXT_CD from TEXT_WHERE_USED row with TEXT_WHERE_USED.AUTODFLT_FL = ‘Y’ and TEXT_WHERE_USED.S_WHERE_USED_CD = ‘P’, and corresponding STD_TEXT row (with matching TEXT_CD) has STD_TEXT.COMPANY_ID equal to that of the user’s. Do not override matching Text Codes in the input file. Required; must exist in the PO Standard Text table. Must exist in the Standard Text - Where Used table with a code of P (Purchase Order).

Must have same Company ID as user.

Row Version ROWVERSION Set by the application. Zero. None.
User MODIFIED_BY Set by the application. PO-UPLOAD (the last upload is processed by the application). None.
Time Stamp TIME_STAMP Set by application. Current system date and time. None.

Purchase Order Header Notes (PO_HDR_NOTES)

Column Name Costpoint Column Name Source Defaults Validations/Notes
Purchase Order ID PO_ID Input file. None. Required; must exist in the PO Header table.
PO Release Number PO_RLSE_NO Input file. None. Required; must exist in the PO Header table.
PO Header Notes PO_HDR_TX Input file. None. Required. If a row exists in the Input File with a code of HN, PO Header Notes is required in the Input File.
Row Version ROWVERSION Set by the application. Zero. None.
User MODIFIED_BY Set by the application. PO-UPLOAD (the last upload is processed by the application). None.
Time Stamp TIME_STAMP Set by the application. Current system date and time. None.

Purchase Order Line (PO_LN)

Column Name Costpoint Column Name Source Defaults Validations/Notes
Purchase Order ID PO_ID Input file. None. Required; must exist in the PO Header table.
PO Release Number PO_RLSE_NO Input file. None. Required; must exist in the PO Header table.
PO Line Key PO_LN_KEY Set by the application. If the data being processed is a change to an existing PO Line, the system will use the PO Line Key from the existing PO Line. Otherwise, the PO Line Key is set to the PO Line Number. None.
PO Line Number PO_LN_NO Input file. None. Required. Must be unique for this PO.
Line Type S_PO_LN_TYPE Set by the application. If the user enters a Misc Type Code, load an M. If an item is provided, load the S_ITEM_TYPE

That is, for new PO lines being created, if the input file has a misc line charge type code, then PO line type will be M. Otherwise, if an item is in the input file, it will take the value corresponding to the ITEM.S_ITEM_TYPE (which can be P (Part), G (Good) or S (Service) as defined in product definition). Users must enter either a misc line charge type code or an item/rev, but not both. If updating an existing PO line, the PO line type from the original line will be used, unless the line charge type code or item/rev itself is being changed.

None
Item Key ITEM_KEY Set by the application. If the Item ID/Rev are entered, lookup on ITEM table. If Misc Line Charge Type is entered, leave null. None.
Description PO_LN_DESC Input file. If the data being processed is a change to an existing PO Line, the system will use the Description from the existing PO Line (except when the item is changed).

If the line is new and no description is provided, load from LN_CHG_DESC if Misc Line Charge Type is entered and ITEM_DESC if Item is entered.

If the line is a new PO Line and Item is entered and the Allow Description Change flag = N in Costpoint Product Definition Settings, ignore the description (if any) in the input file. If the Allow Description Change flag = Y, use description in input file, if provided.

For existing PO line, if Item is changed—Default in the description from Item.

If the PD Settings Allow Description Change flag = N, ignore the description (if any) in the input file.

If the PD Settings Allow Description Change flag = Y, use input file description if provided; else use the item default.

For existing PO line, if Item is not changed—If the Line Type is G (Good) or S (Service), and Allow Description Change in Purchasing—Goods and Services is not selected on Configure Product Definition Settings, always load from ITEM_DESC. If Line Type is P (Part), and Allow Description Change in Purchasing—Part is not selected in Configure Product Definition Settings, always load from ITEM_DESC. If the Configure Product Definition Settings Allow Description Change flag = Y in both cases, load the description from the input file (if provided); else use existing PO line description.

Quantity ORD_QTY Input file. If the data being processed is a change to an existing PO Line, the system will use the Order Quantity from the existing PO Line; otherwise, the default is zero. Required; must be greater than or equal to zero. Must be greater than zero if line type is P (Part) or G (Good).

Must not be less than PO_LN.RECVD_QTY – REJ_REP_QTY, or PO Line's vouchered quantity.

Must be Zero for Subcontract POs (PO_HDR.S_PO_TYPE is "S").

Received Quantity RECVD_QTY Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Received Amount from the existing PO Line; otherwise, the default is zero. None.
Accepted Quantity ACCPTD_QTY Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Accepted Quantity from the existing PO Line; otherwise, the default is zero. None.
Posted Quantity PSTD_QTY Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Posted Quantity from the existing PO Line; otherwise, the default is zero. None.
Order Date ORD_DT Input file. If the data being processed is a change to an existing PO Line, the system will use the Order Date from the existing PO Line; otherwise, the default is the System Date/Change Date.
Due Date DUE_DT Input file If the data being processed is a change to an existing PO Line, the system will use the Due Date from the existing PO Line; otherwise, the default is null. Must be later than, or the same as, the Order Date.

Must be later than, or the same as, the Desired Date.

Required for non-blanket POs.

Desired Date DESIRED_DT Input file If the data being processed is a change to an existing PO Line, the system will use the Desired Date from the existing PO Line; Otherwise, the Original Due Date. Must be earlier than, or the same as, the Due Date.
Volume Discount Rate DISC_PCT_RT Input file. If the data being processed is a change to an existing PO Line, the system will use the Volume Discount from the existing PO Line; otherwise, the default is zero. Must be between 0 and 100 percent.
Receipt Tolerance Percentage RECPT_TOL_PCT_RT Input file. If the data being processed is a change to an existing PO Line, the system will use the Receipt Tolerance Percentage from the existing PO Line. If Item is entered, load from ITEM. RECPT_TOL_PCT_RT. otherwise, the default is zero. Must be zero if Overshipments are not allowed.

Must be between 0 and 100 percent.

Gross Unit Cost — Trans Currency TRN_GR_UN_CST_AMT Input file. For multicurrency, input file to reference transaction currency amounts. If the data being processed is a change to an existing PO Line, the Gross Unit Cost from the existing PO Line is used. Otherwise the default is zero. Must be greater than or equal to zero.
Gross Unit Cost — Func Currency GROSS_UNIT_CST_AMT Set by application. Converted from input file Gross Unit Cost — Trans Currency (TRN_GR_UN_CST_AMT None.
Net Unit Cost — Trans Currency TRN_NET_UN_CST_AMT Set by the application Calculated by the application as (Gross Unit Cost – Volume Discount).

[TRN_GR_UN_CST_AMT – (DISC_PCT_RT * TRN_GR_UN_CST_AMT)]

None.
Net Unit Cost — Func Currency NET_UNIT_CST_AMT Set by the application. Calculated by the application as (Gross Unit Cost - Volume Discount).

[GROSS_UNIT_CST_AMT – (DISC_PCT_RT * GROSS_UNIT_CST_AMT)]

None.
Extended Cost Amount — Trans Currency TRN_PO_LN_EXT_AMT Input File. Set by application if not in Input file as (Quantity * Net Unit Cost) or [ORD_QTY * TRN_NET_UN_CST_AMT]

For subcontract POs, if the data being processed is a change to an existing Sub PO Line, and not in input file, the value from the existing line is used.

For non-subcontract POs, if the data being processed is a change to an existing PO line, and there is no value in input file for PO line Extended Cost Amount, Quantity or Gross Unit Cost, the value from the existing line is used.

None.

Required if Line Type = S (if PO Type = S). Value must be greater or less than zero to allow negative Subcontract PO line amounts. Negative amount is not allowed for Service Items (S_PO_LN_TYPE = S).

Cannot have value if PO line Quantity is greater than 0 and/or Gross Unit Cost is greater than 0 in input file or existing PO line.

Extended Cost Amount — Func Currency PO_LN_EXT_AMT Set by the application. Converted from Extended Cost Amount – Trans Currency (TRN_PO_LN_EXT_AMT) if it exists in the input file.

Otherwise, calculates this value as (Quantity * Net Unit Cost). If the data being processed is a change to an existing Subcontract PO Line and is not in the input file, the value from the existing line will be used.

None.
Total Line Amount — Trans Currency TRN_PO_LN_TOT_AMT Set by application. Calculated by the application as (Extended Line Amount + Sales Tax Amount + Line Charges + Line Charge Taxes).or [TRN_PO_LN_EXT_AMT + TRN_SALES_TAX_AMT + TRN_LN_CHG_AMT + TRN_LN_CHG_TAX_AMT] Must not be less than the PO Line Vouchered Amount or Posted Amount. PO_LN.TRN_VCHRD_AMT or PO_LN.TRN_PSTD_AMT
Total Line Amount — Func Currency PO_LN_TOT_AMT Set by the application. The application calculates this value as (Extended Line Amount  + Sales Tax Amount + Line Charges) or

[PO_LN_EXT_AMT + SALES_TAX_AMT + PO_LN_CHG_AMT + PO_LN_CHG_TAX_AMT]

Total Released Amount —Trans Currency TRN_TOT_RLSED_AMT Set by application. If the data being processed is a change to an existing PO Line, the Total Released Amount from the existing PO Line is used. Otherwise the default is zero.

When a PO release line is added, and a matching blanket line key is found, the TRN_TOT_RLSED_AMT of the blanket (not the release) is incremented by the release TRN_PO_LN_TOT_AMT.

If a PO release line is changed and the release line has a blanket PO line key, Costpoint increments the TRN_TOT_RLSED_AMT of the blanket order (not the release) by the difference of the new release TRN_PO_LN_TOT_AMT – the original blanket order TRN_PO_LN_TOT_AMT.

None.
Total Released Amount — Func Currency TOT_RLSED_AMT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Total Released Amount from the existing PO Line. Otherwise the default value is zero.

If you add a PO release line (if matching blanket line key is found, the system increments the blanket's Total Released Amount by the release's Total Line Amount. If a PO release line is changed and the release line has a blanket PO line key, Costpoint increments the blanket order's Total Released Amount by the difference of the new release's Total Line Amount – the original blanket order's Total Line Amount.

None.
Blanket Balance — Trans Currency TRN_BLKT_BAL_AMT Set by application. If the data being processed is a change to an existing PO Line, the Blanket Balance from the existing PO Line is used; otherwise the default is zero.

When a PO release line is added, and a matching blanket line key is found, the TRN_BLKT_BAL_AMT of the blanket (not the release) must be decremented by the release TRN_PO_LN_TOT_AMT. If a PO release line is changed and the release line has a blanket PO line key, decrement the TRN_BLKT_BAL_AMT of  the blanket (not release) by the difference of the new release TRN_PO_LN_TOT_AMT – the original blanket TRN_PO_LN_TOT_AMT. If the TRN_BLKT_BAL_AMT is less than zero, Costpoint sets it to zero after first performing the validation below. If the TRN_BLKT_BAL_AMT = 0 and the blanket order’s PO_HDR. TRN_RLSE_LN_TOT_FL = Y, set the blanket line status to S. If all blanket lines are Closed, System Closed, or Void, Costpoint changes the Blanket header’s status to closed.

None.
Blanket Balance — Func Currency BLKT_BAL_AMT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Blanket Balance from the existing PO Line.

When a PO release line is added (if matching blanket line key is found), the system will decrease the Blanket Balance by the release's Total Line Amount. If a PO release line is changed and the release line has a blanket PO line key, the Blanket Balance will be decreased by the difference of the new release Total Line Amount - the original blanket Total Line Amount. If less than zero, the Blanket Balance will be set to zero but the validation will be performed first. If the BLKT_BAL_AMT = 0 and the blanket’s PO_HDR. RLSE_LN_TOT_FL = Y, set the blanket line status to S. If all blanket line’s are set to Closed, System Closed or Void, also set the Blanket header’s status to closed.

None.
Received Amount — Trans Currency TRN_RECVD_AMT Set by application. If the data being processed is a change to an existing PO Line, the Received Amount from the existing PO Line is used; otherwise the default is zero. None.
Received Amount — Func Currency RECVD_AMT Set by the application. If the data being processed is a change to an existing PO Line, use the Receive Quantity from the existing PO Line; otherwise, the default value is zero. None.
Accepted Amount — Trans Currency TRN_ACCPTD_AMT Set by the application. If the data being processed is a change to an existing PO Line, the Accepted Amount from the existing PO Line is used. Otherwise the default is zero. None.
Accepted Amount — Func Currency ACCPTD_AMT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Accepted Amount from the existing PO Line; otherwise, the default is zero. None.
Vouchered Amount — Trans Currency TRN_VCHRD_AMT Set by the application. If the data being processed is a change to an existing PO Line, the Vouchered Amount from the existing PO Line is used. Otherwise the default is zero. None.
Vouchered Amount — Func Currency VCHRD_AMT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Vouchered Amount from the existing PO Line; otherwise, the default is zero. None.
Posted Amount — Trans Currency TRN_PSTD_AMT Set by the application. If the data being processed is a change to an existing PO Line, the Posted Amount from the existing PO Line is used. Otherwise the default is zero. None.
Posted Amount PSTD_AMT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Posted Amount from the existing PO Line; otherwise, the default is zero. None.
Sales Tax — Trans Currency TRN_SALES_TAX_AMT Input file. If not in input file – If Taxable flag = Y, calculate PO_LN. TRN_SALES_TAX_AMT = PO_LN.TRN_PO_LN_EXT_AMT * PO_LN.SALES_TAX_RT. Use Sales Tax Rate associated with the PO line Ship ID (SALES_TAX_CD.SALES_TAX_RT for SHIP_ID.SALES_TAX_CD corresponding to PO_LN.SHIP_ID). Do not calculate Sales Tax Amt if PO_SETTINGS.CALC_TAX_FL=N.

If in input file—Use input file value. Calculate the PO line sales tax rate to synchronize with the amount. PO_LN.SALES_TAX_RT = PO_LN. TRN_SALES_TAX_AMT / PO_LN.TRN_PO_LN_EXT_AMT.

If the data being processed is a change to an existing PO Line, the Sales Tax from the existing PO Line is used (if no change is made to columns that affect the sales tax amount calculations, else recalculate.) Otherwise the default is zero.

If a positive value is entered, the PO line must be taxable (PO_LN. TAXABLE_FL is Y), and the Auto Calculate Sales/VAT Tax check box (PO_SETTINGS.CALC_TAX_FL) must be selected on the Configure Purchasing Settings screen.
Sales Tax — Func Currency SALES_TAX_AMT Set by the application. If Taxable flag = Y, calculate PO_LN.SALES_TAX_AMT = PO_LN.PO_LN_EXT_AMT * PO_LN.SALES_TAX_RT.  Use Sales Tax Rate associated with the PO line Ship ID (SALES_TAX_CD.SALES_TAX_RT for SHIP_ID.SALES_TAX_CD corresponding to PO_LN.SHIP_ID).  Do not calculate Sales Tax Amt if PO_SETTINGS.CALC_TAX_FL=N (ref bug 15037).

If in input file:

Use input file value. Calculate the PO line sales tax rate to synchronize with the amount. PO_LN.SALES_TAX_RT = PO_LN. SALES_TAX_AMT / PO_LN.PO_LN_EXT_AMT.

If the data being processed is a change to an existing PO Line, the Sales Tax from the existing PO Line is used (if no change is made to columns that affect the sales tax amount calculations, else recalculate.) Otherwise the default is zero.

Sales Tax Rate SALES_TAX_RT Set by application. If PO line is taxable, default in Sales Tax Rate associated with the PO line Ship ID (SALES_TAX_CD.SALES_TAX_RT for SHIP_ID.SALES_TAX_CD corresponding to PO_LN.SHIP_ID). If PO line Sales Tax Amount is in input file, recalculate the PO line sales tax rate to synchronize with the sales tax amount (PO_LN. SALES_TAX_RT = PO_LN. SALES_TAX_AMT / PO_LN. PO_LN_EXT_AMT)

If PO line is non-taxable, default in Zero.

Ship ID SHIP_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Ship ID from the existing PO Line; otherwise, the default is null.  Required if PO Line Type is P (Part) or G (Goods).

Required if Taxable field is Y (Yes).

Must exist in the Shipping ID table.

Must have same Company ID as user.

Status S_LN_STATUS_TYPE Input file. Required; must be C (Closed), O (Open), P (Pending), or V (Void).

Cannot be changed if the Status is V (Void).

Cannot be changed to P (Pending) or V (Void) if receipts exist.

Cannot be changed to O (Open), P (Pending), or V (Void) if the line has been fully received.

Commit Dollar/Quantity S_PO_COMMIT_TYPE Input file. Standard Orders:

If the data being processed is a change to an existing PO Line, the Commit Dollar/Quantity from the existing PO Line is used.

The Commit Dollar/Quantity from the PO Line Charge Type table.

If the Miscellaneous Type is null and the Line Type is P (Part) or G (Good), this is set to Q (Quantity).

If the Miscellaneous Type is null and the Line Type is S (Service), this is set to D (Dollar).

Blanket Orders:

If the data being processed is a change to an existing PO Line, the Commit Dollar/Quantity from the existing PO Line is used.

If PO_SETTING.INCL_BLKT_CMMIT_FL=Y, defaults for the original blanket order (Rel=0) as well as for release orders (Rel >0) will be as follows:

The Commit Dollar/Quantity from the PO Line Charge Type table.

If the Miscellaneous Type is null and the Line Type is P (Part) or G (Good), this is set to Q (Quantity).

If the Miscellaneous Type is null and the Line Type is S (Service), this is set to D (Dollar).

If PO_SETTING.INCL_BLKT_CMMIT_FL=N,

Defaults for the original blanket order (Rel=0) will be E (Excluded).

Defaults for the release orders (Rel >0) will be as follows:

The Commit Dollar/Quantity from the PO Line Charge Type table.

If the Miscellaneous Type is null and the Line Type is P(art) or G (Good), this is set to Q (Quantity).

If the Miscellaneous Type is null and the Line Type is S (Service), this is set to D (Dollar).

D(ollar).Subcontract POs:

If PO Type = S, default D.

Must be D (Dollar), Q (Quantity) or E (Excluded).
Tax TAXABLE_FL Input file. If the data being processed is a change to an existing PO Line, the system will use the Tax flag from the existing PO Line.

If data being processed is new and you enter a Misc Line Charge Type, the system will load from LN_CHG_TYPE.

If you enter an Item, the system will use PO Settings to determine if value should be Y, N or should come from ITEM_SETTINGS.

Otherwise, the default is N (No).

Must be Y (Yes) or N (No).
Deliver To DEL_TO_FLD Input file. If the data being processed is a change to an existing PO Line, the system will use the Deliver To from the existing PO Line; otherwise, the default is a space. None.
Ship Via SHIP_VIA_FLD Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Ship Via from the existing PO Line. Otherwise, the default is the Ship Via from the Vendor table, or a space. None.
Unit of Measure PO_LN_UM_CD Input file. If the data being processed is a change to an existing PO Line, the system will use the Unit of Measure from the existing PO Line.

If you are entering a new line and enter an Item, the system will load the Item's U/M.

Must exist in Unit of Measure table.

Required if the quantity is greater than zero.

Miscellaneous Type MISC_LN_CHG_TYPE Input file. If the data being processed is a change to an existing PO Line, the system will use the Miscellaneous Type from the existing PO Line; otherwise, the default is null. Required if the Line type is M (Miscellaneous).

If the Line Type is not M (Miscellaneous), you cannot enter a Miscellaneous Type.

Must exist in the PO Line Charge Type table.

Must have same Company ID as user.

Requisition Number RQ_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Requisition Number from the existing PO Line; otherwise, the default is a space. Required if the Require Req No to be Non-Blank on PO Line option is selected in the Requisition Requirements group box on the Configure Purchasing Settings screen (in Costpoint Purchasing).

Must exist in the Requisition table if the Require Valid Req No on PO Line option is selected in the Requisition Requirements group box on the Configure Purchasing Settings screen (in Costpoint Purchasing).

Must have same Company ID as user.

Manufacturer MANUF_ID Set by the application. If the data being processed is a change to an existing PO Line, the system uses the Manufacturer from the existing PO Line.

If you enter a part in the Item row, the system will load this value from the Alternate Parts table for that part key where the Prefer Flag field is Y (Yes) on the Manage Alternate Parts screen.

Otherwise, the default is null.

Must exist in Manufacturer table.

If the Separate Items by Company check box is not selected in the Corporate Settings block of the Configure Product Definition Settings screen and the system loads this value from the Alternate Parts (ALT_PART) table, the system will process only rows that have a company ID that is null or matches the user's company ID.

Manufacturer Part MANUF_PART_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Manufacturer's Part from the existing PO Line.

If you entered a part in the Item row, the system will load this value from the Alternate Parts table for that part key where the Prefer Flag field is Y (Yes) on the Manage Alternate Parts screen.

Otherwise, the default is a space.

None.

If the Separate Items by Company check box is not selected and the application loads this value from the Alternate Parts (ALT_PART) table, the system will process only rows that have a company ID that is null or matches the user's company ID.

Manufacturer Revision MANUF_PART_RVSN_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Manufacturer Revision from the existing PO Line.

If you enter a part in the Item row, the system will load this value from the Alternate Parts table for that part key where the Prefer Flag field is Y (Yes) on the Manage Alternate Parts screen.

Otherwise, the default is a space.

None.

If the Separate Items by Company check box is clear in the Corporate Settings block of the Configure Product Definition Settings screen and the application loads this value from the Alternate Part (ALT_PART) table, the system will process only rows that have a company ID that is null or matches the user's company ID.

Vendor Part VEND_PART_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Vendor Part from the existing PO Line.

If you enter a part in the Item row, the system will load this value from the Alternate Parts table for that part key where the Prefer Flag field is Y (Yes) on the Manage Alternate Parts screen.

Otherwise, the default is a space.

None.

If the Separate Items by Company check box is clear in the Corporate Settings block of the Configure Product Definition Settings screen and the application loads this value from the Alternate Part (ALT_PART) table, the system will process only rows that have a company ID that is null or matches the user's company ID.

Vendor Revision VEND_PART_RVSN_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Vendor Revision from the existing PO Line.

If you enter a part in the Item row, the system will load this value from the Alternate Parts table for that part key where the Prefer Flag field is Y (Yes) on the Manage Alternate Parts screen.

Otherwise, the default is a space.

None.

If the Separate Items by Compan > y check box is clear in the Corporate Settings block of the Configure Product Definition Settings screen and the application loads this value from the Alternate Part (ALT_PART) table, the system will process only rows that have a company ID that is null or matches the user's company ID.

Certificate Of Conformance Required CERT_OF_CNFRM_FL Input file. If the data being processed is a change to an existing PO Line, the system will use the Certificate of Conformance Required from the existing PO Line.

If you enter a Part, the system will load the Certificate of Conformance Required from the Part Project (PART_PROJ) and PART tables (if PART_PROJ row does not exist).

If the Miscellaneous Type is not null, the system will set this to N (No).

Must be Y (Yes) or N (No).
QC Inspection Required QC_REQD_FL Input file. If the data being processed is a change to an existing PO Line, the system will use the QC Inspection Required from the existing PO Line.

If you enter a Part, the system will load the QC Inspection Required from the Part Project (PART_PROJ) and PART tables (if PART_PROJ row does not exist).

If you enter a Misc Line Charge, the system will load the QC Inspection Required from the PO Line Charge Type table.

Otherwise, the default is N.

Must be Y (Yes) or N (No).
Source Inspection Required SRCE_INSP_FL Input file. If the data being processed is a change to an existing PO Line, the system will use the Source Inspection Required from the existing PO Line.

If you enter a Part, the system will load the Source Inspection Required from the Part Project (PART_PROJ) and PART tables (if PART_PROJ row does not exist). Otherwise, the default is "N."

Must be Y (Yes) or N (No).
Over Ship OVRSHP_ALLOW_FL Input file. If the data being processed is a change to an existing PO Line, the system will use the Over Ship from the existing PO Line.

If you entered a Misc Line Charge, the system will load the Over Ship flag from the Line Charge Type table. Otherwise, the system loads from ITEM.

If PO Type is S, set to N.

Must be Y (Yes) or N (No).
Blanket PO Release Number BLKT_PO_RLSE_NO Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Blanket PO Release Number from the existing PO Line.

If the line is for a new release, the system will load zero.

Otherwise, the default is null.

None.
Blanket PO Line Key BLKT_PO_LN_KEY Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Blanket PO Line Key from the existing PO Line. If the line is for a new release, the system will use the input file line record's line number to look up the line key on the corresponding blanket. For example, if the release line number is 2, the system will locate the blanket's line number 2 to determine the line key.

Otherwise, the default is null.

None.
Item ITEM_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Item from the existing PO Line.

Otherwise, the default is null.

Must exist in the Item table.

If the Separate Items by Company check box is selected, the item must have the same company ID as user.

If PO Type is S, the Item Type must be S.

If this value is changed, an error will occur if the PO line has already been received or vouchered.

Validation routines give errors if the PO vendor has not been approved or assigned for the PO line part, depending upon the set up for this part/vendor restriction (ITEM_SETTINGS.VEND_BY_PART_FL, PART. S_VEND_RESTRICT_CD).

See Error Messages.

Item Revision ITEM_RVSN_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Item Revision from the existing PO Line.

Otherwise, the default is a space.

If the Allow Multiple Revisions for Each Item check box is selected in the Corporate Settings block of the Configure Product Definition Settings screen, the Item ID/Item Revision must exist in Item table in Costpoint Product Definition.

If the Separate Items by Company check box is selected in the Corporate Settings block of the Configure Product Definition Settings  screen, the item must have the same company ID as the user.

If the PO Type is S, the Item Type must be S.

If this value is changed, an error will occur if the PO line has already been received or vouchered.

Validation routines give errors if the PO vendor has not been approved or assigned for the PO line part, depending upon the set up for this part/vendor restriction (ITEM_SETTINGS.VEND_BY_PART_FL, PART. S_VEND_RESTRICT_CD).

See Error Messages.

Drop Ship DROP_SHIP_FL Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Drop Ship from the existing PO Line.

Otherwise, the default is N (No).

Order Reference ORDER_REF_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Order Reference from the existing PO Line. None.
Original Due Date ORIG_DUE_DT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Original Due Date from the existing PO Line.

Otherwise, the default is the Due Date.

User Revision USER_RVSN_FLD Input file. If the data being processed is a change to an existing PO Line, the system will use the User Revision from the existing PO Line.

Otherwise, the default is the Item Revision. If null, the default is a space.

None.
Inventory Abbreviation INVT_ABBRV_CD Input File. If the data being processed is a change to an existing PO Line, the system will use the Inventory Abbreviation from the existing PO Line.

Otherwise, the default is null.

Must exist and be active if this field is populated.

Inventory Account Type (S_INVT_ACCT_TYPE) must be A or E.

Item must exist and the Item type must be P (Part). The PART.INVT_FL must be Y.

Must have same company ID as User's.

Voucher Received VCHR_RCV_FL Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Voucher Received from the existing PO Line.

Otherwise, the default is N (No).

Match Option S_MATCH_OPT_CD Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Match Option from the existing PO Line.

Selected from the Configure Purchase Order Voucher Settings based on the Line Type.

If PO Type is S, the default is TOTAL.

Total Line Charge Amount — Trans Currency TRN_LN_CHG_AMT Set by the application. Calculated by the application as the total of all Amounts including tax,  from the Line Charges table. If PO Type is S, default to zero. None.
Total Line Charge Amount — Func Currency PO_LN_CHG_AMT Set by the application. The application calculates this as the total of all Amounts including tax from the Line Charges table.

If PO Type is S, the default is zero.

None.
Total Line Charge Tax Amount — Trans Currency TRN_LN_CHG_TAX_AMT Set by application. Calculated by the application as the total of all Sales Tax from the Line Charges table.

If PO line Charge is taxable (LN_CHG_TYPE.TAXABLE_FL = Y), the system will multiply Line Charge Amount to Sales Tax Rate (PO_LN.TRN_LN_CHG_TAX_AMT = PO_LN.TRN_LN_CHG_AMT * PO_LN.SALES_TAX_RT). The system will use the Sales Tax Rate associated with the PO line Ship ID (SALES_TAX_CD.SALES_TAX_RT for SHIP_ID.SALES_TAX_CD corresponding to PO_LN.SHIP_ID). The Sales Tax Amountt will not be calculated if PO_SETTINGS.CALC_TAX_FL is N.

If the data being processed is a change to an existing PO Line, Sum of all line charge tax rows for the PO line (SUM of PO_LN_CHG. TRN_SALES_TAX_AMT rows for matching PO_ID/PO_LN_KEY). If PO Type is S, default to zero.

None.
Total Line Charge Tax Amount — Func Currency PO_LN_CHG_TAX_AMT Set by the application. The application calculates this as the total of all Sales Tax from the Line Charges table.

If PO line Charge is taxable (LN_CHG_TYPE.TAXABLE_FL = Y), the system will multiply the Line Charge Amount to the Sales Tax Rate (PO_LN.PO_LN_CHG_TAX_AMT = PO_LN.PO_LN_CHG_AMT * PO_LN.SALES_TAX_RT). The system will use the Sales Tax Rate associated with the PO line Ship ID (SALES_TAX_CD.SALES_TAX_RT for SHIP_ID.SALES_TAX_CD corresponding to PO_LN.SHIP_ID). The Sales Tax Amount will not be calculated if PO_SETTINGS.CALC_TAX_FL is N

If PO Type is S, default to zero.

None.
Reject and Replace Quantity REJ_REP_QTY Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Reject and Replace Quantity from the existing PO Line.

Otherwise, the default is zero.

None.
Reject and Pay Quantity REJ_PAY_QTY Set by the application. If the data being processed is a change to an existing PO Line, the system uses the Reject and Pay Quantity from the existing PO Line.

Otherwise, the default is zero.

None.
Reject and Credit Quantity REJ_CR_QTY Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Reject and Credit Quantity from the existing PO Line.

Otherwise, the default is zero.

None.
Reject and Replace — Trans Currency TRN_REJ_REP_AMT Set by application. If the data being processed is a change to an existing PO Line, the Reject and Replace Transaction Currency Amount (TRN_REJ_REP_AMT) from the existing PO Line is used. Otherwise the default is zero. None.
Reject and Replace Amount — Func Currency REJ_REP_AMT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Reject and Replace Amount from the existing PO Line.

Otherwise, the default is zero.

None.
Reject and Pay — Trans Currency TRN_REJ_PAY_AMT Set by the application. If the data being processed is a change to an existing PO Line, the Reject and Pay Transaction Currency Amount (TRN_REJ_PAY_AMT) from the existing PO Line is used. Otherwise the default is zero None.
Reject and Pay Amount — Func Currency REJ_PAY_AMT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Reject and Pay Amount from the existing PO Line.

Otherwise, the default is zero.

None.
Reject and Credit — Trans Currency TRN_REJ_CR_AMT Set by the application. If the data being processed is a change to an existing PO Line, the Reject and Credit Transaction Currency Amount (TRN_REJ_CR_AMT) from the existing PO Line is used. Otherwise the default is zero. None.
Reject and Credit Amount — Func Currency REJ_CR_AMT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Reject and Credit Amount (REJ_CR_AMT) from the existing PO Line.

Otherwise, the default is zero.

None.
Approval Date APPRVL_DT Set by the application. For new PO line, if status is O, set to order date. Otherwise, if status is not O, this will be set to null.

If the data being processed is a change to an existing PO line, the Approval Date from the existing PO line is used (if not null). If null, follow logic for new PO line.

None.
Approval User APPRVL_USER_ID Set by the application. For new PO line, if status is O, set this PO UPLOAD (similar to value for PO_LN.MODIFIED_BY). Otherwise, if status is not O, this will be set to null.

If the data being processed is a change to an existing PO Line, the Approval User from the existing PO Line is used (if not null). If null, follow logic for new POs.

None.
Order Reference Line Key ORDER_REF_LN_KEY Set by the application. If you enter an order reference number and an order reference line number, and S is loaded in the Order Reference Type field, the application will look up the line key from the SO_LN using the Order Ref ID as the SO_ID, the Order Ref Line number as the SO_LN_NO, and 0 as the SO_RLSE_NO. If no match is found, the default is zero. None.
Order Reference Type S_ORD_REF_TYPE_CD Input file. Space. Must be equal to S or M.
Warehouse WHSE_ID Input file. If the data being processed is a change to an existing PO Line, the system uses the Warehouse from the existing PO Line.

If an inventory abbreviation is loaded, the system will get the value from the inventory abbreviation's warehouse ID.

Otherwise, the default is null.

Must have same company ID as User's.

If the PO line has an inventory abbreviation and the Plan Warehouse Separately check box is selected in the Corporate Settings block of the Configure Materials Requirements Planning Settings screen (MRP_SETTINGS_CORP. WHSE_PLN_FL is Y), and the input file does not have a warehouse and no default can be loaded, an error will occur., and the system will display the message: "Warehouse is required for inventory PO lines."

PO Line Close Date PO_LN_CLOSE_DT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Closing Date from the existing PO Line.

Otherwise, the default is null.

None.
Total Released Quantity TOT_RLSED_QTY Set by the application. When a PO release line is added (if a matching blanket line key is found), the system increments the blanket's Total Released Quantity by the release's Order Quantity. If a PO release line is changed and the release line has a blanket PO line key, the system will increment the blanket's Total Released Quantity by the difference of the new release (Order Quantity - the original blanket's Total Released Quantity).

Otherwise, the default is zero.

None.
Match Type S_MATCH_CD Input file. If PO Type is S, set by application. If the data being processed is a change to an existing PO Line, the system will use the Match Type from the existing PO Line.

If the Line Type is P (Part), the system sets this to 3.

If the Line Type is S (Service), G (Goods), or M (Misc), the system will obtain the corresponding Match Type from the Voucher Settings table. If PO Type is S, the default is 3.

Must be 2 or 3.
Commodity Code COMM_CD Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Commodity Code from the existing PO Line.

If you enter the Item, the system will load from the Item table.

Otherwise, the default is a space.

Minimum Quantity MIN_QTY Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Minimum Quantity from the existing PO Line.

Otherwise, the default is zero.

Leadtime ARO LT_DAYS_NO Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Leadtime ARO from the existing PO Line.

Otherwise, the default is zero.

Purchase Agreement S_PURCH_AGRMT_CD Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Purchase Agreement from the existing PO Line. Otherwise the default is N (No).
Issue ISSUE_FL Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Issue flag from the existing PO Line.

Otherwise, the default is N (No).

Procurement Type PROCURE_TYPE_CD Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Procurement Type from the existing PO Line.

Otherwise, the default is a space.

Auto Voucher AUTO_VCHR_FL Input file. If PO Type is S, set by the application. If the data being processed is a change to an existing PO Line, the system will use the Auto-Voucher flag from the existing PO Line.

If the None option is selected in the Auto-Voucher Creation group box in the Configure Purchase Order Voucher Settings screen (in Costpoint Accounts Payable), the system will set this to N (No).

Set to the Auto-Voucher flag from the Vendor table.

You cannot change the Auto-Voucher flag to Y (Yes) if the Auto-Voucher flag in the PO Vendor Settings table is N (No) or the Auto-Voucher flag in the Vendor table is N (No).

The Auto-Voucher flag cannot be Y (Yes) if the None option is selected in the Auto-Voucher Creation group box in the Configure Purchase Order Voucher Settings screen (in Costpoint Accounts Payable).

Must be Y (Yes) or N (No).

Subline Number SUBLINE_NO Set by application. If the data being processed is a change to an existing PO Line, the system will use the Subline Number from the existing PO Line.

Otherwise, the default is zero.

None
Requisition Line Key RQ_LN_KEY Input File If the data being processed is a change to an existing PO Line, the system will use the Requisition Line Key from the existing PO Line.

Otherwise, the default is null.

Combination of RQ_ID/RQ_LN_KEY must exist in RQ_LN.

If input file RQ_ID is blank, validation will not occur and this will not be inserted into the PO_LN.

Award Quote AWARD_QT_ID Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Award Quote from the existing PO Line.

Otherwise, the default is space.

None.
User MODIFIED_BY Set by the application. PO-UPLOAD (the last upload is processed by the application). None.
Time Stamp TIME_STAMP Set by the application. Current system date and time. None.
Row Version ROWVERSION Set by the application. Zero. None.
Sales Tax Rate SALES_TAX_RT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Sales Tax Rate from the existing PO Line.

If the Taxable Flag is Y (Yes), the system will load this value from the Ship ID.

Otherwise, the default is zero.

None.
Military Spec MIL_SPEC_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Military Spec from the existing PO Line.

If this in not in the input file, the system will load this value from the Part table in Costpoint Product Definition if the Line Type is P (Part) and the change is an insert rather than an update.

Otherwise, the default is null.

None.
National Stock Number NSN_ID Set by the application. If the data being processed is a change to an existing PO Line, the system will use the National Stock Number from the existing PO Line.

The system will load this value from the Part table in Costpoint Product Definition if the Line Type is P (Part).

Otherwise, the default is null.

None.
Order Reference Release Number ORDER_REF_RLSE_NO Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Order Reference Release Number from the existing PO Line.

Otherwise, the default is zero.

None.
Contract Line Item Number CLIN_ID Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Contract Line Item Number from the existing PO Line.

Otherwise, the default is null.

None.
Start Date PERF_START_DT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Starting Date from the existing PO Line.

Otherwise, the default is null.

End Date PERF_END_DT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the End Date from the existing PO Line.

Otherwise, the default is null.

Billing Cycle BILL_CYCLE_CD Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Billing Cycle from the existing PO Line.

Otherwise, the default is null.

None.
Billing Cycle Paid Amount — Trans Currency TRN_BILL_CYCLE_AMT Set by the application. If the data being processed is a change to an existing PO Line, the Billing Cycle Paid Amount (TRN_BILL_CYCLE_AMT) from the existing PO Line is used. Otherwise the default is zero None.
Billing Cycle Paid Amount  — Func Currency BILL_CYCLE_PAY_AMT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Billing Cycle Paid Amount (BILL_CYCLE_AMT) from the existing PO Line.

Otherwise, the default is zero.

None.
Order Reference Line Number ORDER_REF_LN_NO Input file. If the data being processed is a change to an existing PO Line, the system will use the Order Reference Line Number from the existing PO Line.

Otherwise, the default is zero.

None.
Last Vouchered Date LAST_VCHRD_DT Set by the application. If the data being processed is a change to an existing PO Line, the system will use the Last Vouchered Date from the existing PO Line.

Otherwise, the default is null.

Valid date.
Industry Class IND_CLASS_CD Input file. From either:

(1) input file

(2) item's industry class (ITEM.IND_CLASS_CD)

(3) Line Charge Type's industry class (LN_CHG_TYP.IND_CLASS_CD) or

(4) Commodity Code's industry class (COMM.IND_CLASS_CD)

Otherwise, the default is null.

Must exist in Industry Class table.
Vendor Size S_CL_SM_BUS_CD Set by application. On a new line or when the PO_HDR.VEND or the PO_LN. IND_CLASS_CD has changed, the system must determine the PO line business size. If the IND_CLASS_CD is not null, the system will look up the VEND_IND_CLASS for that PO_LN. The system will use PO_HDR. VEND_ID and PO_LN. IND_CLASS_CD. If a row is found, the system will load the VEND_IND_CLASS .S_CL_SM_BUS_CD to the PO_LN. S_CL_SM_BUS_CD. If a row is not found or IND_CLASS_CD is null, the system will load the value from the VEND table. None
CIS Withholding Flag CIS_WH_FL Input file. If not in the input file, the default will be Y (Yes) if vendor's CIS Code has a withholding rate greater than zero (on the Manage Construction Industry Scheme Codes screen). Otherwise, the default is N (No). Must be Y (Yes) or N (No).

If Y, the purchase order's CIS Code cannot be null, and the associated withholding rate must be greater than zero.

Completed Work Retention Pct COMPLT_RET_PCT Input file. If the data being processed is a change to an existing PO Line, the system will use the Completed Work Retention Pct from the existing PO Line.

If this value is not in the input file, the default is 0 for new PO lines.

Must be a number between 0.0000 and 1.0000.

Cannot be greater than zero if PO Type (PO_HDR.S_PO_TYPE) is not S.

Must be Zero if PO Type is S, and PO Line Extended Amt is less than zero.

Stored Materials Retention Pct STORED_RET_PCT Input file. If the data being processed is a change to an existing PO Line, the system will use the Stored Materials Retention Pct from the existing PO Line.

If the value is not in the input file, the default is 0 for new PO lines.

Must be a number between 0.0000 and 1.0000.

Cannot be greater than zero if PO Type (PO_HDR.S_PO_TYPE) is not S.

Must be Zero if PO Type is S, and PO Line Extended Amt is less than zero.

Completed Work Amt — Trans Currency TRN_COMPLT_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Completed Work Amt (Transactional Currency) from the existing PO Line.

Otherwise, the default is zero.

None.
Completed Work Amt — Func Currency COMPLT_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Completed Work Amt (Functional Currency) from the existing PO Line.

Otherwise, the default is zero.

None.
Completed Work Retention Amt —Trans Currency TRN_COMPLT_RET_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Completed Work Retention Amt (Trans Currency) from the existing PO Line.

Otherwise, the default is zero.

None.
Completed Work Retention Amt — Func Currency COMPLT_RET_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Completed Work Retention Amt (Functional Currency) from the existing PO Line.

Otherwise, the default is zero.

None.
Stored Materials Amt — Trans Currency TRN_STORED_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Stored Materials Amt (Transactional Currency) from the existing PO Line.

Otherwise, the default is zero.

None.
Stored Materials Amt — Func Currency STORED_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Stored Materials Amt (Functional Currency) from the existing PO Line.

Otherwise, the default is zero.

None.
Stored Materials Retention Amt — Trans Currency TRN_STORED_RET_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Stored Materials Retention Amt (Transactional Currency) from the existing PO Line.

Otherwise, the default is zero.

None.
Stored Materials Retention Amt — Func Currency STORED_RET_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Stored Materials Retention Amt  (Functional Currency) from the existing PO Line is used.

Otherwise, the default is zero.

None.
Completed Work Requested Amt — Trans Currency TRN_RQSTD_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Completed Work Requested Amt (Transactional Currency) from the existing PO Line.

Otherwise, the default is zero.

None.
Completed Work Requested Amt — Func Currency RQSTD_AMT Set by application. If the data being processed is a change to an existing PO Line, the system will use the Completed Work Requested Amt (Functional Currency) from the existing PO Line.

Otherwise, the default is zero.

None.

Purchase Order Line Account (PO_LN_ACCT)

Cross Validations for Projects/Accounts/Organizations:

  • Data for the Account Line must exist in the Input File.
  • If the data being processed is a change to an existing PO Line, there can be only one Account Line in the PO Line Account table for the PO Line being processed.
  • If the Buyer PAO Code drop-down list on the Configure Purchasing Settings screen is not Implicit, the Buyer and Project must exist in the Buyer Project table.
  • If the Buyer PAO Code drop-down list on the Configure Purchasing Settings screen is not Implicit, the Buyer and Account and Organization must exist in the Buyer Organization Account table.
  • If the Buyer PAO Code drop-down list on the Configure Purchasing Settings screen is Implicit and the Buyer is assigned to top level of the Project, the Lower Level flag must be Y (Yes).
  • If a Buyer is associated with the Account and Organization, the Buyer, Account, and Organization must exist in the Buyer Organization Account table.
  • If you entered a valid Inventory Abbreviation code, you do not need to enter a project, account, or organization. The PO Line Account (PO_LN_ACCT) is always loaded by the Inventory Abbreviation's Project ID (INVT_ABBRV_CD. PROJ_ID), Material Account (MATL_ACCT_ID), and Material Org (MATL_ORG_ID).
Column Name Costpoint Column Name Source Defaults Validations/Notes
Purchase Order ID PO_ID Input file. None. Required Must exist in the PO Header table.
PO Release Number PO_RLSE_NO Input file. None. Required; must exist in the PO Header table.
PO Line Key PO_LN_KEY Set by the application. None. None.
Sub Key SUB_KEY Set by the application. None. None.
Project PROJ_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Project from the existing PO Line. If you entered a valid Inventory Abbreviation code, you do not need to enter a project, account, or organization. The PO Line Account (PO_LN_ACCT) is always loaded by the Inventory Abbreviation's Project ID (INVT_ABBRV_CD. PROJ_ID), Material Account (MATL_ACCT_ID), and Material Org (MATL_ORG_ID). If the PO Line has an Inventory Abbreviation, the Project must match the Project for the Inventory Abbreviation in the Inventory Abbreviation table.

Must pass standard Project/Organization Account (POA) validation.

Must exist in the Project table. Must have same company ID as the user.

Organization ORG_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Organization from the existing PO Line.

To get the Organization, the system looks up the Project in the Project Master table.

If you enter a valid Inventory Abbreviation code, you do not need to enter project, account or organization. The PO Line Account (PO_LN_ACCT) is always loaded by the Inventory Abbreviation's Project ID (INVT_ABBRV_CD. PROJ_ID), Material Account (MATL_ACCT_ID), and Material Org (MATL_ORG_ID).

If the PO Line has an Inventory Abbreviation, the Organization must match the Material Organization for the Inventory Abbreviation in the Inventory Abbreviation table.

Must pass standard POA validation. 

Must exist in the Org table.

Required.

Must have same company ID as the user.

Account ACCT_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Account from the existing PO Line.

To get the Account, the system looks up the Project/Account Abbreviation and the Account Group of the Project in the Account Entry Groups table.

If you enter a valid Inventory Abbreviation code, you do not need to enter a project, account, or organization. The PO Line Account (PO_LN_ACCT) is always loaded by the Inventory Abbreviation's Project ID (INVT_ABBRV_CD. PROJ_ID), Material Account (MATL_ACCT_ID), and Material Org (MATL_ORG_ID).

Must be a detail account.

The Account Entry Group on the Manage Accounts screen must be ALL or PO.

If the PO Line has an Inventory Abbreviation, the Account must match the Material Account for the Inventory Abbreviation in the Inventory Abbreviations table.

Must pass standard POA validation.

Must exist in the Account table.

Required.

Reference Number 1 REF_STRUC_1_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Reference Number 1 from the existing PO Line. Must exist in the Reference Structure table and the Reference Heading must be assigned to Reference 1. Must have same company ID as the user's.
Reference Number 2 REF_STRUC_2_ID Input file. If the data being processed is a change to an existing PO Line, the system will use the Reference Number 2 from the existing PO Line. Must exist in the Reference Structure table and the Reference Heading must be assigned to Reference 2. Must have same company ID as the user's.
Amount — Trans Currency TRN_CST_AMT Input file. From PO Line total amount.
Amount — Func Currency CST_AMT Set by the application. From PO Line total amount.
Allocation Percentage CST_AMT_PCT_RT Set by the application. 100%
Project Abbreviation PROJ_ABBRV_CD Input file. If the data being processed is a change to an existing PO Line, the system will use the Project Abbreviation from the existing PO Line.

To get the Project Abbreviation, the system looks up the Project in the Project Master table.

The Project Abbreviation must exist in the Project Master table.

The Project must be active. Must have same company ID as the user's.

Organization Abbreviation ORG_ABBRV_CD Input file. If the data being processed is a change to an existing PO Line, the system will use the Organization Abbreviation from the existing PO Line.

To get the Organization Abbreviation, the system looks up the Organization in the Org Elements table.

The Organization Abbreviation must exist in the Org Elements table.

The Organization must be active.

Must have same company ID as the user.

User MODIFIED_BY Set by the application. PO-UPLOAD (the last upload is processed by the application). None.
Time Stamp TIME_STAMP Set by the application. Current system date and time. None.
Row Version ROWVERSION Set by the application. Zero. None.
Project/Account Abbreviation PROJ_ACCT_ABBRV_CD Input file. If the data being processed is a change to an existing PO Line, the system will use the Project/Account Abbreviation from the existing PO Line. The Project/Account Abbreviation and the Account Group of the Project must exist in the Account Entry Group table.

Purchase Order Line Charge (PO_LN_CHG)

Column Name Costpoint Column Name Source Defaults Validations/Notes
Purchase Order ID PO_ID Input file. None. Required; must exist in the PO Header table. PO Type must not be S.
PO Release Number PO_RLSE_NO Input file. None. Required; must exist in the PO Header table.
PO Line Key PO_LN_KEY Set by the application. None. None.
Charge Type LN_CHG_TYPE Input file. None.

If the data being processed is a change to an existing PO Line, and input file has Null value for line charge type, the system will not modify the existing value.

Must exist in the PO Line Charge Types table.

Must have same company ID as user.

Sub Key SUB_KEY Set by the application. None. None.
Amount — Trans Currency TRN_CHG_CST_AMT Input file. None

If the data being processed is a change to an existing PO Line, and input file has Null value for line charge cost, the system will not modify the existing value.

Requires a numeric value.
Amount — Func Currency CHG_CST_AMT Set by application Converted from TRN_CHG_CST_AMT None.
Sales Tax Amount — Trans Currency TRN_SALES_TAX_AMT Set by the application. If the PO Line is taxable, the system will multiply the Transactional Currency Amount to the Sales Tax Rate to get the Sales Tax Amount—Transactional Currency (PO_LN_CHG.TRN_SALES_TAX_AMT = PO_LN_CHG.TRN_CHG_ CST_AMT * PO_LN. SALES_TAX_RT).

The system will use the Sales Tax Rates associated with the PO Line Ship ID (SALES_TAX_CD.SALES_TAX_RT for SHIP_ID.SALES_TAX_CD corresponding to PO_LN.SHIP_ID).

The Sales Tax Amount will not be calculated if it is configured that way in PO Settings (PO_SETTINGS.CALC_TAX_FL = N).

Otherwise, the default is zero.

None. Please see validations for Sales Tax Amount for PO Lines.
Sales Tax Amount — Func Currency SALES_TAX_AMT Set by the application. If the PO Line is taxable, the system will get its Sales Tax Amount by multiplying the Transactional Currency Amount to the Sales Tax Rate (PO_LN_CHG.SALES_TAX_AMT = PO_LN_CHG.CHG_CST_AMT * PO_LN. SALES_TAX_RT). The Sales Tax Rate Associated with the PO Line Ship ID will be used (SALES_TAX_CD. SALES_TAX_RT for SHIP_ID.SALES_TAX_CD corresponding to PO_LN.SHIP_ID).

The Sales Tax Amount will not be calculated if it is configured that way in PO Settings (PO_SETTINGS.CALC_TAX_FL = N).

Otherwise, the default is zero.

None. Please see validations for Sales Tax Amount for PO Lines.
Taxable TAXABLE_FL Set by the application. The system uses the Line Charge Type from the PO Line Charge Type table to get the Taxable flag.

Otherwise, the default is N (No).

Must be Y (Yes) or N (No).
Previously Vouchered Amount — Trans Currency TRN_CHG_PR_VCH_AMT Set by the application. Zero. None
Previously Vouchered Amount — Func Currency CHG_PREV_VCHRD_AMT Set by the application. Zero. None.
Description LN_CHG_DESC Set by the application. The system uses the Line Charge Type from the PO Line Charge Types table to get the description.

Otherwise, the default is space.

None.
User MODIFIED_BY Set by the application. PO-UPLOAD (the last upload is processed by the application). None.
Time Stamp TIME_STAMP Set by the application. Current system date and time. None.
Row Version ROWVERSION Set by the application. Zero. None.

Purchase Order Line Notes (PO_LN_NOTES)

Column Name Costpoint Column Name Source Defaults Validations/Notes
Purchase Order ID PO_ID Input file. None. Required; must exist in the PO Header table.
PO Release Number PO_RLSE_NO Input file. None. Required; must exist in the PO Header table.
PO Line Key PO_LN_KEY Set by the application. None. None.
User MODIFIED_BY Set by the application. PO-UPLOAD (the last upload is processed by the application). None.
Time Stamp TIME_STAMP Set by the application. Current system date and time. None.
Row Version ROWVERSION Set by the application. Zero. None.
PO Line Text PO_LN_TX Input file. None. Required.

Purchase Order Line Text (PO_LN_TEXT)

Column Name Costpoint Column Name Source Defaults Validations/Notes
Purchase Order ID PO_ID Input file. None. Required; must exist in the PO Header table.
PO Release Number PO_RLSE_NO Input file. None. Required; must exist in the PO Header table.
PO Line Key PO_LN_KEY Set by the application. None. None.

When a new PO line is generated and an Item is included, the system will check the ITEM_TEXT table for that ITEM_KEY. If there are one or more rows in this table where the standard text code have a Where Used Code of P (Purchase Order) on the TEXT_WHERE_USED table. The same is performed for PROJ_TEXT if the PO_Line input file includes a Project.

Text Code TEXT_CD Input file. None. Required.

Must exist in the PO Standard Text table.

Must exist in the Text Where Used table with a Where Used Code of P (Purchase Order).

Must have same company ID as User’s.

Must not be a duplicate with another new/existing line text row.

User MODIFIED_BY Set by the application. PO-UPLOAD (the last upload is processed by the application). None.
Time Stamp TIME_STAMP Input File. Current system date and time. None.
Row Version ROWVERSION Set by the application. Zero. None.
Text Source Code S_TEXT_SRCE_CD Input file. None. Must be I (Item) or P (Project).
Sequence Number SEQ_NO Input file. None. Required.

Must be a valid number.

Must not be duplicate with another new/existing line text row

Requisition Line (RQ_LN_PO)

When a new PO line is created and the input file contains both a requisition ID and a requisition line key, the application must create a RQ_LN_PO row with PO and requisition information. It also must update the RQ_LN.GENERATED_QTY, GENERATED_AMT, and TRN_GENERATED_AMT. In certain cases, it may also need to update the RQ_LN_S_RQ_STATUS_CD and RQ_HDR.S_RQ_STATUS_CD.

Column Name Costpoint Column Name Source Defaults Validations/Notes
Auto-Assign PO AUTO_ASSIGN_PO_FL Set by application N
Award Quote Header Key AWARD_QT_HDR_KEY Set by application Null
Award Quote Line Key AWARD_QT_LN_KEY Set by application Null
Blanket PO Line Key BLKT_PO_LN_KEY Set by application Null
Desired Date DESIRED_DT Set by application RQ_LN.RQST_DT
Due Date DUE_DT Set by application PO_LN
Euro to Functional Rate EUR_TO_FUNC_RT Set by application PO_HDR.EUR_TO_FUNC_RT
Manufacturer ID MANUF_ID Set by application Null
Manufacturer Part ID MANUF_PART_ID Set by application PO_LN.MANUF_PART_ID
Manufacturer Part Revision ID MANUF_PART_RVSN_ID Set by application PO_LN.MANUF_PART_RVSN_ID
Modified By MODIFIED_BY Set by application PO_LN.MODIFIED_BY
Negotiated Discount Percent —Func Currency NEG_DISC_PCT_RT Set by application PO_LN.DISC_PCT_RT
Negotiated Gross Unit Cost — Func Currency NEG_GROSS_UNIT_AMT Set by application PO_LN.GROSS_UNIT_COST_AMT
Negotiated Gross Net Cost — Func Currency NEG_NET_UNIT_AMT Set by application PO_LN.NET_UNIT_COST_AMT
Negotiated Requisition Line Extended Amount — Func Currency NEG_RQ_LN_EXT_AMT Set by application PO_LN.PO_LN_EXT_AMT
Negotiated Requisition Line Total Amount — Func Currency NEG_RQ_LN_TOT_AMT Set by application PO_LN.PO_LN_TOT_AMT
Negotiated Sales Tax Amount — Func Currency NEG_SALES_TAX_AMT Set by application PO_LN.SALES_TAX_AMT
Order Quantity ORD_QTY Set by application PO_LN.ORD_QTY
Order Unit of Measure ORD_UM_CD Set by application PO_LN.PO_LN_UM_CD
PO Created Date PO_CREATED_DT Set by application System Date
PO Created PO_CREATED_FL Set by application Y
PO ID PO_ID Set by application PO_LN.PO_ID
PO Line PO_LN_KEY Set by application PO_LN.PO_LN_KEY
PO Release PO_RLSE_NO Set by application PO_LN.PO_RLSE_NO
Rate Group RATE_GRP_ID Set by application PO_HDR.RATE_GRP_ID
Ready for PO RDY_FOR_PO_FL Set by application Y
ROWVERSION Set by application 0
Requisition ID RQ_ID Set by application RQ_LN.RQ_ID
Requisition Line RQ_LN_KEY Set by application RQ_LN.RQ_LN_KEY
Shipping ID SHIP_ID Set by application PO_LN.SHIP_ID
Ship Via SHIP_VIA_FLD Set by application PO_LN.SHIP_VIA_FLD
SUB_KEY Set by application If no RQ_LN_PO rows exist for the RQ_ID, set to 1; otherwise, set to the highest sub_key number for that RQ_ID + 1.
TIME_STAMP Set by application System Date/Time
Transaction Currency TRN_CRNCY_CD Set by application PO_HDR.TRN_CRNCY_CD
Transaction Currency Date TRN_CRNCY_DT Set by application PO_HDR.TRN_CRNCY_DT
Transaction Freeze Rate Flag TRN_FREEZE_RT_FL Set by application PO_HDR.TRN_FREEZE_RT_FL
Gross Unit Cost—Trans Currency TRN_GR_UNIT_AMT Set by application PO_LN.TRN_GR_UN_CST_AMT
Net Unit Cost — Trans Currency TRN_NT_UNIT_AMT Set by application PO_LN.TRN_NET_UN_CST_AMT
Requisition Line Extended Amount—Trans Currency TRN_RQ_LN_EXT_AMT Set by application PO_LN.TRN_PO_LN_EXT_AMT
Requisition Line Total Amount-Trans Currency TRN_RQ_LN_TOT_AMT Set by application PO_LN.TRN_PO_LN_TOT_AMT
Sales Tax Amount-Trans Currency TRN_SALES_TAX_AMT Set by application PO_LN.TRN_SALES_TAX_AMT
Transaction to Euro Rate TRN_TO_EUR_RT Set by application PO_HDR.TRN_TO_EUR_RT
Transaction to Euro Rate Flag TRN_TO_EUR_RT_FL Set by application PO_HDR.TRN_TO_EUR_RT_FL
Vendor Address Code VEND_ADDR_DC Set by application PO_HDR.VEND_ADDR_DC
Vendor ID VEND_ID Set by application PO_HDR.VEND_ID
Vendor Part ID VEND_PART_ID Set by application PO_LN.VEND_PART_ID
Vendor Part Revision VEND_PART_RVSN_ID Set by application PO_LN.VEND_PART_RVSN_ID

If all RQ_LN_POs for a given RQ_LN have been turned into purchase orders and the total quantity for all RQ_LN_POs (in Req U/M) is equal or greater than the requested quantity, the program will set the RQ_LN status to PO G (Generated.) If the statuses of all RQ_LNs for a given requisition are rejected, void, or generated, the program will set the RQ_HDR status to PO G (Generated). It will increase the RQ_LN's GENERATED_QTY amount (order quantity will be converted to the req line's U/M if it is different than the PO line's unit of measure). It will also increase the RQ_LN's GENERATED_AMT and TRN_GENERATED_AMT by the PO_LN. PO_TOT_AMT and PO_LN.TRN_PO_TOT_AMT (will be converted to the requisition line's U/M if it is different than the PO line's unit of measure).

If the S_ORD_REF_TYPE_CD of the Requisition Line  is M, the program will look up the MO_HDR for the MO number in the ORDER_REF_ID column. If the ALLOW_SUBCT_FL = Y, the system will generate the PO/PO line and add the PO_LN.PO_LN_TOT_AMT from the generated PO line (where the S_ORD_REF_TYPE_CD = M) to the MO_HDR_CST.SUBCT_CST_AMT. If the ORDER_REF_LN_KEY is not zero, it will add the same costs to the MO_ROUTING.SUBCT_CST_AMT for the found row. It will copy Req Line Planner and Operation to the PO Line columns.

Updating Inventory

When creating a new PO line with an inventory abbreviation, the program will update the INVT table for the PO_LN's item key and inventory abbreviation. If the PO_LN unit of measure and the part's default unit of measure are different, the system will calculate the PO_LN.ORD_QTY in the part's default unit of measure. If the INVT row exists, the system will increase the row's ON_ORD_QTY by the PO line's converted order quantity. If a matching INVT row does not exist, the program will insert a new row, setting the ON_ORD_QTY to the PO line's converted order quantity. It will set all other quantities and amounts to zero.

When updating an existing PO_LN where the updated PO line has an inventory abbreviation, the program may have to insert or update an INVT row. If an update changes the item_key, inventory abbreviation, and/or the order quantity, one or two rows will be affected.

If the item key and/or the inventory abbreviation have changed, the program will reduce the INVT.ON_ORD_QTY of the original part /inventory abbreviation combination by the original PO_LN.ORD_QTY (which is converted to the part's default unit of measure, if necessary). If the original PO line does not have an inventory abbreviation, the program skips this step. If the new version of the PO_LN has an inventory abbreviation, the program will increase the INVT. ON_ORD_QTY by the NEW PO_LN. ORD_QTY. If the INVT row does not exist, the program will create one.

If only the order quantity has changed on a PO_LN with an inventory abbreviation, the application will add the new order quantity less the original order quantity (which is converted to the part's default unit of measure to the INVT row.)

When adding or changing a PO line row where the INVT has been updated or inserted, if MRP_SETTINGS.ENABLE_NET_CHG_FL is Y (from global variables), and INVT PART.S_PLAN_TYPE is P (and S_PLAN_TYPE is S if MRP_SETTINGS.PLAN_MPS_FL is Y) and PART.NET_CHG_FL is N, the program will set the PART.NET_CHG_FL to Y. When modifying the part on a PO line, the program performs the check on both the ORIGINAL and NEW parts.

Updating Inventory and Requisitions

If the new PO line references a requisition and requisition line number, the program will check to see whether a part and inventory abbreviation exist on the requisition line. If they do, the application must reduce the requisition line's part/inventory abbreviation code INVT.ON_RQ_QTY by the PO_LN.ORD_QTY (converted to the part's default unit of measure if necessary). If the converted order quantity is greater than the requisition line's RQSTD_QTY less GENERATED_QTY (converted to the part's default UM if necessary), it will reduce the ON_RQ_QTY by the smaller quantity.

If the referenced requisition line has a part and an inventory abbreviation, and the part is different than the PO line's part, if MRP_SETTINGS.ENABLE_NET_CHG_FL is Y (from global variables), the requisition line's PART.S_PLAN_TYPE is P (and S_PLAN_TYPE is S if MRP_SETTINGS.PLAN_MPS_FL is Y), and PART.NET_CHG_FL is N) the program will set the PART.NET_CHG_FL to Y.

When adding the PO line, the program will check to see whether any reservations are attached to the referenced requisition line (RES_HDR with S_INVT_TRN_TYPE is P, RQ_ID = RES_HDR.ORD_ID, RES_HDR.ORD_RLSE_NO = null, and RQ_LN_KEY = RES_HDR.ORD_LN_KEY). If it finds a match, and the requisition line status is being set to G by this requisition line (fully generated), it will change the RES_HDR.S_APPRVL_CD to A and replace the requisition ID/line key with PO ID/line key on RES_HDR. It will also add the release number of the generated PO to the RES_HDR Order Release Number.

If a reservation exists for this requisition line but the generation of the PO line will not cause the RQ_LN.S_RQ_STATUS_CD to be set to G (the requisition line is not being fully generated), the program will generate a new RES_HDR and one or more new RES_LN rows. The new reservation header will have the same information on it as the original except for the following:

  • RES_ID: Automatically numbered by system using warehouse auto-assign. Reservation will not be created without an assigned Reservation ID.
  • S_APPRVL_CD: A
  • ORD_ID: PO_ID of the generated PO_LN
  • ORD_RLSE_NO: PO_RLSE_NO of the generated PO_LN
  • ORD_LN_KEY: PO_LN_KEY of the generated PO_LN

The new reservation will have the same number of rows as the old reservation with the same column values except RES_PART_QTY. The program will determine the quantities of the new reservation lines by multiplying the original reservation line’s reserved quantity by the PO line quantity (converted to the inventory unit of measure) divided by the original REQ_LN.RQSTD_QTY less GENERATED_QTY (converted to the inventory unit of measure). It will decrease the original reservation line's quantity by the same amount. If there is any fractional requirements on either the new or the original requisition line and the reserved part has a unit of measure of EA, it will round the fractions up to the nearest whole number.

If the program changes or adds reservations/requests, it will update the INVT. RES_QTY and PLND_RES_QTY for each part/from inventory abbreviation. If it changes the status of an existing reservation header to A, it will reduce the PLND_RES_QTY and increase the RES_QTY for each RES_LN row by the RES_LN.RES_PART_QTY.

If the program generates a new reservation, it will increase the INVT.RES_QTY by the RES_PART_QTY of each of the new RES_LNs and decrease the same INVT row's PLND_RES_QTY by the same amount by which the original RES_LN row’s RES_PART_QTY was reduced.

In either case, if the program adds or changes a reservation, it will set the NET_CHG_GL of each of the RES_LN rows' parts to Y (if MRP_SETTINGS.ENABLE_NET_CHG_FL is Y (from global variables), and reservation line PART.S_PLAN_TYPE is P (or S_PLAN_TYPE is S if MRP_SETTINGS.PLAN_MPS_FL is Y), and PART.NET_CHG_FL is N).

Creating Change Order

If the Create Change Order flag is Y on the PO header input file (and the record passes all validations), the program will copy the original PO information for the specified PO ID/Release (before any of the input file modifications are made) to the change order tables as follows (also, in the PO_HDR, it will be set the LAST_CHNG_DTT to the system date/time):

  • PO_HDR to PO_HDR_CHNG
  • PO_LN to PO_LN_CHNG
  • PO_LN_ACCT to PO_LN_ACCT_CHNG
  • PO_HDR_NOTES to PO_HDR_NOTES_CHNG
  • PO_TEXT to PO_TEXT_CHNG
  • PO_LN_CHG to PO_LN_CHG_CHNG
  • PO_LN_NOTES to PO_LN_NOTES_CHNG
  • PO_LN_TEXT to PO_LN_TEXT_CHNG
Attention: See Create Purchase Order Change Orders for detailed logic.