Populating VCHR_LINE_STG
This topic 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 |
Dependent on AP_LVL setting if header level = 0, if line level = line_seq_num |
|
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 |