BI_SORT_LIN_TYP(SQL Table) |
Index Back |
|---|---|
Billing Sort-By Line Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LIN_TYP_SORT_BY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Line Type Sort By Identifier |
| 2 | LIN_TYP_ORDER_SEQ |
Number(3,0) | SMALLINT NOT NULL | Line Type Sort Order Sequence |
| 3 | LINE_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Line Type 1
ADV=Advance Billing BAE=Billed Amount in Excess BRT=Billing Retainage DAPP=Cust Deposit Applied DEP=Customer Deposit DISC=Discount Line DREF=Cust Deposit Refunded DRFF=Cust Deposit Refund Fee FRGT=Freight (Surcharge) MISC=Miscellaneous Charge PYCV=Payment with Corporate Voucher RAE=Reclaimed Amount in Excess REV=Revenue Line RSTK=Restock (Surcharge) SUR=Surcharge Line UTL=Utilization Line |
| 4 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 5 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 6 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |