FBYETR – No description in the Lawson data dictionary
- System
- General Ledger (GL)
- Prefix
FBY- Primary key
FLT-OBJ-ID,GOX-OBJ-ID- Fields
- 21
- Updated by
- 325 programs
- Referenced by
- 57 programs
FBYETR is a Lawson General Ledger table (prefix FBY); no description in the lawson data dictionary. It is indexed by FLT-OBJ-ID, GOX-OBJ-ID (FBYSET1); alternate indexes: FBYSET2 and FBYSET3. It is updated by AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 and 317 more and referenced by FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 and 49 more. The table has 21 fields, 3 indexes and 0 documented relations.
About FBYETR
No description in the Lawson data dictionary.
Fields (21)
Column = COBOL field name without the FBY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#FBY-COMPANY SET3COMPANY | Numeric 4 | — | GL197 |
#FBY-ACCT-UNIT SET3ACCT_UNIT | Alpha 15 | — | GL197 |
#FBY-ACCOUNT SET3ACCOUNT | Numeric 6 | — | GL197 |
#FBY-SUB-ACCOUNT SET3SUB_ACCOUNT | Numeric 4 | — | GL197 |
#FBY-FLT-OBJ-ID PKFLT_OBJ_ID | Numeric 12 | — | GL197 |
#FBY-GOX-OBJ-ID PKGOX_OBJ_ID | Numeric 12 | — | GL197 |
#FBY-VAR-LEVELSVAR_LEVELS | Alpha 30 | — | GL197 |
#FBY-AMOUNTAMOUNT | Signed 18.2 | — | AP125, AP126, AP131, AP170, AP190, AP193, AP21.1, AP23.1 +52 more (list truncated in source) |
#FBY-UNITUNIT | Signed 15.2 | — | GL197 |
#FBY-CREATED-YEAR SET3CREATED_YEAR | Numeric 4 | — | GL197 |
#FBY-CREATED-PERIODCREATED_PERIOD | Numeric 2 | — | GL197 |
#FBY-TRANS-DATETRANS_DATE | Numeric 8 (yyyymmdd) | — | GL197 |
#FBY-SOURCE-CODESOURCE_CODE | Alpha 2 | — | GL197 |
#FBY-CURR-YR-TRCURR_YR_TR | Alpha 1 | — | AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source) |
#FBY-COMMIT-AMTCOMMIT_AMT | Signed 18.2 | — | AP125, AP126, AP131, AP170, AP190, AP193, AP21.1, AP23.1 +52 more (list truncated in source) |
#FBY-INVOICEINVOICE | Alpha 22 | — | GL197 |
#FBY-ITEMITEM | Alpha 32 | — | GL197 |
#FBY-RESOURCE-COMPRESOURCE_COMP | Numeric 4 | — | GL197 |
#FBY-RESOURCE-CODERESOURCE_CODE | Alpha 10 | — | GL197 |
#FBY-RESOURCE-TYPERESOURCE_TYPE | Alpha 1 | — | GL197 |
#FBY-RESOURCE-DESCRESOURCE_DESC | Alpha 30 (Lower Case) | — | GL197 |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
FBYSET1 |
| Primary | FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 | |
FBYSET2 |
| KeyChange, Subset | Where CURR-YR-TR = "Y" | AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +22 more (list truncated in source) |
FBYSET3 |
| KeyChange | GL298 |
Programs
Updated by (325)
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP170 Payment Closing
- AP190 Invoice Reinstatement
- AP193 Recurring Invoice Update
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP510 Vendor Conversion
- AP520 Invoice Interface
- API1.1 Add Invoice
- API2.1 Add Invoice
- ARLL.1 AR Transaction Interface
- BN150 Life Insurance Reportable Income
- BN66.1 Estimated Pay Calculation
- CB10.1 Cash Receipt Deposit
- CB15.1 Bank Fund Transfer - Multiple Deposits
- CB150 Mass Release
- CB180 Cash Ledger Void Update
- CB191 Bank Statement Close
- CB20.1 Bank Transaction Entry
- CB30.1 Reconciliation Variance Adjustment
- CB45.1 EFT/CC Extract Entry
- CB46.1 Returned Payment Entry
- CB500 Bank Transaction Interface
- CB543 Receipts Load
- CB544 Returned Payment Load
- CB55.1 Payment Entry
- CB554 Payment Load
- CB57.1 Payment Cancel
- CB80.1 Bank Transaction Adjustment
- CB82.1 Statement Reconciliation
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- EE135 Mass Employee Release
- EE35.1 Advance Release
- EE35.2 Expense Release
- EE520 Expense Interface
- EX175 Company Expense Posting
- EX542 Expense Creation
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- FB145 Budget Batch Journal Control
- FB190 Budget Double Entry Posting
- FB40.1 Budget Journal Entry
- FB40.2 Define Budget Journal
- FB40.3 Budget Speed Entry
- FB45.1 Budget Journal Control
- GL170 Recurring Journal Interface
- GL197 Period, Year End GL Commitments Processing
- GL199 Period Closing
- GL70.1 Recurring Journal
- GL70.2 Define Recurring Journal
- GL70.3 Amounts Only
- GL70.5 Filter
- GL70.6 Recurring Copy
- GL75.1 Recurring Journal Control
- GL76.1 Manual Commitment Entry
- IC12.1 Item Location
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- IFGT.1 GLTRANS Interface
- IFUC.1 Commitment Update GL and AC
- LP130 Absence Plan Payout
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- PA182 Salary Encumbrance Update
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO135 Received, Not Invoiced Report
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO18.1 Workflow Approval Maintenance
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO26.2 Vendor Agreement Line Distributions
- PO26.3 Vendor Agreement Commitments Spread
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO26.6 Vendor Agreement Line Maximums
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO536 Vendor Price Agreement Load
- PO54.5 PO Line Detail List
- POCP.1 POC Comments Copy
- POD0.1 Po Orphan Record Check
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POIF.1 MMDIST Activity Commit
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR140 Earnings and Deductions Calculation
- PR189 Gross Up Calculation
- PR195 Accrual Program
- PR197 Payroll Close
- PR29.1 Pension Payment Maintenance
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR38.1 Time Record Selection
- PR45.1 Error Processing
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- PR85.1 Bank Account Reconciliation
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQD0.1 Invoke for RQ Orphan Check
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program
Referenced by (57)
- FB11.1 Budget Edit Group
- FB111 Budget Edit Group Build
- FB160 Budget Edit Group Interface
- FB211 Budget Edit Group Listing
- FB296 Budget Audit
- FB60.1 Budget Edit Group Interface Maintenance
- FB95.1 Budget Analysis
- FB95.2 Account, Period
- FB95.3 Account, Year to Date
- FB95.4 Accounting Unit, Period
- FB95.5 Accounting Unit, Year to Date
- FB95.6 Totals
- GL298 GL Commitment Analysis Report
- GL299 GL and AC History commitment
- GL90.6 Compare Transaction Analysis
- GL94.1 Commitment Analysis
- GL94.2 Account
- GL94.3 Account Totals
- GL94.4 Accounting Unit
- GL94.5 Accounting Unit Totals
- GL94.6 Commitment Account Detail
- GL94.7 Commitment Accounting Unit Detail
- GL95.1 Account Analysis
- GL95.2 Fiscal Year Summary
- GL95.3 Totals
- GL95.4 Chart Query
- GL95.5 Periods versus Year to Date
- GL95.6 Year to Date Current Year versus Last Year
- GL95.7 Periods Current Year versus Last Year
- GL95.8 Year to Date Actual versus Budget
- GL95.9 Periods Actual versus Budget
- GL96.1 Accounting Units
- GL96.2 Year to Date Current Year versus Last Year
- GL96.3 Periods Current Year versus Last Year
- GL96.4 Year to Date Actual versus Budget
- GL96.5 Periods Actual versus Budget
- GL97.1 Accounts
- GL97.2 Year to Date Current Year versus Last Year
- GL97.3 Periods Current Year versus Last Year
- GL97.4 Year to Date Actual versus Budget
- GL97.5 Periods Actual versus Budget
- GL97.6 Year to Date Account Currencies
- GL97.7 Periods Account Currencies
- GL97.8 Fiscal Year Summary
- GL97.9 Totals
- GL98.1 Companies
- GL98.2 Year to Date Current Year versus Last Year
- GL98.3 Periods Current Year versus Last Year
- GL98.4 Year to Date Actual versus Budget
- GL98.5 Periods Actual versus Budget
- GL99.1 Organization Query
- GL99.2 Periods versus Year to Date
- GL99.3 Year to Date Current Year versus Last Year
- GL99.4 Periods Current Year versus Last Year
- GL99.5 Year to Date Actual versus Budget
- GL99.6 Periods Actual versus Budget
- GLRV.1 General Ledger Report