| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 2 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
|
| 3 |
RMA_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
RMA Line Number
|
| 4 |
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
Default Value: REV
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_BI_NONVW
|
| 7 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 8 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 9 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 10 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 11 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 12 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 13 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 14 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
|
| 15 |
ADJ_INVOICE1 |
Character(22) |
VARCHAR2(22) NOT NULL |
Credit Bill
|
| 16 |
ADJ_LINE_SEQ1 |
Number(5,0) |
INTEGER NOT NULL |
Adjustment Line Sequence 1
|
| 17 |
BILL_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Action
CPY=Copy Bill
CR=Credit Entire Bill
CRB=Credit & Rebill
LIN=Adjust Selected Lines
NO=No Bill Action
Default Value: LIN
|
| 18 |
ADJUST_LINE_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjust Line Option
CDL=Create Reversal and Rebill
CRL=Credit Line
NET=Create Net Adjustment Only
Default Value: NET
|
| 19 |
ADJ_GRP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Group Status
|
| 20 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 21 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 22 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 23 |
RESTOCK_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Restock Product ID
|
| 24 |
PRODUCT_KIT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product Kit Number
|
| 25 |
NEXT_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusting Invoice
|
| 26 |
NEXT_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Next Adjustment Line Sequence
|
| 27 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 28 |
ORIGINAL_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Original Line Sequence 5
|
| 29 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 30 |
PRIOR_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prior Adjustment Line Seq
|
| 31 |
LATEST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Latest Invoice
|
| 32 |
LATEST_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Latest Line Sequence
|
| 33 |
TEMPLATE_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Template Invoice ID
|
| 34 |
TEMPLATE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Template Line Sequence Number
|
| 35 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 36 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No
Y=Yes
|
| 37 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
|
| 38 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
|
| 39 |
BI_NULL_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Null used for Mass Chng
|
| 40 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 41 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 42 |
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.
|
| 43 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 44 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 45 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 46 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|