RUN_BI_LOC(SQL Table) |
Index Back |
|---|---|
BI Run Cntl - Letter of CreditBilling Process Run Control for Letter of Credit. |
| # | 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 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_BI_NONVW |
| 5 | LC_ID | Character(12) | VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
Prompt Table: BI_LC_PRMPT_VW |
| 6 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: BI_LC_SPNSR_VW |
| 7 | INVOICE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Action
C=Reprint I=Invoice P=Pro Forma |
| 8 | RANGE_SELECTION_ID | Character(30) | VARCHAR2(30) NOT NULL | Range Selection ID |
| 9 | LOC_RANGE_OPT | Character(3) | VARCHAR2(3) NOT NULL |
Range Selection
ALL=All CUS=Sponsor LOC=Letter of Credit ID SEL=Range Selection ID Default Value: ALL |
| 10 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |
| 11 | ADD_DT | Date(10) | DATE | Customer Added On |
| 12 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 13 | PRINT_DETAILS | Character(1) | VARCHAR2(1) NOT NULL |
Print Details
N=No Y=Yes Default Value: Y |
| 14 | EXPORT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Export Flag
N=No Y=Yes |