Detailed Table Specifications

This topic lists the Costpoint data elements that are affected by the PO Voucher preprocessor. Each section lists the Costpoint columns and source of data for each table.

Voucher Header (VCHR_HDR)

Costpoint Column Source Table Source Column Other Default or Processing Logic
ANTIC_PAY_DT
APPRVD_FL See the 'Approval Status' section in Processing Details for more information.
APPRVL_DTT If the approved flag is set to Y, set to Costpoint date/time.
APPRVR_USER_ID If the approved flag is set to Y, set to the user ID executing the process.
AP_ACCTS_KEY VEND AP_ACCTS_KEY If available, use value from Payment block on the Import Purchase Order Vouchers screen.
AP_ACCT_ID Derived from AP_ACCTS_KEY.
AP_ORG_ID Derived from AP_ACCTS_KEY.
AP_REF1_ID Derived from AP_ACCTS_KEY.
AP_REF2_ID Derived from AP_ACCTS_KEY.
AUTO_CREATE_FL Load Y.
BATCH_ID Load null.
CASH_ACCTS_KEY VEND CASH_ACCTS_KEY Use PAY_VEND_ID. If available, use value from Payment block on the main screen.
CASH_ACCT_ID Derived from CASH_ACCTS_KEY.
CASH_ORG_ID Derived from CASH_ACCTS_KEY.
CASH_REF1_ID Derived from CASH_ACCTS_KEY.
CASH_REF2_ID Derived from CASH_ACCTS_KEY.
CHK_AMT Calculate sum of all voucher line net amounts (VCHR_LN.NET_AMT) for this voucher. If not available, load null.
CHK_DT If available, use value from Payment block on the main screen. Otherwise, load null.
CHK_FY_CD If available, use value from Payment block on the main screen. Otherwise, load null.
CHK_NO If available, use value from Payment block on the main screen. Otherwise, load 0.
CHK_PD_NO If available, use value from Payment block on the main screen. Otherwise, load null.
CHK_SUB_PD_NO If available, use value from Payment block on the main screen. Otherwise, load null.
CIS_CD PO_HDR CIS_CD
COMPANY_ID PO_HDR COMPANY_ID
CST_AMT Load 0.
DFLT_PS_ID Header input file Packing Slip If not in input file, load space.
DFLT_RECPT_ID Header input file Receipt ID If not in input file, load null.
DFLT_WHSE_ID Header input file Warehouse If not in input file, load null.
DISCR_CALC_DTT Load Costpoint date/time.
DISC_AMT Use standard PO voucher logic.
DISC_DT Use standard PO voucher logic.
DISC_PCT_RT Use standard PO voucher logic.
DISC_TAKEN_AMT Load 0.
DM_FL Header input file Debit Memo If not in input file, load N.
DM_PRNTD_FL Load N.
DOC_LOCATION Load null.
DUE_AMT Use standard PO voucher logic.
DUE_DT Use standard PO voucher logic.
END_FY_CD Load null.
END_PD_NO Load null.
END_SUB_PD_NO Load null.
ENTR_DTT Load system date/time.
ENTR_USER_ID Load process user ID.
EUR_TO_FUNC_RT PO_HDR EUR_TO_FUNC_RT
EUR_TO_PAY_RT Load 1.
EXT_PO_ID Load one space.
EXT_PO_RLSE_NO Load null.
FUNC_TO_EUR_RT Load 1.
FUNC_TO_EUR_RT_FL Load N.
FY_CD Header input file Fiscal Year If not in input file, use the default Fiscal Year entered on the screen.

If no default Fiscal Year was entered, derive from INVC_DT.

