| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PREV_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Previous Business Unit
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 5 |
PREV_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Previous Interface ID
|
| 6 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 7 |
PREV_LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 8 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 9 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 10 |
TRANS_TYPE_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail
|
| 11 |
TRANS_TYPE_BI_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0
|
| 12 |
HDR_OR_LINE_NOTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Header or Line Note
H=Header Note
L=Line Note
|
| 13 |
NOTE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Note Type
|
| 14 |
STD_NOTE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Note Code
|
| 15 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 16 |
OM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OM Work Flag
|
| 17 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|