This section defines the data element in each table to be loaded or updated by the PO Voucher Preprocessor. Each section (Voucher Header, Voucher Line, Voucher Line Account and Voucher Vendor Labor) lists the Costpoint columns and source of data in each table. When you create the input file, the first file format contains the information necessary to populate the Voucher Header (VCHR_HDR), and the second format is used to populate the Voucher lines and its child table (VCHR_LN, VCHR_LN_ACCT). The third record format is optional, and is used to populate the Voucher Vendor Labor (VCHR_LAB_VEND).
|
Costpoint Column Name |
Source Table |
Source Column |
Other Field Value |
Validations/Notes |
|
ANTIC_PAY_DT |
|
|
|
|
|
APPRVD_FL |
|
|
|
Refer to Processing Details. |
|
APPRVL_DTT |
|
|
|
If the approved flag is set to Y, set to the system 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 Info subtask. |
|
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 |
|
|
Y |
|
|
BATCH_ID |
|
|
Null |
|
|
CASH_ACCTS_KEY |
VEND |
CASH_ACCTS_KEY |
|
USE_PAY_VEND_ID. If available, use value from Payment Info subtask. |
|
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 |
|
|
0 |
Sum of all voucher line net amounts (VCHR_LN.NET_AMT) for this voucher. |
|
CHK_DT |
|
|
Null |
If available, use value from Payment Info subtask. |
|
CHK_FY_CD |
|
|
Null |
If available, use value from Payment Info subtask. |
|
CHK_NO |
|
|
0 |
If available, use value from Payment Info subtask. |
|
CHK_PD_NO |
|
|
Null |
If available, use value from Payment Info subtask. |
|
CHK_SUB_PD_NO |
|
|
Null |
If available, use value from Payment Info subtask. |
|
CST_AMT |
|
|
0 |
|
|
DFLT_PS_ID |
|
|
Space |
|
|
DFLT_RECPT_ID |
|
|
Null |
|
|
DFLT_WHSE_ID |
|
|
Null |
|
|
DISCR_CALC_DTT |
|
|
SYSTEM 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 |
|
|
0 |
|
|
DM_FL |
|
|
N |
|
|
DM_PRNTD_FL |
|
|
N |
|
|
DUE_AMT |
|
|
|
Use standard PO Voucher logic. |
|
DUE_DT |
|
|
|
Use standard PO Voucher logic. |
|
END_FY_CD |
|
|
Null |
|
|
END_PD_NO |
|
|
Null |
|
|
END_SUB_PD_NO |
|
|
Null |
|
|
ENTR_DTT |
|
|
SYSTEM DATE/TIME |
|
|
ENTR_USER_ID |
|
|
PROCESS USER |
|
|
EUR_TO_FUNC_RT |
PO_HDR |
EUR_TO_FUNC_RT |
|
|
|
EUR_TO_PAY_RT |
|
|
1 |
|
|
EXT_PO_ID |
|
|
Space |
|
|
EXT_PO_RLSE_NO |
|
|
Null |
|
|
FUNC_TO_EUR_RT |
|
|
1 |
|
|
FUNC_TO_EUR_RT_FL |
|
|
N |
|
|
FY_CD |
Header Input File |
Fiscal Year |
|
|
|
HOLD_VCHR_FL |
|
|
|
|
|
INVC_AMT |
VCHR_HDR |
TRN_INVC_AMT |
Converted |
|
|
INVC_DT |
Header Input File |
Invoice Date |
|
|
|
INVC_ID |
Header Input File |
Invoice ID |
|
|
|
INVC_POP_DT |
|
|
Null |
|
|
JNT_PAY_VEND_NAME |
|
|
Null |
|
|
LST_VCHR_FY_CD |
|
|
Null |
|
|
LST_VCHR_PD_NO |
|
|
Null |
|
|
LST_VCHR_SUB_PD_NO |
|
|
Null |
|
|
MODIFIED_BY |
|
|
PROCESS USER |
|
|
NOTES |
Header Input File |
Header Notes |
|
Enter one space if not in input file. |
|
OVR_BUD_FL |
|
|
N |
|
|
PAY_ADDR_DC |
VEND_ADDR |
ADDR_DC |
|
|
|
PAY_VEND_ID |
VEND |
AP_CHK_VEND_ID |
|
Use PO_HDR.VEND_ID. If available, use value from Payment Info subtask. |
|
PAY_WHEN_PAID_FL |
VEND |
PAY_WHEN_PAID_FL |
|
Use PO_HDR.VEND_ID. |
|
PAYWPD_AMT |
|
|
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 |
|
|
|
POSTED_AP_FL |
|
|
N |
|
|
POST_SEQ_NO |
|
|
Null |
|
|
PO_ID |
Header Input File |
PO_ID |
|
|
|
PO_RLSE_NO |
Header Input File |
PO_RLSE_NO |
|
|
|
PRINT_NOTE_FL |
|
|
N |
|
|
RATE_GRP_ID |
PO_HDR |
RATE_GRP_ID |
|
|
|
RECUR_FL |
|
|
N |
|
|
RECUR_PAR_VCHR_KEY |
|
|
Null |
|
|
RECUR_PAR_VCHR_NO |
|
|
0 |
|
|
RECUR_TMPLT_FL |
|
|
N |
|
|
RECUR_VCHR_DC |
|
|
Null |
|
|
ROWVERSION |
|
|
0 |
|
|
RTN_NT |
|
|
Space |
|
|
RTN_RT |
Header Input File |
Retainage Percent |
|
Load 0 if Retainage Percent is null/space. |
|
RVRS_VCHR_FL |
|
|
N |
|
|
SALES_TAX_AMT |
|
|
|
Sum of Voucher Line Sales Tax Amts (SALES_TAX_AMT). |
|
SALES_TAX_CD |
|
|
Null |
|
|
SEP_CHK_FL |
|
|
N |
|
|
SHIP_AMT |
|
|
0 |
|
|
START_FY_CD |
|
|
Null |
|
|
START_PD_NO |
|
|
Null |
|
|
START_SUB_PD_NO |
|
|
Null |
|
|
SUB_PD_NO |
Header Input File |
Subperiod |
|
|
|
S_INVC_TYPE |
|
|
N |
|
|
S_JNL_CD |
|
|
APV |
|
|
S_PO_DISCR_CD |
|
|
|
|
|
S_RECPT_DISCR_CD |
|
|
|
|
|
S_SALES_TAX_SRC_CD |
VCHR_SETTINGS |
DF_PO_S_TAX_SRC_CD |
|
|
|
S_STATUS_CD |
|
|
N |
|
|
S_SUBCTR_PAY_CD |
|
|
N |
|
|
S_TAXABLE_CD |
|
|
S |
|
|
S_VCHR_TYPE |
|
|
P |
|
|
TAXABLE_FL |
|
|
N |
|
|
TERMS_DC |
PO_HDR |
TERMS_DC |
|
If null, use Pay Vendor's VEND.TERMS_DC. |
|
TIME_STAMP |
|
|
SYSTEM DATE/TIME |
|
|
TRN_CRNCY_CD |
PO_HDR |
TRN_CRNCY_CD |
|
|
|
TRN_CRNCY_DT |
PO_HDR |
TRN_CRNCY_DT |
|
|
|
TRN_CST_AMT |
|
|
0 |
|
|
TRN_DISC_AMT |
|
|
|
Use standard PO Voucher logic in terms of transaction currency. |
|
TRN_DUE_AMT |
|
|
|
Use standard PO Voucher logic in terms of transaction currency. |
|
TRN_FREEZE_RT_FL |
PO_HDR |
TRN_FREEZE_RT_FL |
|
|
|
TRN_INVC_AMT |
Header Input File |
Invoice Amount |
|
|
|
TRN_SALES_TAX_AMT |
|
|
Calculated |
Sum of Voucher Line Sales Tax Amounts (TRN_SALES_TAX_AMT). |
|
TRN_SHIP_AMT |
|
|
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 |
|
|
0 |
|
|
USE_TAX_AMT |
|
|
0 |
|
|
VAT_TAX_DT |
|
|
Null |
|
|
VAT_TAX_ID |
|
|
Null |
|
|
VCHR_KEY |
|
|
|
Use SEQ_GENERATOR to determine next VCHR_KEY. |
|
VCHR_NO |
Header Input File |
Voucher Number |
|
|
|
VEND_ID |
VEND |
AP_CHK_VEND_ID |
|
|
|
CIS_CD |
PO_HDR |
CIS_CD |
|
|
|
DOC_LOCATION |
|
|
Null |
|
|
COMPANY_ID |
PO_HDR |
COMPANY_ID |
|
|
|
Costpoint Column Name |
Source Table |
Source Column |
Other Field Value |
Validations/Notes |
|
DISCR_QTY_RT |
|
|
|
|
|
DISCR_TOT_AMT |
|
|
|
|
|
DISCR_UNIT_PRC_AMT |
|
|
|
|
|
DISCR_UNIT_PRC_RT |
|
|
|
|
|
DISC_AMT |
|
|
|
VCHR_HDR.DISC_PCT_RT * TOT_BEF_DISC_AMT. |
|
EXT_CST_AMT |
VCHR_LN |
TRN_EXT_CST_AMT |
Calculated/ |
|
|
LN_CHG_CST_AMT |
|
|
0 |
|
|
LN_CHG_TAX_AMT |
|
|
0 |
|
|
LN_CHG_USE_TAX_AMT |
|
|
0 |
|
|
MISC_LN_CHG_TYPE |
PO_LN |
MISC_LN_CHG_TYPE |
|
|
|
MODIFIED_BY |
|
|
PROCESS USER |
|
|
NET_AMT |
|
|
Calculated |
TOT_BEF_DISC_AMT - DISC_AMT. |
|
NOTES |
Line Input File |
Line Notes |
|
Enter a space if not in input file. |
|
PO_ID |
Header Input File |
PO |
|
|
|
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 |
Release |
|
|
|
QTY |
Line Input File |
Invoice Quantity |
|
Leave as zero if no quantity is entered. |
|
RECOVERY_AMT |
|
|
0 |
|
|
RECOVERY_RT |
|
|
0 |
|
|
RMA_NO_ID |
|
|
Space |
|
|
ROWVERSION |
|
|
0 |
|
|
SALES_TAX_AMT |
|
|
Calculated |
|
|
SALES_TAX_CD |
|
|
|
|
|
SALES_TAX_NT |
|
|
Space |
|
|
S_PO_LN_TYPE |
PO_LN |
S_PO_LN_TYPE |
|
If no PO line number is entered, load M. |
|
S_TAXABLE_CD |
|
|
S |
|
|
TAXABLE_FL |
|
|
|
|
|
TIME_STAMP |
|
|
SYSTEM DATE/TIME |
|
|
TOT_BEF_DISC_AMT |
|
|
Calculated |
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 |
|
|
Calculated |
VCHR_HDR.DISC_PCT_RT * TRN_TOT_BEF_DC_AMT. |
|
TRN_EXT_CST_AMT |
Line Input File |
Extended Cost |
|
|
|
TRN_LN_CHG_CST_AMT |
|
|
0 |
|
|
TRN_LN_CHG_TAX_AMT |
|
|
0 |
|
|
TRN_LN_CHG_USE_AMT |
|
|
0 |
|
|
TRN_NET_AMT |
|
|
Calculated |
TRN_TOT_BEF_DC_AMT - TRN_DISC_AMT. |
|
TRN_RECOVERY_AMT |
|
|
0 |
|
|
TRN_SALES_TAX_AMT |
|
|
Calculated |
|
|
TRN_TOT_BEF_DC_AMT |
|
|
Calculated |
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 |
|
|
0 |
|
|
UM_CD |
PO_LN |
PO_LN_UM_CD |
|
|
|
UNIT_CST_AMT |
VCHR_LN |
TRN_UNIT_CST_AMT |
Converted |
|
|
USE_TAX_AMT |
|
|
0 |
|
|
VAT_SUPPLY_DC |
|
|
Null |
|
|
VAT_SUPPLY_DT |
|
|
Null |
|
|
VCHR_KEY |
VCHR_HDR |
VCHR_KEY |
|
|
|
VCHR_LN_DESC |
PO_LN |
PO_LN_DESC |
|
Load form LN_CHG_TYPE.LN_CHG_DESC if no line number is given. |
|
VCHR_LN_KEY |
|
|
|
Use SEQ_GENERATOR to determine next VCHR_LN_KEY. |
|
VCHR_LN_NO |
Line Input File |
Invoice Line No |
|
|
|
CIS_WH_FL |
PO_LN |
CIS_WH_FL |
|
|
|
CIS_RPT_FL |
|
|
If PO_HDR. CIS_CD is not null, value is Y. Otherwise, it is N. |
|
|
Costpoint Column Name |
Source Table |
Source Column |
Other Field Value |
Validations/Notes |
|
ACCT_ID |
PO_LN_ACCT |
ACCT_ID |
|
Refer to Processing Details if PO line number is null/zero. |
|
AP_1099_FL |
|
|
|
Refer to Processing Details. |
|
CST_AMT |
|
|
0 |
|
|
CST_AMT_PCT_RT |
PO_LN_ACCT |
CST_AMT_PCT_RT |
|
If PO line Number is null, use 1. |
|
DISC_AMT |
|
|
|
VCHR_LN_ACCT.TOT_BEF_DISC_AMT * VCHR_HDR.DISC_PCT_RT. |
|
FA_TMPLT_ID |
|
|
Null |
|
|
FA_TMPLT_KEY |
|
|
Null |
|
|
FA_TMPLT_RVSN_ID |
|
|
Null |
|
|
LN_CHG_CST_AMT |
|
|
0 |
|
|
MODIFIED_BY |
|
|
PROCESS USER |
|
|
NET_AMT |
|
|
|
VCHR_LN_ACCT.TOT_BEF_DISC_AMT - VCHR_LN_ACCT.DISC_AMT. |
|
NOTES |
|
|
|
|
|
ORG_ABBRV_CD |
|
|
|
Refer to Processing Details. |
|
ORG_ID |
|
|
|
Refer to Processing Details. |
|
PROJ_ABBRV_CD |
|
|
|
Refer to Processing Details. |
|
PROJ_ID |
|
|
|
Refer to Processing Details. |
|
REF1_ID |
|
|
|
Refer to Processing Details. |
|
REF2_ID |
|
|
|
Refer to Processing Details. |
|
ROWVERSION |
|
|
0 |
|
|
SALES_TAX_AMT |
|
|
|
Refer to Processing Details. |
|
S_AP_1099_TYPE_CD |
|
|
|
|
|
S_TAXABLE_CD |
|
|
S |
|
|
TAXABLE_FL |
|
|
|
|
|
TIME_STAMP |
|
|
SYSTEM DATE/TIME |
|
|
TOT_BEF_DISC_AMT |
|
|
|
VCHR_LN.TOT_BEF_DISC_AMT * CST_AMT_PCT_RT. |
|
TRN_CST_AMT |
|
|
0 |
|
|
TRN_DISC_AMT |
|
|
Calculated |
VCHR_LN_ACCT.TRN_TOT_BEF_DC_AMT * VCHR_HDR.DISC_PCT_RT. |
|
TRN_LN_CHG_CST_AMT |
|
|
0 |
|
|
TRN_NET_AMT |
|
|
Calculated |
VCHR_LN_ACCT.TRN_TOT_BEF_DC_AMT - VCHR_LN_ACCT.TRN_DISC_AMT. |
|
TRN_RECOVERY_AMT |
|
|
0 |
|
|
TRN_SALES_TAX_AMT |
|
|
Calculated |
|
|
TRN_TOT_BEF_DC_AMT |
|
|
Calculated |
VCHR_LN.TRN_TOT_BEF_DC_AMT * CST_AMT_PCT_RT. |
|
TRN_USE_TAX_AMT |
|
|
0 |
|
|
USE_TAX_AMT |
|
|
0 |
|
|
VCHR_KEY |
VCHR_LN |
VCHR_KEY |
|
|
|
VCHR_LN_ACCT_KEY |
|
|
|
Use SEQ_GENERATOR to determine next VCHR_LN_ACCT_KEY. |
|
VCHR_LN_KEY |
VCHR_LN |
VCHR_LN_KEY |
|
|
|
PROJ_ACCT_ABBRV_CD |
|
|
Null |
|
|
RECOVERY_AMT |
|
|
0 |
|
|
Costpoint Column Name |
Source Table |
Source Column |
Other Field Value |
Validations/Notes |
|
BILL_LAB_CAT_CD |
Labor Input File |
Project Labor Category |
|
|
|
GENL_LAB_CAT_ CD |
Labor Input File |
General Labor Category |
|
|
|
MODIFIED_BY |
|
|
PROCESS USER |
|
|
RECOVERY_AMT |
|
|
0 |
|
|
ROWVERSION |
|
|
0 |
|
|
SUB_LN_NO |
Labor Input File |
Vendor Labor Subline Number |
|
|
|
TIME_STAMP |
|
|
SYSTEM DATE/TIME |
|
|
TRN_RECOVERY_AMT |
|
|
0 |
|
|
TRN_VEND_AMT |
Labor Input File |
Vendor Amount |
|
|
|
VCHR_KEY |
VCHR_LN |
VCHR_KEY |
|
|
|
VCHR_LN_KEY |
VCHR_LN |
VCHR_LN_KEY |
|
|
|
VCHR_LN_VEND_KEY |
|
|
|
Use SEQ_GENERATOR to determine next VCHR_LN_VEND_KEY. |
|
VEND_AMT |
VCHR_LAB_VEND |
TRN_VEND_AMT |
Converted |
|
|
VEND_EMPL_ID |
Labor Input File |
Vendor Empl ID |
NULL (if not in input file) |
|
|
VEND_HRS |
Lab |
Vendor Hours |
|
|
|
EFFECT_BILL_DT |
|
|
Subperiod End Date of the FY/PD/SPD in the Voucher Header. |
|
|
LAST_VCHRD_DT |
VCHR_HDR (used with PO_LN) |
ENTR_DTT |
Load date only. |
Update for new voucher created for a PO line. |