AR_1099_AUD_TBL (SQL Table)	Index Back
1099C Customer Data

AR_1099_AUD_TBL

(SQL Table)

1099C Customer Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUSTOMER

3 ACTION_DTTM DateTime(26) TIMESTAMP Override Date Time

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Broadcast
D=log Deletedsequence number
E=Check doc seq enable option
G=Generate sequence number
R=Reset for 1099C Submission
X=Deleted from 1099C Prep Table

6 DATE_ADDED Date(10) DATE Date Added

7 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

8 TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID

9 ENTRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the monetary amount of a pending item transaction such as invoice or credit memo.

10 INTEREST_EXPENSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Expense

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

12 MARKET_VALUE Number(27,3) DECIMAL(26,3) NOT NULL Market Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUSTOMER
3	ACTION_DTTM	DateTime(26)	TIMESTAMP	Override Date Time
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	ACTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Broadcast D=log Deletedsequence number E=Check doc seq enable option G=Generate sequence number R=Reset for 1099C Submission X=Deleted from 1099C Prep Table
6	DATE_ADDED	Date(10)	DATE	Date Added
7	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
8	TAXPAYER_ID	Character(14)	VARCHAR2(14) NOT NULL	Taxpayer ID
9	ENTRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the monetary amount of a pending item transaction such as invoice or credit memo.
10	INTEREST_EXPENSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest Expense
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	MARKET_VALUE	Number(27,3)	DECIMAL(26,3) NOT NULL	Market Value