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