DETAILED TABLE SPECIFICATIONS

Column Name

Costpoint Column Name

Source

Defaults

Validations/Notes

Purchase Order ID

PO_ID

Input file.

None.

Required; must not exist in the 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, 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 Buyers table.

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

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" (Hold) or "W" (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 of "Y" (Yes) or "D" (Default).

Must have same Company ID as user.

PO Status

S_PO_STATUS_ TYPE

Input file.

PO 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  (in transaction currency) from all PO Lines.

None

Sales Tax Total - Func Currency

SALES_TAX_ AMT

Set by application.

Calculated as the total sales tax  (in functional currency) from all PO Lines.

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 is a release, this must be calculated for the Blanket. If the PO is a new Release, Costpoint adds the PO_HDR. TRN_PO_TOT_AMT for the release to the original  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 to the original TRN_TOT_RLSED_AMT.

If the blanket’s TRN_TOT_RLSED_AMT = TRN_BLKT_AMT and EXCD_BLKT_TOT_FL = Y, set the header and all open line’s status to ‘S’ystem Closed

None

Total Released Amount - Func Currency

TOT_RLSED_ AMT

Set by application.

If the PO is a release, Total Released Amount must be calculated for the Blanket. If the PO is a new release, the system will add the PO Total Amount for the release to the original Total Released Amount.  If the PO is a change, the system will add the difference between the new release's PO Total Amount and the original amount for that release to the original Total Released Amount.

If the Blanket Amount and Total Released Amount are equal, and the Do Not Allow Rel Amts to Exceed Total Blanket Amt checkbox is selected in the PO Settings screen in Costpoint 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 in the Input File is a new PO, the Order Date will be set to the Change Date from the Input File.

If the record is a change to an existing PO, the Order Date from the existing PO will not be changed.

Must be between the Period of Performance Starting and Ending Dates.

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). Set to "N" when creating a new PO.

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

PO Printed

PO_PRNTD_FL

Set by the application.

"N" (No).

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

Confirming PO

CNFRM_FL

Set by the application.

The flag from the PO Settings table; otherwise, the default is "N" (No).

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

Acknowledgment Required

ACKN_FL

Set by the application.

"N" (No).

Must be "Y" (Yes) or "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 Acknowledgement 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.

Optional; must exist in the Vendor Terms table.

Period Of Performance Starting

PERF_START_ DT

Set by the application.

Null.

Must be earlier than the Period of Performance Ending Date.

Period Of Performance Ending

PERF_END_DT

Set by the application.

Null.

Must be later than the Period of Performance Starting Date.

Restrict Release Items to Items on Blanket

RLSE_FROM_ BLKT_FL

Set by the application.

"N" (No).

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

Restrict Release Line Totals to Blanket Line Totals

RLSE_LN_TOT_ FL

Set by the application.

"N" (No).

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

Do Not Exceed Blanket Gross Unit Cost on Rel Line

GROSS_UNIT_ CST_FL

Set by the application.

"N" (No).

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

Do Not Allow Rel Amts to Exceed Total Blanket Amount

EXCD_BLKT_ TOT_FL

Set by the application.

"N" (No).

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

Return Location

BRNCH_LOC_ID

Input file.

The Branch Location ID from the Buyer table.

Optional; 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.

Optional; 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.

Optional; 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.

Optional; 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.

Optional; must be a valid date.

Approval Date

APPRVL_DT

Set by application.

If the data being processed is a change to an existing PO Line, the system will use the Approval Date from the existing PO Line; otherwise, the default is a null value.

None.

Approval User

APPRVL_USER_ ID

Set by the application.

Null.

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).

None.

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).

Must be "Y" (Yes) or "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.

Valid date.

Last Modification Date

LAST_MOD_DTT

Set by the application.

Current system date.

None.

Disadvantaged Flag

CL_DISADV_FL

Set by the application.

Vendor ID's Disadvantaged Flag.

None.

Historical Black College Flag

CL_HIST_BL_ CLG_FL

Set by the application.

Vendor ID's Historical Black College Flag.

None.

HUBZone Flag

CL_LAB_SRPL_ FL

Set by the application.

Vendor ID's HUBZone Flag.

None.

Woman-Owned Flag

CL_WOM_OWN_ FL

Set by the application.

Vendor ID's Woman-Owned Flag.

None.

CIS Code

CIS_CD

Input file or set by application.

If a value is not 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 will be null.

Must exist in CIS_CODES table.

If the PO's CIS Code is not null, the transaction currency for the purchase order must be "British Pounds" (PO_HDR.TRN_ CRNCY_CD must be "GBP").

