Populating VCHR_HDR_STG
The Generate AP Voucher (generate accounts payable voucher) process (BIGNAP01) populates the AP Voucher Master Staging tables with InterUnit billing information from the PeopleSoft Billing tables. The AP_LVL on the bill header determines if vouchers are created at the header or line level. PeopleSoft Payables generates the vouchers. The PeopleSoft Payables Voucher Build process (AP_VCHRBLD) generates and completes voucher record sets.
This topic discusses how PeopleSoft Billing populates the VCHR_HDR_STG table.
|
Field Name |
How Billing Populates |
|---|---|
|
ASSET_ID |
Blank |
|
BUSINESS_UNIT |
BUSINESS_UNIT_AP |
|
BUSINESS_UNIT_AM |
Null |
|
VCHR_BLD_KEY_C1 |
Billing BU |
|
VCHR_BLD_KEY_C2 |
Invoice Number |
|
VCHR_BLD_KEY_N1 |
Dependent on AP_LVL setting if header level = 0, if line level = line_seq_num |
|
VCHR_BLD_KEY_N2 |
0 |
|
VOUCHER_ID |
NEXT |
|
VOUCHER_STYLE |
REG |
|
INVOICE_ID |
BI_HDR.INVOICE |
|
INVOICE_DT |
BI_HDR.INVOICE_DT |
|
MISC_AMT |
0 |
|
VAT_TREATMENT_GRP |
Blank |
|
STATE_SHIP_FROM |
From BI_HDR |
|
STATE_SHIP_TO |
From BI_HDR |
|
COUNTRY_LOC_SELLER |
From BI_HDR_VAT |
|
STATE_LOC_SELLER |
From BI_HDR_VAT |
|
COUNTRY_LOC_BUYER |
From BI_HDR_VAT |
|
STATE_LOC_BUYER |
From BI_HDR_VAT |
|
COUNTRY_VAT_SUPPLY |
From BI_HDR_VAT |
|
STATE_VAT_SUPPLY |
From BI_HDR_VAT |
|
COUNTRY_VAT_PERFRM |
From BI_HDR_VAT |
|
STATE_VAT_PERFRM |
From BI_HDR_VAT |
|
PREPAID_REF |
Blank |
|
PRPAID_AUTO_APPLY |
Blank |
|
PAY_TRM_BSE_DT_OPT |
Blank |
|
IMAGE_REF_ID |
Blank |
|
IMAGE_DATE |
Null |
|
PAY_SCHEDULE_TYPE |
Blank |
|
TAX_GRP |
Blank |
|
TAX_PYMNT_TYPE |
Blank |
|
INSPECT_DT |
Null |
|
INV_RECPT_DT |
Null |
|
FRGHT_CHARGE_CODE |
Blank |
|
LC_ID |
Blank |
|
LEASE_ID |
Blank |
|
LEASE_PYMNT_DT |
Null |
|
MISC_CHARGE_CODE |
Blank |
|
SALETX_CHARGE_CODE |
Blank |
|
VCHR_SRC |
BILL |
|
ECTRANSID |
BI-VCHR-IN |
|
VENDOR_SETID |
Blank |
|
VENDOR_ID |
BUS_UNIT_TBL_GL.VENDOR_ID when the InterUnit method is direct or indirect. IU_INTER_PR_TR.VENDOR_ID when the InterUnit method is pair. |
|
VNDR_LOC |
BUS_UNIT_TBL_GL.LOCATION when the InterUnit method is defined as direct or indirect. IU_INTER_PR_TR.LOCATION when the InterUnit method is defined as pair. |
|
ADDRESS_SEQ_NUM |
0 |
|
GRP_AP_ID |
Blank |
|
ORIGIN |
From BUS_UNIT_TBL_BI |
|
OPRID |
OPRID |
|
ACCOUNTING_DT |
BI_HDR.ACCOUNTING_DT |
|
POST_VOUCHER |
Blank |
|
DST_CNTRL_ID |
Blank |
|
VOUCHER_ID_RELATED |
Blank |
|
GROSS_AMT |
BI_HDR.INVOICE_AMOUNT |
|
DSCNT_AMT |
0 |
|
SALETX_AMT |
BI_HDR.TOT_SU_TAX |
|
FREIGHT_AMT |
0 |
|
DUE_DT |
Null |
|
DSCNT_DUE_DT |
Null |
|
PYMNT_TERMS_CD |
Blank |
|
ENTERED_DT |
Current Date |
|
TXN_CURRENCY_CD |
BI_HDR.BI_CURRENCY_CD |
|
RT_TYPE |
Blank |
|
RATE_MULT |
0 |
|
RATE_DIV |
0 |
|
VAT_ENTRD_AMT |
BI_HDR.TOT_VAT |
|
MATCH_ACTION |
N |
|
REMIT_ADDR_SEQ_NUM |
0 |
|
CUR_RT_SOURCE |
T |
|
DSCNT_AMT_FLG |
T |
|
DUE_DT_FLG |
T |
|
VCHR_APPRVL_FLG |
P |
|
BUSPROCNAME |
Blank |
|
APPR_RULE_SET |
Blank |
|
VAT_DCLTRN_POINT |
Blank |
|
VAT_CALC_TYPE |
Always E for Billing |
|
VAT_CALC_GROSS_NET |
BI_HDR_VAT.VAT_CALC_GROSS_NET |
|
VAT_RECALC_FLG |
BI_HDR_VAT.VAT_RECALC_FLG |
|
VAT_CALC_FRGHT_FLG |
N |
|
COUNTRY_SHIP_FROM |
BI_HDR.COUNTRY_SHIP_FROM |
|
COUNTRY_SHIP_TO |
BI_HDR.COUNTRY_SHIP_TO |
|
COUNTRY_VAT_BILLFR |
BI_HDR.COUNTRY_VAT_BILLFR |
|
COUNTRY_VAT_BILLTO |
BI_HDR.COUNTRY_VAT_BILLTO |
|
VAT_EXCPTN_CERTIF |
BI_HDR_VAT |
|
VAT_ROUND_RULE |
Blank |
|
STATE_VAT_DEFAULT |
Blank |
|
DSCNT_PRORATE_FLG |
Blank |
|
DESCR254_MIXED |
Blank |
|
DOC_TYPE |
Blank |
|
TAX_EXEMPT |
Blank |
|
EIN_FEDERAL |
Blank |
|
EIN_STATE_LOCAL |
Blank |
|
PROCESS_INSTANCE |
0 |
|
IN_PROCESS_FLG |
N |
|
BUSINESS_UNIT_PO |
Blank |
|
PO_ID |
Blank |
|
PACKSLIP_NO |
Blank |
|
VAT_CALC_MISC_FLG |
N |
|
RECEIPT_DT |
Null |
|
BILL_OF_LADING |
Blank |
|
CARRIER_ID |
Blank |
|
VCHR_BLD_CODE |
Blank |
|
BUSINESS_UNIT_AR |
Blank |
|
CUST_ID |
Blank |
|
ITEM |
Blank |
|
ITEM_LINE |
0 |
|
VAT_EXCPTN_TYPE |
For non-VAT bills: blank For VAT bills: the VAT_EXCPTN_TYPE from BI_HDR_VAT |
|
VCHRH_USER_SBR |
USER_VCHR_CHAR1 USER_VCHR_CHAR2 = blank. USER_VCHR_DEC = 0 USER_VCHR_DATE = null. USER_VCHR_NUM1 = 0 |
|
PUR_USR_HDR_SBR |
USER_HDR_CHAR1 = blank |
|
EC_QUEUEINSTANCE |
0 |
|
ERS_INV_SEQ |
0 |
|
LS_KEY |
0 |
Note: The Generate AP Voucher process inserts a combination of the Payables BU, Billing BU, and Invoice Number to ensure uniqueness when inserting rows into the VCHR_HDR_STG table.