Composite Keys List
This section lists the composite keys for certain tables that the system converts during the base currency conversion. Use the composite key to create and run a query or batch program over the F0086 table.
Table Name |
Table Number |
Composite Key |
|---|---|---|
Taxes |
F0018 |
For F03B11 and F0411 table conversions: TDDOCO, TDDCTO, TDKCOO, TDSFXO For the F0911 table conversion: TDDOCO, TDDCTO, TDKCOO, TDSFXO, TDLNID |
Customer Ledger |
F03B11 |
RPDOC, RPDCT, RPKCO, RPSFX |
Accounts Payable Ledger |
F0411 |
RPDOC, RPDCT, RPKCO, RPSFX |
Accounts Payable - Matching Document |
F0413 |
RMDOCM, RMDCTM, RMPYE |
Accounts Payable Matching Document Detail |
F0414 |
RNDOC, RNDCT, RNDCTM, RNKCO, RNSFX |
Account Balances |
F0902 |
GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBSBLT, GBCRCD |
Account Balances - 52 Period Accounting |
F0902B |
GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBSBLT, GBCRCD |
Account Ledger |
F0911 |
GLDCT, GLDOC, GLKCO, GLDGJ, GLJELN, GLLT, GLEXTL |
Policy Edit Rules |
F09E108 |
POLICY, EXPTYPE, EFTJ, EXRPTTYP, LOCATN |
Credit Card Transaction Interface |
F09E150 |
CCTN |
Multi-Site Consolidation Transfer |
F1002 |
GQEDBT, GBEDUS, GQEDTN, GQSERK, GQMCU, GQOBJ, GQSUB, GQSBL, GQSBLT, GQCRCD, GQCRCX |
Location Tracking Table |
F1204 |
FMNUMB, FMEFTB, FMAL, FMNNBR |
Equipment License Master |
F1206 |
FHNUMB, FHADDS, FHLNUM |
Equipment Rates |
F1301 |
FGRTTB, FGRTGR, FGNUMB, FGEFTB, FGERC |
Rental Rules |
F1302 |
FKCO, FKMCU |
Equipment Location Billing |
F1304 |
FNTRNN, FNNNBR, FNLOC |
Equipment Analysis Costs |
F1383 |
EQGP, EQSP, SEQ, NUMB, AID, SBL, SBLT, LT, SMTP |
Forecast Basis |
F1403 |
MCU, AID, RVNUM |
Forecast Results - Header |
F1404 |
MCU, AID, RVNUM |
Forecast Results - Detail |
F14041 |
AID, RVNUM, FY, CTRY |
Forecast Growth Patterns |
F1406 |
GRWPC |
Lease Master Header |
F1501B |
DOCO, LSVR |
Tenant E.P. Class Master |
F15012B |
DOCO, LSVR, BCI |
Share Factor Denominator Audit |
F150122A |
ICU, SFDN, ECMP, GLMD, MCUS, MCU, UNIT, MT, CENTYR, ARDEFID |
Sales Overage Master File |
F15013B |
DOCO, LSVR, YEOV |
Product Scales Master |
F15014B |
DOCO, LSVR, YEOV, BCI |
Min/Max Rents And Recoveries Master |
F15015B |
DOCO, LSVR |
Tenant Escalation Master |
F15016B |
DOCO, BCI |
Recurring Billings Master |
F1502B |
DOCO, LNID |
Estimated EP Recurring Billings |
F1502WB |
ICU, DOCO, GLC, MCU, UNIT, BCI, UNGR |
Management Fee Master |
F1505B |
DOCO, MCU, BCI |
Revenue Fee Generation History |
F1505HB |
ICU, BCI, PMFY, BPN, CTRY |
Unit Master |
F1507 |
MCU, UNIT |
Lease Billings Master |
F1511B |
GENT, ICU, DOC, SFX, KCO |
Lease Billings History |
F1511HB |
GENT, DOCO, BPN, YR, CTRY, SOBT |
FASB 13 Lease Control |
F1513B |
DOCO, MCU, UNIT, CTRY, YR, ICU |
Building E.P. Caps |
F15151 |
CAPID, MCU, SEQ |
Lease E.P. Caps |
F15152 |
DOCO, LSVR, BCI, SEQN |
Lease Cap History |
F15153 |
ICU, DOCO, LSVR, BCI, CAPID, CAPLVL, MCU, OBJ, SUB, SBL, SBLT |
Fees and Interest |
F1525B |
FETP, DOCO, AN8, MCU, GLC, LNID, AGSN |
E.P. Class Cap Expenses History |
F15303 |
ICU, CAPID, EPCL, MCU, OBJ, SUB, SBL, SBLT |
Expense Participation Class Adjustment |
F1531 |
EPCL, LNID |
Expense Participation Audit File |
F1532B |
DCT, DOC, DGJ, JELN, ICU, EPCL, AID, LT, SBL, CO |
Tenant Account Exclusions |
F1533B |
DOCO, LSVR, ADJL, ADJTY, EPCL, MCU, UNIT, AID, LVLT, BCI |
EP Billing Register |
F1538B |
DOCO, LSVR, ICU, EPCL, BCI |
Occupancy Gross Up Audit |
F1538B1 |
ICU, DOCO, LSVR, EPCL, BCI, AID, SBL |
Exclusion/Redistribution |
F1538B2 |
ICU, DOCO, LSVR, EPCL, AID, BCI, ELRD |
EP Billing Account Adjustments Audit |
F1539A |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
EP Billing Class Adjustments Audit File |
F1539C |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
EP Billing Account Exclusions Audit |
F1539E |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
EP Billing Adj Factor EP Class Audit |
F1539FC |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
EP Billing Adj Factor Lease Audit |
F1539FL |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
Sales Report Control |
F1540B |
DOCO, MCU, UNIT, DBAN, STNR, AN8, PRDC, LIN, RPRD, YR, CTRY |
Tenant Weekly Sales |
F15410 |
DOCO, MCU, UNIT, DBAN, STNR, PRDC, CTRY, YR |
Tenant Sales History |
F1541B |
DOCO, MCU, UNIT, DBAN, STNR, PRDC, CTRY, YR |
Sales History Work File |
F1541BW |
DOCO, MCU, MCUS, UNIT, DBAN, STNR, ULI, PRDC, CTRY, YR |
Projected Sales |
F1542 |
MCUS, DOCO, MCU, UNIT, DBAN, ULI, PRDC, STNR, CTRY, YR |
Tenant Sales Analysis Reporting File |
F1543B |
SASC, CTRY, YR, RPRD, MCU, AN8, UNIT, DBAN, PRDC, MCUS, CO, DOCO, FLOR, ULI, ULI2, DS40 |
Escalation Billing Register |
F1548B |
DOCO, ICU, BCI |
Security Deposit Master |
F1565 |
DOCO, LNID |
Legal Clause Amounts |
F15703 |
DOCO, AN8, CLNO, SEQN |
Market/Potential/Renewal Rent Master |
F159071 |
MCU, UNIT, RNTY, SEQ |
AREF Building Constants |
F15L100 |
MCU, RVNB |
AREF Building Constants Models |
F15L1001 |
BMCI |
AREF Unit Master |
F15L101 |
MCU, UNIT, RVNB (Release 8.0) MCU, UNIT, RVNB, UKID (Release 8.10 and above) |
AREF Unit Assumptions Master Header |
F15L102 |
MCU, ASSD, RVNB |
AREF Growth Pattern File |
F15L105 |
MCU, GRPA, RVNB |
AREF Base Account Definition |
F15L108 |
MCU, AID, RVNB |
AREF Budget Results |
F15L109 |
MCU, RVNB, AID, CTRY, FY, SBL, SBLT |
AREF Account Status |
F15L110 |
MCU, RVNB, AID, CTRY, FY, SBL, SBLT |
AREF Account Status Detail |
F15L111 |
MCU, RVNB, AID, CTRY, FY, SBL, SBLT, LNID |
AREF Unit Assumptions Master Detail |
F15L112 |
MCU, ASSD, RVNB, LNID |
AREF Sales Overage Detail |
F15L113 |
MCU, RVNB, SOID, SOSQ |
AREF E.P. Rules Detail |
F15L114 |
MCU, EPRD, RVNB, SEQ |
AREF Base Account Definition Detail |
F15L118 |
MCU, AID, RVNB, LNID |
AREF Projected Sales |
F15L301 |
DOCO, MCU, UNIT, RVNB, DBAN, PRDC, CTRY, YR |
AREF Prior Gross Billings |
F15L302 |
CTID, MCU, RVNB, DOCO, UNIT, LNID |
Case Master |
F1755 |
STAW, DOCO, UPMJ, UPMT |
Expense Report Header |
F20111 |
EXRPTTP, EXRPTNUM, EMPLOYID, WRKSTNID, DTECRT |
Expense Report Detail |
F20112 |
EXRPTTP, EXRPTNUM, EMPLOYID, WRKSTNID, DTECRT, LIN, RECTYPE, LNID |
Work Center Rates File |
F30008 |
IWMCU, IWLEDG |
Bill of Materials Changes File |
F3011 |
IZMMCU, IZKIT, IZTBM, IZITM |
DFM Bill of Material Master |
FF30L002 |
FSCID, DFKIT, DFMCU, DFTBM, BQTY, CPNB, SBNT, COBY |
Purge - Shop Floor Parts List |
F3111S |
WMCMCU, WMCPIT, WMCOBY, WMDOCO, WMOPSQ |
Outbound Work Order Parts List |
F3111Z1 |
SZCMCU, SZCPIT, SZCOBY, SZDOCO, SZOPSQ |
Work Order Time Transactions |
F31122 |
WTYST, WTAN8, WTDGL, WTDOCO, WTOPSQ, WTTYR |
Work Order Time Transactions Unedited Transaction Table |
F31122Z1 |
SZYST, SZAN8, SZDGL, SZDOCO, SZOPSQ, SZTYR |
Purge Work Order Time Transactions |
F31122S |
WTYST, WTAN8, WTDGL, WTDOCO, WTOPSQ, WTTYR |
Lean Transaction Parts List |
FF31111 |
UKID |
Lean Transaction Labor Detail |
FF31113 |
UKID |
Production Costs |
FF31200 |
PRODF31, TRSID, ITM, COST, PART |
Cost Groups Detail |
F31B211 |
WCG, LNID |
Blend Lot Costs |
F31B31C |
MCU, WLOTN, WCOST |
Blend Transactions |
F31B66 |
WOPID, LNID |
Rules Table Detail |
F3283 |
$2RRN |
Assembly Inclusion Rules |
F3293 |
KYKIT, KYMCU, KYATOT, KYATO#, KYATOS |
Needed for upgrade from Xe and below |
F32961 |
KLDOCO, KLDCTO, KLKCOO, KLLNID, KLITM, KLMCU, KLATLV |
Forecast File |
F3460 |
MFITM, MFMCU, MFDRQJ, MFTYPF, MFDCTO |
Batch Receiver File - Order Headings |
F4001Z |
SYDOCO, SYDCTO, SYKCOO |
Batch Receiver File - Order Headings |
F4011Z |
SZDOCO, SZDCTO, SZKCOO |
Price Adjustment Ledger File |
F4074 |
ALDOCO, ALDCTO, ALKCOO, ALLNID |
Price Variable Table |
F4075 |
VBVBT, VBEFTJ |
Grower Block |
F40G02 |
BLUID |
Grower Harvest |
F40G03 |
WVID |
Harvest Estimate Freeze Detail |
F40G032 |
FRZID, TYPEHB, WVID, UPLNMAT, LNID |
Crush and Purchase Report Details |
F40G150 |
WVID |
Item Cost File |
F4105 |
COITM, COMCU, COLOCN, COLOTN, COLEDG |
Average Cost Work file |
F41051 |
CHITM, CHMCU, CHLOCN, CHLOTN |
Item Ledger File |
F4111 |
ILDOC, ILDCT, ILKCO |
Item ASOF File |
F41112 |
INITM, INMCU, INLOCN, INGLPT, INCTRY, INFY |
Item History |
F4115 |
IHITM, IHMCU, IHCTRY, IHFY |
Container Deposit File |
F4118 |
CNCO, CNMCU, CNAN8, CNITM, CNRORN, CNRCTO |
Container Transaction File |
F41181 |
CMCO, CMMCU, CMAN8, CMITM, CMDOCO, CMDCTO |
Cycle Count Transaction File |
F4141 |
PJITM, PJMCU, PJLOCN, PJLOTN |
Item Cost Components |
F41291 |
IGPRP5, IGITM, IGMCU, IGLVLA, IGEFFT |
Sales Order Header File |
F4201 |
SHDOCO, SHDCTO, SHKCOO, SHSFXO |
Price by Item |
F4207 |
PMPCTY, PMMCAT, PMCLV, PMCXPJ |
Sales Order Detail File |
F4211 |
SDDOCO, SDDCTO, SDKCOO, SDLNID |
S.O. Detail Ledger File |
F42199 |
SLDOCO, SLDCTO, SLKCOO, SLLNID |
Commission Constants File |
F42004 |
CMAN8, CMDCTO, CMCCTY, CMCXPJ |
Sales Commission File` |
F42005 |
SCDOCO, SCDCTO, SCKCOO, SCLNID |
Order Hold Constants |
F42008 |
HCMCU, HCHCOD |
Sales Summary History File |
F4229 |
SSAN8, SSMCU, SSDCTO, SSITM, SSLNTY, SSSRP1, SSSRP2, SSSRP3, SSSEP4, SSSPR5, SSSSFY |
Purchase Order Header |
F4301 |
PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
Supplier/Item Relationships |
F43090 |
PCAN8, PCMCU, PCITM |
P.O. Detail Ledger File - Flexible Version |
F43199 |
OLDOCO, OLDCTO, OLKCOO, OLSFXO, OLLNID, OLNLIN, OLCORD, OLUPMJ, OLTDAY |
Purchase Order Detail |
F4311 |
PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
Purchase Order Detail File |
F4311T |
PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
Purchase Order Receiver File |
F43121 |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRMCU, PRLNID, PRNLIN, PRDOC |
Purchase Order Receiver Tag File |
F43121T |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRMCU, PRLNID, PRNLIN, PRDOC |
Purchase Order Receiver Multiple Account |
F43126 |
P4MATC, P4DOCO, P4DCTO, P4KCOO, P4SFXO, P4LNID, P4NLIN, P4DLIND, P4DOC |
Purchase Order Receiver Multiple Account Tag File |
F43126T |
P4MATC, P4DOCO, P4DCTO, P4KCOO, P4SFXO, P4LNID, P4NLIN, P4DLIND, P4DOC |
Purchase Order Receiver Tag Table |
F43121TB |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRSFXO, PRLNID, PRNLIN, P4DOC |
Purchase Order Receiver Non-Billable |
F43127 |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRSFXO, PRLNID, PRNLIN, PRDLIND, PRNBACTY, PRDOC |
Purchase Order Multiple Account File |
F4316 |
DOCO, DCTO, KCOO, SFXO, LNID, AID, SBLT, SBL, DGL |
Purchase Order Multiple Account Tag File |
F4316T |
DOCO, DCTO, KCOO, SFXO, LNID, DLNID |
Purchase Order Detail Non-Billable |
F4317 |
DOCO, DCTO, KCOO, SFXO, LNID, NBACTY, DLNID, AID |
Purchasing Tolerance Rules |
F4322 |
PZFNTY, PZITM, PZPRP1, PZCO |
Multiple Requisition File |
F4332 |
P2DOCO, P2DCTO, P2KCOO, P2LNID, P2OORN, P2OCTO, P2OKCO, P2OGNO |
Purchase Rebate History |
F4343 |
RHAN8, RHAGSQ, RHDCTO, RHDOCO, RHKCOO, RHLNID |
Contract Header |
F43C01 |
CNTRTID |
Contract Block |
F43C10 |
CNTRTID, BLUID |
Contract Detail |
F43C11 |
CNTRTID, CNTRTDID |
Assessment Donations |
F43C30 |
ADADUKID |
Requisition Order Header |
F43E01 |
DOCO, DCTO, KCOO |
Requisition Detail |
F43E11 |
DOCO, DCTO, KCOO, SFXO, LNID |
Requisition Multiple Account File |
F43E16 |
DOCO, DCTO, KCOO, SFXO, DLNID |
Shopping Cart Detail |
F43E20 |
USER, LNID |
Event Header |
F43Q10 |
EVNU, DCTO, KCOO |
Event Detail |
F43Q11 |
EVNU, DCTO, KCOO, EVLN |
Event Header Bid Questions |
F43Q20 |
EVNU, DCTO, KCOO, BIDQN |
Event Detail Bid Questions |
F43Q21 |
EVNU, DCTO, KCOO, EVLN, BIDQN |
F43Q40 |
F43Q40 |
EVNU, DCTO, KCOO, BIDNUM, AN8 |
Response Header Question |
F43Q401 |
EVNU, DCTO, KCOO, BIDNUM, BIDQN, AN8 |
Response Line |
F43Q41 |
EVNU, DCTO, KCOO,EVLN,BIDNUM, AN8 |
Response Detail Question |
F43Q411 |
EVNU, DCTO, KCOO,EVLN,BIDNUM,BIDQN, AN8 |
Response Detail Question Price Break |
F43Q412 |
EVNU, DCTO, KCOO,EVLN,BIDNUM,BIDQN, AN8, TRNB |
Response Detail Question Price Components |
F43Q413 |
EVNU, DCTO, KCOO,EVLN,BIDNUM,BIDQN, AN8, PCPTN |
Analyze Event Detail |
F43Q51 |
EVNU, DCTO, KCOO,EVLN, AN8, BIDNUM, AWARDNUM |
Bid Questions |
F43Q60 |
BIDCODE, CMDCDE, ITM |
Community Phase Master |
F44H101 |
HBMCUS,CPHASE |
Lot Master |
F44H201 |
HBMCUS,HBLOT |
Plan Master |
F44H301 |
HBMCUS, HBPLAN, CPHASE, HBELEV |
Option Master |
F44H401 |
HBAREA, HBMCUS, CPHASE, HBPLAN, HBELEV, OPTION |
Item Master HomeBuilder Extension |
F44H4101 |
ITM, HBAREA |
Sales Master Table |
F44H501 |
HBMCUS, HBLOT, CSSEQ |
Option Selections |
F44H511 |
HBMCUS, HBLOT, OPKID, OPTION |
Closing Worksheet Entries |
F44H591 |
HBMCUS, HBLOT, CLSRT, OPTION |
Material Item Pricing |
F44H603 |
HBAREA, ITM, AN8, HBMCUS, CPHASE, EFFF |
Bid Details |
F44H611 |
KCOO, DOCO, DCTO, SFXO, LNID |
Lot Start Workfile |
F44H711 |
MCU, OBJ, SUB, OPTION, AN8, ITM, SEQ |
After Start Purchasing |
F44H711P |
DOCO, DCT, KCOO, SFXO, LNID |
Extended Homebuilder Data |
F44H0929 |
HBAREA, HBMCUS, CPHASE, HBLOT, CSSEQ, HBPLAN, HBELEV, OPTION, SDTYP, SDKY, SDLIN |
EDI Purchase Order Header - Inbound |
F47011 |
SYEDOC, SYEDCT, SYEKCO |
EDI Purchase Order Detail - Inbound |
F47012 |
SZEDOC, SZEDCT, SZEKCO |
EDI Request for Quote Header - Inbound |
F47091 |
SYEDOC, SYEDCT, SYEKCO |
EDI Request for Quote Detail - Inbound |
F47092 |
SZEDOC, SZEDCT, SZEKCO |
EDI Product Activity Data Detail - Inbound |
F47122 |
MJEKCO, MJDOC, MJDCT |
EDI Product Activity Data Detail - Outbound |
F47127 |
MJEKCO, MJDOC, MJDCT |
EDI Purchase Order Change Header - Inbound |
F47131 |
EDOC, EDCT, EKCO, EDLN |
EDI Purchase Order Change Detail - Inbound |
F47132 |
EDOC, EDCT, EKCO, EDLN |
EDI P.O. Acknowledgement. Header - Outbound |
F47026 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Acknowledgement. Detail - Outbound |
F47027 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Shipping Notice Detail - Outbound |
F47037 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Invoice Header (Sales) - Outbound |
F47046 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Invoice Detail (Sales) - Outbound |
F47047 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Response to RFQ Header - Outbound |
F47106 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Response to RFQ Detail - Outbound |
F47107 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Purchase Order Header - Outbound |
F47016 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Purchase Order Additional Header - Outbound |
F470161 |
S3EDOC, S3EDCT, S3EKCO, S3EDLN |
EDI Purchase Order Additional Detail - Outbound |
F47017 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Purchase Order Additional Detail - Outbound |
F470171 |
S4EDOC, S4EDCT, S4EKCO, S4EDLN |
EDI P.O. Acknowledgment Header - Inbound |
F47021 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Acknowledgment Detail - Inbound |
F47022 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Invoice Header - Inbound |
F47041 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Invoice Detail - Inbound |
F47042 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Invoice Summary - Inbound |
F47044 |
SWEDOC, SWEDCT, SWEKCO, SWEDLN |
EDI Planning Schedule Detail - Inbound |
F47062 |
MYEDOC, MYEDCT, MYEKCO, MYEDLN, MYITM, MYMCU |
EDI Planning Schedule Detail - Outbound |
F47067 |
MYEDOC, MYEDCT, MYEKCO, MYEDLN, MYITM, MYMCU |
EDI Receiving Advice Header - Inbound |
F47071 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Receiving Advice Detail - Inbound |
F47072 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Receiving Advice Header - Outbound |
F47076 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Receiving Advice Detail - Outbound |
F47077 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Request for Quote Header - Outbound |
F47096 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Request for Quote Detail - Outbound |
F47097 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Purchase Order Change Header - Outbound |
F47136 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Change Acknowledgment Header - Inbound |
F47141 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Change Acknowledgment Detail - Inbound |
F47142 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI P.O. Change Acknowledgement Header - Outbound |
F47146 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Change Acknowledgement Detail - Outbound |
F47147 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Tolerance Rules |
F4722 |
PZEDST, PZAN8, PZEDSP, PZCO |
Work Order Master File |
F4801 |
WADCTO, WATYPS, WASRST, WADPL, WAAN8, WADOCO |
Billing Detail Workfile |
F4812 |
BCI, DGL, SBSQ, PRSQ, SCSQ, SLNK, CLNK, CCOD |
Billing Workfile History |
F4812H |
BCI, DGL, SBSQ, PRSQ, SCSQ, SLNK, CLNK, CCOD |
Invoice Summary Work File |
F4822 |
W4DOCZ, W4DCTI, W4KCOI, W4SFX |
Billing Rate / Mark up Table |
F48096 |
UKID |
Voucher Summary |
F4823 |
DOCZ, DCTI, KCOI, SFX |
Component Table Detail |
F4861 |
CTBL, CRCD, EFTB, UKID |
Burden Rates |
F48S85 |
SEGMID, EFTB, CRCD, BUCA, BURT, POOLID |
G/L Link |
F48S912 |
AID, BCI, DGL, PRSQ, SBSQ, SCSQ, CCOD, DCT, LT, UKID |
Sales Order Detail File - Tag File |
F49211 |
UDDOCO, UDDCTO, UDKCOO, UDLNID |
Load In-Transit Confirmed Quantities |
F49633 |
LDNM, VMCU, DLNO, SHPN |
Load In-Transit Confirmed Quantities Detail |
F49634 |
SHPN, DOCO, DCTO, KCOO, LNID |
Contract Billing Line Detail |
F5202 |
DOCO, DCTO, KCOO, COCH, LNID |
Contract Revenue Summary |
F5280 |
DOCO, DCTO, KCOO, COCH, LNID, CTRY, FY, PN |
Government Contract Modification |
F52G01M |
DOCO, DCTO, KCOO |
ACRN Details |
F52G05 |
DOCO, DCTO, KCOO |
ACRN History |
F52G05H |
DOCO, DCTO, KCOO, DOCZ, DCTI, KCOI, GACRN |
Government Contract Limit Summary |
F52G200 |
DOCO, DCTO, KCOO, PRTPG |
Actual Rate Calculation |
F52G60 |
REFID, SEGMID, SEQ, POOLID, BOBS, TRRN |
Suspended IVA Generation - Receipt/Rebate Control - Italy |
F743B14I |
TIDOC, TIDCT, TIKCO, TISFX, TIDOCM, TIDCTM |
IM Withholdings Setup |
F76V4025 |
WSCO, WSV76MUNW, WSV76MIIM, WSEFTJ |
VAT Withholdings Setup |
F76V4030 |
VWCO, VWV76VATW, VWEFTJ |
Withholding Historical File |
F76V4581 |
HRKCO, HRDCT, HRDOC, HRSFX, HRSFXE, HRCO |
Withholdings I.S.L.R. Fee 2 |
F76V4583 |
TDCO, TDAN8, TDAC07, TDFY, TDPN, TDDCT, TDDOC, TDIRQ |
Competitor Table |
F90CA060 |
CMAN8 |
Opportunity Table |
F90CB020 |
OPPID |
Opportunity Item Table |
F90CB02I |
OPPID, LNID |
Cost Table |
F90CB02M |
COSTID |
Forecast |
F90CB060 |
FCID |
Opportunity For Forecast |
F90CB06B |
FCID, OPPID |
Opportunity Item For Forecast |
F90CB06C |
OPPID, SEQNU, FCID |