Transaction  Currency Code

TRN_CRNCY_CD

Input file (Transaction Currency Else, Set by Application

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 processed 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)Else, Set by Application

Current Date

None.

Rate Group

RATE_GRP_ID

Input file (Rate Group)Else, Set by Application

Default Rate Group from Maintain 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, load 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);

= RT_BY_DT.EXCH_RT (or from RT_BY_PD depending upon setting) for EU country Func currencies (with Convert to Euro Currency flag UNchecked);

= RT_BY_DT.EXCH_RT (or from RT_BY_PD depending upon setting) for non EU country func currencies;

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’(o) if PO_HDR.S_PO_STATUS_TYPE =  P(ending). Otherwise set to ‘Y’(es).

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.

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 data being processed is a change to an existing PO Line, the system uses the Line Type from the existing PO Line. Otherwise, the default is "M" (Miscellaneous).

If a Misc Type Code is provided, load an "M."  If an item is provided, load the S_ITEM_TYPE.

None

Item Key

ITEM_KEY

Set by the application.

If the data being processed is a change to an existing PO Line, the system will use the Item Key from the existing PO Line. Will be Null if "M" (Miscellaneous) line type charge is entered.

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:

If 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 an existing PO line, if Item is changed:

Default in the description from Item. If 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 input file description, if provided; otherwise, use the item default.

If the Line Type is "P" (Part), "G" (Good), or "S" (Service), you must select the Parts or the Goods and Services checkboxes (in the Allow Description Change in Purchasing group box) in the Product Definition Settings screen in order to change the item description (if it is different in the input file).

Optional.

Quantity

ORD_QTY

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 Order Quantity from the existing PO Line; otherwise, the default is zero.

Required; must be greater than or equal to zero. Must not be less than the PO Line Received Quantity or Accepted 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. System Date/Change Date.

Optional; must a valid date between the Period of Performance Starting and Ending Dates.

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.

Optional; must be between the Period of Performance Starting and Ending Dates.

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. Original Due Date; otherwise, the default is null.

Optional; required for non-blanket POs. Must earlier than, or the same as, the Due Date.

Volume Discount Rate

DISC_PCT_RT

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 Volume Discount from the existing PO Line; otherwise, the default is zero.

Optional; 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.

Optional; 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.  If PO Type = S, set by application.

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.

Required for new line and Line Type = S (if PO Type = S).  Value must be greater or less than zero to allow negative Subcontract PO line amounts. Negative Subcontract PO line amounts are allowed except for Service Items (S_PO_LN_TYPE = S). Cannot have value if PO line Quantity > 0 and/or Gross Unit Cost > 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. Required for new line and Line Type is "S" (if PO Type is "S").  Value must be greater or less than zero. Negative Subcontract PO line amounts are allowed except for Service Items (S_PO_LN_TYPE = "S"). 

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_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).

Must not be less than the PO Line Vouchered Amount or Posted Amount.

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.

If 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.

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.

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, PO line must be taxable (PO_LN.TAXABLE_FL = Y), and PO_SETTINGS.CALC_TAX_FL must equal Y

Sales Tax - Func Currency

SALES_TAX_ AMT

Set by  the application.

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

If this value is not in the input file and the Taxable flag is "Y," calculate PO Line Sales Tax Amount as PO Line Extended Amount (PO_LN.PO_LN_EXT_ AMT) * PO Line Sales Tax Rate (PO_LN. SALES_TAX_RT).  Use Sales Tax Rate associated with the PO line Ship ID.  Sales Tax Amount will not be calculated if the Auto Calculate Sales/VAT Tax checkbox is not selected (PO_SETTINGS.CALC_ TAX_FL is "N").

If a value is in the input file, use input file value. Calculate the PO line sales tax rate to synchronize with the amount, where PO Line Sales Tax Rate is PO Line Sales Tax Amount / PO Line Extended Amount.

Required. 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 checkbox (PO_SETTINGS.CALC_TAX_FL) must be selected in the PO Settings screen in Costpoint Purchasing.

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. If PO line Sales Tax Amount is in the input file, recalculate the PO line sales tax rate to synchronize with the sales tax amount, where PO Line Sales Tax Rate is PO Line Sales Tax Amount / PO Line Extended Amount.

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.

If the data being processed is a change to an existing PO Line, the system uses the Status from the existing PO Line; otherwise, the default is from the PO Settings screen.

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 Amount/Quantity

S_PO_COMMIT_ TYPE

Input file. If PO Type is "S," set by application.

