Functional Description
Purpose
This function will load F0911 fields,retrieve the AAI for each journal entry required for a sales
order,call Tax Calculator, and call the F0911 Edit Line to write the journal entries.
Setup Notes and Prerequisites
This fucntion will receive parameters from the calling application to determine the values for F0911
fields.
If update of F0311 is being bypassed this function will be called when the document number changes
and should only do the process for the AR offsett since the other entries will have already been
written. The SDGLC field will be loaded with A5ARC.
Special Logic
None.
Technical Specification
2.2Related Tables
Table Table Description
F41021Item Location
2.3Related Business Functions
Source NameFunction Name
B4000350RetrieveAAI
B4001090TaxCalculator
B0900049F0911 Edit Objects
2.4Processing
Overview
1. If the line type has GL interface Y
Load GL fields.
Write journal entries for the Sales account.
FUTURE - Price Adjustment calculations and journal entries
2. Calculate sales tax
Calculate taxable amount and tax amount to pass back for later creation of F0311 records.
If line type has GL interface = Y then create the journal entries by tax area.
3.If both the Line Type and Inventory Constants have GL interface Y
Create journal entries for Cost Of Goods Sold and Inventory.
FUTURE - Create journal entries for Inter Branch Transfers.
^
D4200520 - GetSalesAAIsAndCallF0911EditLine
Special Input Expected
LFGLIGL Interface Y/NGL Interface flag for the line.
LFIVIInventory Interface Y/NInventory Interface flag for the line.
LFGLCGL Class CodeGL Class Code for taxes if GL class is blank on the tax
area record.
CIPRIMGL Explanation Code
CISYM1Short Item Symbol
CISYM22nd Item Symbol
CISYM33rd Item Symbol
EV14Subledger SelectionUsed to determine values to load to Subledger and
Subledger Type
SDSBLSubledger (F4211)For optional load of SBL
SDSBLTSubledger Type (F4211)For optional load of SBLT
CRYRCurrencey Conversion FlagFuture- Flag to inidicate that currency conversion is on.
EV03GL Cost Center Selection value
Processing Option for GL Account Cost Center if AAI CC is
blank.
'1' = Use subsequent cost center.
'2' = Sold To address number.
'3' = Use the Subsequent CC.
See processing section for details on population of CC.
EV06Bypass update of F0311 Y/N'1' = Bypass update of F0311(accounts receivable)
'0' = Update F0311 (Do NOT bypass).
EV15Interbranch Order Y/N'1' = Do interbranch transfer journal entries.
'0' = DON'T do interbranch transfer journal entries.
LFCDSCInclude In Cash Discount CalculationY/N
Future -
'1' = Include the extended amount in the cash discount or
payment terms discount calculation.
'0' = Don't include
SDCADCCash Discount PercentFuture -For Tax Calculator
SDEXR1Tax Explanation Code1For Tax Calculator
SDTXA1Taxable Area 1For Tax Calculator
SDTAX1Taxable Y/N flagFor Tax Calculator
SDAEXPExtended AmountFor Tax Calculator
SDFEAExtended Amount - ForeignFor Tax Calculator
SDUORGTransaction QuantityFor Tax Calculator
SDSOCNCancelled QuantityFor Tax Calculator
SDITMItem Number -Short IDFor Tax Calculator and load of EXR and optional load of SBL
SDLITMItem Number - 2ndFor load of EXR
SDAITMItem Number - 3rdFor load of EXR
SDSOQSQuantity ShippedFor Tax Calculator
SDTRDJTransaction DateFor Tax Calculator
SDPTCPayment Terms CodeFor Tax Calculator
SDAN8Sold To address numberFor optional load to Cost Center and optional load of SBL
SDSHANShip To address numberFor optional load of SBL
SDDOCOSales Order NumberFor optional load of SBL
SDSLSMSalesperson 1For option load of SBL
SFXPay ItemFor F0911EditLine
SDLNIDLine IdFor F0911EditLine
IMDSC1Item Desc (F4101)For optional load of EXR
SDDSC1Item DescFor optional load of EXR
SDEMCUHeader Cost CenterUsed to retrieve the Revenue Cost Center's Company
SDCODetail CompanyFor optional load of CO
SDMCUDetail Cost CenterFor optional load of MCU
SHCOHeader CompanyFor optional load of CO
SHCRRMHeader Currency ModeFor F0911EditLine
SDCRRExchange RateFor F0911EditLine
SHMCUHeader Cost Center (F4201)For optional load of CO
$RCORevenue CompanyFor optional load of CO
SDGLCGL Offsett For retrieval of AAI's When calling this function to create
the AR offset this parm will be loaded with the AR offset from the customer master(A5ARC) otherwise
it will be loaded with the GL class code from the sales order. 12/8/95
SDDCTOSales Order TypeFor retrieval of AAI's
ECSTExtended CostFor F0911EditLine (work field)
FECExtended Cost - foreignFor F0911EditLine (work field)
UPRCUnit PriceFor F0911EditLIne (work field)
FUCUnit Price - foreignFor F0911EditLine (work field)
VC30AExplanation - remarkFor F0911EditLIne (work field)
ACRAR offset - foreignThis field is input when calling this function to create
the AR offset otherwise it is output to pass back the amount to accumulate for the offset.12/8/95
AAAR offset - domesticThis field is input when calling this function to create
the AR offset otherwise it is output to pass back the amount to accumulate for the offset.12/8/95
$#TAXTaxAmtPostProgramPortion of tax to written to GL by the Post
CIUNGLWrite Journal Units
CIGLPOGL Inter Flag General
DCTDocument Type
JOBSJob NumberJob Number for the I batch
JOBSSTJobNumberJob Number for the ST batch(interbranch JE's)
CTIDComputer ID
EV01F0911 Doc TypeFor F0911EditLine
EV07WriteAROffset Y/N1 = Perform only the logic to write the AR offset.
0 = Do NOT write AR offset.
Perform the logic to write all other journal entries.
UOMTrans UOM - FromRequired only if Interbranch Order
UOM1Primary UOM - ToRequired only if Interbranch Order
TFLAStd UOM ConversionRequired only if Interbranch Order
TCSTUnit Cost Before MarkupRequired only if Interbranch Order
EV20G/L Summarization at Batch Level for Inventory & COGS (Y/N)
Passed from the Processing option for G/L
Summarization at Batch Level for Inventory
and COGS Entries.
JOBSJob Number for G/L Summarization at Batch Level
Job Number for G/L Summarization at Batch Level
EV21G/L Summarization Document Changed
1 = Document Changed
0 = Document not changed
JEL0From Journal Entry Line Number - G/L Summarization
From G/L Summarization Journal Entry Line Number for the
current document
JEL1To Journal Entry Line Number - G/L Summarization
To G/L Summarization Journal Entry Line Number for the
current document
EV09Sales Flex Accouting FlagIf set to '1', will be used by RetrieveAAI (B4000350) BF to
call the Build Flexible Account BF.
JOBSSales Flex Acct Job NumberUsed for the flex account cache. Required to send if the
Sales Flex Accounting Flag is set to '1'.
GENLNGPPAT IDUsed for message center logic.
ICUBatch NumberBatch Number of the 'IB' batch. Used for setting the Level
Break message for 'IB' batch. (Message Center Functionality).
ICUG/L Summarization Batch Number
Batch Number of the 'G' batch. Used for setting the Level
Break message for 'G' batch. (Message Center Functionality).
ICUInterbranch Batch NumberBatch Number of the 'ST' batch. Used for setting the Level
Break message for 'ST' batch. (Message Center Functionality).
Special Output Returned
SDSBLSubledger (F4211)For optional load of SBL
SDSBLTSubledger Type (F4211)For optional load of SBLT
SDCADCCash Discount PercentFuture -For Tax Calculator
SDEXR1Tax Explanation Code1For Tax Calculator
SDTXA1Taxable Area 1For Tax Calculator
SDTAX1Taxable Y/N flagFor Tax Calculator
SDAEXPExtended AmountFor Tax Calculator
SDFEAExtended Amount - ForeignFor Tax Calculator
SDUORGTransaction QuantityFor Tax Calculator
SDSOCNCancelled QuantityFor Tax Calculator
SDITMItem Number -Short IDFor Tax Calculator and load of EXR and optional load of SBL
SDLITMItem Number - 2ndFor load of EXR
SDAITMItem Number - 3rdFor load of EXR
SDSOQSQuantity ShippedFor Tax Calculator
SDTRDJTransaction DateFor Tax Calculator
SDPTCPayment Terms CodeFor Tax Calculator
SDAN8Sold To address numberFor optional load to Cost Center and optional load of SBL
SDSHANShip To address numberFor optional load of SBL
SDDOCOSales Order NumberFor optional load of SBL
SDSLSMSalesperson 1For option load of SBL
SFXPay ItemFor F0911EditLine
SDLNIDLine IdFor F0911EditLine
IMDSC1Item Desc (F4101)For optional load of EXR
SDDSC1Item DescFor optional load of EXR
SDEMCUHeader Cost CenterUsed to retrieve the Revenue Cost Center's Company
SDCODetail CompanyFor optional load of CO
SDMCUDetail Cost CenterFor optional load of MCU
SHCOHeader CompanyFor optional load of CO
SHCRRMHeader Currency ModeFor F0911EditLine
SDCRRExchange RateFor F0911EditLine
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cGLInterface | GLI | char | NONE | NONE |
A code that indicates whether the system reflects the monetary amount or unit value of any activity containing this order line type in the
| ||||
cInventoryInterface | IVI | char | NONE | NONE |
A code that identifies the type of interface to the Inventory Management system. Valid values are:
Y The dollar or unit value of any activity
| ||||
szGLClassCode | GLC | char | NONE | NONE |
| ||||
cGLExplanationCode | PRIM | char | NONE | NONE |
| ||||
cShortItemSymbol | SYM1 | char | NONE | NONE |
Special Input Expected
| ||||
c2ndItemSymbol | SYM2 | char | NONE | NONE |
| ||||
c3rdItemSymbol | SYM3 | char | NONE | NONE |
| ||||
szSubledger | SBL | char | NONE | NONE |
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 | NONE | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
cCurrencyConversionFlag | CRYR | char | NONE | NONE |
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use:
Codes are:
N Do not
| ||||
cGLCostCenterSelectionValue | EV03 | char | NONE | NONE |
| ||||
cBypassUpdateF0311 | EV06 | char | NONE | NONE |
| ||||
cInterbranchOrder | EV15 | char | NONE | NONE |
| ||||
cIncInCashDiscount | CDSC | char | NONE | NONE |
A code indicating whether the system includes the extended monetary amount of the transaction in the cash discount or payment terms
| ||||
mnCshDsctPercent | CADC | MATH_NUMERIC | NONE | NONE |
A discount which is passed forward from the manufacturer or mill to the customer based upon the payment terms of the supplier. Enter 10
| ||||
szTaxExpCode | EXR1 | char | NONE | NONE |
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
| ||||
szTaxableArea | TXA1 | char | NONE | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
cTaxableFlag | TAX1 | char | NONE | NONE |
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
| ||||
mnExtendedAmount | AEXP | MATH_NUMERIC | NONE | NONE |
The number of units multiplied by the unit price. | ||||
mnExtendedAmountForeign | FEA | MATH_NUMERIC | NONE | NONE |
The product of the foreign price times the number of units. | ||||
mnTransactionQuantity | UORG | MATH_NUMERIC | NONE | NONE |
ab ab
| ||||
mnCancelledQuantity | SOCN | MATH_NUMERIC | NONE | NONE |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
| ||||
mnItemNumberShortID | ITM | MATH_NUMERIC | NONE | NONE |
ab ab load of SBL
| ||||
szItemNumber2nd | LITM | char | NONE | NONE |
ab
| ||||
szItemNumber3rd | AITM | char | NONE | NONE |
ab ab ab
| ||||
mnQuantityShipped | SOQS | MATH_NUMERIC | NONE | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
jdTransactionDate | TRDJ | JDEDATE | NONE | NONE |
ab ab ab
| ||||
szPaymentTermsCode | PTC | char | NONE | NONE |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
mnSoldToAddressnumber | AN8 | MATH_NUMERIC | NONE | NONE |
ab ab
| ||||
mnShipToAddressNumber | SHAN | MATH_NUMERIC | NONE | NONE |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
mnSalesOrderNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
mnSalesperson | SLSM | MATH_NUMERIC | NONE | NONE |
The first of two salespeople who have responsibility for or can receive a commission on sales to this customer.
You create this code by
| ||||
szPayItem | SFX | char | NONE | NONE |
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has
| ||||
mnLineId | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szItemDescF4101 | DSC1 | char | NONE | NONE |
ab ab ab
| ||||
szItemDesc | DSC1 | char | NONE | NONE |
ab ab ab ab
| ||||
szHeaderCostCenter | EMCU | char | NONE | NONE |
A business unit is an accounting entity required for management reporting. It can be a profit center, department, warehouse location, job,
| ||||
szDetailCompany | CO | char | NONE | NONE |
ab ab ab
| ||||
szDetailCostCenter | MCU | char | NONE | NONE |
ab ab
| ||||
szHeaderCompany | CO | char | NONE | NONE |
ab ab
| ||||
cHeaderCurrencyMode | CRRM | char | NONE | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
mnExchangeRate | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
szHeaderCostCenterF4201 | MCU | char | NONE | NONE |
ab
| ||||
szRevenueCompany | CO | char | NONE | NONE |
| ||||
szGLOffset | GLC | char | NONE | NONE |
ab ab ab ab ab
| ||||
szSalesOrderType | DCTO | char | NONE | NONE |
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
| ||||
mnExtendedCost | ECST | MATH_NUMERIC | NONE | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mnExtendedCostForeign | FEC | MATH_NUMERIC | NONE | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
mnUnitPrice | UPRC | MATH_NUMERIC | NONE | NONE |
The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table
| ||||
mnUnitPriceForeign | FUC | MATH_NUMERIC | NONE | NONE |
Amount - Foreign Unit Cost | ||||
szExplanation | VC30A | char | NONE | NONE |
| ||||
szTempGLCode | GLC | char | NONE | NONE |
| ||||
szTempSalesOrderType | DCTO | char | NONE | NONE |
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
| ||||
mnAROffsetForeign | ACR | MATH_NUMERIC | NONE | NONE |
ab ab
| ||||
mnAROffsetDomestic | AA | MATH_NUMERIC | NONE | NONE |
Special Input Expected
| ||||
mnNonRecovGSTDomestic | AGST | MATH_NUMERIC | NONE | NONE |
An amount should be entered here when state taxes on supplemental pay are to be calculated using aggregation methods. | ||||
mnDiscountAvailableDomestic | ADSC | MATH_NUMERIC | NONE | NONE |
The amount of the invoice or voucher pay item that is eligible to be subtracted from the gross amount when the transaction is paid. The
| ||||
mnDiscountAvailableForeign | CDS | MATH_NUMERIC | NONE | NONE |
The foreign amount of the discount available as opposed to the amount of the discount actually taken. | ||||
mnTaxableDomAmount | ATXA | MATH_NUMERIC | NONE | NONE |
The amount on which taxes are assessed. | ||||
mnTaxableForAmount | CTXA | MATH_NUMERIC | NONE | NONE |
That portion of the sale that is subject to tax in foreign currency. | ||||
mnTaxAmountDomestic | MATH01 | MATH_NUMERIC | NONE | NONE |
| ||||
mnTaxAmountForeign | MATH01 | MATH_NUMERIC | NONE | NONE |
| ||||
mnTaxAmtPostProgram | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
mnTaxCalculatorParm | ITM | MATH_NUMERIC | NONE | NONE |
| ||||
cSummaryDetailFlag | TAXL | char | NONE | NONE |
An option that specifies whether the system calculates taxes and performs rounding for sales orders at the detail level or the order level.
| ||||
mnNonRecovGSTForeign | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
cWriteJournalUnits | UNGL | char | NONE | NONE |
A code that indicates whether the system moves units to the general ledger after the system records a journal entry from the following
| ||||
cGLInterFlagGeneral | GLPO | char | NONE | NONE |
A code that indicates whether inventory transactions that are processed through this branch/plant create general ledger entries.
In
| ||||
szDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
mnTotalTaxAmtDomestic | MATH01 | MATH_NUMERIC | NONE | NONE |
| ||||
mnTotalTaxAmtForeign | MATH01 | MATH_NUMERIC | NONE | NONE |
| ||||
mnJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
| ||||
szErrorMessage | DTAI | char | NONE | NONE |
Special Input Expected
| ||||
cSubledgerSelection | EV14 | char | NONE | NONE |
| ||||
cErrorCode | ERRC | char | NONE | NONE |
Special Input Expected
| ||||
cF0911DocType | EV01 | char | NONE | NONE |
ab ab ab ab
| ||||
cWriteAROffset | EV07 | char | NONE | NONE |
| ||||
szVersion | VL01 | char | NONE | NONE |
The list of selection values associated with a data selection item in the Dream Writer. This list is generated by the use of the *VALUES
| ||||
mnUnitCostBeforeMarkup | TCST | MATH_NUMERIC | NONE | NONE |
This is the cost of transferring inventory from one branch to another. The method of calculating this transfer cost is maintained in the Inter
| ||||
mnSTJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
| ||||
szTransUOMFrom | UOM | char | NONE | NONE |
| ||||
szPrimaryUOMTo | UOM1 | char | NONE | NONE |
| ||||
szStdUOMConversion | TFLA | char | NONE | NONE |
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:
blank Use the item-specific
| ||||
szLot | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
szOriginalOrderType | OCTO | char | NONE | NONE |
This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher
| ||||
szRelatedItemNumber | RLIT | char | NONE | NONE |
If an individual item of inventory is sold as a component of a kit or assembly (single level bill-of-materials), the item number of that kit is the
| ||||
szTransactionUOM | UOM4 | char | NONE | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. | ||||
szUnitPriceUOM | APUM | char | NONE | NONE |
The basic measurement abbreviation used to designate the quantity of an inventory item.
Examples are:
BA bale
LB - pound
BG bag
| ||||
cAdvPricing | ADVP | char | NONE | NONE |
Indicates how the system determines the price of items within your system. If your system includes the advanced pricing module, you may
| ||||
mnListPrice | LPRC | MATH_NUMERIC | NONE | NONE |
The list price in the unit of measure of the base price retrieved from the Base Price File (F4106). This is the price the customer would pay if
| ||||
mnListPriceForeign | FPRC | MATH_NUMERIC | NONE | NONE |
The list price in the unit of measure of the base price retrieved from the Base Price File (F4106). This is the price the customer would pay if
| ||||
szOrigOrderNumber | OORN | char | NONE | NONE |
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document
| ||||
cPriceOverrideCode | PROV | char | NONE | NONE |
A value established by the sales order entry program whenever a unit or extended price is entered into an order line item, overriding the
| ||||
szKeyCompany | KCOO | char | NONE | NONE |
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 | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnParentAddress | PA8 | MATH_NUMERIC | NONE | NONE |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
cGLSumBatchLvlInvCogsYN | EV20 | char | NONE | NONE |
| ||||
mnGLSummJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
| ||||
cGLSummDocChangedYN | EV21 | char | NONE | NONE |
| ||||
mnGLSummFromJELineNo | JEL0 | MATH_NUMERIC | NONE | NONE |
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry for inquiry purposes. | ||||
mnGLSummToJELineNo | JEL1 | MATH_NUMERIC | NONE | NONE |
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry for inquiry purposes. | ||||
cSalesFlexAccountingFlag | EV09 | char | NONE | NONE |
| ||||
mnSalesFlexAcctJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
| ||||
idPPATWorkField | GENLNG | ID | NONE | NONE |
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | NONE | NONE |
| ||||
mnGLSummBatchNumber | ICU | MATH_NUMERIC | NONE | NONE |
| ||||
mnInterbranchBatchNumber | ICU | MATH_NUMERIC | NONE | NONE |
| ||||
mnQuantityConvToPrimary | PCNT | MATH_NUMERIC | OPT | NONE |
The number of units counted in the primary units of measure. | ||||
szComputerID | CTID | char | OPT | NONE |
mnNonTaxableAmt | ATXN | MATH_NUMERIC | OPT | NONE |
The amount upon which taxes are not assessed. This is the portion of the transaction not subject to sales, use, or VAT taxes because the
| ||||
mnForeignNonTaxableAmt | CTXN | MATH_NUMERIC | OPT | NONE |
The foreign amount associated with this document which is not subject to sales, use or value-added tax due to the nature of the transaction
| ||||
mnUnroundedTaxAmount | STAM | MATH_NUMERIC | OPT | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). | ||||
cBulkPackedFlag | BPFG | char | OPT | NONE |
A code that indicates if the item is a bulk liquid product. If it is a bulk product, you must perform temperature and density/gravity
| ||||
szUnitOfMeasureSecondary | UOM2 | char | OPT | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
szUnitOfMeasurePurchas | UOM3 | char | OPT | NONE |
A code (table 00/UM) that identifies the unit of measure in which you usually purchase the item. | ||||
szUnitOfMeasureShipping | UOM6 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually ship the item. | ||||
mnQuantityConvertedSecondary | QTY | MATH_NUMERIC | OPT | NONE |
The number of units associated with an asset. | ||||
mnQuantityConvertedPurchasing | QTY | MATH_NUMERIC | OPT | NONE |
The number of units associated with an asset. | ||||
mnQuantityConvertedShipping | QTY | MATH_NUMERIC | OPT | NONE |
The number of units associated with an asset. | ||||
mnQuantityConvertedPricing | QTY | MATH_NUMERIC | OPT | NONE |
The number of units associated with an asset. | ||||
mnConversionFactor | CONV | MATH_NUMERIC | OPT | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
mnAmountUnitCost | UNCS | MATH_NUMERIC | OPT | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnAmountUnitCostForeign | FUC | MATH_NUMERIC | OPT | NONE |
Amount - Foreign Unit Cost | ||||
mnReCalcAmountExtendedPrice | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
mnReCalcAmountForeignExtPrice | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
cTempGainLoss | GNLS | char | OPT | NONE |
The name of the call queue group. You assign calls to groups of people that work to resolve a customer problem. | ||||
cSalesOrderStatus12 | SO12 | char | OPT | NONE |
Future use. | ||||
cUpdateGeneralLedger | UPGL | char | OPT | NONE |
Indicates when the system updates the general ledger. Valid values are:
Y Journal entries will be written as soon as the quantity moves
| ||||
cSalesOrderStatus02 | SO02 | char | OPT | NONE |
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
| ||||
cForeignDepot | OT3Y | char | OPT | NONE |
A code that indicates whether another company owns the branch/plant. The Bulk and Packed Load Confirmation programs use this code to
| ||||
cProofOrFinalMode | EV04 | char | OPT | NONE |
PeopleSoft event point processing flag 04. | ||||
mnJobnoToTaxCalculator | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
cVertexIsOnOrNot | VVTX | char | OPT | NONE |
This flag determines whether to use the Vertex Tax Compliance system for tax calculations. Values are:
Y
Use Vertex system to calculate
| ||||
szVertexGlClassCode | GLC | char | OPT | NONE |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
cIntercompanyOrder | SO11 | char | OPT | NONE |
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
| ||||
cFreightAllocationsFlag | TV05 | char | OPT | NONE |
This flag is used in conjunction with miscellaneous order detail lines. This flag is set to 1 by P49510 and P49530 so that the system does not
| ||||
mnAmtCustomerFreightCharge | FRCC | MATH_NUMERIC | OPT | NONE |
The amount of freight for this order line to be charged to the customer. | ||||
mnAmtForeignFreightCharge | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
cSummaryLevelTaxCalculation | TAXL | char | OPT | NONE |
An option that specifies whether the system calculates taxes and performs rounding for sales orders at the detail level or the order level.
| ||||
cManufacturingRecord | SO16 | char | OPT | NONE |
An option that indicates that a record is created by the Variance Journal Entries program (R31804). | ||||
mnProjectNumber | PRJM | MATH_NUMERIC | OPT | NONE |
A number that identifies an EPM project in the system. The project must be set up in the Add/Revise Project program (P31P011). | ||||
mnAmtToDistribute | AD | MATH_NUMERIC | OPT | NONE |
The balance or amount due on an open invoice or voucher. In the Address Book Master file (F0101), this is a memo amount field used to
| ||||
mnAmtToDistributeFor | CTAD | MATH_NUMERIC | OPT | NONE |
For a journal entry with VAT, this represents the amount to be expensed in foreign currency. | ||||
mnNonRecoverableTaxAmt | NRTA | MATH_NUMERIC | OPT | NONE |
The portion of the tax amount for which you cannot take a credit. | ||||
mnForeignNonRecoverableTax | FNRT | MATH_NUMERIC | OPT | NONE |
The portion of the foreign tax amount for which you cannot take a credit. | ||||
cConfigHubMethod | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szCostCenterProjectNumber | MCUS | char | OPT | NONE |
Either a subsequent business unit or a project number.
A subsequent business unit specifies where to charge costs (or revenues) when the
| ||||
jdInvoiceDate | IVD | JDEDATE | OPT | NONE |
The date the invoice was printed. The system updates this date when you run the invoice print program in the Sales Order Management
| ||||
mnBeginDocUniqueID | BDID | MATH_NUMERIC | OPT | NONE |
This field is a unique ID for the G Batch Begin Doc work file. | ||||
cPOFinalModeYN | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
szPurchaseOrder | PO | char | OPT | NONE |
A document that authorizes the delivery of specified merchandise or the rendering of certain services. | ||||
jdServiceDate | SVD | JDEDATE | OPT | NONE |
The date that the service for which the employee submits a claim was rendered.
For example, the date in this field could be the date that
|
B0000283 Calculate Discount Amount No Tax | ||||
B0100011 Error Message Processor to PPAT System | ||||
B0900049 Journal Entry | ||||
B3003130 F30026 Cost Components Cache | ||||
B4000050 Load and Retrieve Vertex Cache | ||||
B4000150 Get Branch Constants | ||||
B4000350 Retrieve Distribution AAI | ||||
B4000520 Get Item UoM Conversion Factor | ||||
B4001050 Get Branch Constants Fields | ||||
B4001090 Tax Calculator | ||||
B4200230 F4074 Maintain Price History | ||||
B4500090 F4074 Price Adjustment Ledger Server | ||||
BLM0079 Set Level - Line Level Errors | ||||
BLM0081 Set Level - G/L Detail Line Level Errors | ||||
N41B0160 Verify and Get Bulk Information | ||||
N41B0450 Get Bulk / Transaction Quantity | ||||
N41B0460 Calculate Extended Price for Bulk Orders | ||||
N7300001 Determine if Quantum is Active | ||||
X0005 Get User Defined Codes | ||||
X4101 Validate and Retrieve Item Master | ||||
XF4105 Item Cost I/O |
F1609 Cost Management Constants | ||||
F4074 Price Adjustment Ledger File | ||||
F41021 Item Location File | ||||
F49211 Sales Order Detail File - Tag File |