RUN_BI_GTA_EXP

(SQL Table)
Index Back

Run Control for Invoce Export

Run Control Record for GTA Invoce Export

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_GTA_NONVW

4 VAT_INVOICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Invoice Type, used by Golden Tax Adapter, created by SOS
C=Common
S=Special

Default Value: S

5 INVOICE_DT_FROM Date(10) DATE Invoice Date From
6 INVOICE_DT_TO Date(10) DATE Through
7 FROM_INVOICE Character(30) VARCHAR2(30) NOT NULL From Invoice
8 TO_INVOICE Character(30) VARCHAR2(30) NOT NULL To Invoice Number
9 FROM_CUSTOMER_ID Character(15) VARCHAR2(15) NOT NULL From Customer ID

Prompt Table: BI_BILL_TO_VW

10 TO_CUSTOMER_ID Character(15) VARCHAR2(15) NOT NULL To Customer ID

Prompt Table: BI_BILL_TO_VW

11 BATCH_CODE Character(10) VARCHAR2(10) NOT NULL used by GTA