For Standard Orders: If the data being processed is a change to an existing PO Line, the system will use the Commit Amount/ Quantity from the existing PO Line. If the Miscellaneous Line Charge Type is specified, the Commit Amount/Quantity will default in from the PO Line Charge Type table. If the Miscellaneous Type is null and the Line Type is "P" (Part) or "G" (Good), the system will set this to "Q" (Quantity).

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

Otherwise, the default is "D" (Dollar).

For Blanket Orders: If the data being processed is a change to an existing PO Line, the Commit Dollar/Quantity from the existing PO Line will be used.

If the Include Unreleased Blanket Amounts on Commitments checkbox is selected in the PO Settings screen (PO_SETTING. INCL_BLKT_CMMIT_FL is "Y") in Costpoint Purchasing, defaults for the original blanket order (i.e., the Release is "0," as well as for PO releases 1 and higher) will be as follows: (1) The Commit Dollar/Quantity from the PO Line Charge Type table. (2) If the Miscellaneous Type is null and the Line Type is "P" (Part) or "G" (Good), this will be set to "Q" (Quantity). (3) If the Miscellaneous Type is null and the Line Type is "S" (Service), this will be set to "D" (Dollar).

If the Include Unreleased Blanket Amounts on Commitments checkbox is not selected, the default for the original blanket order will be "E" (Excluded).  Defaults for releases are the same as above.

If the PO Type is "S," the default will be "D" (Dollar).

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. Otherwise, the system uses the Taxable flag from the PO Settings table, depending upon the type of item or miscellaneous line charge entered. Otherwise, the default is "N" (No).

Optional; 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 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 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 Line Type is "P" (Part).

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 radio button is selected in the Requisition Requirements group box in the PO Settings screen (in Costpoint Purchasing).

Must exist in the Requisition table if the Require Valid Req No on PO Line radio button is selected in the Requisition Requirements group box in the PO 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 entered a part in the Item row, the system will load this value from the Alternate Parts table in Costpoint Product Definition for that part key where the Prefer Flag field is "Y" (Yes) in the Alternate Parts screen.

Otherwise, the default is null.

Must exist in manufacturer table.

If the Separate Items by Company checkbox is not selected in the Product Definition Corporate Settings subtask of the 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 in Costpoint Product Definition for that part key where the Prefer Flag field is "Y" (Yes) in the Alternate Parts screen.

Otherwise, the default is a space.

None.

If the Separate Items by Company checkbox 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 entered a part in the Item row, the system will load this value from the Alternate Parts table in Costpoint Product Definition for that part key where the Prefer Flag field is "Y" (Yes) in the Alternate Parts screen.

Otherwise, the default is a space.

None.

If the Separate Items by Company checkbox is not selected in the Product Definition Corporate Settings subtask of the 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 entered a part in the Item row, the system will load this value from the Alternate Parts table in Costpoint Product Definition for that part key where the Prefer Flag field is "Y" (Yes) in the Alternate Parts screen.

Otherwise, the default is a space.

None.

If the Separate Items by Company checkbox is not selected in the Product Definition Corporate Settings subtask of the 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 entered a part in the Item row, the system will load this value from the Alternate Parts table in Costpoint Product Definition for that part key where the Prefer Flag field is "Y" (Yes) in the Alternate Parts screen.

Otherwise, the default is a space.               

None.

If the Separate Items by Company checkbox is not selected in the Product Definition Corporate Settings subtask of the 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 entered 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 entered 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 entered 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 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 Over Ship from the existing PO Line.

If you entered a Misc Line Charge, the system will load the Over Ship flag from the PO 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.

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 a space.

Must exist in Item table in Costpoint Product Definition. 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. If the Separate Items by Company checkbox is selected, the item must have the same company ID as user.

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 when the Allow Multiple Revisions for Each Item checkbox is not selected in the Product Definitions Corporate Settings subtask of the Product Definition Settings screen.

If the Allow Multiple Revisions for Each Item checkbox is selected in the Product Definitions Corporate Settings subtask of the Product Definition Settings screen, the Item ID/Item Revision must exist in Item table in Costpoint Product Definition. If the Allow Multiple Revisions for Each Item checkbox is not selected and the Item ID/Item Revision exists in the Item table, you can enter any Item ID/Item Revision combination, and the combination will not be validated by the system. If the PO Type is "S," the Item Type must be "S." If you change the value, an error will occur if the PO line has already been received or vouchered.

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

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).

Must be "Y" (Yes) or "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.

Otherwise, the default is a space.

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.

Valid 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 or 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).

Must be "Y" (Yes) or "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 PO Voucher Settings based on the Line Type.

