| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
Prompt Table:
BUS_UNIT_TBL_AR
|
| 2 |
CLAIM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Claim Type
C=Claimbacks
R=Vendor Rebate
|
| 3 |
GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
Prompt Table:
GROUP_TYPE_I_VW
Set Control Field: BUSINESS_UNIT_AR
|
| 4 |
ORIGIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the source or method of entry for a pending item group.
Prompt Table:
ORIGIN_TBL
Set Control Field: BUSINESS_UNIT_AR
|
| 5 |
ENTRY_TYPE_CR |
Character(5) |
VARCHAR2(5) NOT NULL |
Credit Entry Type
Prompt Table:
ENTRY_TYPE_TBL
Set Control Field: BUSINESS_UNIT_AR
|
| 6 |
ENTRY_TYPE_DB |
Character(5) |
VARCHAR2(5) NOT NULL |
Debit Entry Type
Prompt Table:
ENTRY_TYPE_TBL
Set Control Field: BUSINESS_UNIT_AR
|
| 7 |
ENT_TYPE_CR_CM |
Character(5) |
VARCHAR2(5) NOT NULL |
CR Entry TYpe for Credit Memo
Prompt Table:
ENTRY_TYPE_TBL
Set Control Field: BUSINESS_UNIT_AR
|
| 8 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
Prompt Table:
VAT_TXN_CD
Set Control Field: BUSINESS_UNIT_AR
|
| 9 |
ENTRY_RSN_CR_BASE |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table:
AUTO_RSN_CR_VW
Set Control Field: BUSINESS_UNIT_AR
|
| 10 |
ENTRY_RSN_CR_VAT |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table:
AUTO_RSN_CR_VW
Set Control Field: BUSINESS_UNIT_AR
|
| 11 |
ENTRY_RSN_CSH_BASE |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table:
AUTO_RSN_CS_VW
Set Control Field: BUSINESS_UNIT_AR
|
| 12 |
ENTRY_RSN_CSH_VAT |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table:
AUTO_RSN_CS_VW
Set Control Field: BUSINESS_UNIT_AR
|