HOLD_VCHR_FL Set the VCHR_HDR.HOLD_VCHR_FL = N if the Vendor's HOLD_PMT_FL = N.
INVC_AMT VCHR_HDR TRN_INVC_AMT Convert to functional currency.
INVC_DT Header input file Invoice Date
INVC_ID Header input file Invoice ID
INVC_POP_DT Load null.
JNT_PAY_VEND_NAME Load null.
LST_VCHR_FY_CD Load null.
LST_VCHR_PD_NO Load null.
LST_VCHR_SUB_PD_NO Load null.
MODIFIED_BY Load the process user ID.
NOTES Header input file Header Notes If not in input file, load one space.
OVR_BUD_FL Load N.
PAY_ADDR_DC VEND_ADDR ADDR_DC See the 'Pay Vendor and Payment Address' section in Processing Details for more information.
PAY_VEND_ID VEND AP_CHK_VEND_ID Use PO_HDR.VEND_ID. If available, use value from Payment block on the main screen. See the 'Pay Vendor and Payment Address' section in Processing Details for more information.
PAY_WHEN_PAID_FL VEND PAY_WHEN_PAID_FL Use PO_HDR.VEND_ID.
PAYWPD_AMT Load 0.
PAY_CRNCY_CD PO_HDR TRN_CRNCY_CD
PAY_CRNCY_DT PO_HDR TRN_CRNCY_DT
PAY_FREEZE_RT_FL PO_HDR TRN_FREEZE_RT_FL
PD_NO Header input file Period If not in input file, use the default Period entered on the screen.

If no default Period was entered, derive from INVC_DT.

PO_ID Header input file PO Number
PO_RLSE_NO Header input file PO Release
POST_SEQ_NO Load null.
POSTED_AP_FL Load N.
PRINT_NOTE_FL Load N.
RATE_GRP_ID PO_HDR RATE_GRP_ID
RECUR_FL Load N.
RECUR_PAR_VCHR_KEY Load null.
RECUR_PAR_VCHR_NO Load 0.
RECUR_TMPLT_FL Load N.
RECUR_VCHR_DC Load null.
ROWVERSION Load 0.
RTN_NT Load one space.
RTN_RT Header input file Retainage Percentage Load 0 if Retainage Percent is null/space.
RVRS_VCHR_FL Load N.
SALES_TAX_AMT Calculate the sum of voucher line sales tax amounts (VCHR_LN.SALES_TAX_AMT).
SALES_TAX_CD Load null.
SEP_CHK_FL Load N.
SHIP_AMT Load 0.
START_FY_CD Load null.
START_PD_NO Load null.
START_SUB_PD_NO Load null.
SUB_PD_NO Header input file Subperiod If not in input file, use the default Subperiod entered on the screen.

If no default Subperiod was entered, derive from INVC_DT.

S_INVC_TYPE Load N.
S_JNL_CD APV
S_PO_DISCR_CD VCHR_HDR S_PO_DISCR_CD
S_RECPT_DISCR_CD See the 'Receipt Discrepancy Processing' section in Processing Details for more information.
S_SALES_TAX_SRC_CD VCHR_SETTINGS DF_PO_S_TAX_SRC_CD
S_STATUS_CD Load N.
S_SUBCTR_PAY_CD Load N.
S_TAXABLE_CD Load S.
S_VCHR_TYPE Load P.
TAXABLE_FL Load N.
TERMS_DC PO_HDR TERMS_DC If null, use pay vendor's VEND.TERMS_DC. See the 'Terms Calculations' section in Processing Details for more information.
TIME_STAMP Load system date/time.
TRN_CRNCY_CD PO_HDR TRN_CRNCY_CD
TRN_CRNCY_DT PO_HDR TRN_CRNCY_DT
TRN_CST_AMT Load 0.
TRN_DISC_AMT Use standard PO voucher logic in transaction currency.
TRN_DUE_AMT Use standard PO voucher logic in transaction currency.
TRN_FREEZE_RT_FL PO_HDR TRN_FREEZE_RT_FL
TRN_INVC_AMT Header input file Invoice Amount
TRN_SALES_TAX_AMT Calculate the sum of voucher line sales tax amounts (VCHR_LN.TRN_SALES_TAX_AMT).
TRN_SHIP_AMT Load 0.
TRN_TO_EUR_RT PO_HDR TRN_TO_EUR_RT
TRN_TO_EUR_RT_FL PO_HDR TRN_TO_EUR_RT_FL
TRN_USE_TAX_AMT Load 0.
USE_TAX_AMT Load 0.
VAT_TAX_DT Load null.
VAT_TAX_ID Load null.
VCHR_KEY SEQ_GENERATOR determines the next VCHR_KEY.
VCHR_NO Header input file Voucher Number If not in input file, use Starting Voucher Number on input screen to assign voucher numbers in sequence. If that field is not populated, use auto-numbering for vouchers, if enabled. See the 'Voucher Number' section in Processing Details for more information.
VEND_ID VEND AP_CHK_VEND_ID Refer to PO Vendor in Processing Details.

Voucher Line (VCHR_LN)