If PO Type is "S," the default is TOTAL.

Required.

Must be "INDIV" or "TOTAL."

Cannot be changed after vouchers have been entered.

If Match Type is 2, must be "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 = 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), calculate PO_LN.TRN_LN_CHG_TAX_AMT = PO_LN.TRN_LN_CHG_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 PO Type = "S" default to zero.

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 = 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), calculate PO_LN.PO_LN_CHG_TAX_AMT = PO_LN.PO_LN_CHG_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 PO Type = 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 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 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 TRN_REJ_CR_AMT from the existing PO Line is used. Otherwie 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 from the existing PO Line.

Otherwise, the default is zero.

None.

Approval Date

APPRVL_DT

Set by the application.

Set to current date if status is "O."

None.

Approval User

APPRVL_USER_ ID

Set by the application.

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

Otherwise, the default is null.

None.

Order Reference Line Key

ORDER_REF_LN_KEY

Set by the application.

If the data being processed is a change to an existing PO Line, the system will use the Order Reference Line Key from the existing PO Line.

If you enter an order reference number and an order reference line number, and they have loaded an "S" 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, load a zero.

Otherwise, the default is zero.

None.

Order Reference Type

S_ORD_REF_ TYPE_CD

Set by the application.

If the data being processed is a change to an existing PO Line, the system will use the Order Reference Type from the input file; otherwise, the system uses the existing PO Line's Order Reference Type.

Otherwise, the default is a 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, it will be loaded from the inventory abbreviation's warehouse ID.

Otherwise, the default is a space

Must have same company ID as User's.

If the PO line has an inventory abbreviation and the Plan Warehouse Separately checkbox is selected in the MRP Corporate Settings subtask of the MRP Settings screen in Costpoint Material Requirements Planning (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 null, 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.

Otherwise, the default is a space.

Must exist in Commodity Code table.

If the Separate Items by Company checkbox is selected in the Product Definition Corporate Settings subtask of the Product Definition Settings screen, must have same company ID as user.

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.

Cannot be negative.

Cannot be changed on Purchase Orders and Releases.

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.

Cannot be negative.

Cannot be changed for Purchase Orders with a "R" (Released) status or if the Leadtime ARO is not 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.

"N".

Must be "A," "S," or "N."

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).

Must be "Y" (Yes) or "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.

Must exist in the Procurement Type table.

Auto Voucher

AUTO_VCHR_FL

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 Auto-Voucher flag from the existing PO Line.

If the None radio button is selected in the Auto-Voucher Creation group box in the PO Vouchers setting 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 radio button is selected in the Auto-Voucher Creation group box in the PO Vouchers setting 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

Set by the application.

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 zero.

None.

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" 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."

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.

Must be a valid date and earlier than the End Date.

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.

Must be a valid date and later than the Start Date.

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 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, or set by application.

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.

Vendor Master.

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. 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, or set by application.

If not in the input file, the default will be "Y" if vendor's CIS Code has a withholding rate greater than zero (in the Maintain CIS Codes screen in Costpoint System Administration).  Otherwise, the default is "N."

Must be "Y" (Yes) or "N" (No). If "Y," the PO'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 (Trans 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 (Func 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 (Func 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 (Trans 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 (Func 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 (Trans 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  (Func 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 (Trans 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 (Func Currency) from the existing PO Line.

Otherwise, the default is zero.

None.

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 org.  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 entered a valid Inventory Abbreviation code, you do not need to enter project, account or org. 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 entered a valid Inventory Abbreviation code, you do not need to enter a project, account, or org.  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 in the Maintain 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.

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.

Amount – Trans Currency

TRN_CST_AMT

Input file.

Zero.

Required.

Amount – Func Currency

CST_AMT

Set by the application.

Converted from trans currency amount entered in the input file (TRN_CST_AMT)

Required.

Allocation Percentage

CST_AMT_PCT_ RT

Set by the application.

100%

Must be a number between 0 and 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.

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.

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.

Must exist in the PO Line Charge Types table.

Must exist in the Input file.

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.

Zero.

None.

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 PO_LN_ CHG.TAXABLE_FL = "Y," calculate PO_LN_ CHG.TRN_SALES_TAX_AMT = PO_LN_CHG.TRN_CHG_ CST_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 PO line charge Sales Tax Amt if 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 PO_LN_ CHG.TAXABLE_FL = "Y," calculate PO_LN_ CHG.SALES_TAX_AMT = PO_LN_CHG.CHG_ CST_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 PO line charge Sales Tax Amt if 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.