AR_IDITEM_WD

(SQL Table)
Index Back

AR Payload IDItem Work Doc

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ECFILEROWID Character(3) VARCHAR2(3) NOT NULL Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.
2 PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
3 ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
4 ITEM_DT Date(10) DATE Item Date
5 DISC_TAKEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Taken
6 ADJUSTMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Amount
7 ADJUSTMENT_REASON Character(2) VARCHAR2(2) NOT NULL Adjustment Reason
8 REF_QUALIFIER_CODE Character(2) VARCHAR2(2) NOT NULL Reference Qualifier Code
9 REF_VALUE Character(30) VARCHAR2(30) NOT NULL Reference
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 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.