Costpoint Column Source Table Source Column Other Default or Processing Logic
CIS_RPT_FL If PO_HDR.CIS_CD is not null, load Y. Otherwise, load N.
CIS_WH_FL PO_LN CIS_WH_FL
DISCR_QTY_RT See the 'Processing Voucher Discrepancies' section in Processing Details for more information.
DISCR_TOT_AMT See the 'Processing Voucher Discrepancies' section in Processing Details for more information.
DISCR_UNIT_PRC_AMT See the 'Processing Voucher Discrepancies' section in Processing Details for more information.
DISCR_UNIT_PRC_RT See the 'Processing Voucher Discrepancies' section in Processing Details for more information.
DISC_AMT Calculate VCHR_HDR.DISC_PCT_RT * TOT_BEF_DISC_AMT.
EXT_CST_AMT VCHR_LN TRN_EXT_CST_AMT Convert to functional currency.
LN_CHG_CST_AMT Load 0.
LN_CHG_TAX_AMT Load 0.
LN_CHG_USE_TAX_AMT Load 0.
MISC_LN_CHG_TYPE PO_LN MISC_LN_CHG_TYPE
MODIFIED_BY Load the process user ID.
NET_AMT TOT_BEF_DISC_AMT - DISC_AMT.
NOTES Line input file Line Notes If not in input file, load one space.
PO_ID Header input file PO Number
PO_LN_KEY PO_LN PO_LN_KEY Look up using PO, Release, Line Number. If no PO line number is on line input file, leave null.
PO_LN_NO Line input file PO Line Number
PO_RLSE_NO Header input file PO Release
QTY Line input file Invoice Quantity If not in input file, load 0.
RECOVERY_AMT Load 0.
RECOVERY_RT Load 0.
RMA_NO_ID Load one space.
ROWVERSION Load 0.
S_PO_LN_TYPE PO_LN S_PO_LN_TYPE If no PO line number is entered, load M.
S_TAXABLE_CD Line input file Taxable Code If not in input file, load S if the voucher line is taxable. See the 'Sales/VAT Tax' section in Processing Details for more information.
SALES_TAX_AMT VCHR_LN TRN_SALES_TAX_AMT Convert to functional currency.
SALES_TAX_CD
SALES_TAX_NT Load one space.
TAXABLE_FL Line input file Derived from Taxable Code If Taxable Code in the input file is S or U, load Y. If it is N, load N.

If Taxable Code in the input file is blank, see the 'Sales/VAT Tax' section in Processing Details for more information.

TIME_STAMP Load system date/time.
TOT_BEF_DISC_AMT Calculate EXT_CST_AMT + LN_CHG_CST_AMT + SALES_TAX_AMT + LN_CHG_TAX_AMT.
TRN_DISCR_TOT_AMT
TRN_DISCR_UNIT_AMT
TRN_DISC_AMT Calculate VCHR_HDR.DISC_PCT_RT * TRN_TOT_BEF_DC_AMT.
TRN_EXT_CST_AMT Line input file Extended Cost See the 'Extended Cost Amount' section in Processing Details for more information.
TRN_LN_CHG_CST_AMT Load 0.
TRN_LN_CHG_TAX_AMT Load 0.
TRN_LN_CHG_USE_AMT Load 0.
TRN_NET_AMT Calculate TRN_TOT_BEF_DC_AMT - TRN_DISC_AMT.
TRN_RECOVERY_AMT Load 0.
TRN_SALES_TAX_AMT Line input file Tax Amount If S_TAXABLE_CD=S, use amount from the input file. If not in input file, or if no input file is used, calculate using the tax rate from the PO (PO_LN.SALES_TAX_RT * TRN_TOT_BEF_DC_AMT).

If S_TAXABLE_CD is not S, load 0.

TRN_TOT_BEF_DC_AMT Calculate TRN_EXT_CST_AMT + TRN_LN_CHG_CST_AMT + TRN_SALES_TAX_AMT + TRN_LN_CHG_TAX_AMT.
TRN_UNIT_CST_AMT Line input file Unit Cost Use PO_LN. TRN_NET_UN CST_ AMT if not loaded in input file.
TRN_USE_TAX_AMT Line input file Tax Amount If S_TAXABLE_CD=U, use amount from the input file. If not in input file, or if no input file is used, calculate using the tax rate from the PO (PO_LN.SALES_TAX_RT * TRN_TOT_BEF_DC_AMT).

