1 Functional Description
2.1 Purpose
Depending on the mode this function will:
Mode A: Insert F1602Z1 record using all parameters passed in.
Mode C: Update F1602Z1 using all parameters passed in.
Mode F: Fetch F1602Z1 record using EDI User ID, EDI Batch Number, EDI Transaction Number and EDI
Line number
Mode D: Delete F1602Z1 record using EDI User ID, EDI Batch Number, EDI Transaction Number and EDI
Line number
2.2 Setup Notes and Prerequisites
None.
2.3 Special Logic
None.
2 Technical Specifications
2.4Processing
D1600270 - F1602Z1 File Server
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szEdiUserId | EDUS | char | REQ | BOTH |
The source of the transaction. This can be a user ID, a workstation, the address of an external system, a node on a network, and so on. This
| ||||
szEdiBatchNumber | EDBT | char | REQ | BOTH |
The number that the transmitter assigns to the batch. During batch processing, the system assigns a new batch number to the PeopleSoft
| ||||
szEdiTransactNumber | EDTN | char | REQ | BOTH |
The number that an Electronic Data Interchange (EDI) transmitter assigns to a transaction. In a non-EDI environment, you can assign any
| ||||
mnEdiLineNumber | EDLN | MATH_NUMERIC | REQ | NONE |
This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any
| ||||
szEdiDocumentType | EDCT | char | OPT | NONE |
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
| ||||
szTypeTransaction | TYTN | char | OPT | NONE |
The qualifier used to identify a specific type of transaction. | ||||
szEdiTranslationFormat | EDFT | char | OPT | NONE |
The qualifier used to identify a specific mapping structure used to process both inbound and outbound EDI transactions. This does not
| ||||
jdEdiTransmissionDate | EDDT | JDEDATE | OPT | NONE |
The specific date that an EDI transaction was either transmitted or received. | ||||
cDirectionIndicator | DRIN | char | OPT | NONE |
A code that indicates whether the transaction is inbound or outbound. | ||||
mnEdiDetailLinesProcess | EDDL | MATH_NUMERIC | OPT | NONE |
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
| ||||
cEdiSuccessfullyProcess | EDSP | char | OPT | NONE |
An option that indicates whether a record has been successfully processed. Depending on the application, the system updates the EDSP
| ||||
szTradingPartnerId | PNID | char | OPT | NONE |
Field used in an EDI transaction to identify the party that is trading document with you. | ||||
szTransactionAction | TNAC | char | OPT | NONE |
A code that indicates the activity you want to perform on the transaction. In an EDI transaction, this code represents the Transaction Set
| ||||
cEDIType | EDTY | char | OPT | NONE |
The identifier used to mark EDI transaction records as header and detail information. This is an EDI function only. | ||||
mnEDISeq | EDSQ | MATH_NUMERIC | OPT | NONE |
An identifier that is used to assign the relative position within the header or detail information of an EDI transaction-- for example, H01, H02,
| ||||
szEdiTransSet | EDTS | char | OPT | NONE |
The qualifier used to identify a specific type of EDI transaction. | ||||
cEdiSendRcvIndicator | EDER | char | OPT | NONE |
Indicator used to identify if a specific transaction set can be sent, received or both. Valid values are: S Send R Receive B Both | ||||
cEdiTransactionAction | EDTC | char | OPT | NONE |
Code that identifies what the system should do with a transaction during final processing. Valid codes are:
A Add a new transaction
D
| ||||
cEdiTransactionType | EDTR | char | OPT | NONE |
Code that identifies a particular kind of transaction. The originator assigns this code to specify a voucher (V), invoice (I), journal entry (J) and
| ||||
cEdiCreateGl | EDGL | char | OPT | NONE |
A flag in the batch file that indicates whether you want the system to create a general ledger record at the time the invoice or voucher is
| ||||
cBatchFileDiscountHandlin | EDDH | char | OPT | NONE |
A flag in the batch file that indicates how the discount should be calculated.
Valid values are:
0 Use the Payment Terms for calculation.
1
| ||||
mnUserAddressNumber | EDAN | MATH_NUMERIC | OPT | NONE |
An address number assigned by the transmitter. This is used primarily for connecting a new Address Book number on the PC with
| ||||
mnViewNumber | VWNM | MATH_NUMERIC | OPT | NONE |
A number from 1 to 10 that specifies how the system posts records from the Account Ledger table (F0911) to the Cost Analyzer Balances
| ||||
szActivityCode | ACTB | char | OPT | NONE |
The aggregation of actions performed within an organization that are useful for purposes of activity-based costing. | ||||
szAccountId | AID | char | OPT | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
mnCenturyFiscalYear | CFY | MATH_NUMERIC | OPT | NONE |
A field used to store the century concatenated with the fiscal year. | ||||
szLedgerType | LT | char | OPT | NONE |
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
| ||||
szSubledger | SBL | char | OPT | 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 | OPT | 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
| ||||
szManagerialAnalysisCode1 | ABR1 | char | OPT | NONE |
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify
| ||||
cManagerialAnalysisType1 | ABT1 | char | OPT | NONE |
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can
| ||||
szManagerialAnalysisCode2 | ABR2 | char | OPT | NONE |
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify
| ||||
cManagerialAnalysisType2 | ABT2 | char | OPT | NONE |
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can
| ||||
szManagerialAnalysisCode3 | ABR3 | char | OPT | NONE |
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify
| ||||
cManagerialAnalysisType3 | ABT3 | char | OPT | NONE |
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can
| ||||
szManagerialAnalysisCode4 | ABR4 | char | OPT | NONE |
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify
| ||||
cManagerialAnalysisType4 | ABT4 | char | OPT | NONE |
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can
| ||||
mnIdentifierShortItem | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
mnAmtBeginningBalancePy | APYC | MATH_NUMERIC | OPT | NONE |
The cumulative prior year-end balance. The system uses this amount as the beginning balance for balance sheet and job cost
| ||||
mnAmountNetPosting001 | AN01 | MATH_NUMERIC | OPT | NONE |
A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting002 | AN02 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting003 | AN03 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting004 | AN04 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting005 | AN05 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting006 | AN06 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting007 | AN07 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting008 | AN08 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting009 | AN09 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting010 | AN10 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting011 | AN11 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting012 | AN12 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting013 | AN13 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting014 | AN14 | MATH_NUMERIC | OPT | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnNetBalance001 | NB01 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance002 | NB02 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance003 | NB03 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance004 | NB04 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance005 | NB05 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance006 | NB06 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance007 | NB07 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance008 | NB08 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance009 | NB09 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance010 | NB10 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance011 | NB11 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance012 | NB12 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance013 | NB13 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
mnNetBalance014 | NB14 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
cAssignmentFlag | ASMF | char | OPT | NONE |
This field indicates whether this record in the Cost Analyzer Balance table (F1602) has been affected by an assignment. | ||||
mnAmountWtd | AWTD | MATH_NUMERIC | OPT | NONE |
The net amount from the week-to-date postings for an account. | ||||
mnAmtOriginalBeginBud | BORG | MATH_NUMERIC | OPT | NONE |
Field that tracks amounts for an annual budget amount by ledger type in the Account Balances file (F0902). | ||||
mnBudgetRequested | BREQ | MATH_NUMERIC | OPT | NONE |
A code that specifies the ledger type with which to track amounts in the Account Balances table (F0902). Valid values are:
| ||||
mnBudgetApproved | BAPR | MATH_NUMERIC | OPT | NONE |
This field tracks the following amounts in the Account Balances file (F0902):
Ledger type - BA/BU. Approved Budget from Budget by
| ||||
szCostCenter | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szObjectAccount | OBJ | char | OPT | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szSubsidiary | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szCurrencyCodeDenom | CRCX | char | OPT | NONE |
A code that indicates the currency in which an amount is denominated. | ||||
cMode | EV01 | char | REQ | INPUT |
An option that specifies the type of processing for an event. |
None |
None |