Detailed Table Specifications Related Topics
This topic lists the Costpoint data elements that are affected by the Accounts Payable Voucher preprocessor.
Voucher Header Table
The Voucher Header table is filled as follows:
Field | Source | Costpoint performs these Validations |
---|---|---|
Anticipated Pay Date (ANTIC_PAY_DT) | The Due Date from the Input File. | |
A/P Account (AP_ACCT_ID) | The A/P Account from the Default A/P Accounts table. | |
A/P Accounts Key (AP_ACCTS_KEY) | This is a Costpoint-generated key that correlates to the A/P Account Description. The A/P Acct Desc field is taken from the Input File. The default value is the A/P Account Description for the vendor. |
|
A/P Organization (AP_ORG_ID) | The Organization from the Default A/P Accounts table. | |
A/P Reference Number 1 (AP_REF1_ID) | The Ref No 1 from the Default A/P Accounts table. | |
A/P Reference Number 2 (AP_REF2_ID) | The Ref No 2 from the Default A/P Accounts table. | |
Approval Date (APPRVL_DTT) | Costpoint sets the
Approval Date as follows:
|
|
Approved Flag (APPRVD_FL) | Costpoint sets the
Approved Flag as follows:
|
|
Cash Account (CASH_ACCT_ID) | The Cash Account from the Default Cash Accounts table. | |
Cash Account Key (CASH_ACCTS_KEY) | This is a Costpoint-generated key that correlates to the Cash Account Description. The Cash Acct Desc field is taken from the Input File. The default value is the default Cash Account Description for the vendor. |
|
Cash Organization (CASH_ORG_ID) | The Organization from the Default Cash Accounts table. | |
Cash Reference Number 1 (CASH_REF1_ID) | The Ref No 1 from the Default Cash Accounts table. | |
Cash Reference Number 2 (CASH_REF2_ID) | The Ref No 2 from the Default Cash Accounts table. | |
Check Amount (CHK_AMT) | The Input File. This field is optional. The default value is zero. | If the
Check Amount field is not blank in the Input File, Costpoint performs the following validations:
|
Check Date (CHK_DT) | The Input File. This field is optional. Costpoint uses the default of the current system date only if you provide a check number greater than zero in the Input File. | If the
Check Date field is not blank in the Input File, Costpoint performs the following validations:
|
Check Fiscal Year (CHK_FY_CD)
Check Period Number (CHK_PD_NO) Check Subperiod Number (CHK_SUB_PD_NO) |
You can supply values in the Input File. The Check Fiscal Year, Check Period Number, and Check Subperiod Number are optional. Costpoint uses the defaults of the fiscal year, period, and subperiod only if you provide a check number greater than zero in the Input File. | If the fields are not blank in the Input File, Costpoint performs the following validations:
|
Check Number (CHK_NO) | The Input File. This field is optional. The default value is zero. | If the
Check Number field is not blank in the Input File, Costpoint performs the following validations:
|
Company Id (COMPANY_ID) | The company for which the user is currently logged in. | |
Delivery Value (SHIP_AMT) | The Input File. This field is optional. The default value is zero. |
|
Discount Amount (DISC_AMT) | The
Total Discount Amount field in the Input File.
If the Total Discount Amount, Discount Pct, and Discount Date fields from the Input File are all blank, Costpoint calculates the Discount Amount as the rounded product of the Invoice Amount multiplied by the Discount Percent, according to the Terms. |
|
Discount Date (DISC_DT) | The Input File.
If the Total Discount Amount, Discount Pct, and Discount Date fields from the Input File are all blank, Costpoint sets the Discount Date equal to the invoice date plus the Discount Days, according to the Terms. |
|
Discount Percentage Rate (DISC_PCT_RT) | Costpoint computes this rate by dividing the
Discount Pct from the Input File by
100.
If the Total Discount Amount, Discount Pct, and Discount Date fields from the Input File are all blank, Costpoint sets the Discount Percentage Rate to the Discount Percent, according to the Terms. |
|
Discount Taken Amount (DISC_TAKEN_AMT) | The Input File. This field is optional. The default value is zero. | If the
Discount Taken Amount field is not blank in the Input File, Costpoint performs the following validations:
|
Due Amount (DUE_AMT) | Costpoint calculates this amount by subtracting the Discount Amount from the Invoice Amount. |
|
Due Date (DUE_DT) | The Input File. This field is optional. If the Due Date is blank in the Input File, Costpoint calculates the Due Date from the Invoice Date and Terms fields. | |
Entry Date (ENTR_DTT) | The current system date. | |
Entry User (ENTR_USER_ID) | The current user. | |
Fiscal Year (FY_CD)
Period Number (PD_NO) Subperiod Number (SUB_PD_NO) |
The Input File or the screen. The default values are from the screen. |
|
Hold Voucher Flag (HOLD_VCHR_FL) | The Input File. |
|
Input File Voucher Number (INPUT_FILE_VCHR_NO) | The voucher number is taken from the Input File and is copied from the
VCHR_NO field.
The Input File Voucher Number displays on the Manage Accounts Payable Vouchers screen and is useful to link the Costpoint-assigned voucher number to the Input File voucher number when the Use Voucher Numbers In Input File option is cleared on the Import Accounts Payable Vouchers screen. The Input File Voucher Number also displays on the Print Voucher Edit Report. |
|
Invoice (INVC_ID) | The Input File. | |
Invoice Amount (INVC_AMT) | The Input File. |
|
Invoice Date (INVC_DT) | The Input File. |
|
Invoice Period of Performance Date (INVC_POP_DT) | The Input File. | If the
Invoice Period of Performance Date field is not blank in the Input File, it must contain a valid date.
The Invoice Period of Performance Date field is required when:
|
Invoice Type (S_INVC_TYPE) | The Input File. This field is optional. The default value is N. |
|
Joint Payee Name (JNT_PAY_VEND_NAME) | The Input File. |
|
Separate Check Flag (SEP_CHK_FL) | The Input File. The default value is N. |
|
Journal Code (S_JNL_CD) | Costpoint sets the Journal Code to APV. | |
Notes (NOTES) | The Input File. | |
Pay Vendor (PAY_VEND_ID) | The Input File. The default value is the default Pay Vendor for the vendor. |
|
Pay Vendor Pay When Paid Flag (PAY_WHEN_PAID_FL) | The Input File. The default value is the Pay When Paid Flag for the vendor. |
|
Pay When Paid Amount (PAYWPD_AMT) | Costpoint sets the
Pay When Paid Amount as follows:
|
|
Payment Address (PAY_ADDR_DC) | The Input File. The default value is the default payment address for the pay vendor. In other words, where the Address Code has a Pmt Addr pay code of type D (Default) (as set on the Manage Vendors screen). |
|
Print Note-Blank Laser Check Flag (PRINT_NOTE_FL) | The Input File. If the Print Note-Blank Laser Check Flag in the Input File is not Y (Yes), then N (No) is the default value for this field. | |
PO Release Number (EXT_PO_RLSE_NO) |
|
|
Purchase Order Number (EXT_PO_ID) |
|
|
Retainage Percentage (RTN_RT) |
|
|
Sales Tax Amount (SALES_TAX_AMT) | Costpoint computes the Sales Tax Amount by summing the Detail Record(s) Sales Tax Amt field for each unique voucher number and fiscal year combination. | |
Sales Tax Code (SALES_TAX_CD) | Costpoint sets the
Sales Tax Code as follows:
|
|
Subcontractor Pay Code (S_SUBCTR_PAY_CD) | Costpoint sets the
Subcontractor Pay Code as follows:
|
|
Taxable Code (S_TAXABLE_CD) | Costpoint sets the
Taxable Code as follows:
|
|
Taxable Flag (TAXABLE_FL) | Costpoint sets the
Taxable Flag as follows:
|
|
Terms Description (TERMS_DC) | The Input File. The default value is Terms for the vendor. |
|
Use Tax Amount (USE_TAX_AMT) | Costpoint computes the Use Tax Amount by summing the Detail Record(s) Use Tax Amt field for each unique voucher number and fiscal year combination. | |
Vendor (VEND_ID) | The Input File. |
|
Voucher Number (VCHR_NO) | The Voucher Number is taken from the Input File or is assigned by Costpoint, depending upon the voucher numbering method selected on the preprocessor screen. |
|
Voucher Type (S_VCHR_TYPE) | Costpoint sets the Voucher Type to AP. |
Costpoint sets the following fields to N:
- Auto Creation Flag (AUTO_CREATE_FL)
- Debit Memo Flag (DM_FL)
- Debit Memo Printed Flag (DM_PRNTD_FL)
- Over Budget Flag (OVR_BUD_FL)
- Posted Accounts Payable Flag (POSTED_AP_FL)
- Purchase Order Discrepancy (S_PO_DISCR_CD)
- Receipt Discrepancy (S_RECPT_DISCR_CD)
- Recurring Flag (RECUR_FL)
- Recurring Template Flag (RECUR_TMPLT_FL)
Costpoint sets the following fields to zero:
- Cost Amount (CST_AMT)
- Recurring Voucher No (RECUR_PAR_VCHR_NO)
Costpoint sets the following fields to a single space:
- Default Packing Slip (DFLT_PS_ID)
- Retainage Notes (RTN_NT)
- Sales Tax Source Code (S_SALES_TAX_SRC_CD)
- Separate Check Flag (SEP_CHK_FL)
Costpoint leaves the following fields set to null:
- Approval User ID (APPRVR_USER_ID)
- Batch Number (BATCH_ID)
- Default Warehouse (DFLT_WHSE_ID)
- Discrepancy Calculation Date (DISCR_CALC_DTT)
- Posting Sequence Number (POST_SEQ_NO)
- Purchase Order (PO_ID)
- Purchase Order Release Number (PO_RLSE_NO)
- Receipt Number (DFLT_RECPT_ID)
- Recurring Voucher Desc (RECUR_VCHR_DC)
- Last Voucher Fiscal Year (LST_VCHR_FY_CD)
- Last Voucher Period Number (LST_VCHR_PD_NO)
- Last Voucher Subperiod Number (LST_VCHR_SUB_PD_NO)
- Start Fiscal Year (START_FY_CD)
- Start Period Number (START_PD_NO)
- Start Subperiod Number (START_SUB_PD_NO)
- End Fiscal Year (END_FY_CD)
- End Period Number (END_PD_NO)
- End Subperiod Number (END_SUB_PD_NO)
Voucher Line Table
The Voucher Line table is filled as follows:
Field | Source | Costpoint performs these Validations |
---|---|---|
Discount Amount (DISC_AMT) | The Input File.
If a Total Discount Amount exists on the Voucher header record and the Discount Amount on all the matching detail record(s) has a value of zero, Costpoint computes a rounded discount amount for each detail record by multiplying the Discount Percentage Rate on the header record by the result of adding the Line Amount and Sales Tax Amount from each detail record. Any rounding error will be added to the Discount Amount of the first detail record - voucher line number one. |
|
Line Change Cost Amount (LN_CHG_CST_AMT) | The Cost Amount from the Voucher Line Account table. | |
Line Change Tax Amount (LN_CHG_TAX_AMT) | Costpoint sets this amount to be equal to the amount in the Sales Tax Amount field. | |
Line Change Use Tax Amount (LN_CHG_USE_TAX_AMT) | Costpoint sets this amount to be equal to the amount in the Use Tax Amount field. | |
Notes (NOTES) | The Input File. | |
Sales Tax Amount (SALES_TAX_AMT) | The Input File. |
|
Sales Tax Code (SALES_TAX_CD) | The Tax Code field in the Input File. |
|
Taxable Code (S_TAXABLE_CD) | The Input File. |
|
Taxable Flag (TAXABLE_FL) | Costpoint sets the
Taxable Flag as follows:
|
|
Total After Discount (NET_AMT) | Costpoint computes the Total After Discount by subtracting the Discount Amount from the Total Before Discount. | |
Total Before Discount Amount (TOT_BEF_DISC_AMT) | Costpoint computes the Total Before Discount Amount by adding the Line Amount and the Sales Tax Amount. | |
Use Tax Amount (USE_TAX_AMT) | The Input File. |
|
Voucher Line Description (VCHR_LN_DESC) | The Input File. The default value is the Account Description. |
|
Voucher Line Number (VCHR_LN_NO) | The Input File. |
|
Costpoint sets the following fields to zero:
- Extended Cost Amount (EXT_CST_AMT)
- Quantity (QTY)
- Quantity Discrepancy Percentage (DISCR_QTY_RT)
- Total Discrepancy Amount (DISCR_TOT_AMT)
- Unit Cost (UNIT_CST_AMT)
- Unit Price Discrepancy (DISCR_UNIT_PRC_AMT)
- Unit Price Discrepancy Percentage (DISCR_UNIT_PRC_RT)
Costpoint sets the following fields to a single space:
- Purchase Order Line Type (S_PO_LN_TYPE)
- Return Material Authorization Number (RMA_NO_ID)
- Sales Tax Notes (SALES_TAX_NT)
Costpoint leaves the following fields set to null:
- Miscellaneous Line Charge Type (MISC_LN_CHG_TYPE)
- Purchase Order Number (PO_ID)
- Purchase Order Line Key (PO_LN_KEY)
- PO Release Number (PO_RLSE_NO)
- Units of Measure (UM_CD)
Voucher Line Account Table
The Voucher Line Account table is filled as follows:
Field | Source | Costpoint performs these Validations |
---|---|---|
Account (ACCT_ID) | The Input File. The default value is the Account set up for the Project Account Abbreviation. |
|
Accounts Payable 1099 Flag (AP_1099_FL) | The Input File. The default value is from the vendor. |
|
1099-MISC Type Code | The Input File. The default value is from the vendor. (The default value is supplied only when the 1099 Flag is Y and the 1099-MISC Type Code is blank in the Input File.) |
|
Cost Amount (CST_AMT) | The Line Amount field in the Input File. |
|
Cost Amount Percentage Rate (CST_AMT_PCT_RT) | Costpoint computes the Cost Amount Percentage Rate by dividing the Total Before Discount Amount on the detail record(s) for each unique voucher number and fiscal year combination by the Invoice Amount from the header record. | |
Line Change Cost Amount (LN_CHG_CST_AMT) | Costpoint sets the Line Change Cost Amount to equal the Cost Amount field. | |
Organization (ORG_ID) | The Input File.
If you supplied the Org Abbrev in the Input File, the default value is the Organization associated with the Org Abbrev. If you did not supply an Organization or an Org Abbrev in the Input File:
|
|
Organization Abbreviation (ORG_ABBRV_CD) | The Input File. The default value is the Org Abbrev set up for the organization. |
|
Project (PROJ_ID) | The Input File. The default value is the Project associated with the Proj Abbrev. |
|
Project Abbreviation (PROJ_ABBRV_CD) | The Input File. The default value is the Proj Abbrev set up for the Project. |
|
Project Account Abbreviation (PROJ_ACCT_ABBRV_CD) | The Input File. |
|
Reference Number 1 (REF1_ID) | The Input File. | Reference Number 1 must:
|
Reference Number 2 (REF2_ID) | The Input File. | Reference Number 2 must:
|
Costpoint sets the following fields to be the same as the fields in the Voucher Line table:
- Discount Amount (DISC_AMT)
- Sales Tax Amount (SALES_TAX_AMT)
- Taxable Code (S_TAXABLE_CD)
- Taxable Flag (TAXABLE_FL)
- Total After Discount (NET_AMT)
- Total Before Discount Amount (TOT_BEF_DISC_AMT)
- Use Tax Amount (USE_TAX_AMT)
Costpoint sets the following fields to a single space:
- Template ID (FA_TMPLT_ID)
- Template Revision ID (FA_TMPLT_RVSN_ID)
Costpoint leaves the following field set to null:
- Template Key (FA_TMPLT_KEY)
Voucher Labor Vendor Table
The Voucher Labor Vendor Table is filled as follows:
Field | Source | Costpoint performs these Validations |
---|---|---|
Subline Number (SUB_LN_NO) | The Vendor Subline Number field is taken from the Input File. | The
Vendor Subline Number:
|
Vendor Hours (VEND_HRS) | The Input File. |
|
Vendor Amount (VEND_AMT) | The Input File. |
|
Vendor Employee ID (VEND_EMPL_ID) | The Input File. |
|
Effective Billing Date (EFFECT_BILL_DT) | The Input File. |
|
General Labor Category (GENL_LAB_CAT_CD) | The Input File. |
|
Project Labor Category (BILL_LAB_CAT_CD) | The Input File.
Costpoint derives the default value from the Project Vendor Labor Category table for the project and vendor ID combination. |
|