D4700430D - ASN Table Updates-F470371T Update Tag For F470371
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnParentNumber | AAID | MATH_NUMERIC | OPT | INPUT |
A parent number groups related components together. You can associate each item of property and piece of equipment with a parent item.
| ||||
cApplyCommissionYN | ACOM | char | OPT | INPUT |
Used to indicate whether the sales value or gross margin earned in this order detail line should be included in the calculation of
| ||||
szAccountId | AID | char | OPT | INPUT |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
mnBuyerNumber | ANBY | MATH_NUMERIC | OPT | INPUT |
The address book number that identifies who is responsible for setting up and maintaining the correct stocking levels for each inventory
| ||||
szAcctNoInputMode | ANI | char | OPT | INPUT |
A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:
o Standard account
| ||||
cTypeAddressNumber | ANTY | char | OPT | INPUT |
This will indicate the address number that is associated with the order address information. The possible values are as follows:
1 Sold-to
| ||||
szPriceAdjustmentScheduleN | ASN | char | OPT | INPUT |
A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
cBackordersAllowedYN | BACK | char | OPT | INPUT |
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item
| ||||
szPricingCategoryLevel1 | CLVL | char | OPT | INPUT |
A pricing category or price rule can contain a variety of levels. Within each price rule, each level is defined by its effective date range and
| ||||
szCommissionCategory | CMCG | char | OPT | INPUT |
Items with common commission characteristics are assigned to a common category. The assignment is made in the Item Master
| ||||
cAllocateByLot | CMGL | char | OPT | INPUT |
A code that indicates the method that the system uses to commit lot items from inventory. Valid codes are:
1 The normal commitment
| ||||
szInventoryCostingMeth | CMGP | char | OPT | INPUT |
Each inventory item can have up to seven different unit costs. When processing a transaction, the system searches the individual item
| ||||
mnNumberChangeOrder | CORD | MATH_NUMERIC | OPT | INPUT |
The number of times this purchase order has been modified. You can locate a specific change order number to review the fields that were
| ||||
szOrderType | DCTO | char | OPT | INPUT |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
mnContractSupplementDistri | DMCS | MATH_NUMERIC | OPT | INPUT |
The supplement number records any changes or addendum to agreements that occur over time or by item. It can also indicate individual
| ||||
szContractNumberDistributi | DMCT | char | OPT | INPUT |
A unique number your company assigns to identify a particular agreement. You might want to assign some significance to the agreement
| ||||
mnDocumentOrderInvoiceE | DOCO | MATH_NUMERIC | OPT | INPUT |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szEdiBatchNumber | EDBT | char | OPT | INPUT |
The number that the transmitter assigns to the batch. During batch processing, the system assigns a new batch number to the PeopleSoft
| ||||
szEdiDocumentType | EDCT | char | REQ | INPUT |
The document type that is assigned by the transmitter in an EDI transaction.
In a non EDI environment, this would be consistent with the order
| ||||
mnEdiDetailLinesProcess | EDDL | MATH_NUMERIC | OPT | INPUT |
The number of detail lines transmitted in an EDI transaction. This is the total number of lines on a per order basis, number of lines included
| ||||
jdEdiTransmissionDate | EDDT | JDEDATE | OPT | INPUT |
The specific date that an EDI transaction was either transmitted or received. | ||||
cEdiSendRcvIndicator | EDER | char | OPT | INPUT |
Indicator used to identify if a specific transaction set can be sent, received or both. Valid values are: S Send R Receive B Both | ||||
szEdiTranslationFormat | EDFT | char | OPT | INPUT |
The qualifier used to identify a specific mapping structure used to process both inbound and outbound EDI transactions. This does not
| ||||
mnEdiLineNumber | EDLN | MATH_NUMERIC | REQ | INPUT |
This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any
| ||||
mnEdiDocumentNumber | EDOC | MATH_NUMERIC | REQ | INPUT |
The document number that is assigned by the transmitter in an EDI transaction.
In a non EDI environment, this would be consistent with the
| ||||
cEdiSuccessfullyProcess | EDSP | char | OPT | INPUT |
An option that indicates whether a record has been successfully processed. Depending on the application, the system updates the EDSP
| ||||
mnEDISeq | EDSQ | MATH_NUMERIC | OPT | INPUT |
An identifier that is used to assign the relative position within the header or detail information of an EDI transaction-- for example, H01, H02,
| ||||
szEdiTransactionSet | EDST | char | OPT | INPUT |
The qualifier used to identify a specific type of EDI transaction. | ||||
cEDIType | EDTY | char | OPT | INPUT |
The identifier used to mark EDI transaction records as header and detail information. This is an EDI function only. | ||||
szCompanyKeyEdiOrder | EKCO | char | REQ | INPUT |
Company - Key (EDI - Document Key Co) | ||||
szTaxExplanationCode1 | EXR1 | char | OPT | INPUT |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
cDiscntApplicationType | FAPP | char | OPT | INPUT |
The sales order processing system uses this field to indicate the type of discount given to the sales order.
Valid values are:
blank
| ||||
mnTradeDiscountOld | FUN2 | MATH_NUMERIC | OPT | INPUT |
A 15-character 'packed' numeric field which has been included in the record in anticipation of some future need. It currently has no defined
| ||||
szCompanyKeyOrderNo | KCOO | char | OPT | INPUT |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnLineNumber | LNID | MATH_NUMERIC | OPT | INPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szLedgerType | LT | char | OPT | INPUT |
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
| ||||
mnMatrixControlLine | MCLN | MATH_NUMERIC | OPT | INPUT |
A number that the system uses to group line numbers on a purchase order or sales order for use in a matrix. Although the number is
| ||||
szMeRevisionLevel | MERL | char | OPT | INPUT |
The revision level for an item. If you enter a revision level in this field, verify that the revision level of the routing for an item matches the
| ||||
mnAssetItemNumber | NUMB | MATH_NUMERIC | OPT | INPUT |
An 8-digit number that uniquely identifies an asset. | ||||
szObjectAccount | OBJ | char | OPT | INPUT |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
mnOriginalDocumentLineNo | ODLN | MATH_NUMERIC | OPT | INPUT |
A number that indicates the detail line on the original order from which the current order was created. | ||||
szPurchasingCostCenter | OMCU | char | OPT | INPUT |
The business unit from an account number. The account number business unit is usually found in the data item MCU, however, Distribution
| ||||
cOrderRepricedIndicator | ORP | char | OPT | INPUT |
(Future Use) (internal use) Indicates whether this order line has been processed by the Order Repricing facility. This is used to prevent a
| ||||
szOrderRepriceCategory | ORPR | char | OPT | INPUT |
Items with common order repricing characteristics are assigned to an order reprice category on the Item Master Revisions screen.
| ||||
mnSequenceNumber | OSEQ | MATH_NUMERIC | OPT | INPUT |
For OneWorld, the sequence by which users can set up the order in which their valid environments are displayed.
For World, a sequence or
| ||||
cPendingApprovalFlag | PEND | char | OPT | INPUT |
An option that indicates whether the sales order is pending approval. | ||||
szPortOfEntryExit | POE | char | OPT | INPUT |
The port from which or to which the goods were shipped. For VAT reporting, certain countries require information about the port of exit or
| ||||
szPricingCategory | PRGR | char | OPT | INPUT |
A user defined code (system 40/type PI) that identifies an inventory price group for an item.
Inventory price groups have unique pricing
| ||||
cPriceOverrideCode | PROV | char | OPT | INPUT |
A value established by the sales order entry program whenever a unit or extended price is entered into an order line item, overriding the
| ||||
szPurchasingReportCode3 | PRP3 | char | OPT | INPUT |
A code (UDC table 41/P3) that represents an item property type or classification, such as commodity type, planning family, or so forth. The
| ||||
szPurchasingReportCode4 | PRP4 | char | OPT | INPUT |
A user defined code (41/P4) that represents an item property type or classification, such as commodity type or planning family. The system
| ||||
szPurchasingReportCode5 | PRP5 | char | OPT | INPUT |
A user defined code (41/P5) that indicates the landed cost rule for an item.
The landed cost rule determines purchasing costs that exceed
| ||||
jdDatePromisedShipJu | PSDJ | JDEDATE | OPT | INPUT |
Future Date | ||||
cResolutionCodeBC | RESL | char | OPT | INPUT |
Indicates what should happen in the event the available quantity of an ordered item is less than the quantity ordered. A B indicates that the
| ||||
szRepriceBasketPriceCat | RPRC | char | OPT | INPUT |
You can assign items with common repricing characteristics to a reprice category on Item Branch/Plant Revisions. You can define different
| ||||
szSubledger | SBL | char | OPT | INPUT |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | OPT | INPUT |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
cSalesOrderStatus02 | SO02 | char | OPT | INPUT |
A code that indicates if the committed inventory for this sales detail line has been relieved from the On Hand Quantity. A value of 1 reflects
| ||||
cSalesOrderStatus03 | SO03 | char | OPT | INPUT |
A user defined code (32/PF) that indicates whether the system prints the configurator part on the
sales order and work order. The system
| ||||
cSalesOrderStatus04 | SO04 | char | OPT | INPUT |
cSalesOrderStatus05 | SO05 | char | OPT | INPUT |
A value of 1 in this field indicates that this is a substitute line item. | ||||
cSalesOrderStatus06 | SO06 | char | OPT | INPUT |
A value of 1 in this field indicates the line has already ran through preference inventory commitment. | ||||
cSalesOrderStatus07 | SO07 | char | OPT | INPUT |
Indicates which date fields were entered in Order Entry.
Values are:
1 Pick date (PDDJ) entered
2 Delivery date (RSDJ) entered
3
| ||||
cSalesOrderStatus08 | SO08 | char | OPT | INPUT |
A value of 1 in this field indicates to the system that this sales detail line was created during price adjustment processing to record an
| ||||
cSalesOrderStatus09 | SO09 | char | OPT | INPUT |
A code that indicates the existence of pricing history behind a given sales detail line. Valid values are:
1
Standard detail adjustments exist
| ||||
cSalesOrderStatus10 | SO10 | char | OPT | INPUT |
Flag to indicate the sales order detail line was allocated through the product allocation preference. | ||||
cSalesOrderStatus11 | SO11 | char | OPT | INPUT |
This flag indicates if the order line was created by way of a transfer order or a direct ship order.
Valid values are:
1 Transfer order
2
| ||||
cSalesOrderStatus12 | SO12 | char | OPT | INPUT |
Future use. | ||||
cSalesOrderStatus13 | SO13 | char | OPT | INPUT |
This flag is used by select Euro conversion programs to designate processed records. | ||||
cSalesOrderStatus14 | SO14 | char | OPT | INPUT |
Future use. | ||||
cSalesOrderStatus15 | SO15 | char | OPT | INPUT |
Future use. | ||||
cSalesOrderStatus16 | SO16 | char | OPT | INPUT |
An option that indicates that a record is created by the Variance Journal Entries program (R31804). | ||||
cSalesOrderStatus17 | SO17 | char | OPT | INPUT |
Future Use. | ||||
cSalesOrderStatus18 | SO18 | char | OPT | INPUT |
Future Use. Status 18 for a sales order. | ||||
cSalesOrderStatus19 | SO19 | char | OPT | INPUT |
Future Use. Status 19 for a sales order. | ||||
cSalesOrderStatus20 | SO20 | char | OPT | INPUT |
Future Use. Status 20 for a sales order. | ||||
szSubsidiary | SUB | char | OPT | INPUT |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
cStatusInWarehouse | SWMS | char | OPT | INPUT |
This flag can contain the following values:
blank Sales Order line which has not entered warehousing.
I Sales Order line inside the
| ||||
cTaxableYN | TAX1 | char | OPT | INPUT |
A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
| ||||
cTemporaryPriceYN | TPC | char | OPT | INPUT |
The Advanced Price Adjustment System will set this flag to Y when the Price Effective Date (PEFJ) is blank or when a line is split during
| ||||
szTaxArea1 | TXA1 | char | OPT | INPUT |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
cWoOrderFreezeCode | UNCD | char | OPT | INPUT |
A code that indicates if the line on the order is frozen. MPS/MRP does not suggest changes to frozen orders. Valid values are:
Y
Yes, freeze
| ||||
szPriceCode1 | UPC1 | char | OPT | INPUT |
User defined code (system 40, type P1) you can use to control pricing adjustments. You can associate this code with a preference
| ||||
szPriceCode2 | UPC2 | char | OPT | INPUT |
User defined code (system 40, type P2) you can use to control pricing adjustments. You can associate this code with a preference
| ||||
szPriceCode3 | UPC3 | char | OPT | INPUT |
User defined code (system 40, type P3) you can use to control pricing adjustments. You can associate this code with a preference
| ||||
mnPrimaryLastVendorNo | VEND | MATH_NUMERIC | OPT | INPUT |
The address book number of the preferred provider of this item. | ||||
szCrossDockOrderType | XCTO | char | OPT | INPUT |
A code that identifies the type of order. | ||||
cCrossDockFlag | XDCK | char | OPT | INPUT |
A code that associates items or order lines with cross-dock processing. This code might indicate whether an item or an order line is eligible
| ||||
szCrossDockCmpyKeyOrderNo | XKCO | char | OPT | INPUT |
A code that identifies the company for a cross dock supply order. | ||||
mnCrossDockLineNumber | XLLN | MATH_NUMERIC | OPT | INPUT |
The number that identifies a line in a cross dock supply order. | ||||
mnCrossDockOrderNumber | XORN | MATH_NUMERIC | OPT | INPUT |
The number that identifies a cross dock supply order. | ||||
mnCrossDockingPriority | XPTY | MATH_NUMERIC | OPT | INPUT |
The priority that the cross-docking system follows when assigning supply quantity to the sales orders. This priority indicates the sequence
| ||||
szCrossDockOrderSuffix | XSFX | char | OPT | INPUT |
The code that indicates the suffix for a cross dock supply order. | ||||
szCostCenterHeader | EMCU | char | OPT | INPUT |
A business unit is an accounting entity required for management reporting. It can be a profit center, department, warehouse location, job,
| ||||
szIntegrationReference01 | IR01 | char | OPT | INPUT |
Integration Reference 01 | ||||
szIntegrationReference02 | IR02 | char | OPT | INPUT |
szIntegrationReference03 | IR03 | char | OPT | INPUT |
szIntegrationReference04 | IR04 | char | OPT | INPUT |
Integration Reference 04 | ||||
szIntegrationReference05 | IR05 | char | OPT | INPUT |
cSubstitutesAllowedYN | SBAL | char | OPT | INPUT |
Code associated with each customer specifying whether that customer will accept substitute items. Enter N to disallow or Y to allow
| ||||
szUserId | USER | char | OPT | INPUT |
The code that identifies a user profile. | ||||
szProgramId | PID | char | OPT | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szWorkStationId | JOBN | char | OPT | INPUT |
The code that identifies the work station ID that executed a particular job. | ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | INPUT |
The date that specifies the last update to the file record. | ||||
mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | INPUT |
The computer clock in hours:minutes:seconds. | ||||
cSuppressErrorMessage | SUPPS | char | OPT | INPUT |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
| ||||
szErrorMessageID | DTAI | char | OPT | OUTPUT |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
szFormId | FID | char | OPT | INPUT |
The Form ID refers to the report (R), form (V), or table number (F). |
None |
None |