Passing VAT Information to PeopleSoft Billing

You use Process VAT Defaults (BIPVATOO) VAT to insert information for sales orders into the billing interface tables. The Billing Interface process (BIIF0001) inserts the data into the billing tables for invoicing. VAT amounts are calculated in PeopleSoft Billing.

The following table lists the order levels and fields in PeopleSoft Order Management and the corresponding tables and fields in PeopleSoft Billing.

You can run the Process VAT Defaults and Billing Interface processes individually or as part of the OM Invoicing (OM_IVC) multiprocess job.

Note:

The fields are delivered as implicit Bill By fields on the Bill By Identifier page and are not available from the available options: Ship from Country, Ship to Country, Seller's Registration Country, Buyer's Registration Country, and VAT Treatment Group.

Note:

When you are consolidating orders or shipments onto a single bill, these VAT-related fields must be identical: Ship from Country, Ship to Country, Seller's Registration Country, Buyer's Registration Country, Vat Treatment Group, Calculate at Gross or Net, VAT Declaration Point, VAT Declaration Date Source, VAT Exception Certificate, VAT Exception Type, VAT Recalculate at Payment, Buyer's VAT Registration ID, Seller's VAT Registration ID, VAT Round Rule, and VAT Declaration Date.

Note:

When you specify a VAT declaration point, the system sets the VAT Declaration Date Source and VAT Declaration fields automatically.

Sales Order Level	Order Management Field	Billing Interface Table	Billing Field
Schedule	COUNTRY_LOC_BUYER	INTFC_BI_HDR	COUNTRY_LOC_BUYER
Schedule	COUNTRY_LOC_SELLER	INTFC_BI_HDR	COUNTRY_LOC_SELLER
Schedule	COUNTRY_VAT_PERFRM	INTFC_BI_HDR	COUNTRY_VAT_PERFRM
Schedule	COUNTRY_VAT_SUPPLY	INTFC_BI_HDR	COUNTRY_VAT_SUPPLY
Schedule	STATE_LOC_BUYER	INTFC_BI_HDR	STATE_LOC_BUYER
Schedule	STATE_LOC_SELLER	INTFC_BI_HDR	STATE_LOC_SELLER
Schedule	STATE_VAT_DEFAULT	INTFC_BI_HDR	STATE_VAT_DEFAULT
Schedule	STATE_VAT_PERFRM	INTFC_BI_HDR	STATE_VAT_PERFRM
Schedule	VAT_DCLRTN_POINT	INTFC_BI_HDR	VAT_DCLRTN_POINT
Schedule	VAT_DCLRTN_POINT If "I" If "P" If "D" If "A"	INTFC_BI_HDR	VAT_DCLRTN_DT_SRC = "I" and VAT_DCLRTN_DT "blank." VAT_DCLRTN_DT_SRC = "N" and VAT_DCLRTN_DT = "blank." VAT_DCLRTN_SRC = "D" and VAT_DCLRTN_DT = "ship date of transaction." VAT_DCLRTN_SRC = N and VAT_DCLRTN_DT = "blank"
Schedule	VAT_CALC_GROSS_NET	INTFC_BI_HDR	VAT_CALC_GROSS_NET
Schedule	VAT_DST_ACCT_TYPE	INTFC_BI_HDR	VAT_DST_ACCT_TYPE
Schedule	VAT_RECALC_FLAG	INTFC_BI_HDR	VAT_RECALC_FLAG
Schedule	VAT_EXCPTN_CERTIF	INTFC_BI_HDR	VAT_EXCPTN_CERTIF
Schedule	VAT_EXCPTN_TYPE	INTFC_BI_HDR	VAT_EXCPTN_TYPE
Schedule	VAT_RGSTRN_BUYER	INTFC_BI_HDR	VAT_RSTRN_BUYER
Schedule	VAT_ROUND_RULE	INTFC_BI_HDR	VAT_ROUND_RULE
Schedule	VAT_SERVICE_TYPE	INTFC_BI_HDR	VAT_SERVICE_TYPE
Schedule	VAT_SVC_SUPPLY_FLG	INTFC_BI_HDR	VAT_SVC_SUPPLY_FLG
Schedule	COUNTRY_LOC_BUYER	INTFC_BI	COUNTRY_LOC_BUYER
Schedule	COUNTRY_LOC_SELLER	INTFC_BI	COUNTRY_LOC_SELLER
Schedule	COUNTRY_SHIP_FROM	INTFC_BI	COUNTRY_SHIP_FROM
Schedule	COUNTRY_SHIP_TO	INTFC_BI	COUNTRY_SHIP_TO
Schedule	COUNTRY_VAT_BILLFR	INTFC_BI	COUNTRY_VAT_BILLFR
Schedule	COUNTRY_VAT_BILLTO	INTFC_BI	COUNTRY_VAT_BILLTO
Schedule	COUNTRY_VAT_PERFRM	INTFC_BI	COUNTRY_VAT_PERFRM
Schedule	COUNTRY_VAT_SUPPLY	INTFC_BI	COUNTRY_VAT_SUPPLY
Schedule	IST_TXN_FLG	INTFC_BI	IST_TXN_FLG
Schedule	STATE_LOC_BUYER	INTFC_BI	STATE_LOC_BUYER
Schedule	STATE_LOC_SELLER	INTFC_BI	STATE_LOC_SELLER
Schedule	STATE_VAT_DEFAULT	INTFC_BI	STATE_VAT_DEFAULT
Schedule	STATE_VAT_PERFRM	INTFC_BI	STATE_VAT_PERFRM
Schedule	STATE_SHIP_FROM	INTFC_BI	STATE_SHIP_FROM
Schedule	STATE_SHIP_TO	INTFC_BI	STATE_SHIP_TO
Schedule	VAT_SVC_SUPPLY_FLG	INTFC_BI	VAT_SVC_SUPPLY_FLG
Schedule	VAT_SERVICE_TYPE	INTFC_BI	VAT_SERVICE_TYPE
Schedule	VAT_TXN_TYPE_CD	INTFC_BI	VAT_TXN_TYPE_CD*
Schedule	TAX_CD_VAT	INTFC_BI	TAX_CD_VAT*
Schedule	VAT_APPLICABILITY	INTFC_BI	VAT_APPLICABILITY*
NA	Pass SetID value for record PRODGP_NGVAT_VW	INTFC_BI	PROD_GRP_SETID*
Schedule	VAT_TREATMENT	INTFC_BI	VAT_TREATMENT
Schedule	VAT_TREATMENT_GRP	INTFC_BI	VAT_TREATMENT_GRP
Line	PRODUCT_ID* PRODUCT_ID* (if the product is a kit) Component product IDs	INTFC_BI	PRODUCT_ID PRODUCT_KIT_ID PRODUCT_ID and IDENTIFIER
Line	PHYSICAL_NATURE	INTFC_BI	PHYSICAL_NATURE
NA	PRD	INTFC_BI	IDENTIFIER_TBL

Note:

* For product kits, VAT fields are determined based on the components that make up the kit if you assign VAT percentages to the components.