BI_LINE_NUM_AET(SQL Table) |
Index Back |
|---|---|
BIPILNUM State RecordState Record for BIPILNUM - Invoive Line Numbering - AE Library function. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 4 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
| 5 | INVOICE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill ADJ=Adjustment Only bill ARB=Rebill Bill PRF=Pro Forma Invoice RAD=Regular bill with adjustments REG=Regular Bill |
| 6 | ADJ_LINE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Adjustment Line Type
ACR=Adjustment Credit Line ADJ=Adjustment ARB=Adjustment Rebill Line REG=Regular bill line (not adjust) |
| 7 | TEMP_NBR1 | Number(7,0) | INTEGER NOT NULL | Temporary Number |
| 8 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 9 | NEW_COUNTER | Number(5,0) | INTEGER NOT NULL | New Counter |
| 10 | OLD_COUNTER | Number(5,0) | INTEGER NOT NULL | Old Counter |
| 11 | NEW_SORT_BY_ID | Character(10) | VARCHAR2(10) NOT NULL | Sort By |
| 12 | OLD_SORT_BY_ID | Character(10) | VARCHAR2(10) NOT NULL | Sort By |
| 13 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |