BUSINESS_UNITINVOICEPROCESS_INSTANCESEQ_NUMBI_GENAP_TMP(SQL Table) |
Index Back |
|---|---|
Load GL Processing Temp Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 6 | BUSINESS_UNIT_TO | Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
| 7 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 8 | SETID_VENDOR | Character(5) | VARCHAR2(5) NOT NULL | Supplier Setid |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 11 | VCHR_TTL_LINES | Number(5,0) | INTEGER NOT NULL | Lines Entered |
| 12 | ECQUEUEINSTANCE | Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 13 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |