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 |