GST_SRC_DEFN_VW

(SQL View)
Index Back

GST Update Source Defn View

Prompt view for source products using the GSTTransaction Loader

SELECT DISTINCT ORG_BU_TYPE FROM PS_ORG_BU_TAX_APPL WHERE ORG_BU_TYPE IN ('AP','AR','BI','EX')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ORG_BU_TYPE Character(2) VARCHAR2(2) NOT NULL Business Unit Type. This field will have six translate values representing the various BUs
AP=Payables
AR=Receivables
BI=Billing
IN=Inventory
OM=Order Management
PO=Purchasing