If S_TAXABLE_CD is not U, load 0.

UM_CD PO_LN PO_LN_UM_CD
UNIT_CST_AMT VCHR_LN TRN_UNIT_CST_AMT Convert to functional currency.
USE_TAX_AMT VCHR_LN TRN_USE_TAX_AMT Convert to functional currency.
VAT_SUPPLY_DC Load null.
VAT_SUPPLY_DT Load null.
VCHR_KEY VCHR_HDR VCHR_KEY
VCHR_LN_DESC PO_LN PO_LN_DESC Load from LN_CHG_TYPE.LN_CHG_DESC if no line number is given.
VCHR_LN_KEY SEQ_GENERATOR determines the next VCHR_LN_KEY.
VCHR_LN_NO Line input file Invoice Line No

Voucher Line Account (VCHR_LN_ACCT)

Costpoint Column Source Table Source Column Other Default or Processing Logic
ACCT_ID Line Account input file Account This data is taken from the voucher line account input file.

If the voucher line account input file is not available, this data is taken from the voucher line input file.

If the voucher line input file is not available, this data is taken from the PO_LN_ACCT.ACCT_ID table.

If PO line number is null or zero, see the 'Processing Details for Voucher Line Accounts' section in Processing Details for more information.

AP_1099_FL See the '1099 Flag and Type' section in Processing Details for more information.
CST_AMT Load 0.
CST_AMT_PCT_RT Line Account input file Amount or Allocation Calculate input file Amount / VCHR_LN.TOT_BEF_DISC_AMT.

If Amount is not available in the input file, use Allocation (without calculation).

If no input file is used, use PO_LN_ACCT.CST_AMT_PCT_RT.

If PO line number is null, use 1.

DISC_AMT Calculate VCHR_LN_ACCT.TOT_BEF_DISC_AMT * VCHR_HDR.DISC_PCT_RT.
FA_TMPLT_ID Load null.
FA_TMPLT_KEY Load null.
FA_TMPLT_RVSN_ID Load null.
LN_CHG_CST_AMT Load 0.
MODIFIED_BY Load the process user ID.
NET_AMT Calculate VCHR_LN_ACCT.TOT_BEF_DISC_AMT - DISC_AMT.
ORG_ABBRV_CD If the Line Account input file is used, load ORG.ORG_ABBRV_CD associated with ORG_ID.

Otherwise, see the 'Processing Details for Voucher Line Accounts' section in Processing Details for more information.

ORG_ID Line Account input file Organization If no Line Account input file is used, see the 'Processing Details for Voucher Line Accounts' section in Processing Details for more information.
PROJ_ABBRV_CD If the Line Account input file is used, load PROJ.PROJ_ABBRV_CD associated with PROJ_ID.

Otherwise, see the 'Processing Details for Voucher Line Accounts' section in Processing Details for more information.

PROJ_ACCT_ABBRV_CD Load null.
PROJ_ID Line Account input file Project If no Line Account input file is used, see the 'Processing Details for Voucher Line Accounts' section in Processing Details for more information.
RECOVERY_AMT Load 0.
REF1_ID Line Account input file or Line input file Reference 1 If not available in Line Account input file, load from Line input file.

If not in input file, or if no input file is used, load PO_LN_ACCT.REF_STRUC_1_ID.

REF2_ID Line Account input file or Line input file Reference 2 If not available in Line Account input file, load from Line input file.

If not in input file, or if no input file is used, load PO_LN_ACCT.REF_STRUC_2_ID.

ROWVERSION Load 0.
S_AP_1099_TYPE_CD
S_TAXABLE_CD Line input file Taxable Code If not in input file, load S if the voucher line is taxable. See the 'Sales/VAT Tax' section in Processing Details for more information.
SALES_TAX_AMT If an input file is used and S_TAXABLE_CD=S, calculate PO_LN.SALES_TAX_RT * TOT_BEF_DISC_AMT.

If S_TAXABLE_CD is not S, load 0.

If no input file is used, see the 'Sales/VAT Tax' section in Processing Details for more information.

TAXABLE_FL Line input file Derived from Taxable Code If Taxable Code in the input file is S or U, load Y. If it is N, load N.

If Taxable Code in the input file is blank, see the 'Sales/VAT Tax' section in Processing Details for more information.

