| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AMOUNT_BSE_SUM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 3 |
DISC_BSE_SUM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 4 |
DISC_VAT_BSE_SUM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 5 |
PRO_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 6 |
PRO_DISCOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 7 |
PRO_DSCNT_VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 8 |
PRO_DSCNT_VAT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 9 |
AMOUNT_SUM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 10 |
DISC_SUM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 11 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 12 |
DISC_VAT_SUM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 13 |
LINE_SEQ_MAX |
Number(5,0) |
INTEGER NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 14 |
BENEFICIARY_BANK |
Character(30) |
VARCHAR2(30) NOT NULL |
The bank/counterparty associated with a given beneficiary.
|
| 15 |
BENEF_BRANCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Beneficiary Branch field
|
| 16 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 17 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 18 |
BATCH_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
used by GTA
|
| 19 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 20 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 21 |
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
|
| 22 |
VAT_INVOICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Invoice Type, used by Golden Tax Adapter, created by SOS
C=Common
S=Special
|
| 23 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 24 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 25 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 26 |
CONSOL_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidated Hdr?
N=No
Y=Yes
|
| 27 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 28 |
CONSOL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Specifies the invoice identifier associated with a consolidated bill.
|
| 29 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 30 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 31 |
NEXT_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusting Invoice
|
| 32 |
LATEST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Latest Invoice
|
| 33 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
|
| 34 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 35 |
VAT_RGSTRN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT Registration ID
|
| 36 |
BUYER_DESCR2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Buyer Desc, used by GTA
|
| 37 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 38 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 39 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 40 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 41 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone Extension
|
| 42 |
PHONE5 |
Character(33) |
VARCHAR2(33) NOT NULL |
Used by GTA
|
| 43 |
ADDRESS_PHONE |
Character(80) |
VARCHAR2(80) NOT NULL |
Used by GTA
|
| 44 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 45 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 46 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 47 |
BANK_ACCOUNT_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 48 |
BANK_ACCOUNT_INFO |
Character(80) |
VARCHAR2(80) NOT NULL |
Used by GTA
|
| 49 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 50 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 51 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 52 |
INVOICE_AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount in Base Currency
|
| 53 |
INVOICE_AMT_PRETAX |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 54 |
INVOICE_PRETAX_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 55 |
TOT_VAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 56 |
TOT_VAT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 57 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
|
| 58 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
N=No
Y=Yes
|
| 59 |
GOODS_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Only used by GTA
|
| 60 |
MEMO |
Character(160) |
VARCHAR2(160) NOT NULL |
Used by GTA
|
| 61 |
GTA_STG_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Used by GTA
CAL=Canceled
ERR=Error
GEN=Generated
IGN=Ignored
PRO=Prorated
RDY=Ready
REJ=Rejected
TRS=Transferred
|
| 62 |
ERRORS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates errors were found
N=No
Y=Yes
|
| 63 |
SEL_VAT_RGSTRN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
VAT Registration ID, used by GTA
|
| 64 |
BANK_ACCOUNT_INFO2 |
Character(80) |
VARCHAR2(80) NOT NULL |
Used by GTA
|
| 65 |
ADDRESS1_BU |
Character(55) |
VARCHAR2(55) NOT NULL |
BU Address Line 1
|
| 66 |
ADDRESS_PHONE2 |
Character(80) |
VARCHAR2(80) NOT NULL |
Used by GTA
|
| 67 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 68 |
ERR_SEQ_NUM2 |
Number(5,0) |
INTEGER NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 69 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 70 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 71 |
IDENTIFIER_TBL |
Character(3) |
VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID
CON=Contracts
D=Discount Table
G=Generic Identifier
ID=PS/Billing Charge Id
ITM=PS/Inventory Item ID
LAB=Labor type
PDA=Product Alias
PRD=PS/Product Id
PRM=PS/Promotion Code
S=Surcharge Table
SVC=Service
UPC=UPC
UPN=Universal Item ID
|
| 72 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 73 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 74 |
GT_IDENTIFIER |
Character(12) |
VARCHAR2(12) NOT NULL |
New Field for Golden Tax Adapter
|
| 75 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 76 |
TAX_DENOMINATION |
Character(4) |
VARCHAR2(4) NOT NULL |
New field for Golden Tax Adapter
|
| 77 |
BI_MODEL |
Character(40) |
VARCHAR2(40) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 78 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 79 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
|
| 80 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 81 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 82 |
MAX_LINE_NUM_1 |
Number(5,0) |
INTEGER NOT NULL |
Max Line Number
|
| 83 |
MAX_INV_AMT |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
Used by GTA
|
| 84 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 85 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
|
| 86 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|