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. PeopleSoft Payables generates the vouchers. The PeopleSoft Payables Voucher Build process (AP_VCHRBLD) generates and completes voucher record sets.
This chapter discusses how to:
Populate VCHR_HDR_STG.
Populate VCHR_LINE_STG.
Populate VCHR_DIST_STG.
Populating VCHR_HDR_STG
This section 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 |
0 |
|
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.
Populating VCHR_LINE_STG
This section discusses how to use the proposed PeopleSoft Billing approach for populating the VCHR_LINE_STG table.
|
Field Name |
How Billing Populates |
|
BUSINESS_UNIT |
BUSINESS_UNIT_AP |
|
VCHR_BLD_KEY_C1 |
Billing BU |
|
VCHR_BLD_KEY_C2 |
Invoice Number |
|
VCHR_BLD_KEY_N1 |
0 |
|
VCHR_BLD_KEY_N2 |
0 |
|
BUS_UNIT_RELATED |
Blank |
|
VOUCHER_ID_RELATED |
Blank |
|
VOUCHER_ID |
Next |
|
VOUCHER_LINE_NUM |
BI_LINE.LINE_SEQ_NUM |
|
BUSINESS_UNIT_PO |
Blank |
|
PO_ID |
Blank |
|
LINE_NBR |
0 |
|
LEASE_PYMNT_DT |
Null |
|
SCHED_NBR |
0 |
|
DESCR |
Blank |
|
VENDOR_ID |
Blank |
|
VNDR_LOC |
Blank |
|
DESCR254_MIXED |
Blank |
|
SPEEDCHART_KEY |
Blank |
|
TAX_DSCNT_FLG |
Blank |
|
TAX_FRGHT_FLG |
Blank |
|
TAX_MISC_FLG |
Blank |
|
TAX_VAT_FLG |
Blank |
|
PHYSICAL_NATURE |
Value from BI_LINE |
|
VAT_RCRD_INPT_FLG |
Blank |
|
VAT_RCRD_OUTPT_FLG |
Blank |
|
VAT_TREATMENT |
Blank |
|
VAT_SVC_SUPPLY_FLG |
From BI_LINE |
|
VAT_SERVICE_TYPE |
From BI_LINE |
|
COUNTRY_LOC_BUYER |
From BI_LINE |
|
STATE_LOC_BUYER |
From BI_LINE |
|
COUNTRY_LOC_SELLER |
From BI_LINE |
|
STATE_LOC_SELLER |
From BI_LINE |
|
COUNTRY_VAT_SUPPLY |
From BI_LINE |
|
STATE_VAT_SUPPLY |
From BI_LINE |
|
COUNTRY_VAT_PERFRM |
From BI_LINE |
|
STATE_VAT_PERFRM |
From BI_LINE |
|
STATE_SHIP_FROM |
From BI_LINE |
|
MERCHANDISE_AMT |
BI_LINE.NET_EXTENDED_AMT |
|
ITM_SETID |
Blank |
|
INV_ITEM_ID |
Blank |
|
QTY_VCHR |
0 |
|
STATISTIC_AMOUNT |
0 |
|
UNIT_OF_MEASURE |
Blank |
|
UNIT_PRICE |
0 |
|
DSCNT_APPL_FLG |
Y |
|
TAX_CD_VAT |
BI_LINE.TAX_CD_VAT only for domestic VAT. For others, blank. |
|
BUSINESS_UNIT_RECV |
Blank |
|
RECEIVER_ID |
Blank |
|
RECV_LN_NBR |
0 |
|
RECV_SHIP_SEQ_NBR |
0 |
|
MATCH_LINE_OPT |
N |
|
DISTRIB_MTHD_FLG |
A |
|
SHIPTO_ID |
Blank |
|
SUT_BASE_ID |
Blank |
|
TAX_CD_SUT |
BI_LINE.TAX_CD |
|
SUT_EXCPTN_TYPE |
Blank |
|
SUT_EXCPTN_CERTIF |
Blank |
|
SUT_APPLICABILITY |
Blank |
|
VAT_APPLICABILITY |
Blank for non-VAT and for VAT - BI_LINE.VAT_APPLICABILITY. |
|
VAT_TXN_TYPE_CD |
Blank |
|
VAT_USE_ID |
Blank |
|
BUSINESS_UNIT_GL |
Blank |
|
ACCOUNT |
Blank |
|
ALTACCT |
Blank |
|
CF12_AN_SBR |
All blank |
|
DEPTID |
Blank |
|
PROJECT_ID |
Blank |
|
ECTRANSID |
BI_VCHR_IN |
|
STATE_VAT_DEFAULT |
BI_LINE.STATE_VAT_DEFAULT |
|
REQUESTOR_ID |
Blank |
|
VCHRL_USER_SBR |
USER_VCHR_CHAR1 = blank USER_VCHR_CHAR2 = blank USER_VCHR_DEC = 0 USER_VCHR_DATE = null USER_VCHR_NUM1 = 0 |
|
PUR_USR_LIN_SBR |
USER_LINE_CHAR1 = blank |
|
PUR_USR_SHP_SBR |
USER_SCHED_CHAR1= blank |
|
VAT_ENTRD_AMT |
VAT_AMT from BI_LINE |
|
VAT_RECEIPT |
Blank |
|
VAT_RGSTRN_SELLER+ |
For non-VAT bills: blank For VAT bills: the VAT_RGSTRN_SELLER from BI_HDR_VAT |
|
TRANS_DT |
Null |
|
ULTIMATE_USE_CD |
Blank |
|
ADDR_SEQ_NUM_SHIP |
0 |
|
IST_TXN_FLG |
BI_LINE. IST_TXN_FLG |
|
WTHD_SW |
Blank |
|
WTHD_CD |
Blank |
|
MFG_ID |
Blank |
|
BUSINESS_UNIT_PC |
BI_LINE. BUSINESS.UNIT_PC |
|
ACTIVITY_ID |
BI_LINE.ACTIVITY.ID |
|
ANALYSIS_TYPE |
BI_LINE.RESANALYSIS.TYPE |
|
RESOURCE_TYPE |
BI_LINE.RESOURCE_TYPE |
|
RESOURCE_CATEGORY |
BI_LINE.RESOURCE.CATEGORY |
|
RESOURCE_SUB_CAT |
BI_LINE.RESOURCE_SUB_CAT |
|
ECQUEUEINSTANCE |
0 |
Populating VCHR_DIST_STG
This section discusses how to use the proposed PeopleSoft Billing approach for populating the VCHR_DIST_STG table.
|
Field Name |
How Billing Populates |
|
BUSINESS_UNIT |
BUS_UNIT_TBL_GL.BUSINESS_UNIT_AP when the InterUnit method is defined as direct or indirect. IU_INTER_PR_TR.BUSINESS_UNIT_AP when the InterUnit method is defined as pair. |
|
VCHR_BLD_KEY_C1 |
Billing BU |
|
VCHR_BLD_KEY_C2 |
Invoice Number |
|
VCHR_BLD_KEY_N1 |
0 |
|
VCHR_BLD_KEY_N2 |
0 |
|
ECTRANSID |
BI-VCHR-IN |
|
VOUCHER_ID |
NEXT |
|
VOUCHER_LINE_NUM |
BI_LINE_IU_EXP.LINE_SEQ_NUM |
|
DISTRIB_LINE_NUM |
BI_LINE_IU_EXP.LINE_DIST_SEQ_NUM |
|
ACCOUNT |
BI_LINE_IU_EXP.ACCOUNT |
|
STATISTICS_CODE |
BI_LINE_IU_EXP.STATISTICS_CODE |
|
QTY_VCHR |
0 |
|
STATISTICS_AMOUNT |
0 |
|
JRNL_LN_REF |
Blank |
|
DESCR |
Blank |
|
MERCHANDISE_AMT |
BI_LINE.AMOUNT |
|
BUSINESS_UNIT_GL |
Blank |
|
BUSINESS_UNIT_PO |
Blank |
|
PO_ID |
Blank |
|
LEASE_PYMNT_DT |
Null |
|
LINE_NBR |
0 |
|
SCHED_NBR |
0 |
|
PO_DIST_LINE_NUM |
0 |
|
BUSINESS_UNIT_PC |
Blank |
|
ACTIVITY_ID |
Blank |
|
ANALYSIS_TYPE |
Blank |
|
RESOURCE_TYPE |
Blank |
|
RESOURCE_CATEGORY |
Blank |
|
RESOURCE_SUB_CAT |
Blank |
|
ASSET_FLG |
Y if BI_LINE.BUSINESS_UNIT_AMTO does not equal blank. Else, blank. |
|
BUSINESS_UNIT_AM |
BI_LINE.BUSINESS_UNIT_AMTO |
|
ASSET_ID |
BI_LINE.ASSET_ID |
|
COST_TYPE |
BI_LINE.COST_TYPE |
|
PROFILE_ID |
BI_LINE.PROFILE_ID |
|
VAT_TXN_TYPE_CD |
Blank |
|
BUSINESS_UNIT_RECV |
Blank |
|
RECEIVER_ID |
Blank |
|
RECV_LN_NBR |
0 |
|
RECV_SHIP_SEQ_NUM |
0 |
|
RECV_DIST_LINE_NUM |
0 |
|
DEPTID |
BI_LINE_IU_EXP.DEPTID |
|
PROJECT_ID |
BI_LINE_IU_EXP.PROJECT_ID |
|
ALTACCT |
BI_LINE_IU_EXP.ALTACCT |
|
CF12_AN_SBR |
BI_LINE_IU_EXP.CF12_AN_SBR |
|
BUDGET_DT |
Null |
|
ENTRY_EVENT |
Blank |
|
VAT_APORT_CNTRL |
T |
|
VCHRD_USER_SBR |
USER_VCHR_CHAR1 = blank USER_VCHR_CHAR2 = blank USER_VCHR_DEC = 0 USER_VCHR_DATE = null USER_VCHR_NUM1 = 0 |
|
PUR_USR_DST_SBR |
USER_DIST_CHAR1 = blank |
|
OPEN_ITEM_KEY |
Blank |
|
VAT_RECOVERY_PCT |
0 |
|
VAT_REBATE_PCT |
0 |
|
VAT_CALC_AMT |
0 |
|
VAT_BASIS_AMT |
0 |
|
VAT_RCVRY_AMT |
0 |
|
VAT_NRCVR_AMT |
0 |
|
VAT_REBATE_AMT |
0 |
|
VAT_TRANS_AMT |
0 |
|
TAX_CD_VAT_PCT |
0 |
|
VAT_INV_AMT |
0 |
|
VAT_NONINV_AMT |
0 |
|
WO_ID |
Blank |
|
WO_TASK_ID |
0 |
|
RSRC_TYPE |
Blank |
|
RES_LN_NBR |
0 |
|
ECQUEUEINSTANCE |
0 |
See Also
Running the Generate AP Vouchers Process (BIGNAP01)