Functional Description
Purpose
This function deletes all Store and Forward invoice records when called from a browse form.
Actions performed for highlighted transaction are:
1) Delete all Store and Forward G/L lines
2) Delete all Store and Forward A/R lines
3) Delete Transaction Control Record
Setup Notes and Prerequisites
None.
Special Logic
None.
Technical Specifications
Parameters
Related Tables
F03B11Z1Invoice Transactions Batch Table (03B)
F0041Z1Transaction Control File
F0911Z1Journal Entry Transactions Batch File
Related Business Functions
None.
Processing
Open F03B11Z1 table.
Load key to F03B11Z1.
Select all records matching the key.
If success,
While idJDBReturn is equal to JDEDB_PASSED,
Delete F03B11Z1 table.
Fetch the next record.
End while
End if
Open F0911Z1 table.
Load key to F0911Z1.
Select all records matching the key.
If success,
While idJDBReturn is equal to JDEDB_PASSED,
Delete F0911Z1 table.
Fetch the nest record.
End while
End if
Open F0041Z1 table.
Load key to F0041Z1.
Select all records matching the key.
If success,
While idJDBReturn is equal to JDEDB_PASSED,
Delete F0041Z1 table.
Fetch the nest record.
End while
End if
Close F03B11Z1 table.
Close F0911Z1 table.
Close F0041Z1 table.
^
D03B0045 - F03B11Z1 Update Store & Forward Invoice Delete
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| szEDIBatchNumber | EDBT | char | NONE | NONE |
The number that the transmitter assigns to the batch. During batch processing, the system assigns a new batch number to the PeopleSoft
| ||||
| szEDITransactionNo | EDTN | char | NONE | NONE |
The number that an Electronic Data Interchange (EDI) transmitter assigns to a transaction. In a non-EDI environment, you can assign any
| ||||
| szEDIUserID | EDUS | char | NONE | NONE |
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
| ||||
| szComputerID | CTID | char | NONE | NONE |
| None |
| F0041Z1 Transaction Control File | ||||
| F03B11Z1 Batch Invoices | ||||
| F0911Z1 Journal Entry Transactions - Batch File |