| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INV_CAT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Used by GTA
|
| 2 |
VAT_INVOICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Invoice Type, used by Golden Tax Adapter, created by SOS
C=Common
S=Special
|
| 3 |
GT_INVOICE |
Character(8) |
VARCHAR2(8) NOT NULL |
Used by GTA
|
| 4 |
LINE_SEQ_NUM3 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Used by GTA
|
| 5 |
GTA_INVOICE |
Character(20) |
VARCHAR2(20) NOT NULL |
Invoice
|
| 6 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 7 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
N=No
Y=Yes
Y/N Table Edit
|
| 8 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 9 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 10 |
UOM_GTA |
Character(16) |
VARCHAR2(16) NOT NULL |
Used by GTA
|
| 11 |
QUANTITY_GTA |
Signed Number(24,6) |
DECIMAL(22,6) NOT NULL |
Used by GTA
|
| 12 |
UNIT_AMT_GTA |
Signed Number(24,6) |
DECIMAL(22,6) NOT NULL |
Used by GTA
|
| 13 |
NET_AMT_GTA |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Used by GTA
|
| 14 |
TAX_RATE_GTA |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Used by GTA
|
| 15 |
TAX_AMT_GTA |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Used by GTA
|
| 16 |
TAX_DENOMINATION |
Character(4) |
VARCHAR2(4) NOT NULL |
New field for Golden Tax Adapter
|
| 17 |
DISCOUNT_RATE |
Signed Number(11,3) |
DECIMAL(9,3) NOT NULL |
Used by GTA
|
| 18 |
DISCOUNT_AMT_GTA |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Used by GTA
|
| 19 |
DISCUNT_TAX_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Used by GTA
|
| 20 |
TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
TYPE
|
| 21 |
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
|
| 22 |
MTCHX_STATUS_I |
Character(1) |
VARCHAR2(1) NOT NULL |
I Match Status
N=No
Y=Yes
|
| 23 |
CREATED_DTTM |
DateTime(26) |
TIMESTAMP |
Created Date and time
|
| 24 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 25 |
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.
|
| 26 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|