TIME_STAMP Load system date/time.
TOT_BEF_DISC_AMT Calculate CST_AMT_PCT_RT * VCHR_LN.TOT_BEF_DISC_AMT.
TRN_CST_AMT Load 0.
TRN_DISC_AMT Calculate TRN_TOT_BEF_DC_AMT * VCHR_HDR.DISC_PCT_RT.
TRN_LN_CHG_CST_AMT Load 0.
TRN_NET_AMT Calculate TRN_TOT_BEF_DC_AMT - TRN_DISC_AMT.
TRN_RECOVERY_AMT Load 0.
TRN_SALES_TAX_AMT If an input file is used and S_TAXABLE_CD=S, calculate PO_LN.SALES_TAX_RT * TRN_TOT_BEF_DC_AMT.

If S_TAXABLE_CD is not S, load 0.

If no input file is used, see the 'Sales/VAT Tax' section in Processing Details for more information.

TRN_TOT_BEF_DC_AMT Calculate CST_AMT_PCT_RT * VCHR_LN.TRN_TOT_BEF_DC_AMT.
TRN_USE_TAX_AMT If an input file is used and S_TAXABLE_CD=U, calculate PO_LN.SALES_TAX_RT * TRN_TOT_BEF_DC_AMT.

Otherwise, load 0.

USE_TAX_AMT If an input file is used and S_TAXABLE_CD=U, calculate PO_LN.SALES_TAX_RT * TOT_BEF_DISC_AMT.

Otherwise, load 0.

VCHR_KEY VCHR_LN VCHR_KEY
VCHR_LN_ACCT_KEY SEQ_GENERATOR determines the next VCHR_LN_ACCT_KEY.
VCHR_LN_KEY VCHR_LN VCHR_LN_KEY

Voucher Line Receipt Line (VCHR_LN_RECPT_LN)

When a voucher line is saved, the preprocessor creates a new VCHR_LN_RECPT_LN record for any voucher lines saved against a PO line that requires 3-way individual matching.

Costpoint Column Source Table Source Column Other Default or Processing Logic
MODIFIED_BY Load the process user ID.
PO_LN_KEY RECPT_LN PO_LN_KEY
RECPT_KEY RECPT_LN RECPT_KEY
ROWVERSION Load 0.
TIME_STAMP Load system date/time.
VCHR_KEY VCHR_LN VCHR_KEY
VCHR_LN_KEY VCHR_LN VCHR_LN_KEY
VCHRD_QTY VCHR_LN QTY

Voucher Vendor Labor (VCHR_LAB_VEND)

Costpoint Column Source Table Source Column Other Default or Processing Logic
BILL_LAB_CAT_CD Vendor Labor input file Project Labor Category See the 'Project Labor Category' section in Processing Details for more information.
EFFECT_BILL_DT Vendor Labor input file Effective Bill Date If not in input file, load subperiod end date of the FY/PD/SPD in the Voucher Header.
GENL_LAB_CAT_CD Vendor Labor input file General Labor Category If not in input file, load the VEND_EMPL.DF_GENL_LAB_CAT_CD from row with VEND_ID corresponding to the vendor on the voucher PO.
LAST_VCHRD_DT VCHR_HDR (used with PO_LN) ENTR_DTT Load date only. Update for new voucher created for a PO line.
MODIFIED_BY Load the process user ID.
RECOVERY_AMT Load 0.
ROWVERSION Load 0.
SUB_LN_NO Vendor Labor input file Vendor Labor Subline Number
TIME_STAMP Load system date/time.
TRN_RECOVERY_AMT Load 0.
TRN_VEND_AMT Vendor Labor input file Vendor Amount If screen option Sales Tax Included in Vendor Labor Amounts is selected, and VCHR_LN.S_SALES_TAX_CD=S, calculate input file Vendor Amount / (1 + PO_LN.SALES_TAX_RT).

Otherwise, use input file Vendor Amount without the calculation.

VCHR_KEY VCHR_LN VCHR_KEY
VCHR_LN_KEY VCHR_LN VCHR_LN_KEY
VCHR_LN_VEND_KEY SEQ_GENERATOR determines the next VCHR_LN_VEND_KEY.
VEND_AMT VCHR_LAB_VEND TRN_VEND_AMT Convert to functional currency.
VEND_EMPL_ID Vendor Labor input file Vendor Empl ID If not in input file, use null. See the 'Vendor Employee ID' section in Processing Details for more information.
VEND_HRS Vendor Labor input file Vendor Hours